We have items that need to be reworked every month or so. We do not use lot control, and when these items go through rework we issue a rework production order. The item then gets a new inventory date when the rework order is complete (which is a good thing and a bad thing). A report runs daily showing all items older than 30 days (based on the new inventory date of the reworked item) - and that is how we know when it is time to rework.

While we do like the fact that Baan stamps the item with the new inventory date - we actually need to keep track of the original date as well - because we run into problems where we lose visibility of the original manufacture date and FIFO becomes impossible to manage - and we end up scrapping the material.

Has anyone else run into this issue - and if so, is there a workaround? I guess we actually need to track 2 dates – original manufacture date and new reworked date (which is only used for the 30 day old report)

I would say : use Lot control.....
and consequently change your report to use the 'lot-dates'


Another option might be to change your report in such a way that it 'collects' all warehousetransactions and use the qss.sort and qss.search options to 'track' your original receipt date. (inventory date links inventory to the rework order so your 'real'inventory date is the date of the last order before the 'rework' order ? )

We do not want to use lot control - because we are not using it on other product lines, and because we have a "KISS" approach to this system (keep it simple). When we were on Baan 4 we used LTC and the # of steps to get through each transaction was huge.

In Baan IVc 4
If you have location history enabled (check location parameters) and you were manually issuing the item to the new re-work order, that information would be stamped in the location history table.

You could build a report based on tdilc301 (Baan IVc 4) that would show :

Item A: Inventory Date: Nov 01, 2003
manufactured on Production Order 123

Item A: Inventory Date : Nov 01, 2003
Issued to Production Order 126
Item A: Inventory Date : Dec 04, 2003
manufactured on Production Order 126

Item A: Inventory Date : Dec 04, 2003
Issued to Production Order 212
Item A: Inventory Date : Jan 10, 2004
manufactred on Production Order 212

and so on,
if Baan 5b tracks the history at the same level of detail as Baan IVc 4, you should be able to make this work.

Note, multiple items (quantity > 1) on any inventory date, might make this not work.

John