PARTTRAN table - Onhand QTY

I believe you need a "historical" On-Hand and you are in the right track.... You will still need to determine a starting point (perhaps your current On-Hand from your PartWhse and PartBin tables) to start backing out transactions from your PartTran table, sorted by Transaction Date.

You have to be careful with the Transaction quantities as some of them are "absolute" (like Shipping being negative in relation to stock but positive in PartTran) and others are "net" (like adjustments, depending on the sign). On top of my head, I would consider any transaction having a STK element in TranType plus ADJ-QTY.... including STK-STK if transaction includes a part-location outside of your OH-Qty scope.

Also, this could turn into a monster (volume-wise) if you do not limit your report on Date and/or parts..... specially if it is a BAQ based report.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dymilano@...
Sent: Wednesday, September 08, 2010 12:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: PARTTRAN table - Onhand QTY



Thanks. PARTWHSE also shows onhandqty as sum by warehouse. These tables (PARTWHASE and PARTBIN) show ONHANDQTY as of now.

But I am trying to figure out how to compute ONHANDQTY within certain date. For instance PARTTRAN table has TRANDATE. For instance, I am trying to use TRANDATE <= '8/31/2010' for ONHANDQTY as of August 31, 2010.

There is table called 'STKPART' in stock status report I am tying to figure what tables and formula this table uses.

Basically, I am trying to figure out ONHANDQTY by month and create a report that compares ONHANDQTY by month.

Daniel

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Michelle de la Vega <mdelavega@...> wrote:
>
> You can just use the partbin table and subtotal all the bins for a OHQ...
>
> Michelle de la Vega
> Program Director
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
> +1 513-716-6400 (office)
> +1 513-382-3281 (mobile)
> +1 513-831-1209 (fax)
> www.coldjet.com<http://www.coldjet.com>
> [cid:image001.jpg@...]
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of dymilano@...
> Sent: Wednesday, September 08, 2010 12:16 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] PARTTRAN table - Onhand QTY
>
>
>
> Hello everyone,
>
> I am trying to find formula for onhand qty. Do I use PARTTRAN table for calculating onhand qty?
>
> Formula I came up with so far:
>
> [ADJ-QTY] + [PUR-STK] + -[STK-CUS] + -[STK-MTL] + -[STK-UNK]
>
> This formula appears to work with most of parts but not all. Am I missing something?
>
> Thanks,
>
> Daniel
>
>
>
> [Non-text portions of this message have been removed]
>



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

I am trying to find formula for onhand qty. Do I use PARTTRAN table for calculating onhand qty?

Formula I came up with so far:

[ADJ-QTY] + [PUR-STK] + -[STK-CUS] + -[STK-MTL] + -[STK-UNK]


This formula appears to work with most of parts but not all. Am I missing something?

Thanks,

Daniel
You can just use the partbin table and subtotal all the bins for a OHQ...

Michelle de la Vega
Program Director
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CB4F56.65826FE0]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dymilano@...
Sent: Wednesday, September 08, 2010 12:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PARTTRAN table - Onhand QTY



Hello everyone,

I am trying to find formula for onhand qty. Do I use PARTTRAN table for calculating onhand qty?

Formula I came up with so far:

[ADJ-QTY] + [PUR-STK] + -[STK-CUS] + -[STK-MTL] + -[STK-UNK]

This formula appears to work with most of parts but not all. Am I missing something?

Thanks,

Daniel



[Non-text portions of this message have been removed]
The PartWhse Table holds the OnHand Qty

From the Data Dictionary for PartWhse.OnHandQty - "A summary of
PartBin.OnHandQty for the warehouse where the bin is a nettable bin
(WhseBin.NonNettable = NO). Maintained via the PartBin write trigger."

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Wednesday, September 08, 2010 12:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PARTTRAN table - Onhand QTY

You can just use the partbin table and subtotal all the bins for a OHQ...

Michelle de la Vega
Program Director
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CB4F56.65826FE0]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
dymilano@...
Sent: Wednesday, September 08, 2010 12:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PARTTRAN table - Onhand QTY



Hello everyone,

I am trying to find formula for onhand qty. Do I use PARTTRAN table for
calculating onhand qty?

Formula I came up with so far:

[ADJ-QTY] + [PUR-STK] + -[STK-CUS] + -[STK-MTL] + -[STK-UNK]

This formula appears to work with most of parts but not all. Am I missing
something?

Thanks,

Daniel



[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
Thanks. PARTWHSE also shows onhandqty as sum by warehouse. These tables (PARTWHASE and PARTBIN) show ONHANDQTY as of now.

But I am trying to figure out how to compute ONHANDQTY within certain date. For instance PARTTRAN table has TRANDATE. For instance, I am trying to use TRANDATE <= '8/31/2010' for ONHANDQTY as of August 31, 2010.

There is table called 'STKPART' in stock status report I am tying to figure what tables and formula this table uses.


Basically, I am trying to figure out ONHANDQTY by month and create a report that compares ONHANDQTY by month.


Daniel





--- In vantage@yahoogroups.com, Michelle de la Vega <mdelavega@...> wrote:
>
> You can just use the partbin table and subtotal all the bins for a OHQ...
>
> Michelle de la Vega
> Program Director
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
> +1 513-716-6400 (office)
> +1 513-382-3281 (mobile)
> +1 513-831-1209 (fax)
> www.coldjet.com<http://www.coldjet.com>
> [cid:image001.jpg@...]
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dymilano@...
> Sent: Wednesday, September 08, 2010 12:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] PARTTRAN table - Onhand QTY
>
>
>
> Hello everyone,
>
> I am trying to find formula for onhand qty. Do I use PARTTRAN table for calculating onhand qty?
>
> Formula I came up with so far:
>
> [ADJ-QTY] + [PUR-STK] + -[STK-CUS] + -[STK-MTL] + -[STK-UNK]
>
> This formula appears to work with most of parts but not all. Am I missing something?
>
> Thanks,
>
> Daniel
>
>
>
> [Non-text portions of this message have been removed]
>