Welcome, Guest. Please Login.
05/15/25 at 20:56:42
News:
Home Help Search Login


Pages: 1
Send Topic Print
Old entries on AP Aging (Read 796 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Old entries on AP Aging
08/23/05 at 10:59:59
 
Back in the May, June, July 2003 time frame, we voided some checks.
Some of the invoices on these checks are showing up on the aging,
but they do not get presented for payment.
 
One of the vendors shows an open credit on the aging with a description of 'Voided Check # 29496'.
Another Vendor shows a couple of invoices as open bills.
 
These items should not show up at all.
What table would I need to edit to remove them from the aging??
 
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Old entries on AP Aging
Reply #1 - 08/23/05 at 11:54:33
 
It has been my experience, that DBA will put the liability back into accounts payable when a check is voided.
 
If one is not going to pay the original invoice, i.e. and you want it removed, you can go back into AP-B and enter the invoice number and select "REVERSE" this entry to clear the invoice from A/P and its aging.
 
Or if the invoice is against a p.o., go into A/P-C and edit the invoice, but inventory may be affected if the subject invoice was against a purchase order for inventory.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Old entries on AP Aging
Reply #2 - 08/23/05 at 12:04:16
 
You hit right on the problem ... the items that show on the aging do not show up in AP-B.
 
Any other Ideas??
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Old entries on AP Aging
Reply #3 - 08/23/05 at 15:36:18
 
Aging looks at BKAPINVT and BKAPCHKH - since these are old invoices, if you want to use the brute force method, those are the tables.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
worlduph
Browser
*


I love YaBB 1G -
SP1!

Posts: 8
Re: Old entries on AP Aging
Reply #4 - 08/29/05 at 08:55:11
 
I have this same problem.  So how do you use those report names to fix it please?
Back to top
 
 
  IP Logged
Rbuchanan
Browser
*


Is it too late to
change my mind
?!?!?!

Posts: 48
Gender: male
Re: Old entries on AP Aging
Reply #5 - 09/09/05 at 05:05:54
 
Had the same kinds of problems with VOIDs showing up on the aging.  Seems like DBA handles the G/L transactions fine, but in the files Lynn mentioned it doesn't always get all the correcting done.  For us it only is a problem on a multi-line payments.  It handles line #1 and leaves the rest on the aging.
 
You'll need to go into the files and find the record (line) with the invoices still showing on the aging, one of the columns has an invoice amount and another is either the amount paid or the remaining balance (can't get my tired mind to remember which!)  From there adjust the balance to show it as paid, then it'll drop off your A/P Aging without making entries to G/L that put your detail out of sync with the control account!
Back to top
 
 

Rob Buchanan
Macon Metal Products Company, Inc.

ISTS 2005.1 6/20 Update, 21 User
&
Evo 2005.1, 3 User

XP Pro w/ SP2 & Pervasive 2000i
MS SBS 2003 C/S Setup
Email   IP Logged
Pages: 1
Send Topic Print