Skip to content


Debit & Credit Negative

ABC asked 8 years ago
Anybody knows how export general journals from a database to another with debit or credit negative without change the sign on amount. The problem is when the mapping have many lines with negative sign and it
Best Answer
lorren answered 8 years ago
What database are you exporting from and importing in to? Is this dynamics GP?  If so, when you import into Dynamics GP using the existing Nodes, it will not accept negative values for amounts so you would have to import directly to a SQL Table as the destination or to write your own SQL stored procedure and update the tables directly.

I would caution against doing that however since it would by-pass Dynamics GP business logic.


If you would like to submit an answer or comment, please sign in to the eOne portal.