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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
davidweng 11/29/2018 9:17:24 AM

eConnect Multicurrency Out of Balance issue

Using eConnect to import AUS dollar transaction into a GP company db which uses USD as the functional currency, I receive an out-of-balance error message (and the transaction does not post). The transaction clearly balances in AUS dollars.

Error Number = 944  Stored Procedure= taGLTransactionHeaderInsert  Error Description = Unbalanced journal entry, the credits do not equal the debits

Node Identifier Parameters: taGLTransactionHeaderInsert


JRNENTRY = 215452

REFRENCE = SS Cash 10/31/2018

TRXDATE = 10/31/2018 12:00:00 AM


When I hand key the transaction into GP, it goes in just fine.  The system adds in a rounding line to accommodate a rounding difference when it translates to functional USD currency.  In this transaction’s case, there is a penny rounding difference when it translates to USD.   How can we get eConnect to perform the same rounding function for functional currency translation rounding that GP performs systematically when the transaction is hand keyed?


Version: GP 2015
Section: 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