Issue -- Error while applying a transaction to receipt - The sum of debits and credits are out of balance

Issue - Error while applying a transaction to receipt

The sum of debits and credits are out of balance. This action was blocked to avoid inaccurate accounting entries. (AR-855267)

This receipt could not be applied to any invoice. The exchange gain or loss keeps calculating at each invoice addition, therefore we cannot save the receipt as we get the error: “The Sum of debits and credits are out of balance. The Action was blocked to avoid inaccurate accounting entries. (AR-855267).

There should not be any conversion rate as the receipt is in business unit currency. Exchange Gain or Loss originally 0, keeps changing when adding an application.

Solution:

This receipt got created with exchange rate in it. We suspect that this receipt got created with a  spreadsheet which had exchange rate already populated.

Steps:

              1.       As the receipt is in cleared status,  get the receipt uncleared from cash management.

              2.       then reverse the receipt.

              3.       Create a new replacement receipt. Please ensure the exchange rate is blank while creating   

                     the new receipt via spreadsheet or create manually from create receipt screen.

              4.       Do the necessary application with the replacement receipt as would with reversed receipt.