I generate at least 12 Sales Quotations with 50 Inventory Item. some items included in every SQ,
Now i want to Generate on single Purchase Order for all items, in which ill get the total quantity of each item.
can we make this from Custom Report?
Unfortunately not. Custom reports only involve GL transactions.
But that’s a good use case for improvement. I wouldn’t take SQ quantities though, because SQs can be rejected, expire or stay open for quite a while.
I’d rather have this based on SOs.