Purchase Orders Overview
A Purchase Order (PO) is a process used to procure products for a store from a vendor. You can create a purchase order, specifying the vendor, quantities, and agreed prices for products. POs can only include parent items and must reference an associated vendor part number, which helps vendors identify the order upon receipt.
The purchase order process begins with demand analysis and requirement planning, where current stock levels are assessed and replenishment needs are identified. Vendors are then selected based on the specific order requirements.
Once the PO is generated within the POS system, it includes essential details such as a unique PO number, vendor information, item descriptions, quantities, prices, and order creation/update dates. It then undergoes multi-level workflows (send to store and send for review), ensuring accuracy before approval.
Finally, the PO is electronically submitted to the vendor via methods like email or EDI.
The vendor uses the PO number to track the order and initiate fulfillment. Once the items are shipped, the vendor sends an Invoice, which the system processes to update the store’s inventory, ensuring accurate stock levels.
The Verified Invoices feature is used to validate the received quantities against the original PO. Any discrepancies are managed through Back Orders.
This article provides a complete overview of Purchase Orders.
Reaching "Purchase Orders"
To reach "Purchase Orders":
- Log into Control Center
- Choose Point of Sale
- Choose Inventory
- Choose Reorder
- Choose Orders
Click on "Purchase Orders," and it will open the Purchase Orders window. Here, you will see its page with various fields.
Understanding "Purchase Orders" Layout
Please see the images labeled Figure 0.1 for descriptions of the buttons and fields that appear on the screen.
Figure 0.1
The buttons that you see on the Purchase Order form are described below:
- Add New Order: This button lets you create a new purchase order.
- Edit Order: This button lets you edit the existing purchase order.
- View Notes: This button lets you view the notes history of the selected order.
- Multiple option drop-down:
- Print Order: This button lets you print order details in report format.
- Copy Orders: This button allows you to copy the order template of the selected order.
- Order Logs: It allows you to view the items associated with the selected order, along with details such as the order date, order number, order method, and location.
- Delete Order: This button allows you to delete an order that has been completed.
- Merge Orders: "Merge Orders" is used when multiple orders for a particular product share a single location as well as vendor, and you want to combine all of the orders into a single order.
- Mass Merge Orders: This option will merge all the orders for every individual location into one single order.
- Send EDI: If you have your EDI/FTP connection set up for your store, then the "Send EDI" button will help you send the order electronically.
1. Adding a New Order
Follow the steps mentioned below to add a new order:
- Click the “Add New” button highlighted in Figure 0.1 above to add a new order.
The form highlighted in Figure 1.0 will appear on your screen.
Figure 1.0
1. Add New Order Form Fields:
See Figure 1.0.
- Location: This field lets you select one or many locations for which you wish to create an order of products/items.
- Single Location: If
you create an order for a single location, it will create the order for that location.
Clicking on "Create Order" will redirect you to the product draft
page. See Figure 1.1.
Figure 1.1
- Multiple locations: For two or more locations, the orders will be added individually to the list of purchase orders on the purchase order home screen. From there, you can add, edit, and review the created purchase order.
- Vendor: Select the name of the vendor from whom items are going to be purchased. The drop-down will show the names of all vendors allocated to the selected locations.
- Order Comments: Mention any general comments that support/explain the purchase order.
- Order Filters: This field further gives you two choices (explained below):
All: If selected, it will include all the items that the vendor supplies.
Custom: If selected, this will customize the item order according to a category, department, manufacturer, and tags. See Figure 1.2 for a more detailed description.

Figure 1.2
- All: If selected, it will include all the items that the vendor supplies.
- Custom: If selected, this will customize the item order according to a category, department, manufacturer, and tags. See Figure 1.2 for a more detailed description. Upon clicking, the following screen appears:
- The custom filter options to filter orders as per specific parameters such as UPC, Department, Category, Manufacturer, Vendor, and Department Tag the "Manage" button to apply filters to get the customized results.
- The Manage Filters screen will appear, as Figure 1.2 shows.
Figure 1.3
Manage Filter Page Information:
- Manage Filters Drop-Down: Select the saved custom filters from the Manage Filters drop-down (if any) and click "Apply" to apply the saved custom filter. Clicking the "Manage Filters" button will also open the list of saved custom filters.
- Parameter Tabs: You will see seven tabs: Department, Category, Manufacturer, Tag, and Department Tag. Select the required tab, i.e., Department, to create or apply a custom filter specific to the selected departments.
- Filter Items: Use this field for a specific result.
- Match All Filters Drop-Down: Use the "Match All Filters" filter to decide whether or not the Manage Filters screen data matches all applied filters.
- Results: Here, you see the relevant list of data for the selected tab. For example, if you have chosen the Department tab, it will show the list of all Departments. You can search for a specific department in the Search bar.
- Checkboxes: Select the required products by checking the appropriate checkboxes.
- Arrow: Click the green Arrow button to move the selected records to the Selected List area.

Figure 1.4
1. Click the "Clear Selection" button to remove the whole selection. To remove any record from the list, click the Remove (x) icon.
2. Apply or save the customer filter.
- Apply: Click the "Apply" button for the selected parameters. The system will navigate you to the Creating Working Order home screen. Fill in the order form and click on "Create Order." The system will generate reports based on your selection.
- Save Filters: Click the "Save Filters" button to save the custom filter for future use. 4.1 Save and Manage Custom Filters explains the details.
- Close: Use this button to exit the Manage Filters screen.
Figure 1.8
Check for Alternate Vendors:
This field checks whether the item has multiple vendor parts. If so, the system will alert you when the item is available at a lower cost from another vendor. Set this option to "Yes" to optimize savings.
However, you can only switch to a different vendor if no contract exists with the current vendor for that product.
- Use Order Requirements From: When set to "Yes," this option applies a predefined Order Requirement containing rules for when to generate daily or weekly inventory replenishment orders, including the quantity or percentage to order. It helps ensure that these requirements align with and support the store’s overall ordering policy.
Figure 1.9
This is done because, even in the event of a price increase, your vendors are unlikely to want to lose your business. They would prefer that you continue purchasing at least 20% of the volume you bought last month. - Create As Transfer From Store: If this option is toggled to "Yes," it will create a transfer instead of creating an order. If you toggle this option to "Yes," it will direct you to the Transfer form.
- Store Review Not Required: This option is not for the store but for corporate users. If this is toggled to "Yes," the status of the order will be Open Order, and store review is not required.
- Send to Store: This option is for the company that generates an order and sends it to the store for review. This option is not available if the above option, “Store Review Not Required,” is toggled to "No."
1.1. Order Methods
This field offers a variety of methods for a system to generate an order. See Figure 1.1.0.
1.1.1. List All Products from Vendor
When this option is selected, the system will display all products offered by the selected vendor. However, if order filters are applied — such as selecting specific departments — only the vendor’s products that belong to those selected departments will be shown. This allows for a more focused ordering process while still giving access to the vendor’s full catalog when needed.

Figure 1.1.1
Fields:
- Require Multiples Of: Select this checkbox to enable editing of the input value. This setting allows you to order items from the selected vendor only in specified multiples—for example, 30 or any other entered value (e.g., 10). If set to 10, you can only place orders in quantities like 10, 20, 30, etc.
- With a Min Order % Of: This option works in conjunction with "Require Multiples Of" to determine how the system rounds order quantities. For instance, if the multiple is set to 10 and the minimum order percentage is set to 50%, the system evaluates the recommended order and rounds accordingly:
- If the system recommends ordering 5, it rounds up to 10.
- If it recommends 25, it rounds up to 30.
- If it recommends 22, it rounds down to 20.
In short, the percentage threshold decides whether to round up or down to the nearest allowed multiple.
- Create a Negative Order: This option flags items for return to the vendor and is used when generating a return order. It is rarely used, as there is a separate, dedicated process for handling returns.
This method is less likely to be used, as analyzing sales history is a better metric than min/max.
1.1.2. Reorder by Min/Max
This method will allow you to order items based on min/max values. Each product is tagged with its minimum and maximum value. You can set min/max values in Products>>Order Information section.
To read more on this, click here: Products. Whenever the system goes below the item’s minimum value, it will order whatever is needed to get you up to that maximum value. It is done for each item. In short, this method allows you to fine-tune your inventory level to have a specific quantity per item. See Figure 1.1.2.0.

Figure 1.1.2.0
- Include "Children" to Calculate "Parent" Qty on Hand: Check this option if you wish to use the child item (pack) to calculate the parent item (carton) on hand.
Require Multiples Of: Tick this checkbox to allow input in the field. This option restricts ordering from the selected vendor to specific multiples—for instance, 10, 30, or any custom value. If set to 10, you can only place orders in quantities like 10, 20, 30, and so on.
With a Min Order % Of: This setting works together with "Require Multiples Of" to control how the system rounds the order quantities. For example, if the multiple is set to 10 and the minimum order percentage is 50%, the system will round the suggested quantity based on the following logic:
If the suggested quantity is 5, the system will round it up to 10.
If the suggestion is 25, it will be rounded up to 30.
If the suggestion is 22, it will be rounded down to 20.
The percentage actually defines the direction in which it is used to round off the value (lower or higher).
- Create a Negative Order: This flag is used when you have to create a return order. This option is occasionally used, as there is an entirely different method to create a return order.
Item Ineligibility Criteria for Reorder by Min/Max Order Method:
- If the needed quantity for Item A is only 10, and that's less than 15 (which is 50% of the required multiple of 30), then the item is ineligible for ordering because it doesn't meet the minimum reorder threshold set by the filter.
1.1.3. Reorder by Days in Inventory
This is the most popular and accurate method that utilizes your sales history. You will have to look for a certain date range, and the system will look for the items selected by the filter in that date range. The system then averages the sales per item to tell you what your average sales would be for those items. See Figure 1.1.3.0.
Figure 1.1.3.0
- Date Range From: You can choose a date range by weeks (1-8 weeks), months (1-3 months), the custom # of days (select the number of days through the counter), or the custom range (select an appropriate date range from the drop-down calendar) for which you wish to calculate average sales.
Start Date Offset: The Start Date Offset determines how many days back from today the system should begin analyzing sales data. A value of 0 means the system starts analysis from today. For example, if the date range is 2 weeks and the offset is 0, the system will analyze sales from today through the previous 13 days.
If you set the offset to 2, the system will skip today and the previous 2 days. So, if today is Friday, the analysis would start from Wednesday, and the 2-week window would cover Wednesday through the Wednesday two weeks ago (14 days including that Wednesday).
See Figure 1.1.3.0
Example: Assuming today is Friday and the Date Range From is set to 2 weeks:
- Date Offset = 0
- The system starts analysis from Friday (today) and looks back 2 weeks, covering Friday through 13 days before.
- Date Offset = 1
- The system starts from Thursday (1 day before today, i.e., yesterday) and looks back 2 weeks from there, covering Thursday through 13 days before.
- Date Offset = 2
- The system starts from Wednesday and looks back 2 weeks from that day.
So, the offset controls the starting point of the date range used for sales analysis.
Days of Inventory: If you set the "Days of Inventory" value to 10 and the item's average daily sales are 1 unit, it means you need enough stock to cover 10 days—i.e., 10 units. If the current Quantity on Hand (QOH) is 3, the system will prompt you to order 7 more units. However, if you already have 10 units in stock, no additional order is needed.
This method relies on actual historical sales data to calculate the average daily sales. So, if you already have 10 units of an item that sells 1 unit per day on average, no order will be placed because your current inventory meets the requirement.
Use Item Min Qty: When this option is enabled, the system ensures that a minimum quantity (e.g., 10 units) is always maintained, regardless of the calculated requirement. For instance, if the system recommends ordering 7 units of an item with only 1 unit in stock and a minimum required quantity of 10, it will automatically increase the order to 9 units to meet the minimum threshold. This setting ensures inventory never falls below the specified minimum quantity.
- Include Sold Items with 0 Order Qty: When you tick this checkbox, the system will include the items that are sold during the specified period, but based on the system’s calculations, they have 0 quantity in the order and offer you further options to choose from, as Figure 1.1.3.1 or Figure 1.1.3.2 shows. Please choose the appropriate option.
- For example, when you choose any of the following options under "When QOH <= 0," the system will check the item's current QOH and perform the action based on your choice when the current QOH is <= 0:
- Do Nothing: The system will do nothing.
- Add with Zero Qty: The system will add the items with the zero-order quantity to the order. You can edit or remove it, as shown in Figure 1.1.3.1.
- Add with Qty 1: The system will add the items with the order quantity as one in the order.
- Add with 10 Week High (Summary Only): The system will add the items with the order quantity as the highest sold in the last ten weeks in the order. This will override the time range you selected in "Date Range From," and the system will consider the last ten weeks from the current date.
- Add with 52 Week High (Summary Only): The system will add the items with the order quantity as the highest sold in last fifty-two weeks in the order. This will override the time range you selected in "Date Range From," and the system will consider the last fifty-two weeks from the current date.
- Similarly, when you choose any of the above options under "When QOH < 1," the system will check the item's current QOH and perform the action based on your choice when the current QOH is < 1.
Require Multiples Of: Tick this checkbox to allow input in the field. This option restricts ordering from the selected vendor to specific multiples—for instance, 10, 30, or any custom value. If set to 10, you can only place orders in quantities like 10, 20, 30, and so on.
With a Min Order % Of: This setting works together with "Require Multiples Of" to control how the system rounds the order quantities. For example, if the multiple is set to 10 and the minimum order percentage is 50%, the system will round the suggested quantity based on the following logic:
- If the suggested quantity is 5, the system will round it up to 10.
- If the suggestion is 25, it will be rounded up to 30.
- If the suggestion is 22, it will be rounded down to 20.
The percentage actually defines the direction in which it is used to round off the value (lower or higher).
- Create a Negative Order: This option reverses the flag of the items in an order, which is only used when you wish to return items back to the vendor. Essentially, this option is occasionally used, as there is an entirely different method to return items.
Item Ineligibility Criteria for Days in Inventory order method:
- Example: Item A sold 5 units in the past 2 weeks and has 20 units in stock. Based on the reorder formula, it needs only 10 more units.
- If "Require multiples of 30 with 50% min" is selected, 10 < 15 → not eligible to reorder.
1.1.4. Reorder by Products Sold (Replenishment)
This method recommends reorder quantities based on the number of units sold, rather than the current Quantity on Hand (QOH). For example, if 5 units of a product are sold, the system will recommend ordering 5 units to replenish stock. See Figure 1.1.4.0.
Figure 1.1.4.0
Fields:
Round Up When Child Reaches: Some products are sold in both parent units (e.g., cartons) and child units (e.g., packs). During the ordering process, sales of child units are rolled up to the parent level. You can set a threshold percentage for when to round up to the parent unit.
Example: If you sell cigarette packs (child items) and set the round-up threshold to 70%, and a carton contains 10 packs, then when 7 or more packs are sold, the system will round up and recommend ordering a full carton. If sales are below 50%, no reorder will be triggered.
- Date Range From: You are allowed to choose a date range by weeks (1-8 weeks), months (1-3 months), by custom # of days (select number of days through counter), or custom range (select an appropriate date range from the drop-down calendar) for which you wish to calculate average sales.
Start Date Offset: The offset determines how far back in time you want to start the data analysis. The default value is 0, which represents today. For example, if the date range is 2 weeks and the offset is 0, the analysis will cover the last 2 weeks up to today.
If the offset is set to 2 (days) and the date range is 2 weeks, the analysis will start 2 days before today. So, if today is Friday, the start date moves back to Wednesday. The analysis will then cover the 2-week period ending on that Wednesday.
- Use QOH Reorder Point: Check this option if you wish to use QOH Reorder Point to reorder.
- For example: Product_Cig has a QOH of 15 and sold 5 in the reorder history week. The vendor part for this item has 20 num units. So, if the reorder point is set at 25%, then it would only order the item when its QOH reaches 25% of 20 of the num units, i.e., 5.
- Use Item Min Qty: When this option is enabled, the system ensures that a minimum quantity (e.g., 10 units) is always maintained, regardless of the calculated requirement. For instance, if the system recommends ordering 7 units of an item with only 1 unit in stock and a minimum required quantity of 10, it will automatically increase the order to 9 units to meet the minimum threshold. This setting ensures inventory never falls below the specified minimum quantity.
- Include Sold Items with 0 Order Qty: In the round-up field, if you enter 50%, and if you don't sell 50% of the sub-units that are needed to create an order, the item will still be there on the order form but with 0 quantity. You can keep/edit or remove the item(s) with 0 quantity with the help of “Remove Products with 0 Quantity" on the Edit Order form. See Figure 1.1.4.3 below for reference.
- As highlighted in Figure 1.1.4.1, Sug Qty (Suggested Quantity calculated by the system) is 0, Actual Qty is one, and Order Qty is one for the product.
- Still, you can order any number of quantities for such items on a purchase order, even if the system suggests 0 as the order quantity.
- For that, edit the Actual Qty field with the order value that you want to order for that product, which will be reflected in Order Qty field. See Figure 1.1.4.2.
In case you don't wish to order and want them to be removed from the Purchase Order window, then click on "Remove Products with 0 Quantity."
Figure 1.1.4.3
Item Ineligibility Criteria for Reorder by Products Sold (Replenishment) order method:
- For example: Item A sold 8 units in the past 2 weeks. Based on recent sales, 12 units are suggested for reorder. But if "Require multiples of 30 with 50% min" is checked → 12 < 15 → ineligible for reordering.
1.1.5. List All Products from Vendor with Replenishment
This method is a combination of the “List All” and “Replenishment” order methods. It allows you to place an order for all items with the filter, e.g., department, category, tag, etc., from the selected vendor. Then, it is going to look for the date range for the sales history for that item and place an order (same as replenishment). See Figure 1.1.3.0 and its form for reference, except for "Include Sold Items with 0 Order Qty." This method is used in rare cases.
For fields, refer to Reorder by Products Sold (Replenishment).
Item Ineligibility Criteria for Reorder by List All Products from Vendor with Replenishment order method:
- Item B sold 6 units in the past 2 weeks. The system suggests reordering 12. If "Require multiples of 30 with 50% min" is checked → 12 < 15 → Ineligible for reordering.
1.1.6. Reorder Using Blank Order Method
When you generate an order using a blank order method, it will create a blank order no matter how many filters you have applied. You must manually add items that you wish to order. See Figure 1.1.6.0.
Figure 1.1.6.0
1.1.7. Reorder Using Hybrid Days/Replenishment
This method is a combination of Hybrid Days and Replenishment.
Exemplary scenario: Imagine you have a brand-new item that has been on sale for only one week, but you want to analyze sales history for the past two months. Since the item has only been in your store for 7 days, looking back over 2 months means the Days of Inventory method might not generate a reorder. This happens because, based on this method, your average daily sales appear low due to the limited sales history.
So, even though that item is a hot seller or out of stock, you cannot create an order.
This is where the Reorder with Hybrid Days/Replenishment methods come in handy. You can use this method to generate an order for all items based on Days of Inventory other than brand-new items. See Figure 1.1.7.0.
Figure 1.1.7.0
For field information, refer to the Days in Inventory and Reorder Using Hybrid Days/Replenishment order method section until the date offset.
- New Item Days: Here, you will enter the number of days for which you wish to apply the hybrid method.
- For example: If you enter 14 days and the item is newer than 14 days and filtered by category, department, manufacturer, tag, or department tag, then that item is going to be ordered based on the replenishment order. Any item that is older than 14 days will be ordered by days of inventory.
- Include Sold Items with 0 Order Qty: When you tick this checkbox, the system will include the
items that are sold during the specified period, but based on the system’s
calculations, they have 0 quantity in the order and offer you further options
to choose from, as Figure 1.1.7.0 or Figure 1.1.7.1 shows. Please choose the appropriate option.
- For example, when you choose any of the following options under "When QOH <= 0," the system will check the item's current QOH and perform the action based on your choice when the current QOH is <= 0:
- Do Nothing: The system will do nothing.
- Add with Zero Qty: The system will add the items with the zero-order quantity to the order. You can edit or remove it, as shown in Figure 1.1.7.1 above.
- Add with Qty 1: The system will add the items with the order quantity as one in the order.
- Add with 10 Week High (Summary Only): The system will add the items with the order quantity as the highest sold in the last ten weeks in the order. This will override the time range you selected in "Date Range From," and the system will consider the last ten weeks from the current date.
- Add with 52-Week High (Summary Only): The system will add the items with the order quantity as the highest sold in the last fifty-two weeks in the order. This will override the time range you selected in "Date Range From," and the system will consider the last fifty-two weeks from the current date.
Figure 1.1.7.1
- Similarly, when you choose any of the above options under "When QOH < 1," the system will check the item's current QOH and perform the action based on your choice when the current QOH is < 1.
1.1.8. Weekly Max Reorder
This method is similar to the "Days in Inventory" approach but uses weekly sales data from the sales history grid. It’s an effective way to ensure you never run out of stock. For each item in the purchase order, the system displays sales data for X weeks (based on the input value), helping you base reorder quantities on recent weekly demand.
Figure 1.1.8.1
- Number of Weeks: Enter the number of weeks for which the Weekly Max Order is to be applied. Say you enter 6; then the system will look for the previous 6 weeks’ sales history for all the items that are filtered by category, department, manufacturer, or tags.
Example: If a regularly ordered product is consistently out of stock each week, you may be losing potential sales. In such cases, you can manually adjust the Order Qty by increasing it by one unit the following week. If the issue persists, continue to incrementally increase the quantity until demand is met.This ensures the system accurately recognizes actual sales figures and recommends the optimal quantity for each product—neither too little nor too much, but just what is truly needed.
1.1.9. Items with Zero QOH
This method will allow you to create a purchase order only for the items in the selected location that have Quantity on Hand for those items for the selected department/category/manufacturer/tag equal to 0.
Figure 1.1.9.1
- Default Quantity: If the QOH for any item at a location is zero, and the default quantity for the Items with 0 QOH order method is set to, e.g., 20, then the system will suggest 20 quantities to order and will overlook the Require Multiples of and With a Min Order % of value for this order method.
For a complete video tour on Reorders, click here: Reorders.
Item Ineligibility Criteria for Reorder by Items with 0 QOH order method:
- Item X has 2 units in stock → Ineligible (QOH ≠ 0)
- Item Y has 0 units in stock, but the suggested quantity is 10. If “Require multiples of 30 with 50% min” is checked → 10 < 15 → Ineligible for reordering.
1.2. Creating an Order
Follow the steps mentioned below to create an order:
- Fill out the Create Purchase Order form as described under section 1. Add New Order Fields section.
- Choose an order method of your choice.
Here we are taking an example of the order method: Most Famous Order Method: Reorder by Days in Inventory. Figure 1.2.0
- Click on "Create Order."
- The order form highlighted in Figure 1.2.1 will appear on your screen.
Figure 1.2.1
- When you click on "Create Order," the system generates a draft order, which can then be reviewed and edited to adjust item quantities before finalizing.
During the editing stage, the order status remains as Working Order until the "Convert to Order" button is clicked.
1.2.1. Actions on "Products on Order" Ribbon
See Figure 1.2.1:
- Add: This button helps you add item(s) to a purchase order directly. Upon clicking, Figure 1.2.1.0 appears.
- Search: This option allows you to search for a specific product on the purchase order either with its name or UPC.
- Settings: This button lets you configure order-related settings.
Figure 1.2.1.0
- For the selected product(s), the Vendor Part, UPC, Set Quantity, and Cost Each will be autopopulated by the system.
- Select the product by clicking on the "Select"
button; the screen highlighted in Figure 1.2.1.0 above appears.
- Search for the product(s) and check the box next to the ones you want to add. The selected products will appear highlighted, as shown in Figure 1.2.1.1 below.
Figure 1.2.1.1
You can edit the Set Quantity and Cost Each fields as needed. Set Quantity is the Order Quantity that you enter manually. The rest of the fields will be disabled for editing.
- If you have added multiple products, click on "Next" (as shown in Figure 1.2.1.2) to proceed to the next product.
- If no additional products are added, simply click "Apply" to continue.
Figure 1.2.1.2
- After adding products, you can click "Save & Close" or "Save & Add" to include the product in the purchase order.
3. Settings
: Clicking on the "Settings" button will display the screen highlighted in Figure 1.2.1.3.
Figure 1.2.1.3
- Refresh QOH: This button lets you refresh the data in the QOH column.
- Remove Products with Zero Qty: Clicking on this button helps in deleting the products that have zero Quantity on Hand.
- Add Back Order Items: This button will help you Append, Replace, or Ignore the items on the back order to the purchase order.
Figure 1.2.1.4
- When the Back Order form has items listed, clicking on "Apply to Order" will Add, Replace, or Ignore (as per the Manage Quantity option selection) on Edit Purchase Order form.
- Days Left From: This column allows you to select a number of weeks to estimate how long the current Quantity On Hand for a product is expected to last at the store.
- Columns: This option will let you select the number of columns that are to be displayed in the purchase order form. Check the boxes against the options that you wish to include in the purchase order form.
- Reset
Columns: This
button will allow you to reset the column in the purchase order form.
- Show All Products: This option lets you choose the list of products, i.e., the data you wish to display in the purchase order form: Show All Products, Show Only Products with 0 Qty, or Show Deleted Records.
Figure 1.2.1.5
- Show
All Products: Choosing
this option will include all the items on the created purchase order
form.
- Show
Only Products with 0 Qty: This
option, if chosen, will include all the items with 0 Qty on the created
purchase order form.
- Show
Deleted Records: Choosing this
option will include and show only those items that were deleted from the
purchase order form.
Please see Figure 1.2.2.0 to know about the column labels. Kindly, scroll right to see all the columns on the order draft.
1. Product: This defines the product's or item's name that is to be ordered.
2. Sug. Qty: This value is automatically calculated by the system based on the Min/Max settings in Manage Location and the On-Hand Quantity from the Products module.
Figure 1.2.2.1
Figure 1.2.2.2
(See Figure 1.2.3.1 and Figure 1.2.2.2) In the "Products" module for the location Cobleskill, the Min quantity is set to be 5 and Max quantity is said to be 50. As soon as Quantity on Hand reaches below 5 for a selected product, it will suggest the suggested quantity as Max Quantity Order for that product with maximum quantity, i.e., 50
The Suggested Quantity field on the working order is editable only when both the "Store Review Not Required" and "Send to Store" toggles on Create Order Form are set to NO.
3. Store Qty: When a corporate user creates an order but requires input from the store to determine the exact item quantity needed, the order is forwarded to the store. The authorized store employee receives the order, and this field becomes visible on their interface. It allows the store staff to enter the precise quantity of items required at the store.
4. Actual Qty: If the order is created by a corporate user, this column is used to adjust item quantities within the order. These fields remain editable until the "Convert to Order" button is clicked, at which point the working order is converted into a standard purchase order.
5. Order Qty: This field value is finalized after considering the store quantity, actual quantity, and suggested quantity. Once confirmed, it becomes the final order quantity on the purchase order.
Order Quantity field becomes editable when the working order is converted into a standard order.
6. Back Order Qty: This column describes the item values that were not fulfilled by the vendor in the previous order.
7. On Hand: This column displays the quantity of the item that the store currently has in inventory.
8. # Days Left: This column provides an estimate based on historical inventory trends to support effective inventory management. It displays the number of days the listed inventory item is expected to last, relative to the value selected in the "Days Left From" field.
- For example, if the selected value is 3 weeks, the system analyzes sales data from the past 3 weeks to calculate an average weekly sales rate (shown in the Avg Sales column). Based on this rate, it estimates how many days the current Quantity on Hand will last. This estimate is displayed in the # of Days Left column. See Figure 1.2.3.3.
Figure 1.2.2.3
In the # of Days Left column, red values indicate a projected inventory shortage for the specified number of days, while green values indicate sufficient inventory to cover that duration.
9. Week 1: This column shows the sales of the most current week with child/parent breakdown (explained below in 52 High and 52 Low). If the Weekly Max order is used to order the products, the weekly sales data for the first six weeks is important to find out about the week that has the most sales.
10. Week 2-Week 9: In these columns, the weekly sales numbers of the weeks are displayed, respectively.
11. Week 10: This column shows the sales of the past 10th week with a child/parent breakdown.
12. 52 High: If the row displays the number of parent and child items as 445/0, it means 445 are the parent items for that product, and 0 is the child item quantity that was sold at max in 52 weeks in the previous year.
13. 52 Low: If the row displays the number of parent and child items as 0/0, which means 0 are the parent items for that product and 0 is the child item quantity, this means no item was sold, and it was the lowest value to be sold in 52 weeks of the previous year.
14. Cost Each: This is to define the cost of each item on the order.
15. Vendor Part #: This column displays the vendor part number, a unique number provided by the vendor for the product included in the purchase order.
16. Vendor Part Kit #: It is a unique number that is assigned to a vendor part kit (a group that comprises different but related products). It has one part number with multiple UPCs, e.g., chocolate with multiple flavors.
17. Units: This column defines the vendor part units.
18. Cost: This field defines the total cost of the items calculated as Cost
Each x No. of Units.
19. UPC: This is the Universal Product Code for the items to be ordered.
20. Original On Hand: This
field gives the value of the Quantity on Hand available at the time
of order creation for that item at a particular location in parent/child (0/0)
format.
21. Retail: This column gives the total retail value of the items that are being ordered.
22. Alt Vendor: This field is useful if you're permitted to purchase the same product from an alternative vendor offering a lower price. To enable this functionality, set "Check for Alternate Vendor" to "Yes."
23. Avg Sales: It is analyzed data from Week 1 to Week 10, whatever the average sales per week of that product is defined in this column.
24. Trend: Based on weekly sales history, the system will suggest whether the ordered product is a hot-selling item or not, i.e., whether it is trending up or down.
25. Added: This is the timestamp at which the order is created.
26. Last Update: This is the timestamp when the created order was last updated.
27. Supplier Deposit: This is the money that you have paid to the supplier, which can be used against future purchases.
28. Average Sales Per Week: These are different columns to define the average weekly sales as parent/child value (e.g., 178/0) for 10 weeks.
Items that have not been added to any order in the past 365 days will be highlighted in purple.
Figure 1.2.2.4
- Action Buttons:
There are two action buttons associated with each product to edit/delete a product that is added to the purchase order draft.
Figure 1.2.2.5
If the Store Review Not Required toggle is set to "Yes," then the order can be directly sent to the vendor that you have created without the store intervention.
1.2.3. Right-Click Functionality on Purchase Order Items
- Right-clicking on any order will display two options, as highlighted in Figure 1.2.3.0.
- View Logs: The View Log screen lets you see all the details of the product added to the order. It displays all relevant information in this context, and the data is for viewing purposes only.

Figure 1.2.3.1
- Item Analysis: This
feature helps to analyze a particular product at a particular store location from
the purchase order screen itself. A variety of information from different
modules is used together here to analyze the item.
Figure 1.2.3.2
1.3. Convert to Order
- When you create a purchase order, adjust the item quantities on order and click on Convert to Order; the working order will be converted to a Standard Purchase Order.

Figure 1.3.0
The Convert to Dialog box will appear, with two associated options: Close, and Yes, Convert to Order.
Figure 1.3.1
From this point forward, you can mark the order as complete and send it to the vendor in EDI format, as described later in the article.1.4. Send to Store
You can send a purchase working order draft to the store for review to ensure accuracy in product selection, quantities, and delivery timing. This allows the store to make necessary adjustments based on local demand, storage constraints, etc.
There are two ways to do so:
1. Automated "Send to Store"
If Store Review is Required toggle is set to "Yes" and the Send to Store toggle is also set to "Yes," the system will automatically send it to the store as an open order.
The rest of the purchase order process continues in the same manner as outlined above.
2. Manual "Send to Store"
- If both Send to Store toggle and Store Review Not Required are set to "No" on the Create Order page as displayed in Figure 1.4.0.
Figure 1.4.0
- Then, the "Send to Store" button becomes available on the Working Order draft of the purchase order on the admin side. In Manual "Send to Store" case, only the Suggested Qty column will be editable; all other fields will remain non-editable.
- You can edit system-suggested item quantities and then click Send to Store as highlighted in Figure 1.4.1 below.

Figure 1.4.1
1.5. Send For Review (Employee Side)
- Once the order is received at the store, for both cases, the authorized store employee makes the changes in the store quantity column on the order that is received.
- The store employee can then click "Send for Review" to return the purchase order for corporate review, as shown in the figure below.
Figure 1.5.0
- Any changes made by the authorized store employee on the order form should be entered in the Store Quantity field. These changes will be highlighted in yellow to notify the corporate user of the actual quantity required at the store.
Figure 1.5.1
- The order will remain in Open status until it is marked as Completed.
1.6. Completing Order
"Complete Order" indicates that the purchase order is finalized and locked in the system. Once marked as complete, no further edits or actions — such as changing items, quantities, or prices — are allowed.
- To mark the order as complete, click on "Complete Order" as highlighted in Figure 1.6.0.

Figure 1.6.0
- A dialog box will appear as shown in the Figure 1.6.1 below.
Figure 1.6.1
- Click on "Yes, mark completed" to proceed with the order completion process.
The order now will be locked/view only and can't be edited further, and the order status will be Complete Order.

Figure 1.6.2- At this stage, the order can be sent to the vendor either in EDI format via FTP or by email to the respective vendor.
Figure 1.6.3
Send EDI: After the order is created, edited, and reviewed. This option is selected to send this purchase order electronically to the vendor on the FTP side. This option is found on the Edit Purchase Order screen and the Purchase Order home screen as well. It is explained below. 1.7. Send EDI
Please check your EDI setup and FTP connection, then use the "Send EDI" button to send the order electronically.- You can select multiple orders ordered within the selected date range for a single vendor in different locations and send them electronically.
Figure 1.7.0
- Click on "Send EDI," and the order list will be sent to the vendor side.
Figure 1.7.1
- By clicking "Yes," the selected order(s) will be sent to the respective vendor in EDI format either through FTP/SFTP connection or via email.
- To configure EDI Settings, refer to the EDI Setup and for FTP connections, read FTP Connections article.
The system removes the items with 0 Order Qty from the physical file sent during the EDI process. Please note the system will not remove those items from the actual order; it will only remove the physical file.- The next step is to receive the inventory. This option allows you to convert the purchase order into an invoice once the physical inventory is received from the vendor.
Invoice(s) generated from the purchase order(s) help in maintaining a traceable inventory movement record, including item quantities and costs, linked to the respective vendor(s).
Figure 1.8.0
- Enter the name for the invoice and click on the "Create" button.
Figure 1.8.1
- Click on "Refresh Order" to refresh the order list, or click on "Load Invoice" to load the invoice, i.e., redirect you to the invoice page that is created from the purchase order.
- On the Add New Order form, you get two options: "Create Order" and “Schedule Order,” as highlighted in Figure 1.9.0.
This method lets you set up an automated process for generating and managing recurring purchase orders or transactions on a scheduled basis. The benefits of creating a scheduled order:
- Weekly restocking of supplies.
- Regular orders to vendors based on consumption.
- Maintaining inventory levels without manual intervention.
- Fill in the Create Schedule Order Form fields as explained below.
Figure 1.9.1
Fields:
- Schedule Name: Give a unique name for the scheduled order in this field.
- Run Type: Select the run type from the drop-down menu (weekly, bi-weekly, or monthly).
- Run Day: Select the scheduling day that suits your requirements, from Monday to Sunday.
- Run Time: Select the scheduled run time from the attached timer.
- Date Offset: The Date Offset is the number of days added or subtracted from the scheduled run date to determine the purchase order (PO) date.
- Duration: The number of days the PO should cover or remain active. This might control delivery windows or active periods.
- Auto Send EDI: Toggle this option to automatically send this scheduled order electronically to the vendor on the FTP side.
- Send to Store: This option sends scheduled orders to the store for review.
- Mergeable: Whenever multiple orders share a single location and single vendor, the system will merge all the orders together into one single order. If one order has 5 units of an item and another has 7 units, then the system will merge these two into a single order with 7 units. This way, the orders are easier to manage for the store as well as for the vendor.
1.10. Create Transfer
The "Create Transfer" button helps you initiate a transfer of the purchased goods from one location to another within the system, such as from the vendor. This helps track the movement of inventory, ensures accurate stock management across multiple locations, and facilitates the internal logistics process following a purchase.

Figure 1.10.0
- Enter the fields in the form by selecting a "Transfer From" location and a "Transfer To" location.
- Select cost type as vendor part cost or product cost and click on "Create Transfer."
Figure 1.10.1
- Click on "Close" to close the form.
- Click on "Go to the New Transfer" to get redirected to the Transfer form.
1.11. Add/View Notes
Creating and viewing notes on the purchase order allows users to add, view, and manage comments or instructions directly on the purchase order.

Figure 1.11.1
1.11.1. Add Notes
This feature lets you add a quick note for each change to a purchase order that's already been created:
- Write the note explaining it in under 255 characters.
- Click on "Add" to save the note.
1.11.2. View Notes
This option lets you view the history of all the created notes for the changes made in the purchase order with a timestamp, note, and the user who made the change.
Figure 1.11.1.0
1.12. Print Order
The purchase order includes print-related options that allow you to generate a printable version of the order. You can choose to print the order immediately or save it as a PDF, CSV or Excel for future reference. The options related to print order are mentioned below:
Figure 1.12.0
1.12.1. Print Order Guide
See Figure 1.12.1.0.
This button helps you print the order details on the order without the vendor's details. The form is highlighted in Figure 1.12.1.0. Choose the appropriate options and click on "Start Print."
Figure 1.12.1.0
Fields:
- Sort By: Select the option from the drop-down list by which you want to sort the report.
- Group By Department: Set it to Yes/No to print the report grouped by department.
- Export Type: Select the report format, i.e., PDF, CSV, or XLXS.
- Include Header: The system enables this button by default. Please turn it off to exclude the report's header from the report.
- Repeat Header on Every Page: Enable this button to repeat the header on every page.
- Print Title on Every Page: This button is enabled by default. Turn it off if you want to remove the report's title from showing on each page.
- Send As Email: Enable this button to send the report's PDF file via email. The Email Address field will appear. Enter the email address and click "Send Email."
If sending to multiple recipients, be sure to add each email address to its own line.
- Once clicked, the purchase order details are printed in the predefined format (the headers of the columns are predefined) and as per the selected export type (PDF, CSV, or Excel). The order report in PDF format is displayed as highlighted in Figure 1.12.1.0.
- "Print Guide" is used for making an informed decision by looking at the details of the order guide.
Figure 1.12.1.0
1.12.2. Print Order
- When you wish to print order details in report format, this option is chosen. See Figure 1.12.2.0 (same as Print Order Guide) if the same options are chosen.
- The order is printed as highlighted in Figure 1.12.2.1.
1.12.3. Print Altered Items
This button will let you print the items that are altered/updated on the created purchase order with the details of the person who updated the order at the store locations.
Figure 1.12.3.0
Print-related options are available for employees too, which can be used to download the order guide and report to analyze order details.
1.14. Copying Purchase Order
This option lets you copy the order and generate it for another location. See Figure 1.13.0.
Figure 1.13.0
- For the selected Purchase Order, click on the "Copy Order" button to copy the attributes of that particular order.
- Select the desired location from the associated drop-down menu and click "Copy."
- The form highlighted in Figure 1.13.1 will appear on your screen.
Figure 1.13.1
- Clicking on the "Go to the New Order" button will take you to the Edit page for the copied order.
2. Modifying/Editing the Order
You can edit or modify a purchase order before final submission to update quantities, items, or other details. This feature ensures accuracy and flexibility during the order creation process.
Follow the steps mentioned below to edit the order:
- Click the Modifying Order button highlighted in Figure 0.1 above to edit (make changes to) a created purchase order before marking it as complete.
- The form highlighted in Figure 2.0 will appear on your screen.
Figure 2.0
The labels, fields, and buttons are described above under Create Order.
3. Order Logs
Order Logs help you track and record all the steps taken while creating or changing an order. They show when the order was made, which items were added, which items were not, and which store the order is for. This helps you easily check and understand the order details.
Figure 3.0
- Follow the steps mentioned below to view order logs.
- Click on "Order Logs," as highlighted in Figure 3.1 below, to view order logs.
Figure 3.1
Order Logs Information:
- Order Date: It displays the exact date and time when the order was created. It's useful for tracking order timelines and verifying transaction records.
- Order Number: This is a unique reference number for the order that helps in searching and tracking orders.
- Order Method: It shows how the order was created. The order method here is "List All Products From Vendor."
- Location: Specifies the store location associated with the order.
- Search: It helps you in quick filtering within the current tab.
Tabs:
1. Items added to Order: This displays the list of items that were successfully included in the order.

Figure 3.2
- Click the (+) icon, as shown in Figure 3.2, to view more read-only details, such as product UPC, ID, name, vendor part, qty/total qty sold, etc., of the selected product.

Figure 3.3
2. Item Ineligible for Order: Lists the items that were rejected or skipped during the order process for not meeting reorder conditions (e.g., quantity needed = 0).
Figure 3.4
- Click the (+) icon, as shown in Figure 3.4, to view more read-only details, such as product UPC, ID, name, vendor part, date range, etc., of the selected product.

Figure 3.5
It is imperative to note that the order logs feature can also be accessed from Edit Order screen.
Figure 3.64. Deleting the Order
Follow the steps mentioned below to delete the order:
- Click the "Delete Order" button highlighted in Figure 0.1 above to delete an order.
- A dialog box highlighted in Figure 4.0 will appear on your screen.
Figure 4.0
- Click “Yes, Delete” to continue the process of deleting the order record.
- Click “Cancel” to close the pop-up and skip the deletion process.
5. Merging Orders
Merge Order is used when multiple orders for a particular product share a single location as well as vendor, and you want to combine all of the orders into a single order. With this, the order quantity with the highest value will be taken into consideration.
Whenever multiple orders share a single location and single vendor, the system will merge all the orders together into one single order. If one order has 5 units of an item and another has 7 units, then the system will merge these two. This way, the orders are easier to manage for the store as well as for the vendor.
- Click the "Merge Orders" button highlighted in Figure 0.1 above to merge an order.
- The form highlighted in Figure 5.0 will appear on your screen.
Figure 5.0
(See Figure 5.0). There are two options offered: Single Location and Multiple Location.
- Single Location: This option will merge all the selected orders for a single vendor and single location into one order, as depicted in Figure 5.1.
- The orders listed in Figure 5.1 are all the orders under the Show Entries label.
- Select the orders by checking them against their order numbers. Click on "Merge Orders" to merge the selected orders.
Figure 5.1
- Doing so will merge all the selected locations into one order. The system requires a minimum of two orders to merge. The "Merge Orders" button will be disabled unless two or more orders are selected.
- Multiple Location: This option also lets you choose multiple orders with OPEN ORDERS status for different locations while sharing a single vendor.
Figure 5.2
- In Figure 5.2, we see two purchase orders from a single vendor for two different locations.
- Click on the "Merge Orders" button; a dialog, as highlighted in Figure 5.3 shows up.
- Select "Multiple Location" in this case.
Figure 5.3
- After that, select a vendor and location(s) for whom you wish to merge orders for, and select the date range for it.
Figure 5.4
- Select the vendor name, location(s), and date range, and click on "Review Orders."
Figure 5.5
Select the orders you wish to merge (a minimum of 2 should be there; otherwise, it will lead to an error message) and click on "Proceed To Merge Order."
Figure 5.6
- On clicking on "Proceed To Merge Order," the dialog box as highlighted in Figure 5.7 appears.
Figure 5.7
- Clicking on "Yes" will merge the selected orders. See Figure 5.8.
Figure 5.8
The two open orders will be merged and will be reflected with order # addressed with MO (Merged Order) initials. The status of the orders will now be Completed, which can't be edited further.
Figure 5.9
How It Works
- Orders must originate from the same vendor and have the "Open Order" status.
- Even if orders are from different locations, the system allows them to be merged. Quantities for the same items are aggregated and can later be transferred or adjusted to their respective locations.
- Once merged, the combined order receives a new Order Number prefixed with “MO” (e.g., MO-000123).
- The status of the merged order is updated to “Completed,” making it non-editable.
Invoicing Behavior
- Although the merged order is presented as a single record, the system retains location-specific data.
- Upon invoicing, the system automatically generates a separate invoice for each location included in the merged order.
- This ensures that inventory, accounting, and delivery tracking remain accurate and store-specific.
Figure 5.10
- The order quantity for both orders gets appended in this case.
6. Split Order
For the orders to a vendor for multiple locations, if merged, they can be separated back to the original orders with the "Split Order" button.
Figure 6.0
- Select the orders (all those that were merged) to split them into original individual order.
Figure 6.1
- Once the orders are selected, click on "Proceed to Split Order."
Figure 6.2
- Click on "Yes," and the merged order will be reversed.
Figure 6.3
7. Mass Merging Orders
This option will merge all the orders for every single location into 1.
- For example, if a location, say Middletown, has 5 orders and another location, say Oneonta, has 10 orders, the Mass Merge feature will merge all 5 individual orders for Middletown into 1 order and Oneonta's 10 orders into another 1 order.
- Choose the vendor from the drop-down list and also the set of locations.
Figure 7.0
- Click on "Review Mass Merge Orders" to select the open orders for merging.
Figure 7.1
- After reviewing the set of orders for different locations, click on "Proceed To Mass Merge Order."
- A dialogue box will appear, as highlighted in Figure 7.2.
Figure 7.2
- Click on "OK" to proceed with the merging process.
To gain a more comprehensive understanding, check out the FTx Academy training program, where you can enroll in the courses and explore the topic lesson by lesson and reinforce your learning with quick quizzes at the end of each module.