Business Requirement:
Balance sheet report by Business Unit (Financial Dimension).
Context:
We would like to generate financial reports viz. Balance Sheet and Profit & Loss a/c by Business Unit which is a Financial Dimension in the Account Structure.
Additional Information:
- The Account Structure is configured to have Business Unit mandatory.
- Default financial dimensions cannot be defined on Customer and Vendor masters, as they deal with multiple Business Units.
- Default financial dimensions cannot be defined on Balance Sheet Accounts, as they deal with multiple Business Units.
- Currently we are dealing with the below D365 modules:
- AR/ Sales
- AP/ Procurement
1.1 Scenario -1:
To understand the requirement, let’s take Procurement scenario:
- A Purchase Requisition is created for a Business Unit for a single vendor.
- User manually enters the Financial Dimensions on all the Purchase Requisition Lines.
- A Purchase Order is created from the Purchase Requisition once it is auto approved. There is a 1:1 relation between Purchase Requisition and Purchase Order.
- Once Purchase Order is created:
-
Purchase Order Header does not populate any financial dimensions as the Vendor master does not hold any default financial dimensions.
-
Purchase Order Lines populate the Business Unit (Financial Dimensions) from Purchase Requisition Lines.
1.2 Issue:
Is there a way to populate the financial dimensions on Purchase Order Header from Purchase Requisition/PO lines?
1.3 Addition info:
- Currently, we cannot populate the financial dimensions on Purchase Order Header as Vendor master does not have default financial dimensions which is the business requirement.
- Purchase Requisition Lines define only the PO line data and PO header is defined by Vendor master.
- We have accrual mechanism in place.
2.1 Scenario - 2:
We have a payment scenario for multiple vendor invoices.
-
For a Vendor, we have multiple invoiced Purchase Orders but with different financial dimensions (Business Unit) on each Purchase Order.
-
We create a Payment Journal for all vendor invoices with a single CHECK payment.
-
At the time of payment:
- Payment Main Account does not populate any financial dimensions (Business Unit) as the Vendor master does not hold any default financial dimensions.
- Offset a/c (bank a/c) also does not have default dimensions.
2.2 Issue:
We would like to track payment made by SINGLE CHECK across the Business Units. It helps us distribute the payment amount among the business units as per the respective share of liability. Is there a way to achieve this?
2.3 Addition info:
- Currently, we cannot populate the financial dimensions on Vendor Payment journal as neither Vendor master nor Main Account have default financial dimensions.
- Ledger allocation rule cannot be used as the fixed allocation is not possible in this scenario.
- We are using one Liabilities account for AP/Procurement irrespective of Business Unit.
Please contact me for more details or clarifications on this requirement.
*This post is locked for comments
I have the same question (0)
