Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Michael Ramsey]

Is there any situation in a native Dynamics GP environment in where the system posts to the GL tables an amount in both the debit side and credit side on a single line. The picture shows detail for a GL account coming from the Sales and indicates both a debit amount and a credit amount.  One note, this line was generated thru third party code additions.

——————————
Michael Ramsey
Business Analyst
Employer Flexible
Houston TX
——————————

[Bruce Strom]

I have worked with Dynamics since version 3, and I have never seen a GL Entry with both a debit and credit amount.
Do you have any third party products?  I would suspect that non-GP third party code would cause something like this.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Samantha Higdon]

?Good Morning,

I’ve not seen this occur with native GP functionality, but we have seen it with a client using a third party integration tool (which predates our tenure as consultant).  I believe you said your issue resulted from some third party code additions?

In our client’s situation, the import tool allowed for debits and credits on the same account to be integrated on a single distribution line.  This is not normal GP functionality and will likely cause issues with your Management Reporter reports as well so I would recommend checking those as well.

Below is a link to a Microsoft article that discusses several issues including this one. The article itself discusses several reasons why Management Reporter reports may not match the general ledger, but Step 10 of the article specifically addresses instances where debit and credit to the same account exist on the same distribution line.  It also provides a suggested resolution for those already posted items.  It does not, however, prevent the third party code or application from having the same issue occur in the future.

https://support.microsoft.com/en-us/help/2910626/financial-reports-from-management-reporter-do-not-match-the-general-le

Hope this helps!

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Leaf Software Solutions
Carmel IN
——————————
——————————————-

[William Irwin]

?I have run into this with a 3rd party Concur integration tool and this caused us issues in Management Reporter DataMart version which would only reflect one side of the transaction and not the net.  It actually was one of the reasons we are ‘stuck’ in the Legacy provider rather than DataMart as there is no easy way to fix this.

——————————
William Irwin
Arch Insurance Group Inc
——————————
——————————————-