Dynamics Community Forum Thread Details

Transaction with remaining amount moved to historical

Hello all,

We have found where we moved a RM transaction (payment) to historical, but it actually has a Current Transaction amount. I'm not really sure what happened here so feel free to ask any questions. I'm going to provide all the info I have. This transaction was actually from quite a few years ago, we just found it now because we archived recently.

On the Cash Receipts Inquiry window, you can see that the total for the document is for $500. When you look at the applies though, the total actually adds up to $510. The $10 is what is the current transaction amount we see in SQL.

Total Payment = $500

Applied 1 = $100

Applied 2 = $400

Applied 3 = $10

Something other things I would like to note is that when we look into the RM30101 table at the transaction, we see the ORTRXAMT = 500.00 and the CURTRXAM = -10.00. I'm not sure why it has it as a negative. Also, this company integrates a lot of transactions every day so there is the potential it was actually integrated and not manually entered.

Any ideas on what this is?

Is your historical aged trial balance correct? As far as why this happens, I don't have a good answer, it just happens sometimes from perhaps a momentary connectivity problem. Imported transactions are more susceptible to these kinds of things. I just finished a project where a customer had a negative balance like yours causing the payment to be 'over-applied, which is something you cannot do from the user interface. Something went wrong somewhere. For this instance, the reconcile of Outstanding Document Amounts fixed the issue, but our transaction was still in the Open table. When I've had them in the History table, it depends which is the correct answer. I've gone to the PSTL and 'unapplied' the payments to move the transactions back to open and then reconciled. On rare occasions, I've had to actually go into SQL and change the numbers.

Going forward, as part of your month-end close, I recommend doing a Reconcile on Outstanding Document Amounts. This utility normally clears up the kind of thing you're looking at and prevents documents from being moved to history prematurely.

Kind regards,

Leslie

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)