IDLIST

Modified on Thu, 13 Aug 2020 13:48 by J Denniston — Categorized as: Uncategorized

Image

'F' button: This displays a dropdown where you can selected predefined formulas from the ITEMIDCALC rule (defined more in the Rules section below).

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.

Cost Factor: This field allows you to enter a base cost as it pertains to a specific ID1/ID2 combination. For example, if an item's base cost is 2.00 per foot, then you could enter '2.00' as the Cost Factor and '[id1]*[cf]' as the 'Cost Calc' to have it multiply that cost by the length (which is represented by the ID1 field).

Wt Calc: This calculation can determine a specific weight for each ID1/ID2 combination. For example, if something was 3.5 lbs/ft, then you would enter 3.5 as the Wt Factor and '[id2]*[wf]' as the Wt Calc.

Wt Factor: Much like the Cost Factor, this field holds the weight as it pertains to a specific ID1/ID2 combination (weight per foot, weight per square, etc.).

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 [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;

[lf] - References the Length Factor field;

[sf] - References the SqFt Factor field;