June 9th, 2012 by Mohamed Aamer

Inventory costing is one of the most critical functions in business, and business applications as well, many questions are asked about inventory costing and valuation methods during the Diagnostic, Analysis, and Design phases. After going live in the Operation phase transactions are occurred daily, and inventory monthly closing is done.

 

In this post I will discuss a very important function in Inventory Costing Management of MS Dynamics AX which is Marking Function. During the daily business in inventory management there are some transactions need to be returned in same cost which it was issued, or in sales management there are some sales orders need to be issued (Cost Of Goods Sold – COGS) with specific lot cost.

Let us go through the following case:-

 

Date

Qty

Cost

Status

Cost

Avg.Cost

1/1/2012

   5.00

   100.00

Beginning Balance

   500.00

         100.00

2/3/2012

   2.00

   110.00

Purchase – Receiving

   220.00

         102.86

2/15/2012

   1.00

   100.00

Issuance-Marking

   100.00

         106.67

2/20/2012

   1.00

   102.86

Issuance

   102.86

         102.86

3/15/2012

   1.00

   110.00

Sales – Marking

   110.00

         110.00

 

We have a beginning balance (Qty=5 @ 100EGP), Inventory reception from a purchase order (Qty=2 @220EGP) so the average cost is (500+220)/(5+2)=102.86

There is an issuance (movement) need to be issued in the cost of beginning balance  

There is another issuance will be issued at current average cost

There is a sales order need to be issued in the cost of the purchase order

MS Dynamics AX Marking

 

 

 

 

 

 

 

 

 

 

 

The Marking mechanism in MS Dynamics AX is the built on transactions Lot IDs, the function is found in any inventory transaction form (Purchase Order, Sales Order, Inventory movement,…) .

The marking function could be performed manually, and or automatically.

Automatically;

–          Purchase Order return, when creating a credit note that will withdraw quantities from the warehouse in the same cost.

–          Sales order which has linked Purchase order, where marking the sold quantities cost to the received quantities

Manually

–          Sales order line could be manually marked to a specific reception transaction

–          Movement Journal In/Out could be manually marked to a specific reception transaction

 

Facebook user group: DynamicsArabia

Tags: , , , ,
Posted in Microsoft Dynamics, MS Dynamics AX | Comments Off on MS Dynamics AX Inventory Marking function
Comments are closed.