Serialized Items | Purchasing or Manufacturing an Item
  1. EBMS Knowledge Base
  2. Inventory
  3. Serialized Items | Purchasing or Manufacturing an Item

Adding Costs within a Serialized Item

EBMS allows the user to add parts, labor, or other costs to individual serialized items. For example, a serialized item that is purchased from a vendor or is a trade-in may need an additional part before the item is sold. The cost of the part(s) must be reduced from inventory and added to the cost of the serialized item. The total cost of inventory (parts or other perpetual items), labor, and other costs are recorded within the individual items to manage the serialized item.

Costs can be added to a serialized item using any of the following methods:

  1. Add inventory products from stock

  2. Add non-inventory parts or labor that increases the value of the serialized item

  3. Add costs from a purchase order

  4. Add parts and labor from a task or work order

Scenario: An equipment sales and service company may disassemble a used forklift to obtain parts to service a customer’s forklift. This trade-in forklift was disassembled for parts instead of being refurbished. Various component inventory counts need to be increased as the forklift is disassembled or consumed. The reverse manufacturing process is important to identify the forklift end as well as manage inventory of the resulting parts.

Adding Costs

Complete the following steps to add costs using any of these methods:

  1. Open a serialized item record and click on the Costs tab as shown below:

  2. The Costs tab displays the following costs for the serialized item:

    1. Purchase Cost:  This is the purchase cost of the serialized item derived from the expense invoice if the item was purchased or the manufactured value if the item was manufactured. The Vendor will display ($)ADJUST if the item was manually added or ($)MFG if the item was manufactured.

    2. Landed Cost:   This cost is added to the purchase cost to give a total cost including shipping or other process cost.   Review [Financials] Landed Costs > Overview for more details on this advanced purchase cost feature.  

    3. The Cost (G/L) value will be zero if the Only post Track Count Inventory Values to G/L option is enabled and the inventory item is not classified as Track Count or other perpetual item.

    4. The Cost (Pricing) amount will be copied from the perpetual cost of the inventory item and cannot be changed if the inventory item is classified as Track Count. The cost can be edited if the item is classified as No Count or Service.  Review Only Post Track Count Inventory Values to GL for details on the Cost (G/L) amount.

    5. The Processed Costs total reflects the total costs that are processed through added cost batches.  

    6. The All Costs total reflect all costs even if they the costs have not been processed by clicking on the Process button of the added cost batch.  

  3. Additional costs are added to an item in batches. Click on the New Costs button to create a new batch of costs.

    The Batch number is automatically incremented unless the user manually enters a batch number. The Batch number can be set within Inventory > Options > Manufacturing tab.

  4. Enter the Date the batch of costs is added to the inventory item.

  5. Verify the User name.  The User defaults to the login user. This value can be set to identify the individual responsible for posting the costs to the item.

  6. Disable the Only post Track Count Inventory Values to G/L option.  Review Only Post Track Count Inventory Values to GL for details on this option.  

  7. Enter miscellaneous information within the Memo field.

  8. Enter cost details.

  9. Enter the quantity of items added in both the Quantity and Transferred columns. The only advantage of entering a Quantity amount and not entering a Transferred amount is if you wish to allocate some inventory but the inventory has not been added at the time of the entry. The Quantity and Transferred fields are processed in a similar way as the Ordered and Shipped fields within the sales invoice. The quantity affects the Net Ordered amount with in the inventory item's count tab but it is not subtracted from the total inventory On-Hand.

  10. Enter the Inventory item and unit of Measure setting. The Description will be populated from the inventory record.

Repeat the steps listed above for each inventory item that you wish to add to the registered whole goods.

Click on the OK button to save the batch of costs without processing the batch. The batch must be processed by clicking on the Process button to apply costs to serialized item.

The Task and Work Order module within EBMS can be used to apply the costs to a serialized item:  This option is useful when processing a worker order for equipment or vehicles that are being resold.  Review [Labor] Tasks > Creating Tasks > Linking Tasks to a Serialized Item for instructions on this powerful tool for trade-in equipment, up-fitters, or other serialized items that are sold after the work order is processed.  

Added Costs Report

The recommended method to list the Added Cost Batch details is to generate a report.  Complete the following steps to generate the added cost information:

  1. Open a serialized item, click on the Costs tab, and open the Added Costs dialog as shown below:

  2.  Launch the Serialized Item Added Cost Batch Details report from the Print button as shown above.  Many of the prompts shown below will default when launched from the Print button.

    This report can also be launched by selecting Reports > Inventory > Serialized Items > Serialized Item Added Cost Batch Details from the main File > Reports menu.

  3. Select a Range of Added Cost Batch Numbers or select a single batch by launching the report from the batch's print button.  Review [Main] Reports > Print Buttons and Menus for instructions to a print button.

  4. Enter an optional Serial Number:  Leave this entry blank to list all added cost batches rather than limiting the list to a single serial number.  

  5. Enter a Serialized Product to limit the list to a group of serial numbers with the selected inventory ID.  Keep this setting blank to list all items.

  6. Select the Batch Status of All, Unprocessed batches, or Processed batches.  

  7. Set other optional report settings and click Print Preview to generate the following report:

Attaching Costs to a Purchase Order

Complete the following steps to create a purchase order from the Added Cost batch as shown below:

  1. Create an added cost batch and enter the information as described in the steps listed above.
  2. Enter a special order Product code and set the appropriate Purchase Method as shown below:
  3. Enter a detailed description that will be copied to the purchase order.   
  4. Enter a Vendor ID to identify the purchasing vendor.
  5. Right click on the line and select Create Order: Purchase Order as shown below to create the PO.
  6. Create purchase orders for additional lines within the same batch if desired.   

Review Special Orders and Drop Shipped Items > Purchasing Special Orders for more details on this powerful special order process that creates purchase orders from Added Cost Batches, sales orders, and manufacturing batches.   

Attach a Task or Work Order to Add Costs

Parts and labor costs can be added to a serialized Item's added cost batch by attaching a task to a batch.   Review [Labor] Tasks > Creating Tasks > Linking Tasks to a Serialized Item for instructions to use tasks to create an Added Cost Batch.

Process Transactions

The process procedure creates the following general ledger transactions:

Debit

Credit

Amount

Inventory Asset Account

(Serialized item)

Inventory Variance

(Serialized item)

Total Cost (G/L)

Inventory Variance Account of each detail item

If the Cost (G/L) value not zero (Track Count items) t hen Inventory Asset Account

If the Cost(G/L) is zero (No Count Items) then

Manufacturing Offset general ledger found within the item’s Advance tab.

Cost (Pricing) of each line

Unprocess or Void Added Cost Batch

Complete the following steps to unprocess or void a cost batch:

  1. Select a cost batch from the Cost tab of the serialized item.

  2. Click on the Edit Batch button to open the cost batch.

  3. Click on the Unprocess button to reverse the cost transactions.