Sub-ledger opening balances for item and open transactions for customer and vendor load in Microsoft Dynamics 365 Finance and Operations

Sub-ledger opening balances for item and open transactions for customer and vendor load in Microsoft Dynamics 365 Finance and Operations

Import can be done using data entity for movement journal header and line for loading opening inventory.

The challenge is to select the right approach of offset.

One of the way is to use the same inventory account as that of the item so that the new GL effect is zero while inventory gets loaded with accurate costing and quantity and the opening balance for the inventory accounts should come from trial balance from legacy system

Same approach for selecting offset to load open AR and open AP transactions/invoices/payments and could use the general journals open in Excel to load the same