Material Transaction Detail Report

Yahoo Archive
1
Could you put it in one of the files on the Vantage site?

Thanks,

Debbie Smith
Argonics, Inc.



charles06072006 <shadow031449@...> wrote:
--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Hi Michelle,
> > Is there any way to turn the Material Transaction Detail Report
into a
> > format that can be brought into excel? Or is there any other report
> > like the Material Transaction Detail Report that will allow the
> > transaction data to be brought into excel?
>
> You can use ODBC to access the PartTran file. Make sure that the ODBC
> connection is set to READ UNCOMMITTED or you can lock up your users.
>
> Mark W.
>

I have an ODBC crystal reports that I did that goes very nicely into
excel. It has several selection and sort options. I will gladly make
it available to anyone that would like to have it.






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]
2
Is there any way to turn the Material Transaction Detail Report into a
format that can be brought into excel? Or is there any other report
like the Material Transaction Detail Report that will allow the
transaction data to be brought into excel?


Michelle C. Grman
Assistant Controller

KERUSSO
The Greek word means - To herald divine truth as a public crier; to
preach the gospel.

P.O. Box 32
Berryville, AR 72616
Phone: 870-423-6242 Ext. 222
Fax: 870-423-3568
Web Site: www.kerusso.com

Revolutionize your jewelry sales with the Beacon Accessory Center:
"The Beacon is a SERIOUS MARGIN MAKER! We've sold half of the product in
less than a month!"
-Ron Kuzman, Mgr., Sonrise Christian

******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************






[Non-text portions of this message have been removed]
3
I have had some success importing the "Material Transaction Detail
Report.txt" file into excel. You can find these in your
server:\MfgSysData\Reports\username folder. But it is a clumsy way
to go.


--- In vantage@yahoogroups.com, "Michelle C. Grman" <mcgrman@...>
wrote:
>
> Is there any way to turn the Material Transaction Detail Report
into a
> format that can be brought into excel? Or is there any other
report
> like the Material Transaction Detail Report that will allow the
> transaction data to be brought into excel?
>
>
> Michelle C. Grman
> Assistant Controller
>
> KERUSSO
> The Greek word means - To herald divine truth as a public crier; to
> preach the gospel.
>
> P.O. Box 32
> Berryville, AR 72616
> Phone: 870-423-6242 Ext. 222
> Fax: 870-423-3568
> Web Site: www.kerusso.com
>
> Revolutionize your jewelry sales with the Beacon Accessory Center:
> "The Beacon is a SERIOUS MARGIN MAKER! We've sold half of the
product in
> less than a month!"
> -Ron Kuzman, Mgr., Sonrise Christian
>
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Michelle C. Grman wrote:
> Is there any way to turn the Material Transaction Detail Report into a
> format that can be brought into excel? Or is there any other report
> like the Material Transaction Detail Report that will allow the
> transaction data to be brought into excel?
> Michelle C. Grman
> Assistant Controller
> KERUSSO
> The Greek word means - To herald divine truth as a public crier; to
> preach the gospel.
> P.O. Box 32
> Berryville, AR 72616
> Phone: 870-423-6242 Ext. 222
> Fax: 870-423-3568
> Web Site: www.kerusso. com
> Revolutionize your jewelry sales with the Beacon Accessory Center:
> "The Beacon is a SERIOUS MARGIN MAKER! We've sold half of the product in
> less than a month!"
> -Ron Kuzman, Mgr., Sonrise Christian
> ************ ********* ********* ********* ********* ********* *********
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ************ ********* ********* ********* ********* ********* *********
> [Non-text portions of this message have been removed]
>
5
Hi Michelle,
> Is there any way to turn the Material Transaction Detail Report into a
> format that can be brought into excel? Or is there any other report
> like the Material Transaction Detail Report that will allow the
> transaction data to be brought into excel?

You can use ODBC to access the PartTran file. Make sure that the ODBC
connection is set to READ UNCOMMITTED or you can lock up your users.

Mark W.
6
--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Hi Michelle,
> > Is there any way to turn the Material Transaction Detail Report
into a
> > format that can be brought into excel? Or is there any other report
> > like the Material Transaction Detail Report that will allow the
> > transaction data to be brought into excel?
>
> You can use ODBC to access the PartTran file. Make sure that the ODBC
> connection is set to READ UNCOMMITTED or you can lock up your users.
>
> Mark W.
>

I have an ODBC crystal reports that I did that goes very nicely into
excel. It has several selection and sort options. I will gladly make
it available to anyone that would like to have it.