Q. I am pulling a single purchase receipt (including freight) into a purchase invoice and receive a freight conflict error message. Why is this happening?
A. When the billing divisor is relatively high and the invoiced quantities for some of the items are very low, the rounded calculated freight rate per unit will appear different for the items with very low quantities than the items with higher quantities.
For example, you may invoice a product in pounds and inventory it in tons, which makes the billing divisor 2000. On the purchase receipt, you have this product on its own line item. However, perhaps because of pricing differences or partially prepaying the invoice, the line is split on the purchase invoice, one line with a quantity of 55 pounds and the other with a quantity of 500 pounds. An estimated $/unit freight cost of $5 was entered on the purchase receipt.
When Agvance calculates the estimated freight for the line item with 55 pounds, it comes up with $0.14. The actual calculation comes out to $0.1375 (55/2000 * $5/ton). When the estimated freight is calculated for the line item with 500 pounds, the answer calculated in Agvance is $1.25, same as the answer when calculated by hand (500/2000 * $5/ton). There is no question that the per unit calculation works out correctly for the second line item. However, because of rounding, the calculation for the first line item is slightly off (by $0.0025), which is enough for Agvance to recognize that slight difference in unit cost for the same product. The freight conflict message will appear. Freight amounts are populated for each line item, but the freight frame in the lower left corner is not populated.
At this time there is no workaround for this issue. It should not happen frequently, just when extremely small amounts of product are invoiced, as in the example above.
