Microsoft Dynamics AX Posting Profile Inventory Transactions in Modules (Sub Ledgers)

Posted by Alvin You
2013.10.09 23:24 Dynamics AX

Sales order

The ledger accounts listed on the Sales order tab pertain only to the item group selected on the Overview tab. Use Packing slip accounts used only if Microsoft Dynamics AX is set to post to the ledger when goods are delivered to a customer. Once the invoice is generated, Microsoft Dynamics AX reverses the Packing slip postings. You use Commission accounts used only if commissions are set up.

Path: Inventory > Setup > Item groups

Column/Field

Description

Examples/Hints

Sales Order tab

Packing slip

If you select Post physical inventory in the Inventory model group and Post packing slip in ledger in the AR parameter, then the cost of inventory is debited to general ledger when goods are delivered.

Ledger transaction when a SO packing slip is updated:

Debit: Packing slip

Credit: Packing slip offset

Packing slip offset

If you select Post physical inventory in the Inventory model group and Post packing slip in ledger in the AR parameter, then the cost of inventory is credited to general ledger when goods are delivered.

Ledger transaction when a SO packing slip is updated:

Debit: Packing slip

Credit: Packing slip offset

Issue

Cost of inventory is credited to general ledger when goods are invoiced. The packing slip postings are reversed.

Ledger transaction when a SO invoice is updated:

Debit: Packing slip offset

Credit: Packing slip

Debit: Cost of Goods Sold

Credit: Inventory

Consumption

Cost of inventory is debited to general ledger when goods are invoiced. The packing slip postings are reversed.

Ledger transaction when a SO invoice is updated:

Debit: Packing slip offset

Credit: Packing slip

Debit: Cost of Goods Sold

Credit: Inventory

Revenue

Sales amount is credited to general ledger when goods are invoiced. The packing slip postings are reversed.

Ledger transaction when a SO invoice is updated:

Debit: Packing slip revenue Credit: Packing slip rev offset Debit: A/R Summary

Credit: Revenue

Discount

If a discount ledger account is specified, the discount amount is debited and the A/R summary account is debited with (Sales – Discount). If an account is not specified then both the revenue and A/R summary account post as (Sales – discount). Posting occurs when goods are invoiced.

Note: This does not include cash discounts. Cash discounts are not recognized until the payment is processed.

Debit: AR Summary (Sales-Disc) Debit: Discount

Credit: Revenue

Commission

Commission amount is debited to general ledger when goods are invoiced.

Ledger transaction when a SO invoice is updated:

Debit: Commission expense Credit: Commission liability

Commission offset

Commission amount is credited to general ledger when goods are invoiced.

Ledger transaction when a SO invoice is updated:

Debit: Commission expense Credit: Commission accrual

 

 

 

Purchase order

The accounts listed on the Purchase order tab pertain only to the item group selected on the Overview tab. Use Packing slip accounts only if Microsoft Dynamics AX is set to post to the ledger when goods are delivered. Microsoft Dynamics AX reverses the Packing slip postings when the invoice is received. Use Standard cost accounts only if inventory is valued at standard cost.

Path: Inventory > Setup > Item groups

Column/Field

Description

Examples/Hints

Purchase order tab

Packing slip

If you select Post physical inventory in the Inventory model group and Post packing slip in ledger in the AP parameter, then the cost of inventory is debited to general ledger when goods are received.

Ledger transaction when a PO packing slip is updated:

Debit: Goods received

Credit: Purchases clearing

Packing slip offset

If you select Post physical inventory in the Inventory model group and Post packing slip ledger in the AP parameter, then the cost of inventory is credited to general ledger when goods are received.

Ledger transaction when a PO packing slip is updated:

Debit: Goods received

Credit: Purchases clearing

Receipt

If you select Post financial inventory in the Inventory model group, then the cost of inventory is debited to general ledger when goods are invoiced. The packing slip postings are reversed.

Ledger transaction when a PO for an inventory item is invoiced:

Debit: Packing slip offset

Credit: Packing slip

Debit: Receipt (Inventory) Credit: A/P Summary

Discount

If you specify a discount ledger account , the discount amount is credited and the A/P Summary account is credited with (Purchase amount – Discount). If an account is not specified, both the Debit and Credit accounts post as Purchase amount – discount. Posting occurs when the invoice is updated.

Note: This does not include cash discounts. Cash discounts are not recognized until the payment is processed.

Debit: Receipt or consumption Credit: A/P Summary

Credit: Discount

Consumption

If you select Post financial inventory in the Inventory model group, then the Variance on item returns is posted to general ledger when the return price varies from the inventory cost price If you do not select Post financial inventory in the Inventory model group, then the purchase price is debited to general ledger when goods are invoiced.

Ledger transaction when a PO invoice is updated for a non-stock or service item:

Debit: Purchase expense Credit: A/P Summary

Fixed receipt price profit

Credit cost variance when actual cost is lower than standard cost. Used if model group is set up to use standard cost.

Debit: Inventory – Actual Cost Debit:Std cost price offset-var. Credit: A/P Summary – Actual Credit: Std cost profit -variance

Fixed receipt price loss

Debit Cost variance when actual cost is higher than standard cost. Used if model group is set up to use standard cost.

Debit: Inventory – Actual Cost Debit: Std loss –variance

Credit: A/P Summary – Actual Credit: Std cost profit offset-var

Fixed receipt price offset

Use this account to offset the standard cost profit or loss.

Often this account is the same as the inventory account.

 

Inventory

The accounts listed on the Inventory tab pertain only to the Item group selected on the Overview tab. The Standard cost accounts are used only if inventory is valued at standard cost.

Path: Inventory > Setup > Item groups

Column/Field

Description

Examples/Hints

Inventory tab

Receipt

Debit increases to the inventory account.

Inventory journal transaction to record the receipt or increase in inventory:

Debit: Receipt (Inventory) Credit: Profit

Issue

Credit decreases to the inventory account.

Inventory journal transaction to record the issue or decrease in inventory:

Debit: Loss

Credit: Issue (Inventory)

Profit

Credit increases to the inventory account.

Inventory journal transaction to record the receipt or increase in inventory:

Debit: Receipt (Inventory)

Credit: Profit

Loss

Debit decreases to the inventory account.

Inventory journal transaction to record the issue or decrease in inventory:

Debit: Loss

Credit: Issue (Inventory)

Fixed receipt price profit

Credit the gained difference in relation to Standard cost. Offset to Inventory Profit or loss. Used if model group is set up to use standard cost.

Inventory journal transaction to record the receipt or increase in inventory:

Debit:Receipt (Inventory@Std cost)

Credit: Std cost profit (Variance) Credit: Profit (Actual cost)

Fixed receipt price loss

Debit the loss difference in relation to Standard cost. Offset to Inventory Profit or loss. Used if model group is set up to use standard cost.

Inventory journal transaction to record the receipt or increase in inventory:

Debit:Receipt (Inventory@Std cost)

Debit: Std loss (Variance)

Credit: Profit (Actual cost)

Fixed asset issue

Account to be debited if item is issued to a fixed asset.

Rounding variance

Account to be debited/credited due to rounding issues.

 

Production

The accounts listed on the Production tab pertain only to the Item group selected on the Overview tab. The Picking list and Report as finished accounts are used only if Microsoft Dynamics AX is set to post "work in process" to the ledger. The Picking list accounts are used to record the estimated costs of raw materials during the production process. The Report as finished accounts are used to record the estimated cost of the finished good. Both Picking list and Report as finished account postings are reversed when the final item calculation is performed. The Issue accounts record the actual cost of raw materials used in production. The Receipt accounts record the actual cost of the finished good that is being received into inventory.

Path: Inventory > Setup > Item groups

Column/Field

Description

Examples/Hints

Production tab

Picking list

If Post physical inventory in the Inventory model group and Post picking list in ledger in the Production parameters are selected, then the estimated cost of raw material inventory is credited to general ledger during the Picking list update.

The picking list journal is used to record the estimated materials needed for a production order. It can be created manually or automatically by back-flushing. Debit: Picking list offset

Credit: Picking list (Inventory)

Report as finished

If the Post report as finished in ledger in the Production parameters is selected, the estimated value of the finished good is debited to general ledger during the Report-as-finished update.

The Report-as-finished journal is used to record quantities completed

Debit: Report as finished (Inv) Credit: Report as finished Offset

Picking list offset account

If Post physical inventory in the Inventory model group and Post picking list in ledger in the Production parameters are selected, then the estimated cost of raw material inventory is debited to general ledger during the Picking list update.

The picking list journal in the Production module can be created manually or automatically. See Production setup section for more information.

Debit: Picking list offset (WIP) Credit: Picking list

Reported as finished offset account

If the Post report as finished in ledger in the Production parameters is selected, then the estimated value of the finished good is credited to general ledger during the Report-as-finished update.

The Report-as-finished journal is used to record quantities completed.

Debit: Report as finished (Inv) Credit: Report as finished Offset

Issue

When a production order is costed, the estimated material costs previously posted are reversed. The actual cost of raw materials is credited in the general ledger.

Debit: Issue offset (WIP)

Credit: Issue (Inventory-raw material)

Issue offset account

When a production order is costed, the estimated material costs previously posted are reversed. The actual cost of raw materials is debited in the general ledger.

Debit: Issue offset (WIP) Credit: Issue (Inventory-raw material)

Receipt

When a production order is costed, the report-as-finished estimated finished good costs are reversed. The actual cost of the finished good is debited in the general ledger.

Debit: Receipt (Inventory - FG) Credit: Receipt offset account (WIP)

Receipt offset account

When a production order is costed, the report-as-finished estimated finished good costs are reversed. The actual cost of the finished good is credited in the general ledger.

Debit: Receipt (Inventory - FG) Credit: Receipt offset account (WIP)

원본 위치 : http://dynamicssoftware.blogspot.kr/2009/11/microsoft-dynamics-ax-posting-profile.html

신고
이 댓글을 비밀 댓글로