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