Thursday, December 27, 2012

Dynamics GP - Integrating Bank Transactions - "Originating debits and credits do not match"

When integrating bank transaction into GP using econnect, or eOne Smartconnect, you may get the error

"Originating debits and credits do not match"

This is because GP will automatically create one side of the distribution entry depending on the transaction type you are integrating. If you are trying to integrate both sides of the distribution, one side will fail because GP has already created that record.

For Deposits or Increase adjustments - Do not import Debits, GP will create the debit side of the distribution automatically
For Withdrawals or Decrease adjustments - Do not import Credits, GP will create the credit side of the distribution automatically

2 comments:

  1. Hi, I am only importing the debit and I am still receiving this error. Any thoughts?

    ReplyDelete
    Replies
    1. Try entering the transaction manually to see what GP actually does. also, you can try switching around which side of the distribution you are integrating, you may be integrating the wrong side.

      Delete