Support Request System
View Patch #60.101.083
PO Commitment Report - actual costs not accumulating properly
PO commitment report is calculating qty x price to determine transaction amount - in some cases qty x price does not agree to the amount - report needs to be changed to take the amount from the transaction line, not the qty x price on the transaction line.
Changed all SQL statements from getting the trnline.qty * trnline.uprice as the amount of the line to using the already calculated trnline.amount directly. This fixes incorrect values being reported on adjustment lines due to price changes between the PO and the VO. On adjustment lines, qty is the quantity vouchered, uprice is the voucher price and the amount is the difference between what has already been charged by the receipt and what needs to be charged, NOT the qty*price. So, the report just needs to use the calculated amount instead of calculating itself from the qty and the price.
Find a Patch
Return to Request System Menu