Build: 9210
Build date: 12-Aug-15

To make sure that money is accounted for when inventory items are deleted, we’ve made two updates.

Deleting an inventory item with non-zero stock-on-hand
When you delete an inventory item that has stock-on-hand, the item is removed from active inventory and the stock-on-hand (SOH) quantity is converted to shrinkage.

Previously, when you deleted an inventory item, the stock-on-hand was set to zero (0) and the investment dollar loss was not recorded.

Deleting an inventory item that is on backorder is not allowed
An inventory item that has open purchase orders is on backorder and cannot be deleted (removed from active inventory). Active inventory items are required for purchase order receiving

If the backorders for an item will not be fulfilled, you can cancel them on each purchase order, and then delete the inventory item. You can also cancel all backordered items on a single purchase order. The steps below show you how to do both.

Previously, you could delete an item that was on a purchase order.

To cancel all backorders of an item, follow these steps:

  1. Open Paladin Point of Sale.
  2. Click the Inventory module.
  3. Search for the inventory item, and open it.
  4. On the Inventory tab, in the inventory item details, click the On Order magnifying glass.
  5. In the Qty On Order window, highlight any backorder. Note: To find backorders, look for orders where the B/O Canceled checkbox is not selected and the Qty B/O value is greater than zero.
  6. Click F8 Cancel Backorder.
  7. In the Cancel Backorder window, click Yes.
  8. Perform steps 5-8 again for all additional backorders.
  9. Click Done.

To cancel all backordered items on a purchase order, follow these steps:

  1. Open Paladin Point of Sale.
  2. Click the P.O. module.
  3. On the bottom ribbon, on the Mode button, make sure the Receive option is selected. Note: If Receive is displayed in black letters, this option is selected. If it is in gray letters, click Mode to select the Receive option.
  4. On the bottom ribbon, click Find P.O.
  5. In the Find PO window, use the PO Details search fields to find the purchase order.
  6. In the Matching Purchase Orders pane, highlight the purchase order with the backorders that you want to cancel.
  7. Click Cancel B/O on the bottom of the window.
  8. In the Cancel Backorder window, click Yes.
  9. Click Cancel to close the Find PO window.

Tip – How to find backorders that were never received and stop revenue loss
An item may be out-of-stock and you don’t know it because a backorder was only partially fulfilled. Today, most suppliers will fill a purchase order with the items they have on-hand even if the number of items is less than you ordered. Typically, suppliers don’t follow up and you never receive the remaining items. EDI processing normally closes these purchase orders, but orders from non-EDI suppliers may remain open indefinitely. When this happens, you may run out of items and lose sales because you are not aware of the outstanding backorders.

You can prevent this revenue loss by regularly reviewing older open purchase orders and cancelling the backorders that will not be fulfilled.

To review older open purchase orders, follow these steps:

  1. Open Paladin Point of Sale.
  2. Click the P.O. module.
  3. Click Find P.O.
  4. In the Find PO window, in the PO Details pane, select Open POs.
  5. On the bottom ribbon, on the Mode button, make sure the Receive option is selected. Note: If Receive is displayed in black letters, this option is selected. If it is in gray letters, click Mode to select the Receive option.
  6. In the Matching Purchase Orders pane, click the PO Date column title to sort the open purchase orders from oldest to newest.
  7. Evaluate older purchase orders to determine why they are still open. To open a purchase order, double-click it.
  8. See the annotated picture of purchase order below and use the following information to help you make decisions about the purchase order.
    • Backordered items have non-zero Received quantities.
    • If the backordered quantity (Received) is less than the ordered quantity (ORD), then the order was partially fulfilled and the remaining order will likely never be received.
      Shows the receive PO screen with callouts for the ways to delete back orders and how to read the ORD, REC and Received fields for an item on a PO
  9. If the purchase order will not be fulfilled, cancel backordered items in the purchase order and then process the purchase order.
    1. Select backordered items to cancel. Note: This sets the backorder quantity to zero. In the Receive PO pane, select the Del checkbox for each backordered item you want to cancel.
      -or-
      Select the top Del checkbox to cancel all backordered items.
    2. On the bottom ribbon, click Process. The Confirm PO tab displays.
    3. On the bottom ribbon, click Process.
    4. In the PO Freight window, click OK.
  10. Repeat steps 3 thru 9 to evaluate and process other older purchase orders.

Note: The accounting changes we implemented supports the Generally Accepted Accounting Principles (GAAP) standard.

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