Sage 300

Sage 300 Customer Inquiry screen, documents tab - anyone know how the balance column is calculated? Customer has noted a number of invoices where balance column = 0 but the payments in the lower grid don't add up to the invoice total. Doesn't show up on stock aging report but does show on custom aging report.

@PhilMcIntosh - What tables are used in the custom aging report? If it's pulling from the AROBS, these are scheduled payments (outstanding) transactions. The inquiry screen should be pulling data from AROBL.

One custom report is using just AROBL and AROBS. AROBL detail is correct, but the balance field in the screen says 0 when it shouldn't. I don't see an actual balance field in either table...

I would guess someone edited the balance field in the AROBL table. If you look into the AROBL for the transaction in your example, what is the value in AMTDUEHC, SWPAID AND AUDTDATE fields?

Also, you could look into the AROBP table to find the payment against the invoice. You could query by IDCUST, IDINVC to find any payments against the invoice.

@LloydSmith - I did the query of AROBL & AROBP, and fortunately it is just the four invoices for one customer and not something system-wide. I updated SWPAID to 0 and the AMTDUEHC fields in AROBL, but the inquiry screen still shows the full amount paid in the applied amount column.

@PhilMcIntosh - The payments amount come from the table AROBP and are linked to the document via IDINVC, IDRMIT. The AMTPAYMHC is what shows up as the Transaction Amount in the payment section. To affect the Applied amount you need to change the following fields in the AROBL for the invoice(s) in question, AMTDUETC (customer currency) and AMTDUEHC (home currency).

Ahh, amtduetc as well - that fixed it. Thank you!

Fixed these balances, but now when the payment arrives, the user receives a message that the ""Specified amount is greater than the balance due"" SWPAID is zero (unchecked), AROBL shows a balance, AROBP shows the correct partial payment only. What else does the code check before issuing this error?

@PhilMcIntosh - it's going to be the same tables. Check the AMTDUETC and AMTDUEHC in the 3 tables. The tables AROBL, AROBP and possibly AROBS.

One example: orig invoice 1151.65. Previous payment 197.20, shows in AROBP. AROBS still shows 1151.65. AROBL shows AMTDUETC/HC as 954.45. Enter a payment of 954.45 and get the message

aahhh...after wasting an hour watching Sage support spin their wheels and decide the customer must have purged something, found AROBS fields AMTPYMRMTC and AMTPYMRMHC that needed to be set with the current balance.