- Contents
- Index
- Search
Display results with all search words
Calculation of Dimensioned Line Value
A dimensioned price total is calculated for any inventory line that has a weight assigned. The price total also incorporates a discount and tax.
These rules apply:
If the Actual Weight field value does not exist, or equals zero
The price calculation is Active line quantity x inventory item's unit weight x inventory item's unit price
For example:
- Active line quantity = 3
- Item weight = 1.5kg
- Item price = $5.00
The dimensioned price total calculation is 3 x 1.5 x 5 = $22.50
If a discount is applicable, it is deducted from this price.
For example, if a 5% discount applies, the total price = $22.50 x 0.95 = $21.37.
If an Actual Weight field value does exist, and does not equal zero
The price calculation is Active line quantity x (Actual Weight/Active line quantity) x inventory item's unit price
For example:
- Active line quantity = 3
- Actual weight = 5.5kg
- Item price = $5.00
The dimensioned price total calculation is(5.5 รท 3) x 5 x 3 = $27.50
If a discount is applicable, it is deducted from this price.
For example, if a 5% discount applies, the total price = $27.50 x 0.95 = $26.12.
If:
- A unit of measure conversion applies to the line item (for example, the line unit of measure is entered in the selling unit of measure), Greentree Desktop converts the line quantity to the stocking unit of measure before calculating the price.
- Any of these line quantities are edited, Greentree Desktop
recalculates the line price without considering the weight, even if
it was entered:
- Packing Slip Maintenance form - quantity supplied
- AP/AR Invoice Entry form - quantity
- PO Receipt Entry form - quantity received
The unit price may have altered for the item, since the dimensioned price was last calculated. To recalculate the dimensioned price, you must re-enter the Actual Weight for the line.