Topic Options
#28749 - 09/01/11 09:49 AM AP - Vendor Outstanding Balance Incorrect
Janelle Offline
Adagio Enthusiast

Registered: 10/21/10
Posts: 28
Loc: St. Lucia
Hi All

I have an issue in Payables (Version 8.1C) .... 4 invoices were successfully posted for a vendor totaling $3647.25. Posting Journal attached.

In a Vendor Inquiry, however, only the last invoice appears, which amounts to $711.00.

A Data Integrity Check found 3 errors as listed below:

Vendor 40007 balance outstanding is 3,647.25 calculated is 711.00
Vendor 40007 home currency balance is 3,647.25 calculated is 711.00
Vendor 40007 invoice count is 4 found is 1
Checking Transactions... ... 3 error(s) found

A rebuild does not correct the problem as it simply changes the outstanding balancing to match the calculated balance - the missing 3 invoices do not appear.

Has anyone seen this before?

Thanks.


Rgds
Janelle


Attachments
Posting Journal.gif (83 downloads)

_________________________
Rgds
Janelle

Top
#28776 - 09/05/11 08:11 AM Re: AP - Vendor Outstanding Balance Incorrect [Re: Janelle]
BAMPH Offline
Paradise is perspective

Registered: 07/15/01
Posts: 875
Loc: Christ Church, BARBADOS
Just to follow-up on this, Janelle's company decided to do a restore and re-key.

Having had a look at the AP only data, it looks as though AP Invoice postings before and after posting number 53 were all OK, so it would seem as though there was some sort of "glitch" during that specific posting causing only one of the four transactions reported as posted on the PJ to actually make it into the Vendor account. I don't know if the GL side of things went through completely as the AP data that I looked at appears to have already had the GL transactions retrieved and they decided to restore and re-key before I could confirm whether all was well in the GL.

As Janelle reported, the DIC did find and report the situation. In looking at the data, I would also say that the rebuild did as it's designed to do in such a situation and "corrected" the Vendor Balance to match the actual posted details in the Vendor account.

Regards, Pete
_________________________
Peter Banfield
BAMPH Consulting Services
Barbados

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 48 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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