Inventory report with bin info

Yahoo Archive
1
PartBin will have have the same qty as Stock Status report if it is run as of today but I'm not sure what happens if you try to backdate the report. I'm on V8.00 so don't have RDD for the stock status and had to develop an ODBC report for this purpose. This is only shows current status so PartBin works fine and matches up perfectly with Stock Status. Without the RDD I can't check but you should also be able to pull in the BinNum from the PartTran table which I believe is the main table for stock status. This would have a much better chance of retaining the "as of" backdating functionality.

In general, I have found the backdating doesn't always work out so well and prefer to schedule the report if a snapshot for a specific time is needed (e.g. end of the week).

--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> In the end I also found this table but I was wondering if it has the same qty as in the stock status report
> Ephraim Feldman
2
Hi All,

I got already a huge amount of help from this group and i hope i can be helped here too.

i need a report similar to the stock status report but with the bin location info in it.
basically we want to go through some bins that where canceled and see if the system has still qty in them and also verify all other bins.

can i Modify the the stock status report to include it or i have to create a new BAQ for it and if so what table would contain this info.

Maybe the best would be to get a report by bin and the list what parts and qty is in that bin.

Thanks all for you help

Ephraim
3
I recently just did the same thing.

In Report Data Definition I duplicated stkstatus and named it a new name

I added the table plantwhse to the existing tables

in the included fields I added company, part number, primbin, warehousecode

in the crystal report I had to join the plantwhse table to the part table joining company and part together

then I had the primbin and warehouse code available to the report.

Gary Wojtowicz
AJR Industries, Inc.



[Non-text portions of this message have been removed]
4
Thanks for that but my problem is that I have the same part in multiple bins not just the primary bin


Ephraim Feldman

-----Original Message-----
From: "Gary Wojtowicz" <ajrgary@...>
Date: Mon, 19 Apr 2010 09:01:28
To: <vantage@yahoogroups.com>
Subject: [Vantage] Re:Inventory report with bin info

I recently just did the same thing.

In Report Data Definition I duplicated stkstatus and named it a new name

I added the table plantwhse to the existing tables

in the included fields I added company, part number, primbin, warehousecode

in the crystal report I had to join the plantwhse table to the part table joining company and part together

then I had the primbin and warehouse code available to the report.

Gary Wojtowicz
AJR Industries, Inc.



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




[Non-text portions of this message have been removed]
5
I have the same part in multiple bins as well, and I pull the data from the PartBin table.




________________________________
From: "effgroups@..." <effgroups@...>
To: vantage@yahoogroups.com
Sent: Mon, April 19, 2010 8:55:25 AM
Subject: Re: [Vantage] Re:Inventory report with bin info

Â
Thanks for that but my problem is that I have the same part in multiple bins not just the primary bin

Ephraim Feldman

-----Original Message-----
From: "Gary Wojtowicz" <ajrgary@sbcglobal. net>
Date: Mon, 19 Apr 2010 09:01:28
To: <vantage@yahoogroups .com>
Subject: [Vantage] Re:Inventory report with bin info

I recently just did the same thing.

In Report Data Definition I duplicated stkstatus and named it a new name

I added the table plantwhse to the existing tables

in the included fields I added company, part number, primbin, warehousecode

in the crystal report I had to join the plantwhse table to the part table joining company and part together

then I had the primbin and warehouse code available to the report.

Gary Wojtowicz
AJR Industries, Inc.

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

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







[Non-text portions of this message have been removed]
6
In the end I also found this table but I was wondering if it has the same qty as in the stock status report
Ephraim Feldman

-----Original Message-----
From: Leslie Martin <lmartin.allwire@...>
Date: Mon, 19 Apr 2010 09:28:40
To: <vantage@yahoogroups.com>
Subject: Re: [Vantage] Re:Inventory report with bin info

I have the same part in multiple bins as well, and I pull the data from the PartBin table.




________________________________
From: "effgroups@..." <effgroups@...>
To: vantage@yahoogroups.com
Sent: Mon, April 19, 2010 8:55:25 AM
Subject: Re: [Vantage] Re:Inventory report with bin info

Â
Thanks for that but my problem is that I have the same part in multiple bins not just the primary bin

Ephraim Feldman

-----Original Message-----
From: "Gary Wojtowicz" <ajrgary@sbcglobal. net>
Date: Mon, 19 Apr 2010 09:01:28
To: <vantage@yahoogroups .com>
Subject: [Vantage] Re:Inventory report with bin info

I recently just did the same thing.

In Report Data Definition I duplicated stkstatus and named it a new name

I added the table plantwhse to the existing tables

in the included fields I added company, part number, primbin, warehousecode

in the crystal report I had to join the plantwhse table to the part table joining company and part together

then I had the primbin and warehouse code available to the report.

Gary Wojtowicz
AJR Industries, Inc.

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

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







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




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