web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Intercompany posting related question

(0) ShareShare
ReportReport
Posted on by

GBSI - Borrowing entity

USSI - Loaning Entity

Timesheet posted by an employee in USSI for a project in GBSI. This transaction appears in the 'Pending transactions' in the project in GBSI.

When the 'Voucher' is seen for the above timesheet transaction, the voucher seen is as follows:

Dr Project Cost 190

 Cr Payroll Allocation 190

** Cost price is taken from the setup in GBSI

The intercompany invoice is raised from the USSI against GBSI. This posts the free text invoice and the postings are as follows:

Dr Intercompany AR 150

  Cr Intercompany Revenue 150

** Sales price is the transfer price setup in USSI

This also creates a pending supplier invoice in the GBSI company, which when posted, following postings happen:

Dr Intercompany Cost 150

  Cr Intercompany AP 150

After the supplier invoice is posted in the GBSI company, the hours transaction disappears from the Pending supplier invoice.

The user then creates a project invoice in GBSI to bill to the customer

Dr AR 325

  Cr Revenue 325

Intercompany AR and Intercompany AP accounts will be settled by payment between the two.

My question is:

What happens to the postings created while posting timesheet transactions .i.e. 

Dr Project Cost 190

 Cr Payroll Allocation 190

How are these accounts cleared?

The reason for asking this is, the actual cost consumed on the project in GBSI is the transfer price .i.e. 150. The same cost of 150 is also shown on the project statements as well. So what happens to the 190, where is it consumed and how is it cleared?

Kind Regards
Sarang

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sarang Kusare,

    The $190 that you post in company USSI are only recorded at the ledger account level. They are not tracked in any project. You can double check that by investigating the transaction origin of that voucher.

    The voucher that is created in USSI in not cleared somehow because also the intercompany receivable is recorded at the ledger account level only. Please also check the intercompany invoice voucher that is created in USSI.

    In other words, in USSI, you only have transactions recorded at the leder account level. Those transactions will - for example at the end of a period - be included in the financial consolidation process and be cleared against the intercompany transactions occuring in your other companies (GBSI). Until that time, they remain on those accounts.

    Does that clarify the issue and answer your question?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    By this i understand that the Intercompany consolidation process will clear this voucher:

    Dr Project Cost 190

    Cr Payroll Allocation 190

    Is this what you are saying?

    For all the other postings mentioned i can determine how they are cleared. I am only not sure about this one.

    Kind Regards

    Sarang

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sarang,

    The consolidation process will 'clean' the highlighted accounts.

    7215.ic.png

    What will remain then are

    (a) the project costs of $190 in company USSI and

    (b) the sales revenue for the external customer in company GBSI

    This seems to be ok in my opinion becaue the employee is working for company USSI and receives his salary from this company. Therefore, the costs finally remain there.

    On the other hand side you have the revenue in GBSI. As the employee is not engaged in GBSI, only the revenue remains there (from a group perspective).

    The overall 'margin' from this transaction is thus $325-190 = $135; once again from a group perspective.

    This overall margin can be split up in a loss of $40 for company USSI ($150-$190) an a profit of $175 for Company GBSI ($325-$150).

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    I agree to the intercompany accounts clearing but i kind of differ from the explanation given above for project cost. The reason being:

    The cost price of 190 is setup in GBSI. Though this transaction is posted in USSI but it is posted against the project in GBSI, hence the cost price is driven from GBSI.

    The transfer price is initiated from USSI. In the project statements in GBSI, the transfer price of 150 is considered for calculating margin and NOT the cost price of 190, as setup in the prices section.

    Still not sure about the clearing of the following postings:

    Dr Project Cost 190

     Cr Payroll Allocation 190

    As 190 is the cost price of GBSI and not of USSI.

    Kind Regards

    Sarang

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sarang,

    The transaction

    DR Project costs $190

    CR Payroll allocation $190

    is nothing else than a cost allocation that is made in company USSI.

    The reason for that is because your employee is working for USSI. As a result the employee receives his monthly salary from that company. Posting the salary will typically be recorded by

    DR Payroll expense

    CR Payables.

    As the project costs and payroll allocation account are both P&L accounts, the costs of your employee stay in company USSI.

    Regarding the prices issue that you have:

    Can you share the cost price setup of your employee for ordinary hour postings in company USSI and for postings on intercompany projects? You can check this from the price section of the project module. It would be great if you could post some screenprints here based on what you see in those forms.

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    I thought that the cost price for the hours transaction posted in USSI for a project in GBSI was taken from GBSI. But i was wrong. It is taken from the USSI only.

    With this clarification, i can now very well relate to your previous comment:

    "The overall 'margin' from this transaction is thus $325-190 = $135; once again from a group perspective.

    This overall margin can be split up in a loss of $40 for company USSI ($150-$190) an a profit of $175 for Company GBSI ($325-$150)."

     

    Thanks and Kind Regards

    Sarang

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans