cleaning up reservation entry

generic
Member Posts: 511
Hello when MRP runs, it creates thousands of entries in reservation entry.
Looking at code it actually deletes all existing reservation entries based on the following logic before running MRP.
I was wondering that you could run the same process at the end and get rid of all the tracking entries.
All they cause is headache. We are getting constantly errors with this reservation does not exists, this PO does not exists when deleting Requisition lines. It's great that tracking tries to keep track as demand and supply but the code is not fixed. This is version 4.0 sp3.
Looking at code it actually deletes all existing reservation entries based on the following logic before running MRP.
I was wondering that you could run the same process at the end and get rid of all the tracking entries.
All they cause is headache. We are getting constantly errors with this reservation does not exists, this PO does not exists when deleting Requisition lines. It's great that tracking tries to keep track as demand and supply but the code is not fixed. This is version 4.0 sp3.
Name DataType Subtype Length ActionMsgEntry Record Action Message Entry ReservEntry Record Reservation Entry
DeleteTracking(VAR Item : Record Item) ActionMsgEntry.SETCURRENTKEY("Reservation Entry"); WITH ReservEntry DO BEGIN RESET; SETCURRENTKEY("Item No.","Variant Code","Location Code","Reservation Status"); SETRANGE("Item No.",Item."No."); SETFILTER("Reservation Status",'<>%1',"Reservation Status"::Prospect); IF FIND('-') THEN REPEAT IF (("Reservation Status" <> "Reservation Status"::Reservation) OR (Binding = Binding::"Order-to-Order")) THEN BEGIN ActionMsgEntry.SETRANGE(ActionMsgEntry."Reservation Entry","Entry No."); DELETE; ActionMsgEntry.DELETEALL; END; UNTIL NEXT = 0; END;
0
Comments
-
anybody?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 321 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions