mark nelson 1/12/2017 2:03:25 PM

AP upload integration will not allow for distributed transaction posting

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.

Version: GP 2010
Section: Dynamics GP, Integration Manager


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3