You’re offline. This is a read only version of the page.
4,084
Hi,
What would be the easiest way to get the list of customers in RM having outstanding balance on any giving date.
It similar to the aging report but all what I need is the customer number only
thanks,
*This post is locked for comments
The script provided at Victoria's website is just great. Although, If I am not mistaken, Alaa is looking for a customer statement that could calculate the customer balance at any given date. In this essence, you should be looking for the RM work, open and history tables to calculate the balance according to the date parameter provided, to be more precise, a beginning and ending date (From ... To ... )
I would not look for the customer summary table for such a requirement. The transactions table is required to get the beginning and ending balance.
Please check this blog post from Victoria: victoriayudin.com/.../sql-view-for-current-receivables-aging-in-dynamics-gp
Thanks
Sandip
Hi Alaa!
You'll want to take a look at the RM00101 (Customer Master) for customer info and the RM00103(Customer Master Summary) for the info your looking for.
The specific column is the CUSTBLNC of the RM00103 table.
If you have any questions feel free to let me know.
Joshua
sorry I meant to ask how to get this from the back end, what tables to use, I need this information to use in one of the Ssrs report that include some other details
Hi Alaa,
Are you aware of smartlist or Aged Trial Balance reports? Troubleshoot more on these topics.
Thanks
Sandip
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,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (