Just recently, I fielded a question where the user wanted to group a number of customer invoice transactions in a file based on the invoice date. The file happened to contain invoices downloaded from the billing system in a date range, for example 02/01/2010 – 02/05/2010. They wanted the resulting transaction batches in GP to be something like,
This would facilitate analysis by day and to make sure control totals matched those created on a daily basis.
The solution involves adding a field script to the batch ID field which in turn reads the transaction date field from the source query and forms the new batch ID with that information:
Very simple, but useful script. Keep in mind that you must enable the option to Add Missing batches for the integration as shown below:
When the integration is executed, it will create as many AR batches in Microsoft Dynamics GP as unique transaction dates there are in the file.
Until next post!
Mariano Gomez, MVP
Maximum Global Business, LLC