Design details: Accounts in the general ledger

To reconcile inventory and capacity ledger entries with the general ledger, the related value entries are posted to different accounts in the general ledger. For more information, see Design Details: Reconciliation with the General Ledger.

From the Inventory Ledger

The following table shows the relationship between different types of inventory value entries and the accounts and balancing accounts in the general ledger.

Item Ledger Entry TypeValue Entry TypeVariance TypeExpected CostAccountBalancing Account
PurchaseDirect CostYesInventory (Interim)Invt. Accrual Acc. (Interim)
PurchaseDirect CostNoInventoryDirect Cost Applied
PurchaseIndirect CostNoInventoryOverhead Applied
PurchaseVariancePurchaseNoInventoryPurchase Variance
PurchaseRevaluationNoInventoryInventory Adjmt.
PurchaseRoundingNoInventoryInventory Adjmt.
SaleDirect CostYesInventory (Interim)COGS (Interim)
SaleDirect CostNoInventoryCOGS
SaleRevaluationNoInventoryInventory Adjmt.
SaleRoundingNoInventoryInventory Adjmt.
Positive Adjmt., Negative Adjmt., TransferDirect CostNoInventoryInventory Adjmt.
Positive Adjmt., Negative Adjmt., TransferRevaluationNoInventoryInventory Adjmt.
Positive Adjmt., Negative Adjmt., TransferRoundingNoInventoryInventory Adjmt.
(Production) Consumption

Learn more at Production consumption.
Direct CostNoInventoryWIP
(Production) ConsumptionRevaluationNoInventoryInventory Adjmt.
(Production) ConsumptionRoundingNoInventoryInventory Adjmt.
Assembly Consumption

Learn more at Assembly consumption.
Direct CostNoInventoryInventory Adjmt.
Assembly ConsumptionDirect CostNoDirect Cost AppliedInventory Adjmt.
Assembly ConsumptionIndirect CostNoOverhead AppliedInventory Adjmt.
(Production) Output

Learn more at Production output.
Direct CostYesInventory (Interim)WIP
(Production) OutputDirect CostNoInventoryWIP
(Production) OutputIndirect CostNoInventoryOverhead Applied
(Production) OutputDirect Cost - Non InventoryNoInventoryDirect Cost Non-Inventory Applied Account
(Production) OutputVarianceMaterialNoInventoryMaterial Variance
(Production) OutputVarianceCapacityNoInventoryCapacity Variance
(Production) OutputVarianceSubcontractedNoInventorySubcontracted Variance
(Production) OutputVarianceCapacity OverheadNoInventoryCap. Overhead Variance
(Production) OutputVarianceManufacturing OverheadNoInventoryMfg. Overhead Variance
(Production) OutputVarianceMaterial-Non InventoryNoInventoryMaterial Non-Inventory Variance Account
(Production) OutputRevaluationNoInventoryInventory Adjmt.
(Production) OutputRoundingNoInventoryInventory Adjmt.
Assembly Output

Learn more at Assembly output.
Direct CostNoInventoryInventory Adjmt.
Assembly OutputRevaluationNoInventoryInventory Adjmt.
Assembly OutputIndirect CostNoInventoryOverhead Applied
Assembly OutputVarianceMaterialNoInventoryMaterial Variance
Assembly OutputVarianceCapacityNoInventoryCapacity Variance
Assembly OutputVarianceCapacity OverheadNoInventoryCap. Overhead Variance
Assembly OutputVarianceManufacturing OverheadNoInventoryMfg. Overhead Variance
Assembly OutputRoundingNoInventoryInventory Adjmt.

From the Capacity Ledger

The following table shows the relationship between different types of capacity value entries and the accounts and balancing accounts in the general ledger. Capacity ledger entries represent labor time consumed in assembly or production work.

Work TypeCapacity Ledger Entry TypeValue Entry TypeAccountBalancing Account
Assembly

Learn more at Assembly consumption.
ResourceDirect CostDirect Cost AppliedInventory Adjmt.
AssemblyResourceIndirect CostOverhead AppliedInventory Adjmt.
Production

Learn more at Production consumption.
Machine Center/Work CenterDirect CostWIP AccountDirect Cost Applied
ProductionMachine Center/Work CenterIndirect CostWIP AccountOverhead Applied

Assembly costs are always actual

As the table shows, assembly postings aren't represented in interim accounts. They're excluded because the concept of work in process (WIP) doesn't apply in assembly output posting, unlike in production output posting. Assembly costs are only posted as actual cost, never as expected cost.

Learn more at Design Details: Assembly Order Posting.

Calculating the amount to post to the general ledger

The following fields in the Value Entry table are used to calculate the expected cost amount that is posted to the general ledger:

  • Cost Amount (Actual)
  • Cost Posted to G/L
  • Cost Amount (Expected)
  • Expected Cost Posted to G/L

The following table shows how the amounts to post to the general ledger are calculated for the two different cost types.

Cost TypeCalculation
Actual CostCost Amount (Actual) – Cost Posted to G/L
Expected CostCost Amount (Expected) – Expected Cost Posted to G/L

Examples

The tables in the following sections explain the accounts in more detail. They show the posting setups that include the accounts, and how the records are used.

Assembly output

AccountBalancing account
Page: Inventory Posting Setup
Field: Inventory Account

* The Inventory Posting Group comes from the assembly item.
* The Location Code comes from the assembly order.
Page: General Posting Setup
Field: Inventory Adjustment Account

* The General Business Posting Group comes from the assembly order.
* The General Product Posting Group comes from the assembly item.
Page: Inventory Posting Setup
Fields: Material Variance, Capacity Variance Account, Capacity Overhead Variance Account, Manufacturing Overhead Variance Account

* The Inventory Posting Group comes from the assembly item.
* The Location Code comes from the assembly order.

Assembly consumption

AccountBalancing account
Page: General Posting Setup
Field: Inventory Adjmt. Account

* The General Business Posting Group comes from the assembly order.
* The General Product Posting Group comes from the component.
Page: Inventory Posting Setup
Field: Inventory Account

* The Inventory Posting Group comes from the component.
* The Location Code comes from the assembly order line.
AccountBalancing account
Page: General Posting Setup
Field: Inventory Adjmt. Account

* The General Business Posting Group comes from the assembly order.
* The General Product Posting Group comes from the resource.
Page: General Posting Setup
Field: Direct Cost Applied Account
Field: Overhead Applied Account

* The General Business Posting Group comes from the assembly order.
* The General Product Posting Group comes from the resource.

Production output

AccountBalancing account
Page: Inventory Posting Setup
Field: Inventory Account

* The Inventory Posting Group comes from the finished item.
* The Location Code comes from the production order line.
Page: Inventory Posting Setup
Field: WIP Account

* The Inventory Posting Group comes from the finished item.
* The Location Code comes from the production order line.

Page: General Posting Setup
Field: Direct Cost Non-Invent. Applied Account

* The General Business Posting Group comes from the production order.
* The General Product Posting Group comes from the finished item.

Page: General Posting Setup
Field: Overhead Applied Account

* The General Business Posting Group comes from the production order.
* The General Product Posting Group comes from the finished item.

Page: Inventory Posting Setup
Fields: Material Variance Account, Capacity Variance Account, Cap. Overhead Variance Account, Mfg. Overhead Variance Account, Subcontracted Variance Account, Material Non-Inventory Variance Account

* The Inventory Posting group comes from the finished item.
* The Location Code comes from the production order line.

Production consumption

AccountBalancing account
Page: Inventory Posting Setup
Field: WIP Account

* The Inventory Posting Group comes from the finished item.
* The Location Code comes from the production order line.
Page: Inventory Posting Setup
Field: Inventory Account

* The Inventory Posting Group comes from the component.
* The Location Code comes from the assembly.

Page: General Posting Setup
Fields: Direct Cost Applied Account, Overhead Applied Account

* The General Business Posting Group comes from the production order.
* The General Product Posting Group comes from the work center.

Page General Posting Setup
Fields: Direct Cost Applied Account, Overhead Applied Account

* The General Business Posting Group comes from the subcontracting vendor.
* The General Product Posting Group comes from the work center.

Design Details: Inventory Costing
Design Details: Inventory Posting
Design Details: Expected Cost Posting
Managing Inventory Costs
Finance
Work with Business Central

Find free e-learning modules for Business Central here