Dynamics Community Forum Thread Details

Write Off 1/2 cent debit memos

Hi,

We have an issue where customers have a balance 1/2 cent due to a debit memo transaction being 1/2 cent. We use multi-currency and these transactions were caused by an issue w/ Avalara or GP. Problem is now we can't due any write offs because the 1/2 cent transactions cause the GP write off process to crash with a divide by zero error.

Anyone have any ideas on how to clear these out of GP?

Jeff, you may need your GP partner to help you with this. It sounds like this was caused by a bug or a posting interruption or some other problem that resulted in corrupt data.

You mentioned that the customer has a 1/2 cent balance on an open debit memo. You can use this script, in SQL Server Management Studio, to find any open receivables transactions where the current balance has more than two decimal places:

select DEX_ROW_ID, * from RM20101 where (CURTRXAM * 100)%1>0

Once you have your results, you can make a backup of the database and then try updating one or more fields in the affected record so that there is no rounding issue.

This issue may have carried into your GL as well, so you can use this script to check for rounding issues in your general ledger:

SELECT * FROM GL20000 WHERE (DEBITAMT * 100)%1>0 OR (CRDTAMNT * 100)%1>0

Good luck! I hope this information helps you.

Quick Links