Skip to main content

Part Usage report not generating any data when entering suppliers in filter

When we add dates and a supplier only one item comes up, but I know we have purchased and used many items.

J
Written by Jes Foxall-Beckley
Updated over 2 weeks ago

Note: If you have part traceability turned off then you will be unable to search by supplier using this report.
​
The supplier on the report is the preferred supplier, not necessarily the actual one.
​
The supplier range in the report filters looks for the supplier that the batch was actually received from. Check it against the export clicking 'show batch & supplier', to show the specific batch that was received from the specific supplier.
​
If you are running the report against any suppliers that are not approved or have exceeded their expiry date, the stock won't show on the part usage report because it is from a different supplier and batch.
​
If you would like to delve into this further, try the part usage report with different suppliers until some part info shows and then compare this supplier with a supplier that does not produce any data. My inclination is that the suppliers that don't work are not approved or exceeded their expiry date. Check this by selecting the following:

  1. Purchase

  2. Supplier Maintenance

  3. Approval tab

  4. Check approval and expires: field and if uses approval method field


Also, there is a report which generates data for purchase order goods received by supplier. Please complete the following steps:

  1. Select Purchase.

  2. Select Purchase Order Receipts Menu

  3. Select P/O Goods received by supplier

  4. enter date range and supplier code and click Export

Did this answer your question?