How to Create a Variable Weight Item for the Serial In-Serial Out Scenario

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

To create a variable weight item

1. Choose the Search icon, enter items, and choose Items.

2. On the Home tab, choose 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. Click OK.

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

7. Enter information on the Invoicing FastTab.

   • Costing Method: Select FIFO.

   • Sales Price Unit of Measure Code: Select the UOM that represents the weight (for example, LBS) the item is sold in.

   • Purchase Price Unit of Measure Code: Select the UOM that represents the weight (for example, LBS) the item is purchased in.

8. Enter information on the Item Tracking FastTab.

   • Item Tracking Code: Select a code that is set up for variable weight: Serial In-Serial Out.

     If a code has not been set up, see Create a Variable Weight Item Tracking Code for the Serial In-Serial Out Scenario.

9. 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).

To define a customer sales price by weight

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

1. On Item Card window, on the Navigate tab, in the Sales group, choose Pricing>Sales Price Calculations by Item.

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. Click Close.

To define a vendor purchase price by weight

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

1. On Item Card window, on the Navigate tab, in the Purchases group, choose Special Prices & Discounts Overview.

2. In the Unit of Measure Code field, select same unit of measure defined in the item’s Purchase Price Unit of Measure field.

3. In the Direct Unit Cost field, enter the price per weight unit of measure.

4. In the Vendor No. field, select the vendor that the price applies to.

5. Click Close.

See Also

About Variable Weight

© 2018 Microsoft and IndustryBuilt. All rights reserved.

JustFood 2018 (11.00.00.00) | February 2018