Fields for Sales Order Form

[Mike M]

Please accept my apology if this entry is in the incorrect topic location.

I'm attempting to create a Sales Order form and need assistance with calculated fields.

Scenario- User needs to enter Quantity (Qty), Length in Feet (Length in Feet), Length in Inches (Length in Inches), Width in Feet (Width in Feet), Width in Inches (Width in Inches), to calculate (Line Qty). Depending on the type of inventory item some of these fields may or may not be required. Please see below.

I created a (Length) field calculated as "Length in Feet + (Length in Inches/12)" and (Width) field as "Width in Feet + (Width in Inches/12)"

"Line Qty" field is currently calculated as: "Qty * (Length * Width)" but would also need to be just "Qty" when Length and Width are 0. i.e, the item is a "Widget"

"Line Weight" field is calculated as: "Line Qty * Unit Weight:Inventory Table)

Based on the type of inventory item there will at times be only Qty (when selling Widget or PCS that have no dimensional requirements) which require no Length or Width, and other times only QTY and Length, if the item is a linear length item it will not require a Width.

Therefore, I setup a field in the Inventory table (linked to the Sales Order Line Items table) that contains one of the following values "Length", "Area", or "Widget" to reference if Length in Feet, Length in Inches, Width in Feet, Width in Inches, are required entries in the Sales Order form.

Ultimately, if the user enters an Item Id in the Sales Order form and its is a "Widget" class item, the Length and Width fields will not be active or available for data, and the same for "Length" class items will not prompt of Width during data entry.

Questions-

1) How do I setup the fields or calculations to work properly when the value of Length in Feet, Length in Inches, Width in Feet, Width in Inches = 0 or the field is empty?

2) How can I make the fields inactive or unavailable in the form during data entry if the Item Id class value would indicate no data is required in the corresponding field(s)?

3) I need the value of the Length in Feet, Inches, Width in Feet, Inches to be stored for future reference and reporting. I assume there is no need to store the Line Qty or Line Weight but I'm not sure about that due to the data being referenced in future reports.

Thank you for any and all assistance.

Mike Mankin

[email protected]