FIFO/AVERAGE COST PROBLEM

yemi_tujoye

Help.The items in our inventory use the FIFO costing method,and they are in differrent locations.The issue now is that on raising a sales invoice for these items,the system uses the average cost method and assigns the average cost of these items as the unit cost on the sales invoice line.
E.g an item may have different serial numbers,so we use item tracking,and in some cases they have different costs due to the variation in the date of buying them.on choosing this item to sell,the system averages the cost instead of selecting the unit cost that applies to a particular serial no.

Please how do i make the system select the right cost instead of using average cost for the items?

Yemi Tujoye.

bstoyano

For items with serial numbers it is recommended to use the Specific Costing Method.
You have already made entries with Average Costing Method, so I think you should create new items and set them up properly.

dimus

This is standard NAV. NAV doesn’t know the actual cost since no Item application entry(ies) has been created. Once you post a Sales invoice NAV will apply the cost from the inbound to the outbound entry.
This is the reason Statistics screen shows a Cost field as the average cost from the Item card.