ayoobi
29th August 2005, 17:25
Hi Guys,

We can get the last operation of a production order from production planning data (tisfc010). But when the order is closed records are deleted from tisfc010. But if i want to know what is the last operation of a closed production order . Is there any other table from which i can get this information directly or indirectly ?

We are on Baan 5 b.

Thanks and Regards
Ayoobi

mark_h
29th August 2005, 18:24
On our system we have ticst030 that we used for closed orders - not sure if you have the same on your system.

ayoobi
30th August 2005, 09:22
Thanks Mark ! This table is there in our system too . But can I take the operation who actual start date is latest as the last operation ?

Thanks and Regards
Ayoobi

mark_h
30th August 2005, 21:35
Depends on your production order set-up. I usually search for the order, sort descending by operation and only get one row. That is how I find the last operation. On our system we could have operations that run at same time - not many and I can not recall seeing one, but this is what I was told by our assemblers.

ayoobi
1st September 2005, 13:15
We have quite a few production orders whose higest operation number is not the last operation . So i guess i will have to use the actual start date/time to find the last operation of the production order.

Thanks once again for your help