Creating Purchase Orders

Contents of this Topic: ShowHide

Overview

• OMS can create purchase orders (POs) to re-stock your inventory.

• You can receive new inventory against a OMS Purchase Order when it arrives. Supplier invoices can also be tracked by OMS .

• POs can be created manually, or semi-automatically by the program (requires limited human intervention). If you create POs manually, you can either select items individually or use the multi-select too to select multiple items from a single screen.

Best Practice

• Do not create purchase orders on more than one workstation at the same time.
• Do not leave "saved" purchase order work for long periods of time. Return to them and create the purchase order as soon as possible.

Viewing Existing Purchase Orders

1. To open the Purchase Orders screen, go to Main Menu>Manage My Inventory>Manage My Purchase Orders.

2. When the Purchase Orders screen first opens, it not display existing purchase orders, but instead lists several common actions related to Purchase Orders.

3. Select either Find PO or Find & Select a PO in the Accordion.

4. Select Clear Search Form to view all purchase orders in the system or enter criteria in the other fields on the screen to filter the list of purchase orders. For example, enter a single purchase order number or a range of numbers in the From and Thru fields on the PO# line.

5. Select Begin Search. To remove the filter, select Clear Search Form.

6. Select a purchase order in the list and click View PO to see its details. Double-clicking in the fields of a purchase order in the list opens it in detail view as well.

Creating POs Automatically

• OMS can create new purchase orders automatically for a single supplier or all suppliers based on criteria you provide.

• If you select All Suppliers, the program creates a separate PO for each supplier and displays the items and quantities to be ordered. You can then review and modify the data prior to actually creating and sending the purchase orders.

• The automatic PO process only works for products that have a "primary supplier" designated on their product inventory record in OMS . Products without a "primary supplier" can only be added to purchase orders manually.

• The program reviews the following factors for each product when generating Purchase Orders:

• 1. • Quantity on Hand

     • Quantity needed for any un-filled orders

     • Quantity already ordered from your suppliers, but not yet received

     • Minimum order quantity and other purchasing rules

PO Calculation Methods

• The program provides three methods for calculating the quantities to order for each product.
• Each method uses values you specify on the product's inventory record to perform their calculations.
• The Inventory screen changes to display the fields required for the selected calculation method.
• Whichever method you use, the Create POs Automatically function allows you to edit and add items to the generated purchase orders prior to sending them to suppliers.

Target Quantity

• Displays the Target Qty. field on the inventory record, which is the quantity you wish to have in stock at all times.

• For example, if you want 10 pieces of an item on the shelf at all times and you sell 2 pieces so there are now 8 pieces on the shelf, the purchase order system automatically reorders 2 pieces to return the stock level to 10.

Order Quantity

• Displays the Reorder Qty field on the inventory record, which is the number of pieces to order automatically when an item reaches or drops below its Reorder Point.

• Displays the Reorder Point field on the inventory record, which is the number of units currently in stock at which the program triggers an order for the product's Reorder Qty

• For example, if an item reaches or drops below its reorder point of 2 (there are 3 pieces on the shelf and you sell 1), the system orders the reorder quantity or the number of pieces on backorder, whichever is greater.

Delayed Target

• Displays the Target Qty. and Reorder Point fields on the inventory record.

• The Delayed Target setting works similarly to the Target Quantity setting except that the system does not place an order until the inventory level drops below the Reorder Point.

• For example, if your Reorder Point is 2 , your Target Qty. is 10 and you sell 2 pieces leaving 8 pieces on the shelf, the purchase order system does not place an order for the product until the inventory level reaches 2, in which case it orders 8 pieces to return the stock level to 10.

Select the PO Calculation Method

1. Go to Main Menu>Settings>System Functions>Set System Parameters.

2. In the Parameter Group box, select Purchase Orders.

3. Select POCalcMethod from Parameters in Selected Group.

4. Select Order Quantity, Target Quantity or Delayed Target.

5. Select Save.

Purchasing in Lots

• If you have items in your inventory that you purchase from your supplier as a "lot", then you must set Supplier Purchasing Rules before OMS can correctly generate a purchase order and track inventory for lot items.

• You may have already defined your lot items when you imported your inventory during program setup or else entered it when individual items were manually entered.

Review purchasing information for individual products

1. Go Main Menu>Manage My Inventory>View & Manage My Inventory.

2. Scroll through the records using the Record: navigational arrows or Search for specific product records.

3. Select the Suppliers tab.

4. To make changes to the information in the Supplier's Purchase Rules section of the screen, select Edit (above Suppliers for this SKU) to open the Edit Product Supplier screen.

   1. Choose by the Piece (default setting), by the Lot, or by the Piece in fixed Lots (this is not typical). The difference between purchasing in "lots" and "by the piece in fixed lots" is how you, or your vendor, want the line item to display on the purchase order – by the number of units (singles) or the number of lots (cases).

   2. If the supplier of this item has a Minimum Order Qty., enter that number in the field. If you must order this item by the lot, select Lots, otherwise leave it set to Pieces (default setting).

5. In the Purchasing in Quantity Lots box, enter the Pieces per Lot and Cost per Lot.

6. Select Save when finished.

Example 1: Purchasing by the Lot

• In this example, a merchant sells wine by the bottle, which the vendor requires he purchase by the Lot, (case) with a minimum order quantity of 1.

• Should the Auto PO System determine that the merchant needs to order 8 bottles of wine to meet his target quantity on hand, it orders a quantity of (1) Lot because this SKU must be ordered in lots of 12 bottles.

• The Auto PO System places one Lot (1 case) on the purchase order (instead of 12 bottles) because this SKU is ordered "by the Lot."

Example 2: Purchasing by the Piece in Lots

• In this example, the merchant sells wine by the bottle, which he must purchase by the Piece in fixed Lots (cases).

• Should the Auto PO System determine that the merchant needs to order 8 bottles of wine to meet his target quantity on hand, it increases the order quantity to 12 units because this SKU must be ordered in fixed lots of 12 bottles.

• The Auto PO System places 12 units on the purchase order (instead of 1 lot or case) because this SKU is ordered "by the Piece in fixed Lots."

Automatically Generate Purchase Orders

1. At the Purchase Orders screen, select Create a New PO, or click the Create New PO tab in the Accordion.

2. Select Automatically to reorder items based on target quantities, reorder points and reorder quantities.

3. Select the method to determine the scope of products that are ordered:

   1. Needed SKUs – only those items that the program determines are needed based on the purchase order calculation method   

   2. All SKUs – order all items in your inventory based on the Reorder Quantity of each item  

1. 3. Refills – order items based on historical sales data (For example, if there is less than a 30 day supply, bring the QOH up to a 60 day supply, based on the last thirty day's sales or a specific date range. The program calculates the average number of items sold per day in that period. You can then order an "X- Day" supply based on that rate.)  

4. Select the suppliers for whom purchase orders are generated:

   1. Selected Supplier –  creates a single purchase order for the selected supplier (to be added to the purchase order, items must have the selected supplier designated as their Primary Supplier)

   2. All Suppliers –  creates a separate purchase order for every supplier

5. You can also enter a string of characters in Limit to SKUs that start with to control which products are added to the generated purchase order(s).

6. If Refills is the method by which products included on the generated purchase order, enter values in the number of days available supply, the number of days or date range on which to base past sales, percentage or number of units to increase or decrease sales estimates. Otherwise, the program expects to Include backorders from last 30 days by default. Clear this field or enter another value if desired.

7. Enter a value in Date Expected to indicate when you anticipate the merchandise will arrive from the supplier. Access 2007 or 2010 users can use the Calendar icon to select the date.

8. Select Sales Include Externally Fulfilled Item if sales data should include orders for items that are fulfilled by an external third party, such as Fulfillment by Amazon. This selection is only available if using Refills before version 7.5.

9. Once all of your choices are made, select Add to order.

10. Show Details is selected on the right side of the screen which now lists the prospective items and quantities to be added to one or more purchase orders. The Qty. to Order and Unit Cost of each item can be changed here, if necessary. Select an item from the list and click Delete to prevent it from being added to the purchase order.

11. To see the data by individual purchase order, select Show POs. You can enter any special instructions or details for each PO here. Use the Record: navigational arrows to scroll between purchase orders.        

12. Select Preview to see the actual purchase order that is sent to the supplier.

13. Optional: Select Start Over to delete the proposed purchase order data and begin the process again. Respond OK to Delete all information from Items to Order and start over?

14. If you are satisfied with the proposed purchase order data, select Create to generate the purchase order(s).

15. Respond Yes or No to Would you like to send the PO to your supplier? Yes results in the purchase order being printed, faxed or emailed to the supplier based on the settings in the Supplier record.

16. Respond Yes or No to Print file copies? Yes sends each purchase order to the printer for your records.

17. Select OK to acknowledge the process is Done!

Manually Create a Purchase Order by Selecting Items Individually

1. At the Purchase Orders screen, select Create a New PO, or select Create New PO tab in the Accordion.

2. Select Manually by item.

3. Select an entry from Local SKU or Item Name.

4. Adjust the Quantity up or down by using the arrows or entering a value.

5. Optional: Select a Supplier. The Primary Supplier is selected by default.

6. Optional: Enter the OMS order number for which the item is being ordered in For Order #. The data in this field is only for your informational purposes. The program does not automatically fill the backorder for this item when the purchase order is received. You can manually fill the backorder at Process Orders, or, depending on the selections you make before running the batch FillBackorders process, the program may or may not fill the backorder.   

7. Optional: Enter the Date Expected (when the item arrives from the supplier)

8. Select Add to order. The item or items being ordered appear in the right-hand side of the screen.            

9. Optional: Make changes to the Qty. to order or Unit Cost fields. Select an item from the list and select Delete to prevent it from being added to the purchase order.

10. Optional: Select Show POs to see the individual purchase orders. Use the Record: navigational arrows to scroll between records. It is possible to add more information in Instructions, Comments, Terms, and other fields displayed here.

11. Optional: Select Preview to see the actual purchase order that is sent to the supplier.

12. Optional: Select Start Over to delete the proposed purchase order data and begin the process again. Respond OK to Delete all information from Items to Order and start over?

13. If you are satisfied with the proposed purchase order data, select Create to generate the purchase order(s).

14. Respond Yes or No to Would you like to send the PO to your supplier? Yes results in the purchase order being printed, faxed or emailed to the supplier based on the settings in the Supplier record.

15. Respond Yes or No to Print file copies? Yes sends each purchase order to the printer for your records.

16. Select OK to acknowledge the process is Done!

Manually Create a Purchase Order by Selecting Multiple Items at once

1. At the Purchase Orders screen, select Create a New PO, or click the Create New PO tab in the Accordion.

2. Select Manually from list.

3. Select Find items to add.

4. Enter data in the fields or choose other controls on the screen to limit the products listed in the Select Items to Add screen. Press Enter.

5. Enter the quantity you want to order of each product in # to Order.

6. Select OK and return to the Create New PO tab to review the potential purchase orders in Show POs view.

7. Optional: Use the Record: navigational arrows to scroll between records. It is possible to add more information in Instructions, Comments, Terms, and other fields displayed here.

8. Optional: Select Show Details to make changes to the quantity or cost of items to be ordered.

9. Optional: Select Preview to see the actual purchase order that is sent to the supplier.

10. Optional: Select Start Over to delete the proposed purchase order data and begin the process again. Respond OK to Delete all information from Items to Order and start over?

11. If you are satisfied with the proposed purchase order data, select Create to generate the purchase order(s).

12. Respond Yes or No to Would you like to send the PO to your supplier? Yes results in the purchase order being printed, faxed or emailed to the supplier based on the settings in the Supplier record.

13. Respond Yes or No to Print file copies? Yes sends each purchase order to the printer for your records.

14. Select OK to acknowledge the process is Done!

Additional Information

Created: 7/19/12

Revised: 2/11/12

Published: 04/14/16