Hi, Managers
I was trying to get a report to show the (Qty desired) is less than or equal to (Qty owned)
which I couldn’t.
Can anyone tell me how to get the above
Both are columns and you cant compare columns in Advance Queries.
I suggested this sometime ago but dont know if its on the radar of developer or not.
Thanks @Muhamad_Almahdy but the problem I am focusing is not comparing ,where it shall show only the one which goes below the desired qty
A report for example we have an item inventory of 10 and we have marked the qty desired 5
Once you invoice 5 or more it should show us in the report as to fill the inventory without going and compare
1 Like
If your Qty desired is less than your Qty to be available – which is your forecasted Qty on hand based on actual pending Sales Orders and Purchase Orders, then you should use Qty to order column.
Your condition should now be:
Where Qty to order is not zero
Thank You
All my Sales Invoices also act as delivery notes and
All my Purchase Invoices also act as goods receipts
In this scenario what I want is
A report to show me, any item inventory which goes below the re-order point
which I created at the time time of creating the inventory item
Please advise me on this
That should be your answer, and if you are not using Sales Orders or Purchase Orders, that shouldn’t really make any difference, since this will only mean that Qty to be available = Qty owned. This implies that in your case Qty to order = Qty desired - Qty owned – which was your original requirement.