You can view item costs in thousand board feet (MBF), thousand square feet and tons in your inventory and on purchase orders by setting the Cost By: value on the inventory item. When you use this feature, you have the additional option to show prices in these units on invoices and quotes. This is especially useful when you buy or quote items in different units that you sell them. For example, lumber quotes often use MBF units, but actually sell by the piece.

This feature supports lets you view costs and prices in these units:

  • Thousand Board Feet (MBF): Unit is based on the item’s depth, width and length
  • Thousand Square Feet (MSF):  Unit is based on the item’s width and length
  • Ton:  Unit is based item’s weight in pounds or ounces

To learn how this feature works, see the examples at the end of this article.

How to view item cost and/or price in MBF

  1. In the Inventory module, open the lumber item, and then click the Pricing tab or press PgUp three times.
  2. In the Item Cost pane, in the Cost Per list, select MBF
  3. In the Cost of Lumber Wizard window, enter the dimensions for the lumber item, and then click OK.
  4. In the Item Cost pane, the PO costs will change and appear in MBF units. 
  5. Optional: To show MBF prices on quotes and invoices, in the Pricing Levels pane, select the MBF checkbox.
  6. Click Save or press F12.

    Notes

    • Both the cost for the item and the equivalent MBF cost will appear on the purchase order that you create for this item.
    • If you elected to show prices in MSF on the invoice, the MBF price and per piece price will both appear. Quantities will be sold per piece.

How to view item cost and/or price in MSF

  1. In the Inventory module, open the lumber item, and then click the Pricing tab or press PgUp three times.
  2. In the Item Cost pane, in the Cost Per list, select MSF.
  3. In the Cost Per Square Foot Wizard window, enter the dimensions in feet or inches, and then click OK.
  4. In the Item Cost pane, the PO costs will change and appear in MSF units. 
  5. Optional: To show MBF prices on quotes and invoices, in the Pricing Levels pane, select the MSF checkbox.
  6. Click Save or press F12.

Notes

  • Both the cost for the item and the equivalent MSF cost will appear on the purchase order that you create for this item.
  • If you elected to show prices in MSF on the invoice, the MSF price and per piece price will both appear. Quantities will be sold per piece.

How to view item cost in Tons

  1. In the Inventory module, open the lumber item, and then click the Pricing tab or press PgUp three times.
  2. In the Item Cost pane, in the Cost Per list, select Ton.
  3. In the Cost Per Ton Wizard, enter a value in pounds or ounces. Equivalent values will appear.
  4. Optional: To show MBF prices on quotes and invoices, in the Pricing Levels pane, select the MSF checkbox.
  5. Click Save or press F12.

Notes

    • Both the cost for the item and the equivalent MSF cost will appear on the purchase order that you create for this item.
    • If you elected to show prices in MSF on the invoice, the MSF price and per piece price will both appear. Quantities will be sold per piece.

A lumber example

Showing costs in MBF

Let’s assume you sell lumber with the following dimensions, 2 inches x 4 inches x 8 feet, and you want to see the item cost in MBF (thousand board feet) units.

To do this, in the Inventory module, open the lumber item, and then click the Pricing tab or press PgUp three times.

Note: The Item Cost pane layout has changed, but the information is the same.

In the Item Cost pane, in the Cost Per list, select MBF.

Choose MBR from list

When you select MBF, a Cost of Lumber Wizard appears. Enter the dimensions for this lumber item, and then click OK.

MBF cost wizard

After the wizard closes, new PO numbers appear in the Item Cost pane. These numbers show the item costs for a thousand board feet (MBF).

View item costs in MBF

In this example, the average cost (Avg) of $2 is used to calculate the first PO value of $375 per MBF. Similarly, the market value cost (Mkt) of $3 is used to calculate the second PO value of $562.50 per MBF. The Last box displays the item cost of $1.00 from the most recent purchase order as well as the equivalent MBF cost of $187.50.

Note: To ensure precise PO cost values, calculated numbers are saved at much higher accuracy (more values after the decimal point) than we display.

To save the MBF calculations, click Save or press F12.

Once the MBF costs are saved with the inventory item, both the cost for the item, and the equivalent MBF cost, will appear when you add this item to a purchase order.

MBF in purchase order

Showing prices in MBF

If you opt to show prices in MBF on invoices and quotes, the Sale Price changes to the alternate unit price in the inventory item.

Show prices in MBF, MSF and Ton screenshot

This price will also appear on invoices and quotes. However, invoice quantity and pricing is still calculated using the ‘per piece’ (EACH) price.

MBF on invoice

 

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: 9/27/21