Proper Valuation of Jumpbooks

Owned by Mary Volkmer (Unlicensed)
Dec 26, 2019
3 min read

As sales records that include Jumpbooks are posted in Manual Sales, Jumpbook sales and refunds WILL affect stock on hand. Jumpbook sales will decrease stock on hand and refunds will increase stock on hand. Since Jumpbooks are not a physical item, the stock on hand starts at ZERO and will go into a negative number when sold at the POS Register.

 

Posted Jumpbook sales and refunds will be included in:

  1. The <F9> Sales History report.

  1. Stock Adjustments

  1. All posted sales reports.

  1. The stock ledger Sales, Sales Returns and Sales Discount reports.

  1. The stock ledger spreadsheet’s Sales, Sale Returns and Sale Discounts calculations.

  1. General Ledger entries.

 

Since Jumpbooks are not physical items, in that no stock is actually carried within the store, certain steps must be taken in order to ensure proper valuation of these items in the stock ledger, and a proper calculation for cost of goods sold.

 

To properly value Jumpbooks:

  1. Add the Jumpbook item to a course request.

  1. Work the Order Decision for this Jumpbook item (so each Order Decision record is in a “Worked” status).

  1. Create a new item in Item Maintenance called an “OPEN PO ITEM.” This will be the item you use to keep a purchase order open. This OPEN PO ITEM will have $0 cost and $0 retail.

  1. Create a new Purchase Order and add the OPEN PO ITEM to the PO.

  1. Add each of your Jumpbooks to that PO with a requested qty that matches the order decision for that Jumpbook.

  1. Post the PO (so it is in an OPEN status).

  1. Sell the item(s) at POS by the proper SKU.

  1. At the end of each month, look at the stock on hand of each Jumpbook and receive any negative stock on hand, so that the stock on hand of each item is back to zero. In other words, if one item is currently at –60 stock on hand, you will need to receive 60 of this item on the PO so the stock on hand offsets back to zero.

  1. Close your sales month normally and run inventory variance.

10.  When the invoice(s) come in, you will be paying for how many you sold. You can enter the invoice against the PO you received on.

11.  At the end of each term, you will also want to cancel the OPEN PO item on the PO so it will close. At that point, you will create a new PO using the new term information (adding the Jumpbooks attached to the new term).