Welcome Guest, you are in: <root>AFIweb • Login

Page History: TRACKLENGTH

Compare Page Revisions

82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Mon, 18 May 2020 13:23

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).

Cost Factor: This field allows you to enter a base cost as it pertains to a specific ID1/ID2 combination. This base cost is what displays on the sales order and can be used for customer pricing. 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 the ID1 field).

Wt Factor: Much like the Cost Factor, this field holds the weight as it pertains to a specific 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.

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;

[lf] - References the Length Factor field;

[sf] - References the SqFt 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¶

---