Welcome, Guest. Please Login.
10/31/24 at 21:25:30
News:
Home Help Search Login


Pages: 1
Send Topic Print
AP Aging showing old entries (Read 1310 times)
newline
Browser
*




Posts: 37
AP Aging showing old entries
02/10/09 at 20:14:30
 
Since the latest update (December) even after patches installed, when we run AP-I vendor aging or listing a number of really old entries show up (over 120 days) as well as the ones we're expecting, but only for some vendors.
 
The invoices showing up are long since paid. Has anyone seen this  / got any answers
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: AP Aging showing old entries
Reply #1 - 02/11/09 at 13:03:30
 
There is a utility program FIXAPAGE.RUN that should help but once it is run, there may be a few stragglers that will need to be edited in Maintain Database.  The latest version of the utility is available at www.istechsupport.com/dl/fixapage.zip; unzip to DBAMFG and run FIXAPAGE at UT-A
 
Once it is run, to clean up any stragglers, you need to use Maintain Database and find the invoices in the BKAPINVT file and make note of the "Invoice Number" which is actually a reference number and then open the BKAPCHKH file and find the payment(s) associated with the invoice (based on vendor code and invoice date) and edit the Invoice number to match the entry in BKAPINVT so the Aging program can match them up.  Or, if they are extremely old entries and you don't care about the history that far back, you can delete the entry from BAKPINVT.
 
Back to top
 
 

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




Posts: 37
Re: AP Aging showing old entries
Reply #2 - 02/12/09 at 19:06:54
 
That seems to have fixed it, Thanks  Smiley
Back to top
 
 
  IP Logged
Quirk
Full Member
***


It takes a
dysfunctional brain
to do this stuff.

Posts: 126
Gender: male
Re: AP Aging showing old entries
Reply #3 - 02/19/09 at 12:32:21
 
I have 3 stragglers so I ran fixapage and it fixed 2 and gave me 2 more.  1 remains unchanged.  I followed the following instructions and invoice numbers match.  So . . . .
Back to top
 
 
Email WWW   IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: AP Aging showing old entries
Reply #4 - 12/10/09 at 12:41:11
 
I ran this and got several stragglers.  However when I go to Maintain Database and open BKAPINVT I get an error: Btreive Status 35.  How do i fix that?
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: AP Aging showing old entries
Reply #5 - 12/11/09 at 13:51:06
 
UT-A, program MDBFXREG.  Accept the path and exit DBA and go back in.  You may also have to rebuild the DDFs using UT-J.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print