ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP report issues
http://www.istechforum.com/YaBB.pl?num=1242079337

Message started by gtladmin on 05/11/09 at 15:02:17

Title: AP report issues
Post by gtladmin on 05/11/09 at 15:02:17

Accounting also reports these issues

AP Print Aging, Print AP Listing
Vendor A/P Listing, text mode = Y, gives them the check # but not the invoice #.
Vendor A/P Listing, text mode = N, gives them the invoice # but not the check #.

They need the report to show both on the same report like it used to. Has this also been replaced by an RTM?

Thanks

Title: Re: AP report issues
Post by gtladmin on 05/13/09 at 11:00:04

okie dokie, Accounting apparently didn't give enough detail, so here's more info after I did the work:

Running AP-I Print Aging
From Date 05/06/09
Type of Report to print = A/P Listing
Vendor range is specified
Print Source Currency
Text Mode = N
Include Detail, Open and Paid Items
A/P Listing Start Date 01/01/09
A/P Listing for Terms Type = All types
Sort not chosen (running for one vendor)
Invoice Description IS CHECKED
No Follow up Notes

Whether we use t6API1, t6API2, T6API2A, T6API3, none show the check # for a payment. Here's what we see:

Vendor Telephone InvDate Number Descr Invoices Pmts/Credits
Vendor XX xxx-xxx-xxxx 01/13/09 4098 P/O#: 8353 2438.00 0.00
Vendor XX xxx-xxx-xxxx 01/15/09 Payment 0.00 -565.80
Vendor XX xxx-xxx-xxxx 02/06/09 Payment 0.00 -2421.04
Venodr XX xxx-xxx-xxxx 03/18/09 4711 P/O#: 8512 406.25 0.00
Vendor XX xxx-xxx-xxxx 04/23/09 Payment 0.00 -406.25

So it shows the invoice numbers, but does not show the check #s for the payments. This is consistent with any vendor. It used to show both.

Text mode shows the correct check # for payments but not the correct invoice number, it shows something different.

Date of the RTMS:
t6api1.rtm = 11/05/2008
t6api2.rtm = 02/03/2009
t6api2.rtm = 11/05/2008
t6api3.rtm = 11/05/2008

AP-I Print Aging is ISTS Enhancement 11/04/08

What else do you need to know?

Val

Title: Re: AP report issues
Post by gtladmin on 05/13/09 at 12:55:34

More info: using the report editor, I made a copy of t6api2.rtm and edited it. In the subereport1: tasfile, there was a field called "Long Invoice" that's passing out the invoice number but not the check number. To test, I modified the field to use bkap.invt.num, and saved the report. When we repeat the printing process, the check #s now show BUT the invoice numbers are now something else, not the invoice numbers. So something's not quite right somewhere. Where's the long invoice field kept (which table)?

Val

Title: Re: AP report issues
Post by gtladmin on 05/19/09 at 08:14:05

As I mentioned in my GL-E post, AP-C items show up correctly, but AP-F and AP-H items (payments) do not--they do not show anything, and they should be showing the check# when we print a vendor transaction listing.

Val

Title: Re: AP report issues
Post by hattox on 05/27/09 at 13:26:34

My T6API2.rtm for A/P listing and T6API1.rtm for A/P aging both work as they should, showing invoice numbers and check numbers. If you want, I can sent you the files as attachments to e-mail. Just post your e-mail address here.

Darlene Hattox
Admyr Wireline, Inc.

Title: Re: AP report issues
Post by gtladmin on 06/02/09 at 14:49:22

Darlene,

Thanks - I'll send you a PM. No way I'd ever post my email address on a public forum!!!!! :o

Val