Also, if it's urgent just to get the cash receipts updated, they can put the deposit back in and ignore the bark from Sage about overpaying the invoice and it will update correctly. The only place you will still see an issue is Cash Receipts Entry lookup.
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, and Cagney
Beth Bowers
269-445-1625
------------------------------
Original Message:
Sent: 03-23-2019 10:05
From: Brett Zimmerman
Subject: ARWAR4 ineffective Sage 100 Premium
Could just manually edit the ar_openinvoice file if not too many records are in play.
------------------------------
- Brett
------------------------------
Original Message:
Sent: 03-22-2019 21:03
From: Robert White
Subject: ARWAR4 ineffective Sage 100 Premium
That utility should match what's in cash receipts data entry tables and update AR_OpenInvoice.PaymentsToday accordingly.
You could reinitialize the cash receipts data entry tables or throw caution and run a SQL statement
use mas_abc
update ar_openinvoice
set paymentstoday = 0
------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON