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: Tue, 19 May 2020 14:26

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

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

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¶

---