Many of our items are precious metal having very small individual weights. The SO_InvoiceWrk file file has the shipment weight accurately as the sum of he weights of all the goods in the package. We created a special invoice form to show the individual item weights and the total weight for each invoice line. (ItemWeight * QtyShipped) The form only works with items where weight is greater than 0.015. The line item weight field is only accurate to 2 decimal places.
For example:
Item weight is 0.0055. The Line item weight field has this rounded to 0.01.
12 Qty actually weights 0.0660. Using the rounded line item weight Crystal says they weigh 0.12.
Item weight is 0.003, The line item weight rounds this to 0.00.
1000 Qty still calculates in Crystal as 0.00.
If the weights are carried to 4 decimal places in I/M, we'd like the same level of precision in the Crystal Work table.
by: Russ N. | over a year ago | Sales & Distribution
Comments
This should now be done as of 4.40