Reject batch and move file to error folder (2 replies)
Pleroux, following the import, I would add a Map transform prior to the two filters which determines if the data has errors (the following assumes you're importing A/R Invoices):
- Map a value to the SYS.ERROR field on Header level.
- In the Map transform add a field (Errors) to the header level with an expression such as:
IIf(%SYS.ERROR "", 1, 0)
- In the Batch level add a field to sum the total of the newly created field.
Sum("Errors", "AR0032")
This will give you a count of the number of entries in a batch with errors.
- The Filters can then use the new field on the Batch level.
We also have a short FAQ on this too.
https://www.realisable.co.uk/support/faqs/file-routing-based-records-success-failure/
Thanks
There could be an improvement on our side to add the error count to the batch level....but don't expect this in the next week or so.
Importing a Sage 300 AR Batch with one file per batch and we are deleting the batch if there are errors.
The client wants to archive imported files and move unimported files to another folder.
I assume I have to create a filter to determine which batches were created and separate them from the batches that were not or files that had SYS.ERRORS. Even though the batch was deleted the batch number is populated so what should be the syntax on the filter?