Finance | Project Operations, Human Resources, ...

Table(s) with Company ID Field? - Payables Transaction Entry window

(0) Share

Report

Posted on by Platinum1586

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!

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Platinum,

Could you give more details about your issue? Product, table?

It's better if you could share some screenshots.

Was this reply helpful? Yes No
Platinum1586 5 on at

Like (0)

Report
Copy link

Link copied!

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!

Thanks!

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Moved to GP forum: community.dynamics.com/.../microsoft-dynamics-gp-forum

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No