Hello Nico,

The Total Debits and Total Credits fields show the ?Entry Totals?. Instead of these fields, use the ?D ? Amt?.

Debits are positive amounts and Credits are displayed as negatives.

Hello Niko,

You're right, the field Technical Support referred you to is marked "hidden" in the GridView dictionary. Perhaps they can send you an updated dictionary.

What were you going to do with the "captured" batch? Does Archiving, or Copying the batch not provide the functionality you need?

Hello Niko,

R&D is looking into updating the dictionary. We will get back to you.

Hi Niko,

Have you considred just printing the Vendor Transaction report for the dates you need and turning on the option to include the gl details?

Is the problem you are having in creating the date math necessary to isolate last month's transactions? If so, then I'll post the requisite formula.

Here's a formula to select only transactions from the Prior month only. It is generic and not particular to any data file (apart from the name of the date field):

( 12* Year(TODAY()) + Month(TODAY()) ) -
( 12* Year({Entry Date}) + Month ({Entry Date}) ) = 1

This takes the year and month of today, compares it to the year and month of the transaction date, and only selects those that differ by one month. This is necessary for the filter to work in January, when the prior month is in a different year.

Hello Niko,

A/P G/L Disbursements.

Hi Niko,

As mentioned in the first part of that posting, the formula syntax is not specific to a data file, and {entry date} is not the name of a spcific field. This is just an example of how to isolate transactions that exist in a prior month.

You have 2 choices for which file to select. If you want to point at AP, use the table 'AP GL Disbursements', which contains all the GL distributions of transactions posted by Adagio. Note that {Entry date} appears here.

Your other choice is to point at the GL Posted Transactions table. The date is called {Trx Date} and you would need to include a filter against the field {Ledger} in order to select only those records that came from AP (or AR or OE etc).

Which choice you make depends on what information you want - it's up to you.