You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Simple Script
- Thread starter gtmsb
- Start date
Two simple ways.
The MRP required flag is stored in the inventory master.
You have to combine the inventory and the Item master.
Example 1 (SQL)
SELECT pt_part , pt_desc1 , in_site
FROM pt_mstr
, in_mstr
WHERE pt_pm_code = "P"
AND in_part = pt_part
AND in_mrp
/* AND in_site = pt_site */
.
OR Example 2 (Progress 4GL)
FOR EACH pt_mstr NO-LOCK
WHERE pt_pm_code = "P"
, EACH in_mstr NO-LOCK
WHERE in_part = pt_part
AND in_mrp
:
DISPLAY pt_part
pt_desc1
in_site
.
END.
Go to Progress editor.
Copy and Paste.
Run.
Greetings William
The MRP required flag is stored in the inventory master.
You have to combine the inventory and the Item master.
Example 1 (SQL)
SELECT pt_part , pt_desc1 , in_site
FROM pt_mstr
, in_mstr
WHERE pt_pm_code = "P"
AND in_part = pt_part
AND in_mrp
/* AND in_site = pt_site */
.
OR Example 2 (Progress 4GL)
FOR EACH pt_mstr NO-LOCK
WHERE pt_pm_code = "P"
, EACH in_mstr NO-LOCK
WHERE in_part = pt_part
AND in_mrp
:
DISPLAY pt_part
pt_desc1
in_site
.
END.
Go to Progress editor.
Copy and Paste.
Run.
Greetings William
There are some reasons.
It depends on the version of MFG how to solve them.
The first is, can you check that ALL items have been processed. Check the logging of the full mrp run.
One of them is to recalculate the Low Level Codes of ALL items.
Do users modify products during the MRP run?
The following actions modify the MRP-required flag.
- All inventory related actions: purchase, sales, receipts, issues etc
- Modify an item field in the 1.4... , 13.. or 16.. menu
Another important one is that one of the parent items is not used during MRP-run because of the planning parameter setting in 1.4.7.
It depends on the version of MFG how to solve them.
The first is, can you check that ALL items have been processed. Check the logging of the full mrp run.
One of them is to recalculate the Low Level Codes of ALL items.
Do users modify products during the MRP run?
The following actions modify the MRP-required flag.
- All inventory related actions: purchase, sales, receipts, issues etc
- Modify an item field in the 1.4... , 13.. or 16.. menu
Another important one is that one of the parent items is not used during MRP-run because of the planning parameter setting in 1.4.7.
Did you solve it yet. You're item might be having the flag "MRP plan orders" (pt_plan_ord) set to NO in 1.4.17 or 1.4.7. If that is not the case, there might be a stranded record in the qad_wkfl which can be fixed using 23.25.2. After having run the MRP afterwards the flag should be set to mrp required = "NO"