Page History: TRACKLENGTH
Compare Page Revisions
Page Revision: Thu, 14 May 2020 15:04
Item Master
Settings Tab
ID1: Enter a label here to define the primary way to segment inventory for the selected item. For example, enter 'Length' to track different lengths under one item code.
ID2: Define a second measurement (if needed). For example, you can track 'Length' under ID1 and use ID2 for 'Width' to track different sizes of plate.
#Lot tab
Lengths: This button is only available if the 'Track Length' option is selected on the Settings screen. Selecting it displays a screen where you can view/add/delete the different ID1/ID2 combinations and set up formulas to calculate base cost and weight for the different length and width combinations assuming ID1 is Length and ID2 is width. Here's what the screen looks like:
'F' button: This displays a dropdown where you can selected predefined formulas from the ITEMIDCALC rule (defined more in the Rules section below).
Calculations
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.Factors
Cost Factor: This can be used to set up a certain cost as it pertains to the ID1/ID2 combination. The expression is [cf] 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 '[id1]*[cf]' to calculate the base cost per foot, assuming ID1= Length and
cf= base cost per foot.
[id1] - References the ID1 field;
[id2] - References the ID2 field;
[cf] - References the Cost Factor field;
[wf] - References the Weight Factor field;
Database tables
ItemID: This table contains the fields in the grid of the Lengths tab.
ITEMIDCALC: 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
ITEMIDCALC: This rule contains the calculations available in the Lengths screen.
Desc: This is what displays in the dropdown when choosing the calculation.
Type: These types control where the rule displays on the Lengths screen. Valid types are: COST - displays in the 'Cost Calc' drop down; WT - displays in the 'Wt Calc' drop down; LEN - displays in the 'Length Calc' drop down; SQFT - displays in the 'SqFt Calc' drop down.
---
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:
