You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom report to get Available to reserve column in Inventory managemnt

in Inventory Management 4 comments

Hi Team,

We have a requirement to get a custom report where Available to reserve column should have the below formula

Available to Reserve equals the quantity on hand minus the quantity already reserved for other orders.
Available to Reserve = (Reservable Quantity On Hand) - Pending Transactions - Reservations.

I tried to use the above logic in sql query but it is not returning correct value. Below are the two logic I tried using to get Available to reserve column

SUM(IOQD.PRIMARY_TRANSACTION_QUANTITY) - IMT.TRANSACTION_QUANTITY - IR.RESERVATION_QUANTITY AS quantity-----1st
SUM(IOQD.PRIMARY_TRANSACTION_QUANTITY) - IR.RESERVATION_QUANTITY AS quantity -----2nd

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!