Welcome, Guest. Please Login.
10/31/24 at 18:26:13
News:
Home Help Search Login


Pages: 1
Send Topic Print
ap history (Read 876 times)
lburns
Member
**




Posts: 75
Gender: female
ap history
02/28/06 at 15:02:43
 
From the accounting newbie....
 
Is there a way to see what check number is associated with a particular item number that was purchased on a purchase order and received in?  The part does not show up on the received but not invoiced report, however there are many invoice numbers associated with the PO, without looking at each of those invoices physically I cannot seem to find what invoice number we processed.  My vendor says it was not invoiced - but I find it hard to believe that it would not be on the received but not invoiced report if it was not paid...
 
Any ideas on how to extract that information...it has to be there somewhere....
 
Thanks! Smiley
Back to top
 
 

Laurie Burns
Excel Connection USA
dba classic 2004.1/Evo-ERP
is tech build 11/08/2007
pervasive 8.0
Email wigal2000   IP Logged
Tim Goldstein
Full Member
***


'Cause sooner or
later everyone needs
a chief geek

Posts: 213
Gender: male
Re: ap history
Reply #1 - 02/28/06 at 17:29:45
 
No easy way that I know of.
 
However,  Didn't Lynn say something in Phoenix about the RNI report looking at a field on the PO that is blank until it is invoiced then it holds the invoice number?
 
If that's the case you can go in through TAS-D, find the invoice number then go into AP-R and look up the check for that invoice!
 
Or I could be full of it and heard Lynn completly wrong and just sent you on a wild goose chase!  (Not the first time)
 
What do you think lynn?
 
 
Tim
Back to top
 
 

Tim
Email WWW timgolds timgolds   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: ap history
Reply #2 - 02/28/06 at 17:46:02
 
You aren't full of it, Tim (at least not this time  Shocked).  The Invoice number is stored in the PO Line item record in the receiver file.  One way to see it (other than Maintain Database) is to go into AP-C as if you are going to enter an invoice for the PO, and when it says there is nothing to invoice, choose View All to see the lines anyway.
 
There is also an add-on (AP-T) inquiry program that will show that information but I think you have to start with the Invoice or Check number and work backwards, not with the PO number.
 
And as soon (later tonight or tomorrow, I hope) as I get the update posted with the Drill Downs you saw in Phoenix, you can set up your own grid and display it yourself.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: ap history
Reply #3 - 07/21/15 at 08:48:53
 
Before we started using AP-C  (we were exclusively using AP-B) if a vendor called us about an invoice we could go to AP-B and  call up the vendor , enter the invoice number and know in a split second if we had paid the invoice.    
 Also  AP-B is also a pretty efficient way to hone in on a vendor invoice number that might have a few been entered incorrectly. As long as the first few digits were correct, it was easy to find the mis-entered number.      
  
 We were spoiled by the look-up ability in AP-B, and am looking for something similar now that we are using AP-C.  
    
 Does anyone know what I can use to hone in on a vendor invoice?  
  
  
 I  thought AP-U might  do it, but I cant seem to make AP-U work.  I don't think AP-T  (the paid add on) allow you to hone in on an invoice.    
  
 I can’t find any instructions for AP-U  (view vendor information) in the help file.  
  
 If I try the Reports tab in AP-U I get  “Your system administrator must first set up programs for your user name to call PS-H “     I went to PS-H and I don’t see any chains that seem to relate to Paid invoices.  
 
If I try AP-U  (transactions)  I get  FATAL ERR –FILE: WBKLOOKIP.SRC Line 2120    (? WBKLOOKUP.SRC  ?)
  
 You have tried to access a file that has not been previously opened, or the file number value (FNUM) passed was 0  
 
 
 Maybe there is somewhere else that would let me hone in on a vendor invoice number.  
  
  
 Thanks,  
 Laura  
 
Back to top
 
 

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