|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Re: GenTran NT 4.0 Reporting
JJ,
We use MS SQL 7.0 for Gentran & what I have done is written a query in MS SQL
that checks for FA errors (rejections, overdue, etc. etc). I run this query
using the MS SQL command-line executable: isqlw.exe, as part of a Process
Control session. The output contains info. such as the Partner, the ISA/GS & ST
control numbers of the 'outbound' document, the transmit time, the
Acknowledgement receipt time, etc, etc. You can find more information about
Gentran DB tables in the Administration Guide. I am not quite sure which DB you
are using, but if you need to look at this query, let me know & I will send it
to you.
Thanks,
Suhas
----- Original Message -----
From: "Laurie Englehart" <
To: <
Sent: Monday, October 20, 2003 9:59 AM
Subject: [EDI-L] Re: GenTran NT 4.0 Reporting
>
> Back before I even knew there was a report I could generate with
> Process Control, I had created a simple Access query that would show
> what documents were overdue for acknowledgements. The problem was
> that I was having to actually run this query daily to find out if I
> had anything overdue. Then I discovered Audit Notifications. I set up
> a notification event to check for overdue acknowledgements and in the
> event that I have overdues, I receive an email telling me I have
> overdues. Then I just run my query to find out what hasn't been
> acknowledged.
>
> I know it's a bit cumbersome but so far it works for me. I am
> certainly open to anyones suggestions.
>
> Laurie
>
>
> --- In "skywisecruiser" <skywisecruiser@y...>
> wrote:
> > I need to know how other people are creating reports for the
> GenTran
> > server. I am trying to generate a report that will show overdue
> 997
> > messages. I am using the GDW_Document_Rpt command in the process
> > control to generate the comma delimited file of information, but am
> > trying to find a decent way to format the data. I can't map it
> > because it does not have a TAG on each record.
> >
> > At this point, my options are to use another application (Crystal
> > Reports) to format the data and mail it out in a VB application or
> > write a script that will prepend a tag on each record after the
> file
> > is generated.
> >
> > What does your company do to get these reports out of GenTran?
> >
> > Thanks,
> > JJ
>
>
>
> To unsubscribe from this group, send an email to:
>
> Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
