Stock Status Quantity based on as of date

Yahoo Archive
1
Good Day Sanjay:

Create a second version of the Stock-Status and 'simplify" to
one line per part#.
You can just run the normal report, but then you will have to
clean up the Excell sheet after opening.

Run report and archive it so it goes to the system Monitor >>
"Print" the report using "Microsoft XPS Document printer" ( will not
print ), it will ask you to save as a file >> open the file with
Excel.

Sun is on E9 Version: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Len

<<Picture (Device Independent Bitmap)>>

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Tuesday, March 26, 2013 1:52 PM
To: Vantage
Subject: Re: [Vantage] Stock Status Quantity based on as of date

The easiest way to do this, is to run the report, then ParsetheXML into
a DataTable. Using something like VBA otherwise you can write your own
by looking at PartTran and adding / removing Parts one by one. I've done
this before and it works.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Tue, Mar 26, 2013 at 1:39 PM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> I need to import the stock status report to an excel spreadsheet. I am

> using Vantage 8.03.409c. I used tables PartTran and Part. I tried
> backing off the transactions from current OnHand Quantity. But its not
working.
> Please help me figure it out, what i am missing.
> Thanks,
> Sanjay.
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

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/linksYahoo! Groups Links





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
2
I need to import the stock status report to an excel spreadsheet. I am using Vantage 8.03.409c. I used tables PartTran and Part. I tried backing off the transactions from current OnHand Quantity. But its not working. Please help me figure it out, what i am missing.
Thanks,
Sanjay.
3
The easiest way to do this, is to run the report, then ParsetheXML into a
DataTable. Using something like VBA otherwise you can write your own by
looking at PartTran and adding / removing Parts one by one. I've done this
before and it works.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Tue, Mar 26, 2013 at 1:39 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> I need to import the stock status report to an excel spreadsheet. I am
> using Vantage 8.03.409c. I used tables PartTran and Part. I tried backing
> off the transactions from current OnHand Quantity. But its not working.
> Please help me figure it out, what i am missing.
> Thanks,
> Sanjay.
>
>
>


[Non-text portions of this message have been removed]