Finance | Project Operations, Human Resources, ...

RM Detail Historical Aged Trial Balance shows 1 cent but Customer's AR GP balance shows zero

(0) Share

Report

Posted on by DebbyW

My AR SQL report "RM Detail Historical Aged Trial Balance" is showing there is a penny from 2019 on a customers AR account. When I look in GP under that customer it does not show up in the account.

I've checked to see if the amounts applied equal the invoice and they do.

I'm trying to get rid of that penny. I've tried to "Reconcile the AR" but that usually only works when I see an invoice in a credit balance situation. I've also tried to close the Paid Transactions for that customer which I found in the community forum. Unfortunately that didn't work either and now I cannot minipulate the pament applied to that invoice.

Is there a way to remove that penny off the SQL report? I have several accounts in multiple businesses that have the same problem.

Thoughts?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Debby,

I do assume GP is Great Plains? Let me move your question to the correct forum.

Was this reply helpful? Yes No
DebbyW 8 on at

Like (0)

Report

Yes, GP stands for Great Plains. It says "Microsoft Dynamics GP Forum" at the top. Am I not in the right place? My AR shows zero but my SQL report generated shows a penny.

Was this reply helpful? Yes No
Suggested answer

Frank_Heslin 895 on at

Like (0)

Report

I would check in the following SQL tables for an amount not equal to zero in the 3rd, 4th, or 5th decimal place, and change it to zero. RM30101, RM30201, RM30301. For documents that are not in History, look in RM10101, RM10201, RM10301, RM20101, RM20201. Afterwards, make sure to run Reconcile Receivables Amounts (Sales > Utilities) for Current Customer Information & Outstanding Document amounts.

Was this reply helpful? Yes No
DebbyW 8 on at

Like (0)

Report

Still having an issue, haven't figured out how to fix it without a step by step guide on how to fix the tables (if that's the issue). The SQL report will show several over or under balances of a penny which do not reconcile. In GP I cannot see that there is anything outstanding at all. It ONLY shows on the SQL report. Anyway to remove these pennies?

Was this reply helpful? Yes No
StefanieC 434 on at

Like (1)

Report

Hi Debby,

Are you importing transactions from another software? Sometimes those imports will bring in a transaction with an amount like 345.678. Normally you only allow 2 decimal places for US dollars so you'll only see 2 in the GP windows. What Frank had mentioned, was checking to see if you have any of these transactions.

This article https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/difference-must-be-zero-before-reconcile-error-when-reconciling-checkbook explains how to handle it when it happens during a bank reconciliation. In my experience, those transactions do not start in the bank module. I've had a lot come from Purchase Orders. In your case, they might be in Sales. You can look for them using the scripts in Step but using the tables Frank mentioned. You'll want to look at those tables and put in a check for all the dollar amount fields. I usually start with just the main currency fields like transaction amount, etc.

Here is an example script from the article. So, you'd replace CM20400 with another table like RM30101 and then DEBITAMT and CRDTAMNT with the field names you need to check.
select 'CM20400' AS 'TABLE',DEX_ROW_ID,DEBITAMT,CRDTAMNT,* from CM20400 where right(DEBITAMT,3)<>0
or right(CRDTAMNT,3)<>0

You might want to get assistance from your partner.

Stefanie

Was this reply helpful? Yes No

Join the conversation

Community site session details

RM Detail Historical Aged Trial Balance shows 1 cent but Customer's AR GP balance shows zero

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

RM Detail Historical Aged Trial Balance shows 1 cent but Customer's AR GP balance shows zero

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates