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

Posted by Alvin You
2013.10.09 23:24 Dynamics AX
크리에이티브 커먼즈 라이선스
Creative Commons License

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

신고
이 댓글을 비밀 댓글로

MS Dynamics AX 2012 Posting Profile Concept

Posted by Alvin You
2013.10.09 23:12 Dynamics AX
크리에이티브 커먼즈 라이선스
Creative Commons License

The posting profiles are the integration point between the sub module (Fixed assets, Payables, Inventory, Banks, Receivables, Project, and Production) and general ledger sub module, it is a set of ledger accounts which are used in generated an automatic ledger entry where transaction occurred. We could select different ledger accounts for each type of sub modules transactions.

The application consultant working with the controller in several workshops during the implementation phases, in the analysis phase to identify the business requirements in financial directions, in the design phase to identify the integrations point through the posting profiles for each module, in the deployment phase apply the posting profile in MS Dynamics AX 2012 and get the user acceptance (UAT) by testing every transaction and ensure that MS Dynamics AX 2012 is generate the correct entry based on the posting profile setup.

MS Dynamics AX 2012 master data are designed to be contained a group for categorization from the sub module point of view, for example the customer groups are build up considering two main sides first side is the customers categorizations for sales reporting (Business domain, Company relations, Customer size, import, and export), and the second side is financial direction, whether setting up the posting profiles based on customer groups where each customer group is mapped into a ledger account.

MS Dynamics AX offers a great flexibility in posting profiles setups where the posting could be on three different levels as the following:-

All Any transaction occurred on any customers will be directed to the ledger account which assigned to all customer
Group Any transaction on a particular customer inherits the posting profile of the customer group to which the customer is assigned.
Table Any transaction occurred on a particular customer will be directed to the ledger account which is assigned in the posting profile

The controllers have a common question during the design phase which level of All, Group, and Table is dominate over the other level, and do we can to assign customer to a specific group, but exceptionally this customer should be directed to another ledger account.

The logic of posting profile domination in MS Dynamics AX 2012 is working as the following, the lowest level is Table where specify customer ID is dominate over Group, and All.

MS Dynamics AX 2012 posting profile

For example: All customers directed to same ledger account, except one group is directed to another ledger account, exceptionally one customer directed to a third ledger account.

User group: DynamicsArabia

- 원본 위치: http://blog.mohamedaamer.com/microsoft-dynamics/ms-dynamics-ax-2012-posting-profile-concept/

신고
이 댓글을 비밀 댓글로

티스토리 툴바