Options

Valued qty in value entries table

johnson_alonsojohnson_alonso Member Posts: 690
edited 2006-02-27 in Navision Financials
Dear all,
I have a problem that relates to FIFO costing method in navision especially to understand some fields on the value entries table of a purchased item that has FIFO costing. the item itselfs is included in the product item's BOM. The value entries table is as follows (but it's only the fields that I can't understand):
Item ledger entry type Entry type cost/unit valued qty invoiced qty
purchase direct 3000 1 1
purchase direct 20000 10 10
consumption direct 3000 -0.5 -0.5
consumption direct 2048 -0.5 -0.5
consumption direct 2048 -0.5 -0.5
consumption direct -48 -0.5
consumption direct 952 -0.5

in unit cost field on invoicing tab of the item at first is 1000 LCY. But I change direct unit cost excl. VAT to 3000 in the first PO, then I create second PO with new direct unit cost excl. VAT to 2000. before, invoicing production order, the purchased item's average cost/unit is 2048 LCY, the fields that I can't understand is cost per unit especially the numbers -48 and 952, and emptied invoiced qty on the 2 last rows. how the numbers come in the cost per unit and why the invoiced qty is empty in the 2 last rows?
#-o :-k

rgds,
Johnson Alonso

"Mary Tyler Moore, losing you is painfully unacceptable"
Sign In or Register to comment.