On Hand Qty required

Yahoo Archive
1
You can link two separate BAQs by creating a dashboard and then a Crystal Report – but it is sometimes tricky to link them in Crystal depending on how they are related and what you need to show.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sreejith Jaganathan
Sent: Tuesday, February 14, 2012 2:17 AM
To: Vantage Group
Subject: [Vantage] On Hand Qty required



Dear Friends

I need a help in creating a report.

I want to prepare a report with the following headings

Field Name
Table Name
Part
Num
JobMtl
Description
JobMtl
RequiredQty JobMtl
QtyinHand
PartBin
RequiredDate JobMtl

The issue is that I need QtyinHand from the partbin table. I
need the total qtyinhand of the part and not the binwise qty. To get the total
qty in hand we can create a BAQ using the table PartBin and selecting the
fields Partnum and Onhandqty grouping by partnum.

I don’t know how to link this query with the JobMtl table.

Kindly help me to sort out the issue.

Regards

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



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

I need a help in creating a report.
Â
I want to prepare a report with the following headings
Â
Field Name       Â
Table Name
Part
Num           Â
JobMtl
Description       Â
JobMtl
RequiredQty     JobMtl
QtyinHand        Â
PartBin
RequiredDate   JobMtl
Â
The issue is that I need QtyinHand from the partbin table. I
need the total qtyinhand of the part and not the binwise qty. To get the total
qty in hand we can create a BAQ using the table PartBin and selecting the
fields Partnum and Onhandqty grouping by partnum.
Â
I don’t know how to link this query with the JobMtl table.
Â
Kindly help me to sort out the issue.
Â
Regards

[Non-text portions of this message have been removed]
3
Good Day Sreejith:



I think after 9.05.604, E9 has "aggregate" fields



Display>> Column select >> Calculated Field Icon in middle of screen
>> (far left list) >>Function.Aggregate,Max



I have not used much, but it is very, very, very tricky; so play
with it in a blank BAQ first.

For example once used, you cannot use other fields in that file.



I attached is a screen shot, but it might not come through. Above
instructions are for "Business Activity Query Dsogner: program", which
is just the normal BAQ design program.


len.hartka@...
<blocked::mailto:len.hartka@...>








________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sreejith Jaganathan
Sent: Tuesday, February 14, 2012 3:17 AM
To: Vantage Group
Subject: [Vantage] On Hand Qty required




Dear Friends

I need a help in creating a report.

I want to prepare a report with the following headings

Field Name
Table Name
Part
Num
JobMtl
Description
JobMtl
RequiredQty JobMtl
QtyinHand
PartBin
RequiredDate JobMtl

The issue is that I need QtyinHand from the partbin table. I
need the total qtyinhand of the part and not the binwise qty. To get the
total
qty in hand we can create a BAQ using the table PartBin and selecting
the
fields Partnum and Onhandqty grouping by partnum.

I don't know how to link this query with the JobMtl table.

Kindly help me to sort out the issue.

Regards

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






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]
4
Sreejith ,
What version are you on? Are you looking for total QtyOnHand for the plant level or warehouse level?

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Tuesday, February 14, 2012 6:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] On Hand Qty required



Good Day Sreejith:

I think after 9.05.604, E9 has "aggregate" fields

Display>> Column select >> Calculated Field Icon in middle of screen
>> (far left list) >>Function.Aggregate,Max

I have not used much, but it is very, very, very tricky; so play
with it in a blank BAQ first.

For example once used, you cannot use other fields in that file.

I attached is a screen shot, but it might not come through. Above
instructions are for "Business Activity Query Dsogner: program", which
is just the normal BAQ design program.

len.hartka@...<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...<mailto:len.hartka%40sunautomation.com>>

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Sreejith Jaganathan
Sent: Tuesday, February 14, 2012 3:17 AM
To: Vantage Group
Subject: [Vantage] On Hand Qty required

Dear Friends

I need a help in creating a report.

I want to prepare a report with the following headings

Field Name
Table Name
Part
Num
JobMtl
Description
JobMtl
RequiredQty JobMtl
QtyinHand
PartBin
RequiredDate JobMtl

The issue is that I need QtyinHand from the partbin table. I
need the total qtyinhand of the part and not the binwise qty. To get the
total
qty in hand we can create a BAQ using the table PartBin and selecting
the
fields Partnum and Onhandqty grouping by partnum.

I don't know how to link this query with the JobMtl table.

Kindly help me to sort out the issue.

Regards

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

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]





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