This procedure explains the variable weight settings that need to be defined on the Item Card window for items in the Lot in-Serial Out scenario.

This procedure is not meant to explain how to create an item from scratch, it only shows the variable weight settings.

To create a variable weight item

  1. In the Search box, enter items, and choose Items.

  2. Click New.

  3. Enter a value in the No. field.

  4. Enter a description in the Description field.

  5. Create the item's units of measure.

    1. On the Navigate tab, in the Master Data group, choose Units of Measure. The Item Units of Measure window opens.

    2. In the Code column, add CASE (or similar) as the base UOM.

    3. On the CASE line, enter a value in the Weight column (which indicates the weight of a single unit. For example, a case weighs 10 pounds). The Qty. per Base UOM field is automatically populated.

    4. Go to the next line, and in the Code column, add LBS (or whatever UOM will make up the case).

    5. On the LBS line, enter a value in the Qty. per Base UOM column (which indicates how many pounds are in a case). The Qty. of Base Unit of Measure per Unit field is automatically populated.

    6. On the LBS line, enter a value in the Weight column (which indicates the weight of a single unit).

    7. Ensure that Allow Variable Qty. Per is NOT selected for any of the UOMs.

    8. Select CASE in the Base Unit of Measure field.

      9. Item Units of Measure

    9. Click OK.

  6. Select a value for the Item Category Code field.

  7. Enter information on the Invoicing FastTab.

    1. Select FIFO in the Costing Method field.

    2. Select the UOM that represents the weight (for example, LBS) in the Sales Price Unit of Measure Code and Purchase Price Unit of Measure fields.

      3. Item Card Invoicing FastTab


  8. If required, you can define a sales price by weight for certain customers.

    1. On the Navigate tab, in the Sales group, choose Pricing>Prices.

    2. In the Sales Type field, select Customer.

    3. In the Sales Code field, select the customer.

    4. Set up sales prices and/or sales price calculations using the same unit of measure defined in the item’s Sales Price Unit of Measure Code field.

      5. Item Card Sales Prices

    5. Click OK.

  9. If required, you can define a purchase price by weight for certain vendors.

    1. On the Navigate tab, in the Purchases group, choose Pricing>Prices.

    2. In the Purchase Type field, select Vendor.

    3. In the Purchase Code field, select the vendor.

    4. Set up purchase prices using the same unit of measure defined in the item’s Purchase Price Unit of Measure field.

      5. Item Card Purchase Prices

    5. Click OK.

  10. Enter information on the Item Tracking FastTab.

    1. Select a code that is set up for variable weight (Lot In-Serial Out) in the Item Tracking Code field. If a code has not been set up, see Create a Variable Weight Item Tracking Code for the Scenario Lot In-Serial Out Scenario.

    2. Select a value in the Lot Nos. or Lot Algorithm Code field.

    3. Enter a value in the Expiration Calculation field.

      Item Card Item Tracking FastTab

  11. On the Actions tab, in the Functions group, choose Weight>Calculate Net Weight.

    The Net Weight field is populated on the E-Ship FastTab. The net weight is calculated based on the defined units of measure (for example, if a case weighs 10lbs, then the net weight is 10lbs). The net weight flows to document lines (sales, picks, warehouse entries).

    Item Card E-Ship FastTab

  12. Click OK. The Item Card window is closed.

See Also

Tip