Hi,

how to get FIFO price based on inventory date (receipt).
What session if I want to refer.
im using baan ln fp7..

TQ

Is it for costing? Is it for Inventory Analysis? or for some other purpose?

purpose:

for inventory analysis which is ( inventory valuation )
I need to customize that report using crystal report because finance user want to look FIFO Price based on inventory date.

You can set valuation method by item warehouse combination in whwmd2510m000

we already setting valuation method. now I want to customize report.
What session involved?
For now, finance user just look at valuation report. but in valuation report the data ( price ) not separate by FIFO.
they want me to customize it that report by separate inventory date and price based on fifo.
please help me

Standard uses session Perform Inventory Valuation whinh1210m000

hi ,

standard session , for stock valuation whinh1210m000, its cumulative for stock qty with the stock value .
it serves the purpose to have overall stock value .. it gives macro view for logistic user to know their on hand value ...
if you using lot price, you can try customize report from lot price.

Trying to understand...
Are you saying inventory valuation report (whina1210m000) is not showing FIFO price even after setting up inventory valuation method (whina1100m000) as FIFO for the warehouse and because of this you are creating the crystal report ?
You could do a FIFO report,will require some work. Table whinr112 could help.

Note: Sessions referred above are from 5c

hai,

based on report perform inventory valuation the qty and the cost is lumsum.
we want to separate the qty and the price based on inventory date or receipt.
that why i to customize it using crystal report, but i don't which database table should i pickup.
please see the attachment.

need ur help....

Hi ,

u should use Lot Price .
use table twhltc100 & twhltc101.

Thank you