Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MRP Planned Work Orders
06-03-2018, 06:35 AM,
#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?
Reply


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

Forum Jump:


Users browsing this thread: 1 Guest(s)