Purchase Orders: Generate a report on PO by item code
I would like to request that a report be designed where you can determine which purchase orders contain the "quantity on order" on a specific code. At the moment the only report you can pull is one where it shows which bills and invoices contain that code.
We work with thousands of products, and we need to find a way to determine which purchase orders have certain codes. There should be an option to pull a report based on the item code, showing what is on order (including the PO number) as well as the bills and invoices.
This will make my life so much easier, rather than looking through every PO to find a specific item.
Hi community, since this idea was raised we have developed Xero reports - You'll now find a common format option to the left side panel within the Payable Invoice Detail report to view All purchase order details'
The report includes the Item Code column by default, and you can also set Grouping/Summarising to Group by Item Code to group items together.
Additionally you could Filter the report, for example by Status, to only view Current orders.