Cuts and Mods: Using the Application

(ITR users only)

Use the following procedure to adjust inventory quantities when you cut or modify an inventory item.

The To SKU (the SKU you are creating by cutting or modifying the original SKU) must have the same stocking unit as the original SKU. For example, if the original SKU's stocking unit is Board Feet, the To SKU must also have Board Feet as its stocking unit.

1. Display the Cuts and Mods dialogFrom the Eagle Browser, click Cuts and Mods. Or, enter CM, C&M, or IAD in the Launch bar and press Enter:
   
   You can also access Cuts and Mods from Inventory Maintenance and from Inventory Transaction Register (ITR).
   
   
    .

2. Fill in the fields. For more information about a particular field, click it in the list below.

3. StoreMultistore users: enter the store to use for this adjustment. This field defaults to the Lockin Store.

4. Adjustment TypeSelect the type of adjustment you are making to an inventory item.
   
   Cut: Select this option if you are cutting the item (the "From SKU"). For example, use Cut when a 12-foot board is cut into two 6-foot boards.
   
   Downgrade: Select this option to change the item (the "From SKU") to a different SKU (the "To SKU") that has less value. For example, use Downgrade when an item has been damaged in some way, but can still be sold under a different SKU, for a lower price.
   
   Upgrade: Select this option if the item (the "From SKU") has increased in value. For example, use Upgrade when a SKU was received under a certain SKU number but it is later discovered that the quality of the SKU is such that it can be sold for a higher price under a different SKU. 

5. Last Receipt Date?This field defaults to the value set in Option 8380 "Cuts and Mods Default – Update last receipt.”  To change this field, you must make a selection from the drop-down list.
   
   Yes = When you finalize a Cuts & Mods transaction, the Last Receipt field in Inventory Maintenance is updated with the current date for all SKUs in the transaction.
   
   No = When you finalize a Cuts & Mods transaction, the Last Receipt field in Inventory Maintenance is not changed for any of the SKUs in the transaction.

6. Phys Inv Date?This field defaults to the value set in Option 8381 "Cuts and Mods Default – Update phys inv date.” To change this field, you must make a selection from the drop-down list.
   
   Yes = when you finalize a Cuts & Mods transaction,  the Last Phys Inv field in Inventory Maintenance is updated with the current date for all SKUs in the transaction.
   
   No = when you finalize a Cuts & Mods transaction,  the Phys Inv field in Inventory Maintenance is not changed for any of the SKUs in the transaction.

7. Avg or Repl Cost?

   This field defaults to the value set in Option 8138 "Default cost update for Cuts and Mods.” you must make a selection from the drop-down list.
   
   
   If you decide to update the cost of the Cuts & Mods transaction, only the To SKU's average and/or replacement cost is updated; the costs of the From SKU in the transaction remain unchanged.
   
   A = Average Cost. Select this option to update the Average Cost in Inventory Maintenance for the To SKUs in the transaction.
   
   B = Both Average and Replacement Cost. Select this option to update both the Average and Replacement Cost for the To SKUs in the transaction.
   
   N = No Cost Update. Select this option to prevent Cuts & Mods from updating the Average or Replacement Cost for the To SKUs in the transaction.
   
   R =Replacement Cost. Select this option to update the Replacement Cost for the To SKUs in the transaction.

8. Inventory Stock U/MSelect the stocking unit of measure— Board Feet, Lineal Feet, or Each/Piece— of the SKUs in the transaction. For example, if you are cutting 2 x 4 x 12 into 2 x 4 x 6's, and the stocking unit of the 2 x 4 x 12 is Board Feet in Inventory, select Board Feet from the drop-down list. If the stocking unit is set to a unit that refers to an each or piece, such as BD (by the board), select "Each/Piece.” If the stocking unit is set to a unit that refers to lineal feet, select "Lineal Feet”, and so on.
   All calculations in Cuts & Mods for the From and To SKU will be based on the values on the Pricing tab in the Stock column – this is why you must indicate which stocking unit of measure you are using.

9. From SKUEnter the item that is being modified by the adjustment and which will become the To SKU(s). This field defaults to the value in the SKU field in ITR at the time you enter the Cuts & Mods application. If you are creating a Cut transaction, the From SKU must be an L-type (lumber) inventory record with the Lumber Type set to 0 (User-Defined), 1 (Dimensional) or 2 (Hardwoods).
   
   If Lumber Type is set to 0, you are required to enter the dimensions (Thickness, Width, and Length) of the From-SKU. For hardwoods, use the decimal form for fractional values of thickness and width. For example, if the thickness is 5/4 inch, enter 1.25. If the width is 10 1/2 inches, enter 10.5.
   
   If the Lumber type is set to 1 or 2, the dimensions are automatically copied from Inventory Maintenance.

10. CommentIf desired, enter a short description for the Cuts & Mods transaction so that it can be viewed in ITR at a later time. This field defaults to the description of the From SKU. When the From SKU field is empty, the Comment field is also blank. When you finalize a Cuts & Mods transaction, the contents of this field write to the Cuts & Mods Desc column in ITR for both the From SKU and To SKU(s)..

3. When finished, click OK. The Qty field displays. If you selected "Cut" as the Adjustment Type, additional fields for Thickness, Width, and Length also display. These fields are filled in automatically with the dimensions in Inventory Maintenance, unless the item is set up as Lumber Type 0 (user-defined), in which case you'll have to manually enter the dimensions.

4. In the Qty field, enter the quantity (the number of pieces) of the From SKU that you have cut/downgraded/upgraded. For example, if you are upgrading one piece of lumber, enter 1, if you cut two pieces of lumber, enter 2, etc. Make sure you enter the number of pieces, NOT the number of board feet. If there are no more fields in the dialog, skip to step 6.

5. If the fields for Thickness, Width, and Length are displayed, they will already be filled in if the From-SKU is Lumber Type 1 or 2. If the From-SKU is set up as Lumber Type 0, the fields will be blank, and you must enter the dimensions of the From-SKU. For example, if you are using From-SKU pieces that are 2x4x12, enter 2 in the Thickness field, 4 in the Width field, and 12 in the Length field. For hardwoods, use the decimal form for fractional values of thickness and width. For example, if the thickness is 5/4 inch, enter 1.25. If the width is 10 1/2 inches, enter 10.5.

6. Click OK. The To SKU fields display at the bottom of the dialog. In the middle of the screen, the From SKU information is displayed, as well as a summary of remaining board feet and cost, if the Adjustment Type is a Cut.

7. In the To SKU field, enter the SKU of the items you created from the From SKU. For example, if you cut a 2x4x12 to create 2x4x6's, enter the SKU for 2x4x6's. If you are upgrading a 2x4x16 because you had it treated, enter the SKU for treated 2x4x16's.

8. In the Qty field, enter the quantity (the number of pieces) of the To SKU. For example, if you created two 2x4x6's from a 2x4x12, enter 2. If you are upgrading one 2x4x16, enter 1. Make sure you enter the number of pieces created/modified, NOT the number of board feet. If there are no more fields in the dialog, skip to step 10.

9. If the fields for Thickness, Width, and Length are displayed, they will already be filled in if the From-SKU is Lumber Type 1. If the From-SKU is set up as Lumber Type 0, the fields will be blank, and you must enter the dimensions of the From-SKU. For example, if you have created 2x4x6's, enter 2 in the Thickness field, 4 in the Width field, and 6 in the Length field. For hardwoods, use the decimal form for fractional values of thickness and width. For example, if the thickness is 5/4 inch, enter 1.25. If the width is 10 1/2 inches, enter 10.5.

10. Click OK. The To SKU fields at the bottom of the dialog are now cleared, and the From SKU Definition and the To SKU List display in the middle of the dialog.

11. If you have another To SKU to enter, enter it now, enter the Qty, and click OK. Repeat as necessary until you've entered all To SKUs.

12. If you need to delete a To SKU from the To SKU List, click the checkbox to the left of the To SKU you want to delete, then click Delete To SKU.

13. When you have finished entering To SKUs, click OK. The Confirm Finalization screen displays.

Scrap SKU information displays in the middle of the screen if both of the following are true: 1) you selected Cut as the Adjustment Type, and 2) option 8136 "Allocate unapplied amounts in Cuts and Mods" is set to S (Scrap SKU) in Options Configuration.

14. Do one of the following:

15. If you're satisfied with your entries, click Finalize.

16. If you need to enter more To SKUs, click Continue Entry. When finished, click OK, then click Finalize.

17. If you need to delete a To SKU, select a SKU in the list, then click Delete To SKU. When finished, click OK, then click Finalize.

18.  To abort all changes, click Cancel to close Cuts & Mods.

If you clicked Finalize, a confirmation message displays.

Submit Your Comments on This Help Topic