Notifications
Announcements
No record found.
What table contain the Company ID field that is shown at the top left of the Payables Transaction Entry screen? I have been working with some purchasing table data feeds in Power BI and I can't figure out where I can return this particular Company ID field.
Thanks!
Hi Platinum,
Could you give more details about your issue? Product, table?
It's better if you could share some screenshots.
I have attached a screenshot of the field I am looking for.
I just realized that I made this post in the Dynamics 365 forum so feel free to move it to the correct forum. I don't know how similar 365 is to Dynamics GP 2018 so any help you can provide would be greatly appreciated!
Moved to GP forum: community.dynamics.com/.../microsoft-dynamics-gp-forum
ICTRX field in PM10000 table tell us if this transaction is intercompany transaction or not, 1 is for intercompany transaction. INTERID field on distribution table PM10100 contains the company interid and from DYNAMICS database table SY01500, you can find the company id (which is shown in your screen shot) and other company information.
select interid,CMPANYID,CMPNYNAM from DYNAMICS18..SY01500
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 677 Super User 2025 Season 2
André Arnaud de Cal... 442 Super User 2025 Season 2
Martin Dráb 339 Most Valuable Professional
