Would anyone happen to know what SQL table the below window pulls its data from (specifically the detail contained in the grid?)
Use GP Power Tools Resource Information window to find the window by typing in part of the window name (case insensitive) into the display name. Once the form is selected, click Associated Tables to see the tables linked with the form.
Ignoring the setup and master tables, we can see that the data will be in the CM_Receipt or CM_Receipt History tables depending on whether the transaction is in history or not.
If you have the window open already you can select Resource Information or Resource Finder from the Tools menu to jump straight to the information needed.
The window is actually using the CM_Receipt_TEMP table in the scrolling window which a temporary table populated by code from either CM_Receipt or CM_Receipt_History.
So look in CM20300 or CM30300.
Regards
David
Thank you David!
Don't thank me.... Thank GP Power Tools (which I wrote), as it provided the answer in seconds.
Took longer to write the response than to get the information.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,028
André Arnaud de Cal... 878 Super User 2025 Season 2
Sohaib Cheema 579 User Group Leader
