What table is customer balance coming from

(0) Share

Report

Posted on by Community Member

On the AR Customer aging report, what table is the customer balance coming from, I can't get the numbers for current, 45-60,91-120 and 120+ to equal that total.

It can be found though GP->SmartList->sales->Customers->AR Customer aging.

I need to find the customer balance.

*This post is locked for comments

I have the same question (0)

All responses (22)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Here are the summary tables in Receivable Management:

Customer summary master | RM00103

Customer period summary | RM00104

I would start as a prerequisite with a reconciliation, which should take care of the customer balances as it main purpose is to go through your transactions and re-calculate the customer balance, then update the customer balance accordingly.

Furthermore, to help you better troubleshoot the problem, you can consider a database level calculate for the customer aging considering the SQL view provided on SQL view for current Receivables aging detail in Dynamics GP

Keep us posted,

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Your SmartList must be a Favorite or a SmartList Builder object. Do you know if this is a custom SmartList? There is no out of the box SmartList by that name. SmartList is not the best tool for producing a customer aging. Better choice would be the aging under Sales>>Reports>>Trial Balance.

To answer your question, the Customer Balance comes from RM01003.CUSTBLNC.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

You can view the particular customer balance from Customer Summary window (Cards-->Sales-->Summary).

Note: Before check the customer balance in GP, run the Reconcile (Tools-->Utility-->Sales-->Reconcile) for Current Customer Information & Outstanding Document Amounts.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I don't know where to find this report as I don't use GP often

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I have just been alerted by Mr. Frank comment, this is a customized smart list. I thought initially you are talking about the original trial balance report.

Check it out on "Reports > Sales > Trial Balance", there are several types to consider.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Sales>>Reports>>Trial Balance. Maybe get someone in your accounting department to run it for you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I found it. now how do I run a query against it to get that balance? I can't find the table

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Mr. Frank Hamelly

Shall you proceed with it ... ?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Rigamonk,

If you want to print the AR aging report within GP, then follow the below steps. Otherwise go this link and create a view against your company database in SQL Server Management Studio and select the view to get the AR aging detail.

1. Go to Reports-->Sales-->Trail Balance.

2. Select Historical Aged Trail Balance from the Reports drop down and click new.

3. Now enter the option name (whatever you want) and select the values (eg.,Print/Age as of, Range & Exclude options) as shown below.

4. Now click the destination button and set the report destination option (whatever you want) as shown below and click OK.

5. Then click the Print button to print the AR aging report.

Hope this helps!!!

Was this reply helpful? Yes No

Community Member on at

Like (0)

Report

I found it and got the query to get the ending balance. however, I used a query from Victoria Yudin (can't remember which one) that list the amount due during certain periods (0-44, 45-90 etc...) and these numbers aren't adding up. any way to get those numbers?

CUST 0-44 45-60 61-90 91-120 120+ total

A 1 Precision Inc 6599.65000 2240.44000 0.00000 0.00000 -0.20000 11477.980000000000

Was this reply helpful? Yes No