The direct settlement principle used in this version of Microsoft Dynamics AX is the same used for weighted average in previous versions. The system will settle directly between receipts and issues. Microsoft Dynamics AX uses this direct settlement principle in certain specific situations:

• One receipt and one or several issues has been posted in the period

• Only issues have been posted in the period and the inventory contains on-hand items from a previous closing

In the scenario below, a financially updated receipt and issue have been posted. During inventory close, Microsoft Dynamics AX will settle the receipt directly against the issue, and no adjustment to the cost price is needed on issue.

The following transactions are illustrated in the graphic below:

• 1a. Inventory physical receipt updated for a quantity of 5 at USD 10.00 each

• 1b. Inventory financial receipt updated for a quantity of 5 at USD 10.00 each

• 2a. Inventory physical issue updated for a quantity of 2 at USD 10.00 each

• 2b. Inventory financial issue updated for a quantity of 2 at USD 10.00 each

• 3. Inventory close is performed using the direct settlement method to settle the inventory financial receipt to the inventory financial issue.

The following diagram illustrates this series of transactions with the effects of choosing the Weighted average inventory model and the direct settlement principle without the Include physical valueoption.

Key to diagram

• Inventory transactions are represented by vertical arrows.

• Receipts into inventory are represented by vertical arrows above the timeline.

• Issues out of inventory are represented by vertical arrows below the timeline.

• Above (or below) each vertical arrow, the value of the inventory transaction is specified in the format Quantity@Unit price.

• An inventory transaction value surrounded by brackets indicates that the inventory transaction is physically posted into inventory.

• An inventory transaction value without brackets indicates that the inventory transaction is financially posted into inventory.

• Each new receipt or issue transaction is designated with a new label.

• Each vertical arrow is labeled with a sequential identifier, such as 1a. The identifiers indicate the sequence of inventory transaction postings in the timeline.

• Inventory closings are represented by a red vertical dashed line and the label Inventory Close.

• Settlements that are performed by inventory close are represented by dotted red arrows going diagonally from a receipt to an issue.

In this version of Microsoft Dynamics AX, a new settlement principle has been introduced for weighted average based on the principle that all receipts within in a closing period are summarized into a new inventory transfer transaction called Weighted average inventory closing. All the receipts for the period will be settled against the issue of the newly created inventory transfer transaction. All issues for the period will be settled against the receipt of the new inventory transfer transaction.

If the on-hand inventory is positive after the inventory close, that on-hand inventory and value of the inventory are summarized on the new inventory transfer transaction (receipt).

If the inventory on-hand is negative after the inventory close, the on-hand inventory and value of the inventory is the sum of individual issues that have not been fully settled.

In the scenario below, several financially updated receipts and one issue have been posted.

During inventory close, Microsoft Dynamics AX will generate and post the summarized inventory transfer transaction in order to settle all the receipts for the period against the summarized inventory transfer issue transaction. All the issues posted for the period will be settled against the summarized inventory transfer receipt transaction. The weighted average is calculated to be USD 15.00.

Because the issue was originally posted with an estimated cost price of USD 14.67, an adjustment of negativeUSD 0.33 will be created and posted on the issue. As of the inventory closing date, the on-hand inventory is 3 pieces with a value of USD 45.00.

The following transactions are illustrated in the graphic below:

• 1a. Inventory physical receipt updated for a quantity of 2 at a cost of USD 11.00 each.

• 1b. Inventory financial receipt updated for a quantity of 2 at a cost of USD 14.00 each.

• 2a. Inventory physical receipt updated for a quantity of 1 at a cost of USD 12.00 each.

• 2b. Inventory financial receipt updated for a quantity of 1 at a cost of USD 16.00 each.

• 3a. Inventory physical issue updated for a quantity of 1 at a cost of USD 14.67 each (running average).

• 3b. Inventory financial issue updated for a quantity of 1 at a cost of USD 14.67 each (running average).

• 4a. Inventory physical receipt updated for a quantity of 1 at a cost of USD 14.00 each.

• 4b. Inventory financial receipt updated for a quantity of 1 at a cost of USD 16.00 each.

• 5. Inventory close is performed.

• 6a. "Weighted average inventory close transaction" financial issue is created to sum the settlements of all the inventory financial receipts.

• 6b. "Weighted average inventory close transaction" financial receipt is created as the offset to 5a.

The following diagram illustrates this series of transactions with the effects of choosing the Weighted average inventory model and the summarized settlement principle without the Include physical valueoption.

Key to diagram

• Inventory transactions are represented by vertical arrows.

• Receipts into inventory are represented by vertical arrows above the timeline.

• Issues out of inventory are represented by vertical arrows below the timeline.

• Above (or below) each vertical arrow, the value of the inventory transaction is specified in the format Quantity@Unit price.

• An inventory transaction value surrounded by brackets indicates that the inventory transaction is physically posted into inventory.

• An inventory transaction value without brackets indicates that the inventory transaction is financially posted into inventory.

• Each new receipt or issue transaction is designated with a new label.

• Each vertical arrow is labeled with a sequential identifier, such as 1a. The identifiers indicate the sequence of inventory transaction postings in the timeline.

• Inventory closings are represented by a red vertical dashed line and the label Inventory Close.

• Settlements that are performed by inventory close are represented by dotted red arrows going diagonally from a receipt to an issue.

• Red arrows illustrate the receipt transactions being settled to the issue transaction created by the system.

• The green arrow represents the offsetting system-generated receipt transaction to which the originally posted issue transaction is settled

In this version of Microsoft Dynamics AX, the parameter Include physical valueworks differently with the weighted average inventory model than in previous versions of the product.

If the Include physical valuebox is selected for an item in the Inventory model groupform, Microsoft Dynamics AX will use physically updated receipts when calculating the estimated cost price, or running average. Issues will be posted based on this estimated cost price during the period. During the inventory close, financially updated receipts only will be considered in the weighted average calculation.

We recommend a monthly inventory close when you use the weighted average inventory model.

In this weighted average direct settlement example, the inventory model group is marked to include physical value.

The following transactions are illustrated in the graphic below:

• 1a. Inventory physical receipt updated for a quantity of 1 at a cost of USD 11.00 each.

• 1b. Inventory financial receipt updated for a quantity of 1 at a cost of USD 10.00 each.

• 2a. Inventory physical receipt updated for a quantity of 1 at a cost of USD 15.00 each.

• 3a. Inventory physical issue updated for a quantity of 1 at a cost of USD 12.50 each (running average cost, since the physical receipt value is taken into consideration).

• 3b. Inventory financial issue updated for a quantity of 1 at a cost of USD 12.50 each (running average cost, since the physical receipt value is taken into consideration).

• 4. Inventory close is performed. During inventory close, Microsoft Dynamics AX will disregard all inventory transactions that have been only physically updated. Instead, the direct settlement principle will be used because only one financial receipt exists. An adjustment of USD 2.50 will be posted to the inventory transaction that has been financially issued as of the inventory closing date. After inventory close, the on hand inventory will be a quantity of 1 with a running average cost price of USD 15.00.

The following diagram illustrates this series of transactions with the effects of choosing the Weighted average inventory model and the direct settlement principle with the Include physical valueoption.

Key to diagram

• Inventory transactions are represented by vertical arrows.

• Receipts into inventory are represented by vertical arrows above the timeline.

• Issues out of inventory are represented by vertical arrows below the timeline.

• Above (or below) each vertical arrow, the value of the inventory transaction is specified in the format Quantity@Unit price.

• An inventory transaction value surrounded by brackets indicates that the inventory transaction is physically posted into inventory.

• An inventory transaction value without brackets indicates that the inventory transaction is financially posted into inventory.

• Each new receipt or issue transaction is designated with a new label.

• Each vertical arrow is labeled with a sequential identifier, such as 1a. The identifiers indicate the sequence of inventory transaction postings in the timeline.

• Inventory closings are represented by a red vertical dashed line and the label Inventory Close.

• Settlements that are performed by inventory close are represented by dotted red arrows going diagonally from a receipt to an issue.

In this version of Microsoft Dynamics AX, the Include physical valueparameter works differently with weighted average than in previous versions of the program.

If the Include physical valuebox is selected for an item in the Inventory model groupform, Microsoft Dynamics AX will use physically updated receipts in the calculation of estimated cost price, or running average. Issues will be posted based on this estimated cost price during the period. During the inventory close financially updated receipts only will be considered in the weighted average calculation.

We recommend a monthly inventory close when you use the weighted average inventory model.

In this weighted average summarized settlement example, the inventory model is marked to include physical value.

The following transactions are illustrated in the graphic below:

• 1a. Inventory physical receipt updated for a quantity of 2 at a cost of USD 11.00 each.

• 1b. Inventory financial receipt updated for a quantity of 2 at a cost of USD 14.00 each.

• 2. Inventory physical receipt updated for a quantity of 1 at a cost of USD 10.00 each.

• 3a. Inventory physical receipt updated for a quantity of 1 at a cost of USD 12.00 each.

• 3b. Inventory financial receipt updated for a quantity of 1 at a cost of USD 16.00 each.

• 4a. Inventory physical issue updated for a quantity of 1 at a cost of USD 13.50 each (running average cost, since the physical receipt value is taken into consideration).

• 4b. Inventory financial issue updated for a quantity of 1 at a cost of USD 13.50 each (running average cost, since the physical receipt value is taken into consideration).

• 5a. Inventory physical receipt updated for a quantity of 1 at a cost of USD 14.00 each.

• 5b. Inventory financial receipt updated for a quantity of 1 at a cost of USD 16.00 each.

• 6.Inventory close is performed. During inventory close, Microsoft Dynamics AX will disregard all inventory transactions that are updated only physically. The summarized settlement principle will be used because only one financial receipt exists. An adjustment of USD 1.50 will be posted to the inventory transaction that has been financially issued as of the inventory closing date. After inventory close, the on- hand inventory will be a quantity of 3 with a running average cost price of USD 15.00.

• 7a. "Weighted average inventory close transaction" financial issue is created to sum the settlements of all the inventory financial receipts.

• 7b. "Weighted average inventory close transaction" financial receipt is created as the offset to 5a.

The following diagram illustrates this series of transactions with the effects of choosing the weighted average inventory model and the summarized settlement principle without the Include physical valueoption.

Key to diagram

• Inventory transactions are represented by vertical arrows.

• Receipts into inventory are represented by vertical arrows above the timeline.

• Issues out of inventory are represented by vertical arrows below the timeline.

• Above (or below) each vertical arrow, the value of the inventory transaction is specified in the format Quantity@Unit price.

• An inventory transaction value surrounded by brackets indicates that the inventory transaction is physically posted into inventory.

• An inventory transaction value without brackets indicates that the inventory transaction is financially posted into inventory.

• Each new receipt or issue transaction is designated with a new label.

• Each vertical arrow is labeled with a sequential identifier, such as 1a. The identifiers indicate the sequence of inventory transaction postings in the timeline.

• Inventory closings are represented by a red vertical dashed line and the label Inventory Close.

• Settlements that are performed by inventory close are represented by dotted red arrows going diagonally from a receipt to an issue.

• Red arrows illustrate the receipt transactions being settled to the issue transaction created by the system.

• The green arrow represents the offsetting system-generated receipt transaction to which the originally posted issue transaction is settled

Marking is a process in Microsoft Dynamics AX that allows you to link, or mark, an issue transaction to a receipt transaction. Marking can occur either before or after a transaction is posted. You can use marking when you want to be sure of the exact cost of the inventory when the transaction is posted or when the inventory close is performed.

For example, your Customer Service department accepted a rush order from an important customer. Because this is a rush order, you will have to pay more for this item to accommodate your customer's request. You would like to be certain the cost of this inventory item is reflected in the margin, or cost of goods sold (COGS), for this sales order invoice.

When the purchase order is posted, the inventory is received at a cost of USD 120.00. If this sales order document is marked to the purchase order before the packing slip or invoice is posted, the COGS will be USD 120.00 instead of the current running average cost for the item. If the sales order packing slip or invoice is posted before the marking occurs, the COGS will be posted at the running average cost price.

Before inventory close is performed, these two transactions can still be marked to each other.

When a receipt transaction is marked to an issue transaction, the valuation method selected for the item's inventory model group will be disregarded and Microsoft Dynamics AX will settle these transactions to each other.

To mark an issue transaction to a receipt before the transaction is posted, open the Sales orderform, select a transaction line, and then click the Inventorybutton on the transaction line and select Marking. The Markingform will open and display all the open receipt transactions. You can then select one of these transactions to match to, or mark, this issue transaction.

To mark an issue transaction to a receipt after the transaction has been posted, navigate to the inventory item on the Transactions on Itemform and click the Transactionbutton. Select the issue transaction that you want to mark, and then click the Inventorybutton and select Marking. The Markingform will open and display all the open receipt transactions. You can then select one of these transactions to match to, or mark, this issue transaction.

The following transactions are illustrated in the graphic below:

• 1a. Inventory physical receipt for a quantity of 1 at a cost of USD 10.00 each.

• 1b. Inventory financial receipt for a quantity of 1 at a cost of USD 10.00 each.

• 2a. Inventory physical receipt for a quantity of 1 at a cost of USD 20.00 each.

• 2b. Inventory financial receipt for a quantity of 1 at a cost of USD 20.00 each.

• 3a. Inventory physical receipt for a quantity of 1 at a cost of USD 25.00 each.

• 4a. Inventory physical receipt for a quantity of 1 at a cost of USD 30.00 each.

• 4b. Inventory financial receipt for a quantity of 1 at a cost of USD 30.00 each.

• 5a. Inventory physical issue for a quantity of 1 at a cost price USD 21.25 (running average of financial and physical updated transactions).

• 5b. Inventory financial issue for a quantity of 1 is marked to the inventory receipt 2b before the transaction is posted. This transaction is posted with a cost price of USD 20.00.

• 6a. Inventory physical issue for a quantity of 1 at a cost price of USD 21.25 each.

• 7 Inventory close is performed. Since the financially updated transaction is marked to an existing receipt these transactions are settled to each other and no adjustment is made.

The new running average cost price reflects the average of the financially and physically updated transactions at USD 27.50.

The following diagram illustrates this series of transactions with the effects of choosing the Weighted average inventory model with marking.

Key to diagram

• Inventory transactions are represented by vertical arrows.

• Receipts into inventory are represented by vertical arrows above the timeline.

• Issues out of inventory are represented by vertical arrows below the timeline.

• Above (or below) each vertical arrow, the value of the inventory transaction is specified in the format Quantity@Unit price.

• An inventory transaction value surrounded by brackets indicates that the inventory transaction is physically posted into inventory.

• An inventory transaction value without brackets indicates that the inventory transaction is financially posted into inventory.

• Each new receipt or issue transaction is designated with a new label.

• Each vertical arrow is labeled with a sequential identifier, such as 1a. The identifiers indicate the sequence of inventory transaction postings in the timeline.

• Inventory closings are represented by a red vertical dashed line and the label Inventory Close.

• Settlements that are performed by inventory close are represented by dotted red arrows going diagonally from a receipt to an issue.