ZEVA: Fix Rounding Error Between Credit Transaction Line Items and Detailed Credit Balance

[shayjeff]

Describe the task
Identify and correct a rounding error on the credit transactions page. The issue involves discrepancies between the sum of Credit Transaction line items and the Detailed Credit Balance for multiple suppliers.

Purpose
This task is important for maintaining accurate credit balance data on the credit transactions page. Correcting the rounding error will improve data integrity and prevent discrepancies that could affect credit balance and compliance reporting.

Acceptance Criteria

• [ ] The rounding error is identified and fixed, resulting in consistent totals between the sum of Credit Transaction line items and the Detailed Credit Balance.
• [ ] The discrepancy is resolved for all affected suppliers, with accurate credit balances displayed.
• [ ] The fix is validated by sampling multiple suppliers to confirm that the rounding issue is consistently addressed.

Additional context

• The rounding error has been observed among several suppliers, indicating it is not an isolated issue.
• The discrepancy occurs between the summed Credit Transaction line items and the Detailed Credit Balance, affecting overall credit balance accuracy.

The BA had sampled a handful of suppliers and all of them have a rounding issue. Please reach out to the PO for the list if needed.

[shayjeff]

Notes from the business area: Rounding issue – All Suppliers (including Tesla) Credit Transaction Page -Under Credit Transactions: i. The credit column when summed result with a rounding error of (0.01). ii. This can affect both credit A or B columns depending on how the supplier paid their obligation

[katerinkus]

The fix works for current calculations but not for numbers that are already stored. PO to check with the business area about the plan.