Welcome, Guest. Please Login.
06/07/25 at 15:05:59
News:
Home Help Search Login


Pages: 1
Send Topic Print
AP report issues (Read 1193 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
AP report issues
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
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: AP report issues
Reply #1 - 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
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: AP report issues
Reply #2 - 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
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: AP report issues
Reply #3 - 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
Back to top
 
 

Val Feehan
  IP Logged
hattox
Browser
*


I Love Flying!

Posts: 21
Gender: female
Re: AP report issues
Reply #4 - 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.
Back to top
 
 

Darlene Hattox
Admyr Wireline, Inc.
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: AP report issues
Reply #5 - 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!!!!! Shocked
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Pages: 1
Send Topic Print