This article includes two procedures that must be followed in this order:

  • How to use an RF unit to import a sale list
  • How to assign the sale to a pricing plan and activate the sale

How to use the RF unit to import a sale list

  1. On the RF unit, select option number ‘3’ Working PO, and then scan the sale items.
  2. Open Paladin Point of Sale.
  3. On the top ribbon, click the PO module.
  4. Open the RF Terminal purchase order.
  5. To change the name of the PO, select the purchase order, and then save it as Sale List or another new name.
  6. Delete the previous RF Terminal purchase order.
  7. On the Maintain menu, click Data Viewer.
  8. In the Paladin POS Data Viewer, click the Purchase Orders tab.
  9. In the Type list, select Stored PO’s, and then click the Sale List that you just created.
  10. Click Export Inventory. The exported list should open in Microsoft Excel.
  11. In the Excel worksheet, save the following columns:
    • Column A: PARTNUMBER
    • Column V: UNITCOST
    • Column W: MKTCOST
    • Column X: PLVL_PRICE1
  12. Select one of the following columns to create a new sale price:
To calculate this type of cost Select this Excel column
Average Cost UNITCOST
Market Cost MKTCOST
Retail Cost PLVL_PRICE1
  1. Create a new column, and then name it SALEPRICE.


  • The SALE PRICE column can only contain a numeric value and cannot include formulas. Highlight the column data, press Ctrl+C, right-click to select Paste Value Only, insert a new column, and then press Ctrl+V to paste the data into the new column.
  • Optional: To use the pricing plan to calculate a price percentage using the retail price or cost in the Inventory module, set all of the prices to 0 (zero).
  • If you enter a zero in a cell in the new SALEPRICE column, Paladin Point of Sale will not recognize a sale report as a promotion, so it will not appear in a Promotion report.
  1. Delete all but the following columns:

The worksheet should look similar to this one:

013144 39.99
012025 12.49
032174 7.915
  1. Save the Excel worksheet as a text (.txt) file.
  2. In Paladin Point of Sale, click the File menu, and then click Setup.
  3. In the Paladin Configuration window, click the Sale List
  4. In the Sales pane, click New.
  5. In the Name box, enter a sale name.
  6. In the ID box, enter a sale ID number.
  7. Click Import.
  8. In the File name box, navigate to the Sale List file that you created, and then click OK. The sale list should appear in the Sale Items box.

How to assign the sale to a pricing plan and activate the sale

  1. On the File menu, click Setup.
  2. In the Paladin Configuration window, click the Pricing Plan
  3. In the Pricing Plan pane, click New.
  4. In the Name pane, enter a pricing plan name.
  5. Select one of the following check boxes:
    • Apply to all transactions
    • Limit to Rewards
    • Respect min margin
  6. Note:  To limit the sale to certain customers, do not select any of the checkboxes.
  7. In the Sale List Range Start box, enter the Sale List ID number that you just created.
  8. In the Sale List Range End box, enter the Sale List ID number that you just created.
  9. In the Date Range Start box, enter a starting date for the sale.
  10. In the Date Range End box, enter an ending date for the sale.


  • If the sale is at a fixed sale price, your sale is completed.
  • If you retained your regular retail price or set the price to zero, add a percentage markup or percentage discount on either the cost price or retail price, then set a percentage amount.

If you have questions or suggestions about this information, contact

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 1/24/22