MPS and Item Tracking

Fisherman · 2006-09-13

All -

We've run into a snag with MPS when it is run on items that have Lot Tracking defined.

It appears that when MPS is run, the algorithm tries to find Lots that match each demand (correct?), because after the run, Lot Tracked items have Item Tracking Lines associated with them.

The problem is that, if a user makes a mistake in the setup, then MPS is forcing them to go through each item that is Lot Tracked, and remove the Tracking Lines. One MPS run had 300 such items that had to have the Item Tracking removed before the user could clear the schedule and start over - resulting in a 3 hour delay.

Is there a faster/easier way to do this - or are we missing something?

johnson_alonso · 2006-09-14

There are two options when running MPS that is calculate regenerative plan and calculate net change plan. Choose calculate net change plan if you only have changed several items and calculate regenerative plan if you want all items replanned. The fastest is calculate net change plan.

The problem is that, if a user makes a mistake in the setup, then MPS is forcing them to go through each item that is Lot Tracked, and remove the Tracking Lines

You must explain what mistaken is done. Because the setup are in the item card and in the tab option.

Filtering are also the best way to calculate MPS faster and easier.
You do it in the tab item.

Rgds,

ara3n · 2006-09-14

Yes there is an easier way Fisherman to delete the entries, I would not suggest it unless you know what you are doing. I would rather ask your NSC to write a report to do that.

But basically the data is in the table reservation entry. Fillter on source batch and source ID and you'll see the entries that need to be deleted. Delete them and then you can delete the records in planning worksheet.

Fisherman · 2006-09-14

Thanks for the replies.

I didn't think about running net change.

I think that the mistakes were on the Item card, and were discovered after running MPS, but I'm getting this information second-hand, and was asked to post the question.

aran3n - I thought that might be the case. I think that's what they've talked about doing, but I didn't know if there was a system-provided option or not.

What would be the ramifications of deleting the Item Tracking Lines in the OnDelete() trigger?

ara3n · 2006-09-14

I ran in dev toolkit on requisition line for delete(true) and it's used in the following places. Each of these cases will run your code, and you don't want to delete the lines. Also entries in that table are not just for tracking, but also for reservation. Also if they are of type reservation, you need to cancel the reservation. and delete the entries with corresponsing entry no. So that you don't have orphaned reservation entry. To be safe, it should be a report the user can run manualy.
Also to test this, to make sure that it makes the correct deletions, you need to make a copy of reservation entry records. RUN MRP, then run the report, then compare the reservation entries. The before and after records in reservation entry should be identical.

===============================================================================

Text-Export of : Table 246 Requisition Line - Object Tree

Company  : obj
Database : c:\navision\dev\Database2.fdb

Time : 12:15:16 AM
Date : 9/14/2006

================================================================================

- Table 246 Requisition Line
  - * Where Used
    + Where Used Options
    - Table 246 Requisition Line
      + Trigger OnDelete 
      - Procedure 34 DeleteMultiLevel()
          * ReqLine2.DELETE;
    - Form 5522 Order Planning
      + Trigger OnAfterGetCurrRecord 
      - Trigger OnDeleteRecord 
          * TempReqLine.DELETE(TRUE);
          * EXIT(TempReqLine.DELETE);
      + ControlTrigger OnAssistEdit 58 CalcSubstitionAvailable [TextBox]
      - Procedure 14 RefreshTempTable()
          * ReqLine.DELETE(TRUE);
          * DELETE
      + Local Procedure 4 ToggleExpandCollapse()
    - Report 699 Calculate Plan - Req. Wksh.
      - Trigger OnAfterGetRecord Dataitem 1 Table 27 Item
          * ReqLineExtern.DELETE(TRUE);
    - Codeunit 333 Req. Wksh.-Make Order
      - Local Procedure 8 Code()
          * DELETE(TRUE);
      - Local Procedure 5 FinalizeOrderHeader(PurchOrderHeader : Record 38)
          * ReqLine2.DELETE(TRUE);
    - Codeunit 5431 Calc. Item Plan - Plan Wksh.
      - Procedure 1 Code()
          * ReqLineExtern.DELETE(TRUE);
    - Codeunit 5522 Order Planning Mgt.
      - Procedure 16 InsertAltSupplySubstitution(VAR ReqLine : Record 246)
          * ReqLine.DELETE(TRUE);
    - Codeunit 99000854 Inventory Profile Offsetting
      - Local Procedure 27 MaintainPlanningLine(VAR SupplyInvProfile : Record 99000853;NewPhase : Option [ ,Line Created,Routing Created,Exploded,Obsolete];Direction : Option [Forward,Backward])
          * ReqLine.DELETE(TRUE);
          * ReqLine.DELETE(TRUE);
      - Local Procedure 67 SuggestSupplyForROPDemand(VAR DemandInvProfile : Record 99000853;VAR SupplyInvProfile : Record 99000853;OrderDate : Date) : Return : Boolean 
          * ReqLine.DELETE;
          * ReqLine.DELETE;
    - Codeunit 99000886 Capable to Promise
      - Procedure 6 RemoveReqLines(OrderPromisingID : Code[20] ;SourceLineNo : Integer ;LastGoodLineNo : Integer ;FilterOnNonAccepted : Boolean)
          * DELETE(TRUE);

================================================================================

Microsoft Business Solutions-Navision Developer's Toolkit

Fisherman · 2006-09-14

Thank you very much.

I have to get some of those toys

ara3n · 2006-09-23

You are welcome very much. 8)
Without the toys, I would spend hours researching things like this.

MPS and Item Tracking

Comments

Categories