Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lookup AP document

Status
Not open for further replies.

ramam1

Programmer
Mar 20, 2009
226
US
I can't seem to find a good way to look up an AP document. We have an AP Invoice that shows up in the DIC but I don't know a good way to look it up via Accpac. I see two options:
1 AP Transactions -> GL Transactions -> Print *all* AP documents and then search through for the document number; this seems ludicrous
2 Go directly into the DB and do a SQL query - easy but clearly not what end users are expected to do.

I must be missing something obvious - what is it?
 
I don't have the vendor number - DIC doesn't list it but I see now that it does list the batch type (PY) number and entry number so that's the easiest way to do it. Odd that there is no way to look it up via Doc # - we have 200k AP docs and if we don't have the other info handy there is no good way to do it, apparently.
thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top