The Total Requirements figure is calculated from the ORDERS table to sum the requirements (minus any allocations) for all transaction types (Sales Orders, Work Orders, MRP suggestions, etc.). I'm sure that the figure is calculated using the RMNEXTQTY_0 - ALLQTY_0 to give the total requirements in the specified time bucket.

When filtering the lines you need to ensure that you exclude the replenishment type lines, e.g. Purchase Orders, Work Orders,  MRP suggestions, etc..

The Total Requirements figure is calculated from the ORDERS table to sum the requirements (minus any allocations) for all transaction types (Sales Orders, Work Orders, MRP suggestions, etc.). I'm sure that the figure is calculated using the RMNEXTQTY_0 - ALLQTY_0 to give the total requirements in the specified time bucket.

When filtering the lines you need to ensure that you exclude the replenishment type lines, e.g. Purchase Orders, Work Orders,  MRP suggestions, etc..

That was it. Thank you!

Hi papisueno, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey

Absolutely, always a huge help!