I know it is a little confusing.
The formula to calculate Unit Cost on ILE is Total cost / Qty. base = 3112.47/125.2
Total Cost is from Whse. Receipt Line, which is from Purchase Line. The formula is Unit cost x Base Qty. - Discount = 24.86 x 125.2 = 3112.47 (rounded to 2 decimals)
Total Cost can only have 2 decimals.
We must do it this way because of the potential line discount amount, unit of measure conversion (you can buy in EA, Box, Case, etc), and potential foreign exchange rate conversion if you buy from a foreign vendor.
In the end, it is not unusual that the inventory base unit cost is a little bit off than the PO unit cost. The difference is immaterial.
Scott
Comments
0 comments
Please sign in to leave a comment.