Welcome, Guest. Please Login.
10/31/24 at 19:32:52
News:
Home Help Search Login


Pages: 1
Send Topic Print
A/P - B (Enter Vouchers) (Read 3056 times)
ddalman
Browser
*




Posts: 3
Gender: female
A/P - B (Enter Vouchers)
04/16/03 at 07:19:25
 
Hi,
 
I am on version 2001.1.  I am trying to back out an A/P voucher entered back in Jan.  Normally you can just enter the vendor name and invoice number and it will give you the choice to either back out the entry or reverse it.  However, I am not getting that option.  Instead I get a pop up window that says that invoice number already exists in the vendor file and it won't let me do anything else.  This is the 2nd time this has happened and I don't know why.  The invoice shows up on the vendor aging, but it does not appear in A/P-B and doing a look up on invoices for that vendor.  How do I get rid of this invoice?  Does any one know why this happens every now and then?
 
Thanks,
Denise
ddalman@iserv.net
Back to top
 
 

Denise Dalman
Office Manager
Imperial Carving Co.
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: A/P - B (Enter Vouchers)
Reply #1 - 04/16/03 at 08:09:34
 
Try to do a lookup and select it there instead of typing it in.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: A/P - B (Enter Vouchers)
Reply #2 - 04/16/03 at 08:21:29
 
Are you sure it was originally entered in AP-B?  If it was a PO Invoice from AP-C or a transfer from commissions or payroll, then you can't reverse it.
Back to top
 
 

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




Posts: 3
Gender: female
Re: A/P - B (Enter Vouchers)
Reply #3 - 04/16/03 at 09:09:05
 
Yes, it was entered as a voucher in A/P-B.  It was not a purchase order or a commission.  I have tried to do the look up on it, but it shows no invoices for this vendor yet it shows up on the vendor aging and also under A/P-F (Pick vouchers to pay).  Normally I can back out an invoice or reverse it, but for some reason this one just keeps saying that invoice number already exists.  Any ideas?
Back to top
 
 

Denise Dalman
Office Manager
Imperial Carving Co.
  IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: A/P - B (Enter Vouchers)
Reply #4 - 04/17/03 at 00:02:14
 
you will probably need to take note of the a/p invoice number, and using Maintain Database, go and look into the BKAPINVT.B and BKAPCHKH.B  or .Bxx where xx is the company code of your data. and search for that invoice number. chances are you are either missing the entire record in the BKAPCHKH.B or the data for that invoice doesn't exactly match the record transaction also recorded in the BKAPINVT.
 
THE other thing could also be, make sure that that specific invoice has two transactions in the BKAPINVT.B, usually the 1st one is the record of the invoice when created, and the 2nd one is the record when paid.
 
if you need further assistance let me know.
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
trumed
Browser
*


I love YaBB 1G -
SP1!

Posts: 1
Re: A/P - B (Enter Vouchers)
Reply #5 - 04/17/03 at 15:42:13
 
I had the very same problem.  You need to get the latest patch from DBA (this actually was available in January but not sent out).  This will prevent new problems created when voiding checks and reversing invoices.  Unfortunately, you will need to go into maintain database to fix the existing problem.   Sad
Back to top
 
 
  IP Logged
Theran
Member
**


I'm not a browser,
I'm a low end Bronze
member...

Posts: 70
Gender: female
Re: A/P - B (Enter Vouchers)
Reply #6 - 12/09/03 at 18:34:18
 
I have the same problem and I have identified the invoices and have found the records in the database files that you have listed.  Now what?  You don't say how to fix the records.  Do I delete them? Or change them?
 
Please advise
Back to top
 
 

Teres Heran
Armature Coil Equipment, Inc
DBA Classic, Ver 2004.1 with IS Tech 9/21/07
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: A/P - B (Enter Vouchers)
Reply #7 - 02/10/16 at 10:56:42
 
Quote from ddalman on 04/16/03 at 09:09:05:
Yes, it was entered as a voucher in A/P-B.  It was not a purchase order or a commission.  I have tried to do the look up on it, but it shows no invoices for this vendor yet it shows up on the vendor aging and also under A/P-F (Pick vouchers to pay).  Normally I can back out an invoice or reverse it, but for some reason this one just keeps saying that invoice number already exists.  Any ideas?

 
 
I have this probem.  
 
Fixed half of the problem....
 
BKAPINVT.---For some reason the dollars values of the voided check were in the BKAP_INVT_AMTRM column and there was 0 in the  BKAP_INVT_AMT column
I zeroed out BKAP_INVT_AMTRM  and I put the correct dollar amount in BKAP_INVT_AMT where there had been a zero. This made the invoices no longer show up in AP-F  (pick vouchers/invoice to pay)  YAY!
 
But sadly it did not fix AP-I.   the invoices are still showing in AP-I
 
 
edited ... I added these quotes from Lynn ..
Quote from Lynn_Pantic on 01/19/15 at 14:07:40:
Use Maintain Database on the BKAPINVT and BKAPCHKH files and look for the matching entries, or brute force, find the entry based on vendor and invoice date in BKAPINVT and just delete it if its 15 years old.

 
 
Quote from Lynn_Pantic on 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.  

 
 
Quote from Lynn_Pantic on 08/31/03 at 18:54:08:
The AP-I and AP-F programs use different logic.  AP-F looks at the AMTRM field (amount remaining) in BKAPNIVT (invoice file) while AP-I starts with the original amount in BKAPINVT and then subtracts based on payments in BKAPCHKH (payment file) up through the "as of" date of the aging.  Sounds like you have BKAPCHKH records that aren't linking right with the original invoices, causing paid invoices to show on the aging with a balance due even though the amount remaining is actually 0.  Take a look at both files in Maintain Database, email me if you need help sorting it out.

Back to top
 
« Last Edit: 02/10/16 at 13:47:15 by Laura  D. Oliver »  

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print