Reservation Entry

nasijuan

Hello!
I have Reservation Entry table with to many errors (in a 3.60)
Can I delete all records and reconstruct these table?

ara3n

I wouldn't delete them. I would rather fix the entries that cause the problem.

nasijuan

It's hard to fix the problem due to the amount of information that there is. Possibly there are information of the 2003
or the 2004 or reserves that no longer have sense.

ara3n

Write a routine that will try to find the related records if it doesn't find them then delete them. If they date is from 2003 etc. and you are absolutely sure there are not records from that date you can delete them. It's safe. I know 3.6 left a lot of orphaned entries. It was frustrating to clean them up. I think everybody went through a lot of pain with serial no. in 3.6. I would suggest any client that is on 3.6 with serial no to upgrade to 4.0.

nasijuan

Luckyly in this case we don't work with serial numbers nor with
lot numbers.
What if is certain it is that reservation entry table haves many orphaned and 'splited' movements without sense.
In any case I would avoid working to write a routine to reconstruct the
table by the hard analysis work that it requires and never is well paid.
Anyway i will try to write a routine that you suggest and I will tell you the results.
Thanks a lot!.

nasijuan

Hi:
Maybe I are wrong but if I delete all Item's entries in Reservation Entry Table and after I run Planning Worksheets --> Functions --> Calculate regenarative plan --> filtered by the Item no. and with Order date = Today and Ending Date 12/31/2007 for ex. the system regenerates all items' entries in Reservation Entry.
Itme no. was configurated with 'Order tracking policy' = 'Tracking & Act. Msg.' and 'Requisition System' = 'Prod. Order'.
What do you think about?
(It seems works in the same way when the item's requisition system is Purchase and you run Requisition worksheets --> functions --> Calculate plan).

DenSter

If you just delete all records in that table, you will lose all reservations as well, so you'd have to re-reserve your orders in addition to running MRP.

nasijuan

Hi:
By the moment I solved the situation making the follwing steps:
1. Delete all the entries of an specific item.
2. Run MRP regenerative for this Item. Reservation Entry is regenerated.
3. Reservation entry makes entries with Reservation Status like 'Tracking' or 'Surplus', against Sales Line, Item ledger entry, Transfer Line. Then if I change 'Tracking' with 'Reservation' (both entries positive and negative) of Sales line's entries we get sales reservation.
We did that item by item until we see that is correct.
Thanks!