Welcome, Guest. Please Login.
06/07/25 at 11:28:31
News:
Home Help Search Login


Pages: 1
Send Topic Print
GL-E Giving Diff results (Read 1755 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
GL-E Giving Diff results
05/11/09 at 14:55:47
 
Accounting reports that when running GL-E Print Detailed Trial Balance, they no longer get the detail they used to in the Inv/Vch# column.   Right now it is giving them just a trans # which has no relevance to them when they do research on an item.  The detail they need to see (used to get) was the invoice number or the voucher number.  
 
The report is a text report.  Did an RTM replace this?
 
Thanks,
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-E Giving Diff results
Reply #1 - 05/13/09 at 08:58:57
 
There is not an RTM version of the GL-E report but if you say Y to "Print Long Check Numbers" you should get the Invoice number rather than the cross reference number.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #2 - 05/13/09 at 11:38:30
 
Thank you, Lynn.  I passed along to Nancy to try.
 
Regards,
 
Val
Back to top
 
 

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


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #3 - 05/13/09 at 13:08:53
 
Nancy just came to me and said running with the long check #s did not change anything.  She is still not seeing the invoice #.
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-E Giving Diff results
Reply #4 - 05/13/09 at 16:08:18
 
What is the modified date of BKGLE.RUN?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #5 - 05/15/09 at 05:29:50
 
It is 11/05/2008  10:47AM,  203KB.
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-E Giving Diff results
Reply #6 - 05/15/09 at 11:05:52
 
That's the current version and when I run it for Purchase Journal and say Y to "Use Long Check Numbers" I get the correct invoice numbers on the report.  If you look at the transactions in Maintain Database BKGLTRAN, do the invoice numbers have a # in fromt of the reference number?  That is the trigger for GL-E to know that it is a reference number and not a true invoice number and to go get the true invoice number from the cross reference file.  Similarly, the Customer Check Numbers have a * to designate the Cross Reference number.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #7 - 05/18/09 at 06:55:13
 
I'll check tonight and let you know. Thanks, Lynn.
 
Val
Back to top
 
 

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


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #8 - 05/18/09 at 14:34:00
 
Ok, I see entries in both company's BKGLTRAN files that have a # sign and also entries that have an *. I will have to have Nancy look closer to see if these are associated with invoices and checks. Sorry. I'll get back to you.
 
Val
Back to top
 
 

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


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #9 - 05/19/09 at 08:13:05
 
Ok, so here's what we determined:
 
If something in AP is done via voucher, we are not seeing the correct info in reports, only the transaction #.  If something is done via AP-PO, those show up correctly.  
 
Also 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 (I guess this references my other post on AP Report Issues.
 
Does that help?
 
Val
Back to top
 
 

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


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #10 - 06/08/09 at 12:58:43
 
Lynn, anyone:  Nancy wants an answer to resolve this. Should I post it in the problems instead???
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-E Giving Diff results
Reply #11 - 06/08/09 at 18:55:48
 
Check the menu for the person entering AP-B Vouchers - is it calling BKAPB.RUN or T6APB.RUN?  In either case, what is the modified date of the .RUN file?  The current versions are populating the # for the GL reports.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: GL-E Giving Diff results
Reply #12 - 06/09/09 at 07:00:59
 
She is running t6apb.run, AP-B Enter Vouchers ISTS Enhancement 01/06/09.  Date/time is 01/06/09 4:57PM in our DBAMFG folder.
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Pages: 1
Send Topic Print