Stock Status Report - Excel VB script

Yahoo Archive
1
IF you only need to see current stock status (as opposed to the stock status
at some date in the past) you can use Crystal Reports to do a stock status
report. This is easily exportable to Excel.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Friday, May 02, 2003 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Stock Status Report - Excel VB script


I just export the inventory info I need and then use the sort and subtotal
functions in Excel.

Quick and easy.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Doug Oswald [mailto:dougo@...]
Sent: Thursday, May 01, 2003 4:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status Report - Excel VB script


Has anyone created a script that will take the stock status report
into Excel and format it with subtotals by part codes?

My controller is asking for this and I don't know if it is possible.

We are running 4.0.

Thanks,

Doug Oswald
MIS
Fleetwood Fixtures



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
2
Has anyone created a script that will take the stock status report
into Excel and format it with subtotals by part codes?

My controller is asking for this and I don't know if it is possible.

We are running 4.0.

Thanks,

Doug Oswald
MIS
Fleetwood Fixtures
3
I just export the inventory info I need and then use the sort and subtotal
functions in Excel.

Quick and easy.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Doug Oswald [mailto:dougo@...]
Sent: Thursday, May 01, 2003 4:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status Report - Excel VB script


Has anyone created a script that will take the stock status report
into Excel and format it with subtotals by part codes?

My controller is asking for this and I don't know if it is possible.

We are running 4.0.

Thanks,

Doug Oswald
MIS
Fleetwood Fixtures



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/