Shekhar: Dynamics AX 2009 – Inventory – GL integration

[Blog bot]

Источник: http://shekhardiptiman.spaces.live.c...B978!233.entry
==============

Sales order TAB

Group : Packing Slip:

Packing Slip & Packing Slip Offset Accounts : Both are BALANCE SHEET type accounts.

Packing Slip is Inventory Clearing account which has “delivered but un invoiced” transactions posted.

Packing slip offset account is AR Clearing account.

These two accounts are optional to be setup and are required only if the company wishes to POST the delivery Notes to GL.

Group : Invoice:

Issue : This is inventory ISSUE account of type BALANCE SHEET.

Consumption : This is COGS accounts of Type Profit & Loss account.

Revenue : Sales revenue is a Profit & Loss type account.

Discount : This can be made same as the Revenue account Its of Type Profit & Loss. If the company wishes to have the discounts monitored separately then a separate chart of account should be used other than Revenue.



The above accounts can be maintained specific per Item group for analysis if the company wishes.



Group Commission :

Commission: It is a Profit & Loss type expense account for capturing commissions . Generally one account is sufficient for capturing commissions for all the Item groups.

Commission Offset: It is a BALANCE SHEET Type account for capturing Commissions Payable. Generally one account is sufficient for capturing commissions payable for all the Item groups.

Purchase Order TAB :

Group : Packing Slip:

Packing Slip & Packing Slip Offset Accounts :Both are BALANCE SHEET type accounts.

Packing Slip is Inventory Clearing account which has “Received but un invoiced” transactions posted.

Packing slip offset account is AP Clearing account.

These two accounts are optional to be setup and are required only if the company wishes to POST the delivery Notes to GL.

Group : Invoice:

Receipt : This is inventory Receipt account of type BALANCE SHEET. Item Group wise receipt account can be maintained for better clarity. This account can be made same as the ISSUE account but for better clarity it is made different and the “Issue + Receipt” accounts balances are used for knowing the inventory value at hand.

Discount: This is Vendor Discount account of Type Profit & Loss .



Group : Credit Adjustment Note

Consumption : It is a Profit & Loss type expense account which is used to post the difference of the actual purchase price and the return price in case of vendor returns. One account is enough to capture posting for all items.

Group Standard Cost price:

Standard Cost Profit: It is a Profit & Loss type account to capture the postings for Inventory cost adjustments if they have different cost than the Std Cost . Profit means if the std cost was @10 and the purchase was done @ 8 then $2 is Standard Cost Profit.

Standard cost loss: It is a Profit & Loss type account to capture the postings for Inventory cost adjustments if they have different cost than the Std Cost .

Standard cost price offset : This is configured as same as Inventory receipt account and is of type BALANCE SHEET. This way the purchase receipts at the actual purchase order price is posted to the inventory receipt account .



Inventory TAB :

Group : Inventory Journals

Issue : This is inventory ISSUE account of type BALANCE SHEET. SAME AS IT IS IN Sales order TAB

Receipt : This is inventory Receipt account of type BALANCE SHEET. SAME as it is in Purchase order TAB.

Profit :It is a Profit & Loss type account.. to book inventory profit for a transaction ( inventory adjustment account)

Loss :It is a Profit & Loss type account.. to book inventory loss for a transaction ( inventory adjustment account)

Generally only ONE account is maintained for PROFIT and LOSS



Group : Standard cost price

Standard cost profit : Same corresponding account as it is on the Purchase TAB

Standard cost loss : Same corresponding account as it is on the Purchase TAB





































Источник: http://shekhardiptiman.spaces.live.c...B978!233.entry