We recently moved to gp 2010 -> gp 2016
and we pointed our Biztalk edi / Econnect process to the new database
Nothing changed in the process of edi invoices coming in.
But... now, when we have an invoice that has a variance... we see a really large $ amount
showing up
The high dollar amount is not coming thru on the invoice itself
Not sure if it's happening in Stored procedures for Econnect, or something else is going on
Poprctnm seq actindx crdtamt debitamt ordbtamt disttype dex_row_id
INV_79689DC1 16384 1696 437711.14000 437711.14000 0.00000 0.00000 1 5888659
INV_79689DC1 32768 2317 8354.40000 8354.40000 0.00000 0.00000 7 5888660
INV_79689DC1 49152 2323 0.00000 0.00000 8258.76000 8258.76000 9 5888661
*This post is locked for comments
The above data came from the pop10390 table. I believe this table is the distribution work table. The invoice came thru on Econnect. However, I didn't specify the Distribution. I believe the XML was set to auto-dist. So, How does the system come up with the above distribution? Any ideas?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156