Sage 100

v4.4 client. Has about 800 AP checks to void and reissue. Looking at a VI job, but am concerned there is not way to answer the prompt ""do you want to recall the invoices"". Thoughts??

How about testing by importing one check and see what happens. Like you, I can't see where to put the answer into the import.

I imported all 863 lines (passed the test, no surprise) but it failed based on the division/vendor number being required. I haven't tried adding the these two fields yet.

Adding the division/vendor number imported into the header field but did nothing to restore the invoices. Current plan is to have the client clear the checks in BR, do a JE to restore the money to cash, fix the balance amount in bank code maintenance, then reimport the invoices for check printing...

Why does the client need to void/reverse and reissue that many checks? Did someone forget to change the starting check number when they originally printed?

Nothing as easy as that...

Client is a medical group that issues checks from the medical billing software via Sage 100. These checks represent outstanding items from 2013. They are cleaning up the books prior to their merger with another practice. They want to void and reissue the checks to see if they can't clear some of them.

Tell them they can feel free to send the checks to me instead.

@JeffSchwenk, how'd you make out with this? Did you happen to use either of these KB articles? https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20MAS%2090%20and%20200/Gated%20Customers/Warr_Svc_Support%20Plan/501183.html https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20MAS%2090%20and%20200/Gated%20Customers/Warr_Svc_Support%20Plan/527281.html

@JeffSchwenk how did you resolve this? I am fighting something exactly like this for a client just like yours; a medial practice who processes payments to patients for refunds, etc. Need to reverse a large batch of checks and reinstate the invoices so we can reissue correct payments. Thanks in advance for your help.

Client manually voided the checks.

Ouch!

They will know better for next time, though it would be very nice if the VI import of voided checks would restore to AP....

if the invoices weren't reinstated from the reversal wouldn't it be possible to import new AP invoices based on an export from invoice history?

That was actually what I was going to propose. Clear the checks in bank reconciliation normally. Reimport into AP with a slightly different invoice number. Make a JE to offset the impact...

Alrighty then, I was able to get a VI job to work and create the batch of void checks. We did this by reverse engineering a manual adjustment. I entered a check reversal and then created a VI export to dump all values in the AP_ManualCheckDetail, AP_ManualCheckHeader, and AP_OpenInvoice tables to see what the system was entering for me. I dumped the resulting data to a text file and included field names. I then opened the text file in Excel and deleted all blank columns and defaults related to the vendor. (Note, I had to go back into the file with a text editor after saving the file to correct text values that had leading zeros.) I then deleted the manual check reversal I had manually entered and created a VI Import job using the above text file as a source. The import worked. I then slowly removed columns to determine 1) the minimum column list needed to get the import to work, and 2) what column I was missing that caused my ""out of balance"" error. #2 first. I had assumed that if I provided the invoice number, the invoice amount paid would automatically populate, just like it does when entering by hand. WRONG (that ASS-U-ME thing bit me again!) You must enter the amount of the invoice being reinstated as a negative number. Otherwise the system brings in a 0. The resulting error from the VI job is the same you get entering the reversal by hand and changing the invoice amount to $0. The invoice distribution does not equal the amount of the check. Therefore it is out of balance. #1 - The list of columns I had to populate to get the import to work correctly: H.BankCode H.CheckType ('R') H.CheckNo H.APDivision H.VendorNo H.CheckAmt L.InvoiceNo L.InvoiceAmt I thought I would share this for the next poor soul who comes along trying to reverse a batch of checks.

WOW