Counterpoint has the functionality to make suggestions about what items should be purchased called Purchasing Advice. The Purchasing Advice report can be filtered to show items that Counterpoint thinks you ought to purchase. There are three methods for running the purchasing advice report:
- Maximum
- Days of Supply
- Replenishment
Defining Minimums and Maximums
Defining inventory quantity minimums and maximums are crucial to using the Maximum method in purchasing advice. Minimum is the lowest quantity of items that you want to have in stock before you order more. Maximum is the highest quantity you want to have in stock. To define minimums and maximums:
- 1.
Select Inventory → Items - 2.
Enter, scan, or look up an item - 3.
Click Inventory
- 4.
Look up the location or use the arrows in the toolbar to find the location
- 5.
Enter a Min Qty (lowest quantity on hand before reorder) - 6.
Enter a Max Qty (highest quantity you want in inventory)
- 7.
Click Save
Running the Purchase Advice Report
- 1.
Select Purchasing → Purchase Requests → Purchasing Advice - 2.
Choose Maximum from the Report drop-down
- 3.
Choose a location or group of locations
- 4.
Choose setting for Print Cell detail for gridded items - 5.
(Optional) Check the box to show all quantities for items (Qty on Hand, suggested order Qty)
6. Choose a vendor setting
- Primary – choose vendor based on the item’s primary vendor
- Lowest cost – choose vendor for the item with the lowest cost
- Specific – allows you to specify a vendor
7. Choose a Units option
- Stocking – shows units by the item’s stocking unit
- Vendor – shows units by the unit specified on the vendor item record, or the stocking unit if no unit is defined on the vendor item record
- 8.
Optional) Check the box to Print quantity sold and define a date range to see how many items were sold in a period
9. (Optional) Check boxes to adjust quantities for
- Open purchase requests
- Open purchase orders
- Vendor minimum order quantities
10. Choose a setting for Vendor multiple
- Do not adjust – quantities will not be changed to match vendor multiple settings
- Decrease to next multiple – rounds down to nearest multiple
- Increase to next multiple – rounds up to nearest multiple
- Round to nearest – rounds to closest multiple, can round up or down/li>
11. Click the Item or Inventory tab to define filters like primary vendor or item category12. Click Preview
13. Review the report 14. (Optional) Close preview and edit filters
Converting Purchasing Advice Report to Purchase Requests
Once you have filtered the Purchasing Advice report to show the items that you want to purchase:1. Close the previewed report 2. Click Generate
3. Click OK
4. (Optional) Click Yes to view purchasing advice report 5. Select Purchasing → Purchase Requests → Purchase Requests Enter to edit and post the new purchase requests