You can specify a reference margin to calculate the retail price of an item by using the market cost when an item is received by an EDI process or a manually-received purchase order. When you set a reference margin, you will maintain a constant margin on an item as the market cost fluctuates.

For example, if the retail price of one item is based on a market cost of $10 and a reference margin of 50%, the retail price will be $20. If an EDI process updates the market cost to $20, the retail price will change to $40.

You can specify different reference margins to calculate the prices for one item and for other quantities (known as quantity price discounts or price levels).

This article provides instruction and information on the following:

To learn more about reference margins, view our webinar: The many uses for reference margin

How to set up the reference margin feature

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. Scroll to the Purchase Orders pane, and then set the following check boxes:
    • Update retail pricing based on receiving cost and reference margin
    • Force PO Received cost to Market cost
  4. Click Save, and then click Close.

Back to Top

How to add the reference margin to an inventory item

  1. Verify that the reference margin feature is be set up. To learn more, see How to set up the reference margin feature.
  2. In Paladin, on the top ribbon, select the Inventory module.
  3. Enter a part number in the Part # box.
  4. Open the Pricing tab.
  5. In the Pricing Levels pane, in the Ref column, enter the reference margin percentage as a whole number without a percent sign. 
  6. Do the following based on whether you are running the single store or multi-store version of Paladin:
    • Single-store: Make sure the Pricing Levels pane is NOT locked (lock is open). If the Pricing Levels pane is locked, EDI and manual receiving processes cannot apply the reference margin or update the retail price.
    • Multi-store: Make sure the Pricing Levels pane IS locked (lock is closed). The ensures that the reference margin will be applied. If the Pricing Levels pane is not locked for multi-store, the reference margin is ignored and the retail price is updated instead.
  7. On the bottom ribbon, click F12 Save.

Notes:

  • When you set a reference margin, retail prices are calculated based on last received cost.
  • If you entered a freight cost during receiving, the retail price based on the reference margin will be computed using the last received cost, including the portion of the distributed freight cost.

    Example:
    Supplier cost per item: $10.00
    Distributed freight per item: $0.05
    Reference margin: 50
    Retail price = $20.10

    Also note that in the Inventory module, on the Pricing tab, the Last Cost value does NOT include freight cost. In our example the Last Cost on the Order Control tab would be $10.00. However, the Avg Cost value on the same tab will average in the cost with freight to $10.05.

Back to Top

Only non-inventory items can have a reference margin of 100 percent

In the Inventory module, an item’s reference margin(s) cannot be set to 100% unless it a non-inventory item. An item with a price based on a non-zero cost, cannot have a 100% margin. If you set an item’s reference margin (Ref) to 100, and the Non-Inventory check box is not selected, you will see the following message:


Figure 1: Save Inventory Item window/Cannot save the item message

An item’s reference margins are set in the Inventory module, on the Pricing tab in the Pricing Levels pane.


Figure 2: Inventory module/Pricing tab/Pricing Levels pane

To designate an item as non-inventory item, in the Inventory module, on the General tab, select the Non-Inventory checkbox.


Figure 3: Inventory module/General tab/Non-Inventory checkbox

Back to Top

How to apply a quantity discount using a negative reference margin

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. Enter a part number in the Part # box.
  3. Open the Pricing tab.
  4. In the Pricing Levels pane, in row 1, in the Sale Price column, enter the single-item price.
  5. In the row for each quantity greater than 1 that you want to discount, in the Ref column, enter a negative percentage as a whole number without the percentage sign. You cannot discount the single-item price.
    Example: To apply a 10 percent discount off of the single-item price for buying two items, in the Ref column, enter -10.
  6. On the bottom ribbon, click F12 Save.

Back to Top

If you have questions or suggestions about this information, contact support@paladinpos.com.

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