fredintaiwan
23rd June 2011, 08:16
Hello,

The current Inventory evaluation method is BaaN standard cost based on Fixed Transfer Price Unit(ftp). At this point, would like to know the actual cost by each SALES ORDER and the actual cost of EACH LOT. I would like to know what tables/fields/sessions keep the ACTUAL COST OF EACH LOT and Sales order.

Following are the pre-requisites
1) Would like to keep the current Inventory valuation method as FTP.
2) Do not want to change the current business process and procedures.

This request is just to know the actual cost of Lot and Sales Order for profit management purposes.

Thanks!!
Fredrick.

trisulo
23rd June 2011, 10:27
did you used manufacturing/shop floor control module?
if yes find out on that table. tisfcxxx

fredintaiwan
24th June 2011, 05:35
Hello,

Thanks for your response.

We are using the SFC module.

Regards,
Fredrick

Hitesh Shah
25th June 2011, 07:01
In Baan IV , the lot tables tdltc001 , tdltc004 and tdilc102/4/6 used to store information relating to lots , lot prices (valuation method lot price) , lot results and lot tracking. AFAIK this is not changed in Baan V too . The tables along with ticst/sfc/hra tables may help u develop the actual cost reports.

fredintaiwan
26th June 2011, 13:57
Thanks Hitesh for your response.

Since the valuation method is FTP, could you please let me know which tables will help me to arrive at the Actual Price per lot. Incase you do not have access to Baan V, please let me know the same in Baan IV.

Appreciate your help and thanks in advance.