Welcome, Guest. Please Login.
05/29/25 at 21:42:01
News:
Home Help Search Login


Pages: 1
Send Topic Print
AR INVOICES NOT APPEARING ON AGING (Read 903 times)
patm
Browser
*


I love YaBB 1G -
SP1!

Posts: 12
AR INVOICES NOT APPEARING ON AGING
05/02/06 at 12:39:18
 
Accounting assistant accidently entered a date of 06/18/06 for invoices to be posted on 04/18/06.  Before they were posted in the GL, we went to GL-P and corrected the date on all the transactions showing.  It seems to have posted correctly in the GL, but none of the invoices are appearing on the AR Aging report.  How can we correct this problem so the invoices will appear on the aging and on statements if not paid?  
 
Thanks for any help you can give.
Back to top
 
 
  IP Logged
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Re: AR INVOICES NOT APPEARING ON AGING
Reply #1 - 05/04/06 at 06:36:58
 
You'll have to go into maintain database.  I think the correct file to edit for the aging is BKARINVT.  You'll also want to check and correct BKARINV and BKARHINV.
 
Sean
Leybold Optics
Back to top
 
 
WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: AR INVOICES NOT APPEARING ON AGING
Reply #2 - 05/04/06 at 06:52:08
 
As well as the inventory files, Sales commissions, serial history and ? When invoices are posted, a ton of files are written to. If you void the invoice using the date on the original you will reverse all the transactions with the bad date. You will need to GL-P the entries that you have already changed to the date you used before.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
patm
Browser
*


I love YaBB 1G -
SP1!

Posts: 12
Re: AR INVOICES NOT APPEARING ON AGING
Reply #3 - 05/10/06 at 11:41:19
 
Sean
 
Thanks for your information.  I went into Maintain Database and corrected all the items.  They now appear in A/R for each customer but DO NOT appear in the aging?  Anyway to find our which file is for the aging?
 
Thanks.
 
Pat
Back to top
 
 
  IP Logged
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Re: AR INVOICES NOT APPEARING ON AGING
Reply #4 - 05/11/06 at 08:20:12
 
In the BKARINVT file, there is a field for the date and also one for date opened and closed.  Did you check the one for the open date?  
 
John's point above is well taken.  We don't use anything like lot control, serial control, commissions, etc. so I can't comment there.  But you may also want to check INVTXN.
 
Sean
Back to top
 
 
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR INVOICES NOT APPEARING ON AGING
Reply #5 - 05/11/06 at 10:21:40
 
Also the BKART file which uses a really convoluted logic to link together invoices and payments.  Voiding would have been a much better approach but too late now.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR INVOICES NOT APPEARING ON AGING
Reply #6 - 05/11/06 at 10:23:24
 
Also the BKART file which uses a really convoluted logic to link together invoices and payments.  Voiding would have been a much better approach but too late now.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR INVOICES NOT APPEARING ON AGING
Reply #7 - 05/11/06 at 10:24:11
 
Also the BKART file which uses a really convoluted logic to link together invoices and payments.  Voiding would have been a much better approach but too late now.
Back to top
 
 

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