HI friends,
I am working on Nav 4.0 SP3
INventory costing manual 4.0 , Chapter - III , Page - 17 according to this chapter the below statement :
when it comes Navision costing manual it tells when u sold or issue the material firast it will take the Averae cost for Cost amount , then when u run the Batch job then it will adjust the costs actual.
For FIFO , Average , Standard, specific - it will take Average cost
My setups are .
Ne w item = Cost FIFO , costing method = FIFO
Inventory setup :
Automatic cost adjustmnet = No
Automatic cost posting = Yes
Expected cost posting = No
i purchased the item Cost FIFO with different dates and different rates ( 3 transactions)
Receipt & Invoice concept
Item ledger entry :
Posting date Item Name qty Cost amount ( actutal
01/01/01 Cost FIFO 1 1000
02/01/01 Cost FIFO 1 2000
03/01/01 Cost FIFO 1 3000
so In item card Unit cost field has the value = 1000 ( even i post 3 the transactions )
Now it comes to sale :
Ship & invoiced concept.
Item ledger entry Transactions :
Posting date Item Name qty cost amount Sales Amout
020202 Cost FIFO 1 1000 2000
030303 Cost FIFO 1 1000 3000
So system has taken the Unit cost vallue when i sell the item s on 02/02/02.
My doubt is which cost will take the system at first when u do sale/ issue/ consumption ?
is it average or Unitcost in Item card .
I done the same transactions for another new item with costing method = Average.
For this item also it is taking the Unit cost only.
Please clarify about this doubt.
My doubt is which cost will take the system at first when u do sale/ issue/ consumption ?
is it average or Unitcost in Item card .