Can we kick some item from MRP calculate in 23.2?

Hi All,

Now, we still run 23.2 every weekend and next monday we got a plan order to supplier,
But we have many item obsolete and it is have a bit time to verify obsolete item.... but more a bit it get then an hours...

How can we kick off that item from 23.2?

Thank you
 
Planned
Items Orders Elapsed
Process Started Processed Processed Time Process Stopped
-------------------- --------- ------------ --------- --------------------
30/06/19 10:01:35 AM 35,204 80,585 6:10:10 30/06/19 4:11:45 PM

Process Started: 30/06/19 10:01:35 AM
Item Processed: 35,204
Orders Process: 80,585
Elapsed Time: 6:10:10
Process Stopped: 30/06/19 4:11:45 PM

This is the result of MRP process on Sunday.
Remark: we do not allow user to login that time.

Do you have any advice to reduce time process?
 
Some i think of are:

1. Check your index
2. If you use temp-table without index definitions, build some that you use. (it can help you reduced time by 2 maybe more )
3. For our ERP with have some setup value to tell if we want them to be processed by the mrp or not.

Best Regards,

BobyIsProgress
 
Now we are doing:
1. we doing compact mfg index
2. complete 23.15.1 and 36.25.55 and then complete 23.22

Now,



Process Started: 07/07/19 10:01:28 AM
Items Processed : 35,242
PlannedOrders Processed: 75,420
Elapsed Time : 8:15:11
Process Stopped: 07/07/19 6:16:39 PM

And we got abnormal MRP result with no FGs required in 23.14:

Gross Scheduled Projected Planned
Due Date Reqmt Receipt Qty OH Order(Due) Details
-------- ---------- ---------- ---------- ---------- ----------------------------------------------------------------------
0 Beginning Available
09/11/15 9 -9 W/O: XXXXX-XXXX-XXXX ID: 10210985
08/07/19 591 600 W/O: 07071226 ID: 17118402 Release 08/07/19



And then we got some Finished Goods no "Gross Reqs" result.

Qty on Hand: 168.0 UM: P Time Fence: 224 Manufacturing Lead Time: 0 MRP Required: No
Order Policy: POQ Minimum Order: 0 Safety Time: 0 Pur/Mfg: M Purchase LT: 0 Mstr Sched: Yes
Order Period: 7 Maximum Order: 0 Safety Stk: 0 Inspect: No Inspect LT: 0 Plan Orders: Yes
Order Qty: 0 Ord Mult: 0 Yield%: 100.00% Cumulative Lead Time: 0 Issue Policy: Yes
BOM/Formula Code:

Past 08/07/19 15/07/19 22/07/19 29/07/19 05/08/19 12/08/19 19/08/19 26/08/19 02/09/19 09/09/19 16/09/19 23/09/19
07/07/19 14/07/19 21/07/19 28/07/19 04/08/19 11/08/19 18/08/19 25/08/19 01/09/19 08/09/19 15/09/19 22/09/19 29/09/19
-------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- --------
Gross Reqs 0 0 0 0 0 0 0 0 0 0 0 0 0
Sched Receipt 0 0 0 0 0 0 0 0 0 0 0 0 0
Projected QOH 168 504 896 1256 1472 1712 2144 2480 2816 3128 3392 3536 3632
Plan Ords Due 0 336 392 360 216 240 432 336 336 312 264 144 96
Plan Ords Rel 0 336 392 360 216 240 432 336 336 312 264 144 96

T_T, Have any body got experience like us?
 
Top