ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> ap history
http://www.istechforum.com/YaBB.pl?num=1141167763

Message started by lburns on 02/28/06 at 15:02:43

Title: ap history
Post by lburns on 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! :)

Title: Re: ap history
Post by timgolds on 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

Title: Re: ap history
Post by Lynn Pantic on 02/28/06 at 17:46:02

You aren't full of it, Tim (at least not this time :o). 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.

Title: Re: ap history
Post by Laura Oliver on 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