Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MRP Planned Work Orders
06-02-2018, 04:23 AM
Post: #1
MRP Planned Work Orders
I am using version 4.14.1, (have not upgraded this instance yet). However, I didn't see that any changers were made to the MRP system in the new version.

When I run the MRP, I only have "Use Reorder Level Demands" selected. I have a part, that is not part of any bill of material, that has

35 Open Order
107 in stock
250 Reorder level
The part is a manufactured part.

I would think the system would tell me I need to make 35 to cover the open order and then 143 to get to my reorder level of 250. However, the system tells me I need to make 35 for the open order and 36 for the reorder level. This is exactly 107 wrong, (which is what I have in stock.)

Then, I invoiced the 35, now I have a stock of 72. I ran the MRP again, same parameters, and now it says I need to make 106 to fulfill reorder level. (Exactly 72 off).

It seems that they system is subtracting the current inventory twice when calculating the quantity to make for the reorder level?

I tried to follow the script to see where the calculation occurs, but it seems a bit over my head. I did see in the table mrprequirements table, the quantity for this part is 178, with a MRPdemandtype of REORD
But, in the mrpplannedorders, it shows supplyquantity 106, with an ordertype REORD
Find all posts by this user
Quote this message in a reply
06-03-2018, 06:35 AM
Post: #2
RE: MRP Planned Work Orders
I did a little more digging and found that when inserting the data into mrprequirements table, on line 326 it inserts the data for reorder level as
(locstock.reorderlevel - locstock.quantity)
Which is the reorder level minus the stock on hand.

then on line 724 it sets the planned orders quantity to what I believe, is the total from the mrprequirments table minus the total supply.

$Requirements[$reqi]['quantity'] -= $TotalSupply;

The total supply seems to be calculated from mrpsupplies table and has entries based on quantity on hand, open PO, open WO, etc. So when summing the total supply, it includes the quantity in stock (QOH).

So, to me, it looks like for reorder levels, we are subtracting the amount in stock twice? If I change line 326 in MRP.php to (locstock.reorderlevel), basically not subtract out the existing stock in the mrprequirements table, it seems to be working?
Find all posts by this user
Quote this message in a reply
Yesterday, 03:50 AM
Post: #3
RE: MRP Planned Work Orders
Can anyone "closer" to MRP usage (which means, more knowledgeable than me Smile ) check this handling to see if it appears to be ok?

If so, I'll commit the proposed fix to the bug_fixes and HEAD.
Find all posts by this user
Quote this message in a reply
Today, 10:59 AM
Post: #4
RE: MRP Planned Work Orders
BrianTMG is correct. The reorder quantity should not be reduced by the quantity on hand.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
Today, 12:28 PM
Post: #5
RE: MRP Planned Work Orders
Thanks Brian! (...and to Phil for the validation)

Change committed to bug_fixes_only and HEAD, credited to BrianTMG.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)