Track Length - Revision history

Mwillard at 05:13, 8 April 2025

2025-04-08T05:13:05Z

Amohammad at 14:09, 9 April 2024

2024-04-09T14:09:36Z

Tcampbell: Tcampbell moved page Tracklength to Track Length

2023-01-23T18:26:41Z

Tcampbell moved page Tracklength to Track Length

Tcampbell: Tcampbell moved page TRACKLENGTH to Tracklength

2023-01-23T18:26:26Z

Tcampbell moved page TRACKLENGTH to Tracklength

Tcampbell at 18:25, 23 January 2023

2023-01-23T18:25:35Z

Tcampbell at 18:25, 23 January 2023

2023-01-23T18:25:03Z

Tcampbell: /* Rules */

2023-01-23T18:22:15Z

‎Rules

Tcampbell: /* Modification Processor */

2023-01-23T18:18:45Z

‎Modification Processor

Tcampbell: /* Transfers & Adjustments */

2023-01-23T18:18:27Z

‎Transfers & Adjustments

Tcampbell: /* Purchase Orders */

2023-01-23T18:18:14Z

‎Purchase Orders

@@ Line 1: / Line 1: @@
 __NOTOC__
 '''Default Menu Location''' Available from the Item Master sidebar
@@ Line 8: / Line 9: @@
 '''Any item with 'Track Length' selected should also be lot controlled.'''
 ===Settings Tab===
@@ Line 17: / Line 19: @@
 ''' When you select the 'Track Length' option on an item, the following fields on the Settings tab of the Item Master record aren't used anymore:  Base Cost, Unit Weight, Sq. Ft. '''
-[[image:TrackLengthSettings.png]]
+[[File:Screenshot_2025-03-17_101425.png]]
 ==Track Length Screen==
 The Track Length screen is accessed by clicking "Track Length" on the Item Master screen for an item.
 ===Fields and Filters===
@@ Line 34: / Line 37: @@
 '''The grid at the bottom of the screen can be used to override Base Cost, Min Qty/Max Qty (for ordering), Unit Weight, Unit Length, Unit SqFt for each ID1/ID2 combination.  If any of the calculated fields are set to zero (0), they will be recalcuated based on the factors and calculations at the top of the screen. '''
 ===Factors===
 '''Cost Factor: ''' This can be used to set up a certain cost as it pertains to the ID1/ID2 combination.  The expression is <nowiki>[cf]</nowiki> if you want to use it in a calculation. For example, if ID1 represents length, the amount entered here can reference a certain base cost per foot or inch.  This calculation would be entered as <nowiki>'[id1]*[cf]'</nowiki> to calculate the base cost per foot, assuming ID1= Length and <nowiki>[cf]</nowiki> = base cost per foot.
@@ Line 49: / Line 54: @@
 <nowiki>[sf]</nowiki> - References the SqFt Factor field;
-[[image:Lengthsscreen.png]]
+[[File:Screenshot_2025-03-17_102233.png]]
 ==Sales Orders==
 When you add an item to a sales order that has the 'Track Length' option selected, two fields will display so you can enter a length/width (or whatever the ID1/ID2 combination happens to be).  This will enter that specific combination to the Lengths screen automatically if it doesn't already exists, and calculate the weight, cost, etc. according to the defined calculations.  You can also change the Pricing Unit to display the sell price per LB, CWT, FT, IN, EA and SQFT (if item has an ID2 field for width).  '''ID1 and ID2 entries should be in decimal format.  Also, the sell unit is always 'EA'.'''
 ==Purchase Orders==
 Similar to sales orders two fields will display on a purchase order for these 'Track Length' items so you can enter a length/width (or whatever the ID1/ID2 combination happens to be).  This will enter that specific combination to the Lengths screen automatically if it doesn't already exists, and calculate the weight, cost, etc. according to the defined calculations.  '''ID1 and ID2 entries should be in decimal format.  Also, the purchase unit is always 'EA'.'''
 ==Transfers & Adjustments==
 The ID1 and ID2 fields were added to the inventory adjustment screen.  This allows adjusting in new combinations of lengths and widths without using a purchase order.
 ==Modification Processor==
@@ Line 70: / Line 81: @@
 You can use the Crop button to divide the ID1 field in half, or the Slit function split the ID2 field.  Once you either crop or slit the desired number of pieces, you can adjust the ID1/ID2 fields to the desired dimensions.
 ==Database tables==
@@ Line 76: / Line 88: @@
 ''' ITEMIDH: ''' This table links the calculations available in the ITEMIDCALC rule to the specific item code.  It also contains the base cost and weight factors from the Lengths screen.
 ==Rules==
@@ Line 81: / Line 94: @@
 ''' ITEMIDCALC: ''' This rule contains the calculations available in the Lengths screen.
-[[image:RuleMaintenanceITEMIDCALC.png]]
+[[File:Screenshot_2025-03-17_103426.png]]
 ''' Desc: ''' This is what displays in the dropdown when choosing the calculation.
@@ Line 90: / Line 101: @@
 '''Calculation: ''' This fields contains calculations using variables from the Factors section to calculate the cost, weight, length and square footage of each individual ID1/ID2 combination.
 ''' UNITS: ''' Since the calculations on the Lengths screen drives weights and cost conversions, you will want to set up a separate unit group for items with 'Track Length' selected in Item Master.  This new unit group should contain the following units, each with a one-to-one conversion ratio:
@@ Line 102: / Line 111: @@
 *SQFT
-[[image:IDgroup.png]]
+[[File:Screenshot_2025-03-17_104247.png]]
 ==FAQ==
@@ Line 108: / Line 117: @@
 '''Question: ''' Is there a way to update the values on the Lengths screen other than accessing each individual Item Master record?
-'''Answer:  ''' Yes.  There is an import that allows you to edit these values.  More information on that import can be found in the following link: [[IMPORTITEMID|CLICK HERE]].
+'''Answer:  ''' Yes.  There is an import that allows you to edit these values.  More information on that import can be found in the following link: [[Track Length Cost Update|CLICK HERE]].
 [[category:Item Control]]

@@ Line 23: / Line 23: @@
 The Track Length screen is accessed by clicking "Track Length" on the Item Master screen for an item.
-===Fields and filters===
+===Fields and Filters===
 '''Cost Calc:'''  This calculation can determine a specific base cost for each ID1/ID2 combination.  This base cost can be used for customer pricing.  For example, a customer tier of WALKIN can be set up to pay 75% over this base cost.  '''''Available fields for the calculation are defined in the Factors section below.'''''

← Older revision		Revision as of 18:25, 23 January 2023
Line 109:		Line 109:

	'''Answer: ''' Yes. There is an import that allows you to edit these values. More information on that import can be found in the following link: [[IMPORTITEMID\|CLICK HERE]].		'''Answer: ''' Yes. There is an import that allows you to edit these values. More information on that import can be found in the following link: [[IMPORTITEMID\|CLICK HERE]].
		+	[[category:Item Control]]

@@ Line 5: / Line 5: @@
 '''URL''' TrackLength_S.htm?
-The 'Track Length' selection on the Item Master screen is a way of tracking different subsets of inventory under one item code.  For example, you could have an item called FLATBAR12 for 1/2 inch thick flat bar and track all the different length and width combinations under that one item code.
+'''Function''' The 'Track Length' selection on the Item Master screen is a way of tracking different subsets of inventory under one item code.  For example, you could have an item called FLATBAR12 for 1/2 inch thick flat bar and track all the different length and width combinations under that one item code.
 '''Any item with 'Track Length' selected should also be lot controlled.'''

@@ Line 79: / Line 79: @@
 ==Rules==
-''' ITEMIDCALC: ''' This rule contains the calculations available in the Lengths screen. The complete rule maintenance wiki can be found [RULE-ITEMIDCALC|here].
+''' ITEMIDCALC: ''' This rule contains the calculations available in the Lengths screen.
 [[image:RuleMaintenanceITEMIDCALC.png]]

← Older revision	Revision as of 18:26, 23 January 2023
(No difference)

@@ Line 66: / Line 66: @@
 The ID1 and ID2 fields were also added to Modification Processor.  This allows making different length/width combinations by modifying existing inventory.
 '''Make sure the Allocate By is 'Catch Unit'.  This distributes the cost using the unit weight of the new pieces. (The unit weight is dictated by the weight calculation on the Lengths screen).  '''
 You can use the Crop button to divide the ID1 field in half, or the Slit function split the ID2 field.  Once you either crop or slit the desired number of pieces, you can adjust the ID1/ID2 fields to the desired dimensions.
 ==Database tables==