AR Invoice Balance not updating when payment is applied

Kinetic ERP
1

We are encountering some Invoices that fail to update the Invoice Balance when a payment is applied (whether partial, full payment, or adjustments).

We’ve observed that while the InvcHead.UnpostedlBal field reflects the correct balance, InvcHead.InvoiceBal does not.

When we notice this issue, we use an updatable BAQ to manually fix the InvoiceBal field. However, in recent months, we have seen an increase in these cases, prompting us to seek a solution to prevent this from happening rather than fixing them on demand.

Here are two examples:

  1. Invoice 900693: Invoice Balance on screen should be $0 instead of $130.68, as it has been fully paid:

    image
    image1505×459 189 KB

  2. Invoice 900867: Invoice Balance on screen should be $5,425 instead of $10,850, as a credit memo has been applied:

    image
    image1422×472 178 KB

Has anyone else had this issue? We are currently on Kinetic 2022, using classic screens.

Appreciate any insight.

2

Can you recheck whether payment entries are posted or not. Check review journal too.
KR

3

This is regarding AR invoice balances being out of sync.

Payment entries are unrelated to this use case.

No review journals. However, we don’t have review journals turned on for all adjustment types or cash applications. Trial Balance is balanced

4

I mean receipt entries gets stuck in review journals in case of errors, check them too.