ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP vendor history for a time period
http://www.istechforum.com/YaBB.pl?num=1103313810

Message started by Keith H on 12/17/04 at 12:03:30

Title: AP vendor history for a time period
Post by Keith H on 12/17/04 at 12:03:30

We use DBA Acctg modules only at this time, but I am having trouble finding a report that would print a report of the summary purchaces (invoice totals) totaled for a vendor for a period of time.

Am I missing something or does someone have a work around?

Title: Re: AP vendor history for a time period
Post by Laura Oliver on 12/17/04 at 13:01:48

Try AP-R, making sure you restrict the vendor codes and dates.

Title: Re: AP vendor history for a time period
Post by Lynn Pantic on 12/17/04 at 13:15:47

AP-I, Listing, open and paid items will also do it - again make sure you limit the dates.

IS Tech also has an RTM for PO-I-E that will print one summary line per vendor for all receipts within a specified date range. If you are an IS Tech Subscriber, select BKPOIE1V.RTM when printing the report.

Title: Re: AP vendor history for a time period
Post by Keith H on 12/20/04 at 11:48:48

Results of the above suggestions didn't produce a report showing summary purchaces by vendor from the AP module.

AP-R - sorts by check number

AP-I - has no date restriction and is only detail

PO-I-E - we are not using this module

Any other suggestions, I know the data is there in summary form, the stats tag on AP-A shows a ytd ( calendar or physcal?).

Title: Re: AP vendor history for a time period
Post by Lynn Pantic on 12/20/04 at 13:09:57

You can run SM-J-O to rebuild the summary YTD values and then export from BKAPVEND.

Title: Re: AP vendor history for a time period
Post by Keith H on 12/20/04 at 15:30:24

Perfect, export to excel works, thanks