Finance | Project Operations, Human Resources, ...

Intercompany posting profiles for posting intercompany revenue and intercompany cost of sales

(0) Share

Report

Posted on by Purchase ledger

Dear experts,

When an invoice is raised on an customer account with Interco or Intraco as their customer group, the revenue should post to an intercompany revenue account rather then the standard 3rd party accounts.

When a PO/Invoice is booked onto a supplier account with Interco or Intraco as their supplier group, the costs should be posted to an intercompany cost of sales account rather then the standard 3rd party accounts.

How we can set the posting profile so that the revenue can be posted to intercompany revenue GL account for customers who are of intercompany customer group and

the costs should be posted to an intercompany cost of sales GL account for the PO/invoice booked on suppliers of intercompany supplers group.

Thanks,

I have the same question (0)

All responses (21)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (0)

Report

Hi Purchase ledger.

On the Inventory Posting form, you can setup combinations of the item relation and customers/vendors.

On the customer and vendor posting profiles, you can also set a summary account per group.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Purchase ledger,

You can achieve that as Andre described; simply detail your inventory posting matrix setup accordingly.

Below is an example from one of the MS demo companies where the customer groups 100 and 90 designate intercompany customers that post on separate revenue accounts.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

a

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Expert,

Ref to your answer below, can you pls specify the navigation for the 1st point.....

**************

1.On the Inventory Posting form, you can setup combinations of the item relation and customers/vendors.

2.On the customer and vendor posting profiles, you can also set a summary account per group.

**************

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ludwin: How do i navigate to the above screen?

Thanks

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Purchase ledger,

You can find this form in inventory management / setup / posting / posting.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

Do we need setup at both the places ie,

2.On the Inventory Posting form, you can setup combinations of the item relation and customers/vendors.

2. On the customer and vendor posting profiles, you can also set a summary account per group.

Or any one setup will work?

Thanks,

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

On the inventory posting form , you can maintain settings for accounts to be used which are product related, such as revenue, cost of goods sold. The other mentioned forms do have the summary account for the balance of customers and vendors.

So, it depends on your exact requirements which exact forms to use to setup specific intercompany related ledger accounts.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Purchase ledger,

In the customer and vendor posting profiles companies typically use separate groups and summary accounts for their intercompany transactions. That's basically a must have if you want to consolidate your data later on. In other words, you need separate AP intercompany / AR intercompany accounts.

The same applies to the inventory posting matrix where you need to separate intercompany sales from ordinary sales account and intercompany purchases from other ordinary purchases.

If you are not making this separation, the financial consolidation will be very difficult and a very manual process.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ludwig....

We have challenge here ie., our client is not maintaining the standard intercompany, so can we fix this issue through Ledger Allocation rules.

Thanks,

Was this reply helpful? Yes No