Thursday, May 30, 2024

Intercompany Setup in D365PO (non-stock)

Intercompany Configuration

       Parameter setup in both the legal entities (Borrowing legal entity – Procurement category, Lending Legal entity – Default Hours and Expense category)

       Intercompany customer vendor setup in both the legal entities

       Intercompany setup in the General Ledger setup

       Project category for expenses to be created in both the legal entities

       Procurement categories in both the legal entities for IC Supplier Invoice Test

       For IC Supplier Invoice test, vendor to be created in FinOps and then created in ProjOps

       For IC Expenses test, employee vendor to be created in Lending entity and linked to the employee

       Bookable resource created in Lending entity in ProjOps with correct resource role

       Intercompany Cost and Intercompany Revenue Account in “Ledger posting setup” needs to be setup

       Employee created in Lending entity in FinOps and associated with the User in System Admin module

       Price List

       Two costs price list

       One for Lending entity – On Organisation Unit

       One for Borrowing legal entity (Transfer price) – On organisation Unit

       One sales price list

       One for Borrowing legal entity – On Project Contract (Pay attention to the “Unit schedule” and “Unit” otherwise the sale price is 0)

       Unit

       For Expense (Transaction Category) the Unit should be – Primary Unit

       For Purchase (Transaction Category) the Unit should be – ea

       Hence the “Expense” type of Project Categories used for Out of pocket Expense and Pending supplier invoice (Purchase) should be different

       Customer, Project Contract, Project Contract Line, Project and TASKS created in Borrowing Entity. Tasks are mandatory.

       “Default offset account for expenses” needs to be setup in the Borrowing entity otherwise integration journal does not bring the offset account for the sales posting. System does not use this “Default offset account for expenses”  but it requires it for posting. This is weird but this is true. System still uses the project posting profile.

       Check fiscal period is open in Lending and Borrowing Legal entity

       Exchange rate should be same in ProjOps and FinOps

       Make sure the Unit of Measure are set to – Fixed unit assignment = Yes (otherwise the Free Text Invoice fails)

     Intercompany Price List Configuration

        Price Lists

        UK Cost Price (Type = Cost) – Associated with the loaning entity organization unit

        Role - Robotics Engineer

        Cost price

        US Cost Price (Type = Cost) – Associated with the borrowing entity organization unit

        Role - Robotics Engineer

        Resourcing Company – GBPM

        Resourcing Unit – GBPM

        Cost price

        Demo Sale Price (Type = Sales) – Associated with the borrowing entity project contract

        Role – Robotics Engineer

        Resourcing Company – USPM

        Resourcing Unit – USPM

        Sale price

        Sales price set “At Cost” for Expense and Purchase transaction categories

 

No comments:

Post a Comment