ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> GL-E Giving Diff results
http://www.istechforum.com/YaBB.pl?num=1242078947

Message started by gtladmin on 05/11/09 at 14:55:47

Title: GL-E Giving Diff results
Post by gtladmin on 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

Title: Re: GL-E Giving Diff results
Post by Lynn_Pantic on 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.

Title: Re: GL-E Giving Diff results
Post by gtladmin on 05/13/09 at 11:38:30

Thank you, Lynn. I passed along to Nancy to try.

Regards,

Val

Title: Re: GL-E Giving Diff results
Post by gtladmin on 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

Title: Re: GL-E Giving Diff results
Post by Lynn_Pantic on 05/13/09 at 16:08:18

What is the modified date of BKGLE.RUN?

Title: Re: GL-E Giving Diff results
Post by gtladmin on 05/15/09 at 05:29:50

It is 11/05/2008 10:47AM, 203KB.

Val

Title: Re: GL-E Giving Diff results
Post by Lynn_Pantic on 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.

Title: Re: GL-E Giving Diff results
Post by gtladmin on 05/18/09 at 06:55:13

I'll check tonight and let you know. Thanks, Lynn.

Val

Title: Re: GL-E Giving Diff results
Post by gtladmin on 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

Title: Re: GL-E Giving Diff results
Post by gtladmin on 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

Title: Re: GL-E Giving Diff results
Post by gtladmin on 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

Title: Re: GL-E Giving Diff results
Post by Lynn_Pantic on 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.

Title: Re: GL-E Giving Diff results
Post by gtladmin on 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