Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: TRACKLENGTH

Compare Page Revisions



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


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:

Image

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


Image



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:

  • CWT
  • EA
  • FT
  • IN
  • LBS
  • SQFT





Image



Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions