Voucher Build ROUNDING ISSUE with multi-invoice line vouchers
Asking on behalf of my client: PS AP Release 9.2 PUM 28 Tools: 8.56.10
- spreadsheet voucher uploads have multiple invoice lines (but only 1 distribution line per invoice line)
- voucher build executes successfully but resulting vouchers are in RECYCLE status due to "Voucher Pay Amount <> sum of Scheduled Payment amounts". Differences are usually just a few cents.
- EXAMPLE: voucher GROSS_AMOUNT = 4528.87 ....there are 10 invoice lines. The PCODE is performing the following calculation: ROUND(4528.87/10,2) which yields 452.89 per line. When the lines are summed, the total is 4528.90 which results in the error message referenced above.
- see APVEDTSCHD.SCHDGrAm.STEP01
%Round(%DecDiv((%Bind(PVX_UNALLOC_AMT) - %Bind(PVX_ALLOC_SHR_AMT)), %Bind(PVX_UNALLOC_CNT)), %Bind(DECIMAL_POSITIONS))
0