You’re offline. This is a read only version of the page.
What is this table used for dbo.RM00103 and the following fields
AGPERAMT_1 through AGPERAMT_7
NUMADTPL
NUMADTPY
*This post is locked for comments
Hi Michael
From inside Dynamics GP you can go to Tools >> Resources Descriptions >> Tables. From here you would be able to sort by Physical Name in the sales series and find the table.
Once you have the table, you can look through the fields to find the descriptive names of the ones your are interested in.
The RM00103 table is RM_Customer_MSTR_SUM (Customer Master Summary).
The 7 AGPERAMT fields are the array of Aging Period Amount buckets.
The NUMADTPL is Number ADTP Documents - Life. ADTP is Average Days To Pay.
The NUMADTPY is Number ADTP Documents - Year.
Hope this helps.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (