Purchases by Supplier Report
From Opentaps Wiki
Jump to navigationJump to searchThis report shows the total purchases for each supplier for your company during a period of time.
The parameters of the report are:
- from and through date: by default, these are filled in for the last 30 days.
- product ID: you can optionally restrict the report to search for purchases of a single product only. Note that in this case, the system would do a search for all products which begin with the ID that you enter. Thus, if you enter "100", the system will generate a report for all purchases of products "1001", "10010", "1002", etc. Note that this field does not support UPC or SKU codes at this time, but you can look up a product by UPC or SKU using the lookup widget. If you leave this field blank, the system will report on all purchases for all products.
The system will search through all purchase orders of your organization with order date that fall within the from and through dates specified. It will include all purchase orders, which were not canceled or rejected. It would not include any purchase orders, which are for another organization. The report will show the following columns:
- name and ID of the supplier
- number of purchase orders
- total value of purchases