Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
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
site