Reservation Entry

nasijuannasijuan Member Posts: 8
edited 2006-07-18 in Navision Attain
Hello!
I have Reservation Entry table with to many errors (in a 3.60) :(
Can I delete all records and reconstruct these table?

Answers

  • ara3nara3n Member Posts: 9,255
    I wouldn't delete them. I would rather fix the entries that cause the problem.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • nasijuannasijuan Member Posts: 8
    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.
  • ara3nara3n Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • nasijuannasijuan Member Posts: 8
    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!.
  • nasijuannasijuan Member Posts: 8
    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).
  • DenSterDenSter Member Posts: 8,304
    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.
  • nasijuannasijuan Member Posts: 8
    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!
Sign In or Register to comment.