Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MRP Planned Work Orders
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
Post Reply 


Messages In This Thread
MRP Planned Work Orders - briantmg - 06-02-2018, 04:23 AM
RE: MRP Planned Work Orders - briantmg - 06-03-2018 06:35 AM
RE: MRP Planned Work Orders - TurboPT - 06-17-2018, 03:50 AM
RE: MRP Planned Work Orders - phil - 06-18-2018, 10:59 AM
RE: MRP Planned Work Orders - TurboPT - 06-18-2018, 12:28 PM
RE: MRP Planned Work Orders - VortecCPI - 11-07-2018, 06:39 AM
RE: MRP Planned Work Orders - TurboPT - 11-07-2018, 11:33 AM

Forum Jump:


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