Purchase Reorder Report
The Purchase Reorder Report is used to determine the replenishment quantities for products within an outlet based on the Reorder and Par Level and on hands.
- To run the this report, go to Report Center > Purchasing Reports > Purchase Reorder Report
- To open the report criteria screen, double-click Purchase Reorder Report or select the report and click Run Report, as per Fig.1
Fig.1 - Running the Purchase Reorder Report
Enter report criteria below to get desired results, as per Fig.2.
Fig.2 - Report Criteria for the Purchase Reorder Report
|Outlet||Allows the selection of an outlet which has been marked for inventory under Property > Setup > Location > Outlet.|
|Description||A field in which the user can type anything to distinguish the reorder.|
|Quotes Effective Dt||The chosen date will be used to determine which quotations will be applied to the Purchase Requisition.|
This option will define how the values will be calculated for the Reorder Report.
Par: the value will be always same as par value set for the product in the outlet's guide located under Inventory > Maintain Guide.
Up to Par: the value will display the difference between the current on hand and what is defined as the par on the outlet's guide.
|Report Selection||Category: generates the report with products that belong to one or more of the chosen categories.
Vendor: generates the report with products for which the one or more selected vendor(s) are the primary vendor for the products, which may be set up under Property > Products > Vendor.
Location: this can only be used for location outlets. All products that belong to the selected location(s) will be included in the report. For category outlets, only one location will be shown in the selection list.
|Below Min. Value||When enabled, then only the products for which the current stock is equal or less than the reorder value (which may be set up under Inventory > Maintain Guides) will be displayed.|
|Usage From / Through||Allows the choice of time frame for which usage (posted outlet requisitions) information for the selected products will be shown on the report. This is for user information only and has no effect on the data.|
|Products||All Products: generates the report for all products that have been added to the guide of the selected outlet and comply with selection criteria (Report Selection).
Par Products: generates the report using the above criteria as well as the Par value needing to be greater than 0 for the products in the selected outlet's guide.
|Sort Order||Description: the products will be arranged alphabetically by product description.
Inventory Location: the order of products will be the same as their sequence in the outlet's guide.
|Include Specification||When enabled, the text in the Specification field (Property > Products > Specification) will be displayed.|
|Include Outlet Requisitions||This function defines how the values will be calculated for the report and only works if Up to Par is chosen for Quantity. Otherwise, this check box will have no effect.
If this box is checked, the system will take into account the released (but not yet posted) outlet requisitions where chosen outlet is the supplying outlet.
For example, for product A in outlet 1:
Par value = 10
Current stock = 6
There is one or several outlet requisitions for 3 products in total, where outlet 1 is supplying outlet. The requisitions have been released but have not been posted.
The box is not checked: reorder value will be calculated as
10 - 6 = 4
The box is checked: reorder value will be calculated as
10 - (6 - 3) = 7
(6-3) is available quantity, i.e. the quantity that will remain after the above-mentioned outlet requisitions are posted.
|Select All||When checked, all the items, depending on the selection in Report Selection, appearing below will be checked.|
Fig.3 - Purchase Reorder Report results
|Product Name||The name of the product.|
|Description/Attributes||The retail attributes assigned to the product under Property > Products > Retail.|
|Pur. Cost||The current purchase cost located on the Product Master.|
|Inv. Cost||The current inventory cost for the outlet which can be seen under Property > Products > Inventory.|
|Purch. Unit||The purchase unit assigned on the Product Master.|
|Purch Info||The text typed into the Purchase Info field on the Product Master.|
|Product||The Adaco product number.|
|Pack Size||The quantity of the purchase unit as defined on the Product Master.|
|Order Quantity||This field may be written in when the report is printed out.|
|Available||The current stock of the product in the outlet.|
|Order||The ordered quantity taking into consideration released purchase requisitions and purchase orders.|
|Par||The Par level assigned to the product on the outlet's guide located under Inventory > Maintain Guide.|
|Reorder||The Reorder level assigned to the product on the outlet's guide located under Inventory > Maintain Guide.|
|Beginning/Ending Date||The starting and ending dates chosen by the user for the Usage From / Through field.|
|Last Vendor||Displays the name of the vendor from which the product was most recently received.|
|Last Purchase Cost||Displays the most recently received cost of the product.|
|Vendor 1 / 2||Displays the quotes from the first two vendors with active quotes.|
|Price||Displays the quoted cost for the two vendors.|
|Report Selection||The name of the Report Selection choice displays here (Category, Vendor, Location).|
|Below Minimum||The stock of the products that display under this heading is less than the Reorder level amount defined for the product in the outlet's guide.|
|Other Products||The stock of the products that display under this heading are at or above the Reorder level amount defined for the product in the outlet's guide, or the Reorder level has not been defined.|
Please sign in to leave a comment.