Skip to main content

Hi colleagues,

It’s interesting that I can see that Lot usage doesn’t guarantee link with appropriate cost.

What am I doing wrong?

Example:

Inventory receive 1 | qty 2 | unit cost 50 | lot 3107-01

Inventory receive 1 | qty 2 | unit cost 56 | lot 3107-02

Inventory receive 1 | qty 2 | unit cost 59 | lot 3107-03

Inventory issue 1 | qty 1| unit cost 50 | lot 3107-03

Frankly, I expected unit cost 59 because of the lot 3107-03.

Attached are settings and transactions fragments.

 

Using FIFO as you show, the system will relieve inventory at the cost of the earliest receipt (transaction ID 231, cost = 50), regardless of which lot is issued.

If you were using Weighted Average and Cost per Lot Batch, the system would have done what you expected, relieving inventory at the cost associated with the lot being issued.

 


Indeed, it works properly with Weighted Average+Cost per Lot.

Thank you, ​@matt.watters .


Dear ​@matt.watters ,

It might be you have the answer for FIFO method usage without Lot or Serial.

In attachments you can find 4 inventory operations: 2 receives , 1 movement and 1 issue.

In issue the cost is correct 50. In movement I expected 50 as well. But actually there is 54 average.

Is there a way to make system use FIFO in movement operations as well?

 


No, FIFO does not pertain to movements, only transactions into and out of inventory. Inventory moves are ‘costed’ at the current Unit Cost of the on-hand inventory.

As you are doing these transactions, you should also be looking at the changes to the Unit Cost and Total Inventory Value in the Inventory Parts in Stock page and also monitor the Fifo/Lifo Cost Analysis page.

Just to summarize, and assuming starting inventory was zero.

  • After transaction 242 you had 2 on hand, Unit Cost = 50, Total Inventory Value = 100.
  • After transaction 243, you had 4 on hand, Unit Cost = 54, Total Inventory Value = 216.
  • Transactions 244, 245 (moving inventory) were costed correctly at 54 and had no effect on the Unit Cost or the Total Inventory Value of on-hand inventory. These remained at 54 and 216, respectively.
  • Transaction 246, the Issue, was costed correctly at 50 as this relates to the cost of transaction 242.

@matt.watters thank you very much.


Reply