SAP B1 Query and add-on screen

Job ID: 36620536

Budget: ₹1,500 – ₹12,500 INR

1. I need a Query to find out how long does it take to sell all the quantities of a particular item code in a GRPO. Need an add-on screen just like inventory posting screen but without IM and PU
2. I need a Query to know the Sum of Sales / Purchase and No of days without stock - Refer Screenshot

Please note that I am not using Batch Concept
Related categories: SQL Oracle SAP MySQL Database Programming