475
When I print the receivable detailed Historical Aged Trial Balance report, this report is showing two customers with transactions from prior year details ( invoice and payment) even though it has a zero balance. Can someone tell me what I need to do in order for these items and customer to stop showing up on this report ?
Thank you.
Gedco
*This post is locked for comments
Dear Tristan,
Thanks again for your support.
I had checked for the two table which the both information consist into the RM30101 and RM30201 tables. Is it possible because of the APPTOAMT and APFRMAPLYAMT figure difference by 0.01 where system record as APYTORNDAMT?
The following SQL result which show in HATB:-
RM30101
DOCNUMBR TRXSORCE ORTRXAMT CURNCYID CURTRXAM
INV17472 RMSLS00000031 19,343.94910 SGD 0
INV17480 RMSLS00000031 20,942.99090 SGD 0
OR00203 RMCSH00000007 52,889.10940 SGD 0
OR00215 RMCSH00000009 93,249.89000 SGD 0
RM30201
APFRDCNM APTODCNM TRXSORCE APPTOAMT APYTORNDAMT APFRMAPLYAMT
OR00203 INV17472 RMCSH00000007 11479.8348 0 11,479.83480
OR00215 INV17472 RMCSH00000009 7864.11 0.01 7,864.12000
OR00215 INV17480 RMCSH00000009 20942.99 0 20,942.99000
Thank you.
Wei
Hi Wei,
You need to check if both the Invoice and Cash Receipt are in the RM30101 and RM30201 tables.
If either one of them is not in the tables mentioned then they will appear in the RM HATB report.
Thanks Tristan Thor Clores I already tried all Victoria's suggestions but still get the same result.
I tried run in SQL RM20201 there was no result show however the documents in CURTRXAM fields of the RM30101 table also already zero-out.
Thank you.
Wei Ching
Hi weiching,
If you already tried Victoria's suggestions above and still encounter the issue, you can try checking if the transactions involved still have amounts on the 3rd decimal places.
There are instances where your Currency Decimal Places are set to 2, however, amounts in SQL have values in the 3rd-4th decimal places - which in turn will not zero-out the amounts in the CURTRXAM fields of the RM20201 table.
Let me know if you need assistance on writing up the SQL script.
Good evening Gedco,
I am having the same issue and I am not able to find the solution to solve it. Were you able to fix it? If so, may you please indicate what you have done?
Thanks much in advance for your help.
Amilie
Hi Gedco,
Sorry to hear this is still an issue. Do you have a GP Partner you are working with? You may want to ask them for help with this. Or, an alternative would be to contact Microsoft Dynamics GP support.
Good day Victoria,
I have completed the check links and reconcile the outstanding transaction amounts on the sales series as promised, but this did not clear the receivable amount for that particular customer. I guess I will have to consider your other suggestion.
How do I go about working with someone to look at the data in the tables?
Thank you very much for your support.
Gedco
Thanks Victoria I am just having some backup issues right now so as soon as that is resolved I will try your suggestion and provide you with a feedback then.
Will update you soon.
That's true, thanks. I will address the RZ issue with another question.
Gedco
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (