Topic Options
#64669 - 09/09/20 11:07 AM Apply system checks issues from SP 20200716
Braedon Offline
Adagio Graduate

Registered: 09/16/16
Posts: 42
Loc: BC
Hello

From my reading it appears that there was an issue posting system checks in AP service pack 20200716. That appears to have been fixed in SP 200811.

However we appear to have had 2 batches create the errors well we had the older pack and well that does not happen anymore under the new one I can't find instructions to repair the errors that are appearing in 6 of our vendors.

I've tried to use data integrity check and it finds the errors and says it has fixed the errors but I go look at the vendor and the error is now different.

Before the repair it showed the invoices as outstanding and the payment as zero. After it shows both the payment and invoices outstanding but I can't find a way to apply them to each other and clear them.

Top
#64670 - 09/09/20 11:53 AM Re: Apply system checks issues from SP 20200716 [Re: Braedon]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3617
Loc: Toronto ON, Canada
Braedon:

As a precaution, do a backup of Payables. Then, using the Manual Checks function, enter a $0.00 cheque for each affected Vendor and apply the outstanding payment against the outstanding Invoice.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#64671 - 09/09/20 11:58 AM Re: Apply system checks issues from SP 20200716 [Re: Braedon]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4514
Loc: Wynnewood, PA
Hi Braedon

If your problem is related to the faulty service pack, then the outstanding payment is really a prepayment. You can match prepayments against invoices by applying them against each other in a manual check batch, so that the total of the check is $0.

If you are unable to select the prepayment, use this advice that I got from my friend Vickie Cegliastro:

"Steve, I don't know if it's the same issue as I've seen but you have to set the Maximum amount on the PP entry created by the cheque run (as it's set to zero), then you can match it to the invoice."

Or show this to your Adagio consultant and they will be able to help you.

Steve

Top
#64672 - 09/09/20 12:06 PM Re: Apply system checks issues from SP 20200716 [Re: Bruce Gardner]
Braedon Offline
Adagio Graduate

Registered: 09/16/16
Posts: 42
Loc: BC
I can post a manual check for some. But for others the un-applied payment does not appear when I go to create a check so I can't make a net zero check to those accounts.

Top
#64673 - 09/09/20 12:11 PM Re: Apply system checks issues from SP 20200716 [Re: Steve Schwartz]
Braedon Offline
Adagio Graduate

Registered: 09/16/16
Posts: 42
Loc: BC
I've done this now for 5 of the 7 vendors. 2 of the vendors don't show a prepayment line for me to match the invoice to
Not quite sure what is meant in the latter part about the maximum amount on the pp entry created.

EDIT: I've noted that the 2 that don't show a prepayment line in the manual check batch still show as negative system checks rather than prepayments in the vendor profile transaction details


Edited by Braedon (09/09/20 12:18 PM)

Top
#64674 - 09/09/20 01:08 PM Re: Apply system checks issues from SP 20200716 [Re: Braedon]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4514
Loc: Wynnewood, PA
System checks with outstanding balances are a sign of corrupted data - it should never happen.

The solution is to use GridView ReadWrite to delete the matching transactions - most likely you don't own that module. But your Adagio consultant does, and he/she can do it for you.

Steve

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 80 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14483 Topics
70727 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31