One of our integrations for AP upload allows for all one to one (db/cr) entries to post with no issues.
However when there is a entry that involves numerous cr or db entries to one offsetting cr/db entry it fails and forces AP to need to manually enter the transaction.
I have included the source file in .csv format Rows 4-8 (yellow rows) equal the offsetting entry of. Row 9( red row)
Any thoughts on this would be appreciated is this a limitation within IM?
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Field 'Batch ID' does not have a default value.
DOC 3 WARNING: Distributions for this transaction contain errors.
DOC 3 WARNING: This transaction will not post; it includes distributions with errors.
DOC 5 WARNING: Distributions for this transaction contain errors.
DOC 5 WARNING: This transaction will not post; it includes distributions with errors.
Integration Complete -- Partial Success
Integration Results
5 documents were read from the source query.
5 documents were attempted:
2 integrated without warnings.
2 integrated with warnings.
1 failed to integrate.