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
dgutie02 4/22/2019 3:53:55 PM

taPMTransactionInsert - 4610 - "Unable to calculate the discount and due dates"

Hello,

 I wrote a SQL based integration for a client that takes customer and vendor invoices from a proprietary system, and inserts them into their MS Dynamics database. Overall the integration is working pretty well -- but some vendor invoices fail with error 4610 (Unable to calculate the discount and due dates) when calling "taPMTransactionInsert". I've looked at the data, and don't see any patterns (e.g., not always happening to a specific customer or vendor) and I really don't know much about dynamics in general.

 Can someone point me in the right direction to troubleshooting this problem? I can provide the procedure code in a private message if necessary, but the general flow I have is this...

 

1) begin transaction

2) Call taGetPMNextVoucherNumber and store next voucher number

3) Validate customer # I have exists in Dynamics (by querying GL00100)

4) Validate vendor # I have exists (by querying GL00100)

5) Call taPMTransactionInsert twice (once for the AP account and once for the customer account)

6) Each of the calls above are wrapped w/ try catches where I do error logging and a rollback on the transaction

 

Thanks,

David

Version: GP 2010
Section: Dynamics GP, eConnect








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