Report Builder guidance

Yahoo Archive
1
I skipped the Alloc. Quantity approach to finding obsolete inventory in our case (version 3) because it wasn't accurate for us to determine obsolete inventory. So I went to a concept our controller came up with whereby we looked for parts that had no transactions against them over a certain period of time (like 9 months or something). We excluded certain transactions like adj-stk and the like. Crystal was the only way I could get it close.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Greg Clauser
To: vantage@egroups.com
Sent: Thursday, January 11, 2001 10:16 AM
Subject: [Vantage] Report Builder guidance


Could someone please steer me in the right direction? I'm getting
cross-eyed looking at the same thing over and over but can't get my head
around it.

I want a simple report that shows the total stock balance by part number
that also shows the total allocated requirements for each part. The idea is
to identify parts that are potentially obsolete by filtering for balances
with no allocations. I had something that I thought worked O.K. in version
3.0 when the AllocQty was in one table. In version 4.0 there is an AllocQty
in both the PartPlant table and the PartWhse table. (BTW - we build
practically everything to stock)

I can't seem to figure out how to get the links right so I can subtotal by
part. Multiple bins and having the AllocQty in two tables is causing
duplication. As a result I'm getting way too frustrated for it to be only
Thursday. HELP
Greg Clauser
Lakin General Corporation
gclauser@... <mailto:gclauser@...>



eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
2
Could someone please steer me in the right direction? I'm getting
cross-eyed looking at the same thing over and over but can't get my head
around it.

I want a simple report that shows the total stock balance by part number
that also shows the total allocated requirements for each part. The idea is
to identify parts that are potentially obsolete by filtering for balances
with no allocations. I had something that I thought worked O.K. in version
3.0 when the AllocQty was in one table. In version 4.0 there is an AllocQty
in both the PartPlant table and the PartWhse table. (BTW - we build
practically everything to stock)

I can't seem to figure out how to get the links right so I can subtotal by
part. Multiple bins and having the AllocQty in two tables is causing
duplication. As a result I'm getting way too frustrated for it to be only
Thursday. HELP
Greg Clauser
Lakin General Corporation
gclauser@... <mailto:gclauser@...>
3
Greg,
If you ever get a report, I would be interested in it also! I haven't been
able to create exactly what I want also. Good luck!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com


-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Thursday, January 11, 2001 10:16 AM
To: vantage@egroups.com
Subject: [Vantage] Report Builder guidance


Could someone please steer me in the right direction? I'm getting
cross-eyed looking at the same thing over and over but can't get my head
around it.

I want a simple report that shows the total stock balance by part number
that also shows the total allocated requirements for each part. The idea is
to identify parts that are potentially obsolete by filtering for balances
with no allocations. I had something that I thought worked O.K. in version
3.0 when the AllocQty was in one table. In version 4.0 there is an AllocQty
in both the PartPlant table and the PartWhse table. (BTW - we build
practically everything to stock)

I can't seem to figure out how to get the links right so I can subtotal by
part. Multiple bins and having the AllocQty in two tables is causing
duplication. As a result I'm getting way too frustrated for it to be only
Thursday. HELP
Greg Clauser
Lakin General Corporation
gclauser@... <mailto:gclauser@...>



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)