https://community.qlik.com/t5/QlikView/Automatic-Calculation-of-Reorder-Point/m-p/1520786#M1291729 <P>Dear Friends</P><P>My factory has 02 management system MES and SAP which works independently</P><P>1. MES to control production</P><P>- It calculate the total material consumption of production</P><P>- Every 10 minutes it send a report to SAP about consumption</P><P>2. SAP To control warehouse stock</P><P>- It bases on MES report to calculate supply quantity</P><P>- It will trigger the reorder quantity that is rounded down to Handling Unit (it means the supply quantity less than Handling Unit, there will no supply quantity)</P><P>The problem I don't know how to calculate the left over quantity in production bin at the mean time we prepare quantity to supply so that I can avoid the shortage materials for production</P><P>Please help to solve this solution</P><P>The attachment is my calculation sheet for your information</P><P>thanks for your concern</P><P>Nguyen Thanh Chung</P> Mon, 26 Jan 2026 18:19:17 GMT Anonymous 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/Automatic-Calculation-of-Reorder-Point/m-p/1520786#M1291729 <P>Dear Friends</P><P>My factory has 02 management system MES and SAP which works independently</P><P>1. MES to control production</P><P>- It calculate the total material consumption of production</P><P>- Every 10 minutes it send a report to SAP about consumption</P><P>2. SAP To control warehouse stock</P><P>- It bases on MES report to calculate supply quantity</P><P>- It will trigger the reorder quantity that is rounded down to Handling Unit (it means the supply quantity less than Handling Unit, there will no supply quantity)</P><P>The problem I don't know how to calculate the left over quantity in production bin at the mean time we prepare quantity to supply so that I can avoid the shortage materials for production</P><P>Please help to solve this solution</P><P>The attachment is my calculation sheet for your information</P><P>thanks for your concern</P><P>Nguyen Thanh Chung</P> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Automatic-Calculation-of-Reorder-Point/m-p/1520786#M1291729 Anonymous 2026-01-26T18:19:17Z