Page History: TRACKLENGTH
Compare Page Revisions
Page Revision: Mon, 11 May 2020 16:14
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 is 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.
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.
Rules
ITEMIDCALC: This rule contains the calculations available in the Lengths screen.
