[BULK] Epicor 9 - BAQ Help

system · June 19, 2009, 2:39pm

PartBin records are not persistent. They only exist if O/h is not zero. When a qty is received or transfered in the whse bin that was previosuly zer for the part, the partbin record is recreated.

You have two choices:

Either create your part to partbin join as outer (showing ALL part records whether there is a partbin record or not),

Or utilize PartBinInfo. Intended as a Bin level KanBan enabling field, just filling out some of the info (whse & Bin) is enough to make a permanent part-bin relationship.

The data table contains O/H data that DOES persist if o/h he zero.

Rob

Â

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Friday, June 19, 2009 5:29:06 AM
Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help

Hi,

I have set up a BAQ that will display the Part, Description and OnHandQty.

I have linked the Part as the parent table with the PartBin as the child.

I can get it to display everything EXCEPT ...

When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.

Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?

Cheers,

CHRIS

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, 15 June, 2009 15:57:18
Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help

Hi Cliff,

That's almost there actually.

However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.

____________ _________ _________ __
From: Cliff Drumeller <cliff@massprecisio n .com>
To: vantage@yahoogroups .com
Sent: Monday, 15 June, 2009 15:49:00
Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help

Try making partbin your primary table and then linking part for your
description, etc.

Cliff Drumeller
IT Manager
Mass Precision, Inc.
408 786 0348
408 314 7420 cell

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Monday, June 15, 2009 5:18 AM
To: vantage@yahoogroups .com
Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
Importance: Low

I have tried that, but as soon as I introduce the PartAlloc table to the
phrase builder, when I Analyse, it returns no results as if there is a
conflict between the two table.

I have had something similar where I wanted to see Part No, Weight,
Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
it returned no results.

Cheers.

____________ _________ _________ __
From: Steven Gotschall <sgotschall@ yahoo. com
<mailto:sgotschall% 40yahoo.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Monday, 15 June, 2009 12:59:28
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I think you are going to have to pull in the PartAlloc table also and
subtract the allocations from the on hand quantities.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use
with a Quick Search.

I want it to display the following:

Part Number | Description | Net Weight | On Hand Qty | Available
Qty

This way, before the part is even added to a SO or Quote, the user in
our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can
sucessfully display the first 4 columns on my quick search/BAQ, however,
I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

[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]

[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]

system · June 15, 2009, 6:41am

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use with a Quick Search.

I want it to display the following:

Part NumberÂ |Â DescriptionÂ |Â Net WeightÂ |Â On Hand QtyÂ |Â Available Qty

This way, before the part is even added to a SO or Quote, the user in our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can sucessfully display the first 4 columns on my quick search/BAQ, however, I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

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

system · June 15, 2009, 7:59am

I think you are going to have to pull in the PartAlloc table also and subtract the allocations from the on hand quantities.

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use with a Quick Search.

I want it to display the following:

Part NumberÂ |Â DescriptionÂ |Â Net WeightÂ |Â On Hand QtyÂ |Â Available Qty

This way, before the part is even added to a SO or Quote, the user in our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can sucessfully display the first 4 columns on my quick search/BAQ, however, I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

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

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

system · June 15, 2009, 8:17am

I have tried that, but as soon as I introduce the PartAlloc table to the phrase builder, when I Analyse, it returns no results as if there is a conflict between the two table.

I have had something similar where I wanted to see Part No, Weight, Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder it returned no results.

Cheers.

________________________________
From: Steven Gotschall <sgotschall@...>
To: vantage@yahoogroups.com
Sent: Monday, 15 June, 2009 12:59:28
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I think you are going to have to pull in the PartAlloc table also and subtract the allocations from the on hand quantities.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use with a Quick Search.

I want it to display the following:

Part NumberÂ |Â DescriptionÂ |Â Net WeightÂ |Â On Hand QtyÂ |Â Available Qty

This way, before the part is even added to a SO or Quote, the user in our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can sucessfully display the first 4 columns on my quick search/BAQ, however, I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

[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]

system · June 15, 2009, 10:19am

I see you are on 9.Â I am on 8.03.407a, but I don't think it will make to much of a difference.Â You will need to do an outer join on the PartAlloc table, but after looking at mine, there is no information in it.Â I do see that there are a number of allocation and reservedQty fields in the PartWhse table.Â I'm just not sure what you would add and/or subtract to get your available quantity.

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Monday, June 15, 2009 8:17:30 AM
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I have tried that, but as soon as I introduce the PartAlloc table to the phrase builder, when I Analyse, it returns no results as if there is a conflict between the two table.

I have had something similar where I wanted to see Part No, Weight, Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder it returned no results.

Cheers.

____________ _________ _________ __
From: Steven Gotschall <sgotschall@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, 15 June, 2009 12:59:28
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I think you are going to have to pull in the PartAlloc table also and subtract the allocations from the on hand quantities.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use with a Quick Search.

I want it to display the following:

Part NumberÂ |Â DescriptionÂ |Â Net WeightÂ |Â On Hand QtyÂ |Â Available Qty

This way, before the part is even added to a SO or Quote, the user in our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can sucessfully display the first 4 columns on my quick search/BAQ, however, I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

[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]

system · June 15, 2009, 10:49am

Try making partbin your primary table and then linking part for your
description, etc.

Cliff Drumeller
IT Manager
Mass Precision, Inc.
408 786 0348
408 314 7420 cell

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, June 15, 2009 5:18 AM
To: vantage@yahoogroups.com
Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
Importance: Low

I have tried that, but as soon as I introduce the PartAlloc table to the
phrase builder, when I Analyse, it returns no results as if there is a
conflict between the two table.

I have had something similar where I wanted to see Part No, Weight,
Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
it returned no results.

Cheers.

________________________________
From: Steven Gotschall <sgotschall@...
<mailto:sgotschall%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Monday, 15 June, 2009 12:59:28
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I think you are going to have to pull in the PartAlloc table also and
subtract the allocations from the on hand quantities.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use
with a Quick Search.

I want it to display the following:

Part Number | Description | Net Weight | On Hand Qty | Available
Qty

This way, before the part is even added to a SO or Quote, the user in
our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can
sucessfully display the first 4 columns on my quick search/BAQ, however,
I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

[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]

system · June 15, 2009, 10:57am

Hi Cliff,

That's almost there actually.

However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.

________________________________
From: Cliff Drumeller <cliff@...>
To: vantage@yahoogroups.com
Sent: Monday, 15 June, 2009 15:49:00
Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help

Try making partbin your primary table and then linking part for your
description, etc.

Cliff Drumeller
IT Manager
Mass Precision, Inc.
408 786 0348
408 314 7420 cell

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Monday, June 15, 2009 5:18 AM
To: vantage@yahoogroups .com
Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
Importance: Low

I have tried that, but as soon as I introduce the PartAlloc table to the
phrase builder, when I Analyse, it returns no results as if there is a
conflict between the two table.

I have had something similar where I wanted to see Part No, Weight,
Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
it returned no results.

Cheers.

____________ _________ _________ __
From: Steven Gotschall <sgotschall@yahoo. com
<mailto:sgotschall% 40yahoo.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Monday, 15 June, 2009 12:59:28
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I think you are going to have to pull in the PartAlloc table also and
subtract the allocations from the on hand quantities.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use
with a Quick Search.

I want it to display the following:

Part Number | Description | Net Weight | On Hand Qty | Available
Qty

This way, before the part is even added to a SO or Quote, the user in
our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can
sucessfully display the first 4 columns on my quick search/BAQ, however,
I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

[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]

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

system · June 19, 2009, 5:40am

Hi,

I have set up a BAQ that will display the Part, Description and OnHandQty.

I have linked the Part as the parent table with the PartBin as the child.

I can get it to display everything EXCEPT ...

When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.

Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?

Cheers,

CHRIS

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Monday, 15 June, 2009 15:57:18
Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help

Hi Cliff,

That's almost there actually.

However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.

____________ _________ _________ __
From: Cliff Drumeller <cliff@massprecision .com>
To: vantage@yahoogroups .com
Sent: Monday, 15 June, 2009 15:49:00
Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help

Try making partbin your primary table and then linking part for your
description, etc.

Cliff Drumeller
IT Manager
Mass Precision, Inc.
408 786 0348
408 314 7420 cell

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Monday, June 15, 2009 5:18 AM
To: vantage@yahoogroups .com
Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
Importance: Low

I have tried that, but as soon as I introduce the PartAlloc table to the
phrase builder, when I Analyse, it returns no results as if there is a
conflict between the two table.

I have had something similar where I wanted to see Part No, Weight,
Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
it returned no results.

Cheers.

____________ _________ _________ __
From: Steven Gotschall <sgotschall@ yahoo. com
<mailto:sgotschall% 40yahoo.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Monday, 15 June, 2009 12:59:28
Subject: Re: [Vantage] Epicor 9 - BAQ Help

I think you are going to have to pull in the PartAlloc table also and
subtract the allocations from the on hand quantities.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Monday, June 15, 2009 6:41:18 AM
Subject: [Vantage] Epicor 9 - BAQ Help

Hi,

I am trying to write a simple (so I thought) BAQ which I want to use
with a Quick Search.

I want it to display the following:

Part Number | Description | Net Weight | On Hand Qty | Available
Qty

This way, before the part is even added to a SO or Quote, the user in
our Sales Department can see if we have the part available.

I have written a BAQ with the PART and PARTWHSE tables and can
sucessfully display the first 4 columns on my quick search/BAQ, however,
I am struggling to get the 5th column to display.

Any help would be greatly appreciated.

Regards,

CHRIS THOMPSON

[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]

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

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

system · June 19, 2009, 7:00am

This is where the join type comes into play. If the on hand qty is zero - there is no bin

You need an outer join to return results of Part table if there is no PartBin record

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi,
>
> I have set up a BAQ that will display the Part, Description and OnHandQty.
>
> I have linked the Part as the parent table with the PartBin as the child.
>
> I can get it to display everything EXCEPT ...
>
> When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.
>
> Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?
>
> Cheers,
>
>
>
> CHRIS
>
>
>
>
> ________________________________
> From: Chris Thompson <chriselectrix@...>
> To: vantage@yahoogroups.com
> Sent: Monday, 15 June, 2009 15:57:18
> Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
>
>
>
>
>
> Hi Cliff,
>
> That's almost there actually.
>
> However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.
>
> ____________ _________ _________ __
> From: Cliff Drumeller <cliff@massprecision .com>
> To: vantage@yahoogroups .com
> Sent: Monday, 15 June, 2009 15:49:00
> Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
>
> Try making partbin your primary table and then linking part for your
> description, etc.
>
> Cliff Drumeller
> IT Manager
> Mass Precision, Inc.
> 408 786 0348
> 408 314 7420 cell
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> Of Chris Thompson
> Sent: Monday, June 15, 2009 5:18 AM
> To: vantage@yahoogroups .com
> Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> Importance: Low
>
> I have tried that, but as soon as I introduce the PartAlloc table to the
> phrase builder, when I Analyse, it returns no results as if there is a
> conflict between the two table.
>
> I have had something similar where I wanted to see Part No, Weight,
> Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
> it returned no results.
>
> Cheers.
>
> ____________ _________ _________ __
> From: Steven Gotschall <sgotschall@ yahoo. com
> <mailto:sgotschall% 40yahoo.com> >
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Sent: Monday, 15 June, 2009 12:59:28
> Subject: Re: [Vantage] Epicor 9 - BAQ Help
>
> I think you are going to have to pull in the PartAlloc table also and
> subtract the allocations from the on hand quantities.
>
> ____________ _________ _________ __
> From: Chris Thompson <chriselectrix@ ymail.com>
> To: vantage@yahoogroups .com
> Sent: Monday, June 15, 2009 6:41:18 AM
> Subject: [Vantage] Epicor 9 - BAQ Help
>
> Hi,
>
> I am trying to write a simple (so I thought) BAQ which I want to use
> with a Quick Search.
>
> I want it to display the following:
>
> Part Number | Description | Net Weight | On Hand Qty | Available
> Qty
>
> This way, before the part is even added to a SO or Quote, the user in
> our Sales Department can see if we have the part available.
>
> I have written a BAQ with the PART and PARTWHSE tables and can
> sucessfully display the first 4 columns on my quick search/BAQ, however,
> I am struggling to get the 5th column to display.
>
> Any help would be greatly appreciated.
>
> Regards,
>
> CHRIS THOMPSON
>
> [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]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · June 19, 2009, 7:34am

Superb!!

One last thing.

If I want to display the 'available' qty i.e. the qtyonhand in all bins MINUS the qty allocated to orders (parts that are on unshipped orders).

If you can helo with that, I will be very grateful.

CHEERS.

________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Friday, 19 June, 2009 12:00:31
Subject: Re: [Vantage] Epicor 9 - BAQ Help

This is where the join type comes into play. If the on hand qty is zero - there is no bin

You need an outer join to return results of Part table if there is no PartBin record

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi,
>
> I have set up a BAQ that will display the Part, Description and OnHandQty.
>
> I have linked the Part as the parent table with the PartBin as the child.
>
> I can get it to display everything EXCEPT ...
>
> When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.
>
> Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?
>
> Cheers,
>
>
>
> CHRIS
>
>
>
>
> ____________ _________ _________ __
> From: Chris Thompson <chriselectrix@ ...>
> To: vantage@yahoogroups .com
> Sent: Monday, 15 June, 2009 15:57:18
> Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
>
>
>
>
>
> Hi Cliff,
>
> That's almost there actually.
>
> However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.
>
> ____________ _________ _________ __
> From: Cliff Drumeller <cliff@massprecisio n .com>
> To: vantage@yahoogroups .com
> Sent: Monday, 15 June, 2009 15:49:00
> Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
>
> Try making partbin your primary table and then linking part for your
> description, etc.
>
> Cliff Drumeller
> IT Manager
> Mass Precision, Inc.
> 408 786 0348
> 408 314 7420 cell
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> Of Chris Thompson
> Sent: Monday, June 15, 2009 5:18 AM
> To: vantage@yahoogroups .com
> Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> Importance: Low
>
> I have tried that, but as soon as I introduce the PartAlloc table to the
> phrase builder, when I Analyse, it returns no results as if there is a
> conflict between the two table.
>
> I have had something similar where I wanted to see Part No, Weight,
> Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
> it returned no results.
>
> Cheers.
>
> ____________ _________ _________ __
> From: Steven Gotschall <sgotschall@ yahoo. com
> <mailto:sgotschall% 40yahoo.com> >
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Sent: Monday, 15 June, 2009 12:59:28
> Subject: Re: [Vantage] Epicor 9 - BAQ Help
>
> I think you are going to have to pull in the PartAlloc table also and
> subtract the allocations from the on hand quantities.
>
> ____________ _________ _________ __
> From: Chris Thompson <chriselectrix@ ymail.com>
> To: vantage@yahoogroups .com
> Sent: Monday, June 15, 2009 6:41:18 AM
> Subject: [Vantage] Epicor 9 - BAQ Help
>
> Hi,
>
> I am trying to write a simple (so I thought) BAQ which I want to use
> with a Quick Search.
>
> I want it to display the following:
>
> Part Number | Description | Net Weight | On Hand Qty | Available
> Qty
>
> This way, before the part is even added to a SO or Quote, the user in
> our Sales Department can see if we have the part available.
>
> I have written a BAQ with the PART and PARTWHSE tables and can
> sucessfully display the first 4 columns on my quick search/BAQ, however,
> I am struggling to get the 5th column to display.
>
> Any help would be greatly appreciated.
>
> Regards,
>
> CHRIS THOMPSON
>
> [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]
>
> [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]

system · June 19, 2009, 7:46am

Why not use Part and PartWhse - the PartWhse table holds Qty on hand and all the allocated qtys (at least in V8.03xxx) - look in the data dictionary to see if this would work for you...

One thing to note - sometimes the qtys in this table are not updated properly which requires a 'conversion' routine to be run to recalculate them (6430)

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Superb!!
>
> One last thing.
>
> If I want to display the 'available' qty i.e. the qtyonhand in all bins MINUS the qty allocated to orders (parts that are on unshipped orders).
>
> If you can helo with that, I will be very grateful.
>
> CHEERS.
>
>
>
>
> ________________________________
> From: bw2868bond <bwalker@...>
> To: vantage@yahoogroups.com
> Sent: Friday, 19 June, 2009 12:00:31
> Subject: Re: [Vantage] Epicor 9 - BAQ Help
>
>
>
>
>
> This is where the join type comes into play. If the on hand qty is zero - there is no bin
>
> You need an outer join to return results of Part table if there is no PartBin record
>
> --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
> >
> > Hi,
> >
> > I have set up a BAQ that will display the Part, Description and OnHandQty.
> >
> > I have linked the Part as the parent table with the PartBin as the child.
> >
> > I can get it to display everything EXCEPT ...
> >
> > When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.
> >
> > Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?
> >
> > Cheers,
> >
> >
> >
> > CHRIS
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Chris Thompson <chriselectrix@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 15 June, 2009 15:57:18
> > Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> >
> >
> >
> >
> >
> > Hi Cliff,
> >
> > That's almost there actually.
> >
> > However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.
> >
> > ____________ _________ _________ __
> > From: Cliff Drumeller <cliff@massprecisio n .com>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 15 June, 2009 15:49:00
> > Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> >
> > Try making partbin your primary table and then linking part for your
> > description, etc.
> >
> > Cliff Drumeller
> > IT Manager
> > Mass Precision, Inc.
> > 408 786 0348
> > 408 314 7420 cell
> >
> > ____________ _________ _________ __
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> > Of Chris Thompson
> > Sent: Monday, June 15, 2009 5:18 AM
> > To: vantage@yahoogroups .com
> > Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> > Importance: Low
> >
> > I have tried that, but as soon as I introduce the PartAlloc table to the
> > phrase builder, when I Analyse, it returns no results as if there is a
> > conflict between the two table.
> >
> > I have had something similar where I wanted to see Part No, Weight,
> > Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
> > it returned no results.
> >
> > Cheers.
> >
> > ____________ _________ _________ __
> > From: Steven Gotschall <sgotschall@ yahoo. com
> > <mailto:sgotschall% 40yahoo.com> >
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> > Sent: Monday, 15 June, 2009 12:59:28
> > Subject: Re: [Vantage] Epicor 9 - BAQ Help
> >
> > I think you are going to have to pull in the PartAlloc table also and
> > subtract the allocations from the on hand quantities.
> >
> > ____________ _________ _________ __
> > From: Chris Thompson <chriselectrix@ ymail.com>
> > To: vantage@yahoogroups .com
> > Sent: Monday, June 15, 2009 6:41:18 AM
> > Subject: [Vantage] Epicor 9 - BAQ Help
> >
> > Hi,
> >
> > I am trying to write a simple (so I thought) BAQ which I want to use
> > with a Quick Search.
> >
> > I want it to display the following:
> >
> > Part Number | Description | Net Weight | On Hand Qty | Available
> > Qty
> >
> > This way, before the part is even added to a SO or Quote, the user in
> > our Sales Department can see if we have the part available.
> >
> > I have written a BAQ with the PART and PARTWHSE tables and can
> > sucessfully display the first 4 columns on my quick search/BAQ, however,
> > I am struggling to get the 5th column to display.
> >
> > Any help would be greatly appreciated.
> >
> > Regards,
> >
> > CHRIS THOMPSON
> >
> > [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]
> >
> > [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]
>

system · June 19, 2009, 8:20am

I have managed to get the SalesDemandQty to appear, but if a part has two bins assigned, the no. of lines in the BAQ returned is doubled.

For example a Part has two bins A and B, before adding the PartWhse table it shows the onhandqty correctly. As soon as I add the PartWhse table it repeats the two lines.

All that I require is an OnHandQty for all the bins added together, minus the SalesDemandQty to give me my Available qty.

________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Friday, 19 June, 2009 12:45:41
Subject: [Vantage] Re: Epicor 9 - BAQ Help

Why not use Part and PartWhse - the PartWhse table holds Qty on hand and all the allocated qtys (at least in V8.03xxx) - look in the data dictionary to see if this would work for you...

One thing to note - sometimes the qtys in this table are not updated properly which requires a 'conversion' routine to be run to recalculate them (6430)

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Superb!!
>
> One last thing.
>
> If I want to display the 'available' qty i.e. the qtyonhand in all bins MINUS the qty allocated to orders (parts that are on unshipped orders).
>
> If you can helo with that, I will be very grateful.
>
> CHEERS.
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Friday, 19 June, 2009 12:00:31
> Subject: Re: [Vantage] Epicor 9 - BAQ Help
>
>
>
>
>
> This is where the join type comes into play. If the on hand qty is zero - there is no bin
>
> You need an outer join to return results of Part table if there is no PartBin record
>
> --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
> >
> > Hi,
> >
> > I have set up a BAQ that will display the Part, Description and OnHandQty.
> >
> > I have linked the Part as the parent table with the PartBin as the child.
> >
> > I can get it to display everything EXCEPT ...
> >
> > When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.
> >
> > Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?
> >
> > Cheers,
> >
> >
> >
> > CHRIS
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Chris Thompson <chriselectrix@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 15 June, 2009 15:57:18
> > Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> >
> >
> >
> >
> >
> > Hi Cliff,
> >
> > That's almost there actually.
> >
> > However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.
> >
> > ____________ _________ _________ __
> > From: Cliff Drumeller <cliff@massprecisio n .com>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 15 June, 2009 15:49:00
> > Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> >
> > Try making partbin your primary table and then linking part for your
> > description, etc.
> >
> > Cliff Drumeller
> > IT Manager
> > Mass Precision, Inc.
> > 408 786 0348
> > 408 314 7420 cell
> >
> > ____________ _________ _________ __
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> > Of Chris Thompson
> > Sent: Monday, June 15, 2009 5:18 AM
> > To: vantage@yahoogroups .com
> > Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> > Importance: Low
> >
> > I have tried that, but as soon as I introduce the PartAlloc table to the
> > phrase builder, when I Analyse, it returns no results as if there is a
> > conflict between the two table.
> >
> > I have had something similar where I wanted to see Part No, Weight,
> > Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
> > it returned no results.
> >
> > Cheers.
> >
> > ____________ _________ _________ __
> > From: Steven Gotschall <sgotschall@ yahoo. com
> > <mailto:sgotschall% 40yahoo.com> >
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> > Sent: Monday, 15 June, 2009 12:59:28
> > Subject: Re: [Vantage] Epicor 9 - BAQ Help
> >
> > I think you are going to have to pull in the PartAlloc table also and
> > subtract the allocations from the on hand quantities.
> >
> > ____________ _________ _________ __
> > From: Chris Thompson <chriselectrix@ ymail.com>
> > To: vantage@yahoogroups .com
> > Sent: Monday, June 15, 2009 6:41:18 AM
> > Subject: [Vantage] Epicor 9 - BAQ Help
> >
> > Hi,
> >
> > I am trying to write a simple (so I thought) BAQ which I want to use
> > with a Quick Search.
> >
> > I want it to display the following:
> >
> > Part Number | Description | Net Weight | On Hand Qty | Available
> > Qty
> >
> > This way, before the part is even added to a SO or Quote, the user in
> > our Sales Department can see if we have the part available.
> >
> > I have written a BAQ with the PART and PARTWHSE tables and can
> > sucessfully display the first 4 columns on my quick search/BAQ, however,
> > I am struggling to get the 5th column to display.
> >
> > Any help would be greatly appreciated.
> >
> > Regards,
> >
> > CHRIS THOMPSON
> >
> > [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]
> >
> > [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]

system · June 19, 2009, 9:44am

I have added my BAQ to a quick search and each time it returns the results, it returns two lines per part. One with an available value and one without.

Any ideas?

________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Friday, 19 June, 2009 12:45:41
Subject: [Vantage] Re: Epicor 9 - BAQ Help

Why not use Part and PartWhse - the PartWhse table holds Qty on hand and all the allocated qtys (at least in V8.03xxx) - look in the data dictionary to see if this would work for you...

One thing to note - sometimes the qtys in this table are not updated properly which requires a 'conversion' routine to be run to recalculate them (6430)

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Superb!!
>
> One last thing.
>
> If I want to display the 'available' qty i.e. the qtyonhand in all bins MINUS the qty allocated to orders (parts that are on unshipped orders).
>
> If you can helo with that, I will be very grateful.
>
> CHEERS.
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Friday, 19 June, 2009 12:00:31
> Subject: Re: [Vantage] Epicor 9 - BAQ Help
>
>
>
>
>
> This is where the join type comes into play. If the on hand qty is zero - there is no bin
>
> You need an outer join to return results of Part table if there is no PartBin record
>
> --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
> >
> > Hi,
> >
> > I have set up a BAQ that will display the Part, Description and OnHandQty.
> >
> > I have linked the Part as the parent table with the PartBin as the child.
> >
> > I can get it to display everything EXCEPT ...
> >
> > When the BIN has a qty of Zero it will not show. If it has a positive or negative figure it displays.
> >
> > Does anyone know how I can get it to display the Bin qty for ANY qty incl Zero?
> >
> > Cheers,
> >
> >
> >
> > CHRIS
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Chris Thompson <chriselectrix@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 15 June, 2009 15:57:18
> > Subject: Re: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> >
> >
> >
> >
> >
> > Hi Cliff,
> >
> > That's almost there actually.
> >
> > However, it now only displays if a bin has a qty. If qty=0 the bin or part doesnt show.
> >
> > ____________ _________ _________ __
> > From: Cliff Drumeller <cliff@massprecisio n .com>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 15 June, 2009 15:49:00
> > Subject: RE: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> >
> > Try making partbin your primary table and then linking part for your
> > description, etc.
> >
> > Cliff Drumeller
> > IT Manager
> > Mass Precision, Inc.
> > 408 786 0348
> > 408 314 7420 cell
> >
> > ____________ _________ _________ __
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> > Of Chris Thompson
> > Sent: Monday, June 15, 2009 5:18 AM
> > To: vantage@yahoogroups .com
> > Subject: [BULK] Re: [Vantage] Epicor 9 - BAQ Help
> > Importance: Low
> >
> > I have tried that, but as soon as I introduce the PartAlloc table to the
> > phrase builder, when I Analyse, it returns no results as if there is a
> > conflict between the two table.
> >
> > I have had something similar where I wanted to see Part No, Weight,
> > Whse, Bin, but as soon as I added the PartBin table to the Phrasebuilder
> > it returned no results.
> >
> > Cheers.
> >
> > ____________ _________ _________ __
> > From: Steven Gotschall <sgotschall@ yahoo. com
> > <mailto:sgotschall% 40yahoo.com> >
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> > Sent: Monday, 15 June, 2009 12:59:28
> > Subject: Re: [Vantage] Epicor 9 - BAQ Help
> >
> > I think you are going to have to pull in the PartAlloc table also and
> > subtract the allocations from the on hand quantities.
> >
> > ____________ _________ _________ __
> > From: Chris Thompson <chriselectrix@ ymail.com>
> > To: vantage@yahoogroups .com
> > Sent: Monday, June 15, 2009 6:41:18 AM
> > Subject: [Vantage] Epicor 9 - BAQ Help
> >
> > Hi,
> >
> > I am trying to write a simple (so I thought) BAQ which I want to use
> > with a Quick Search.
> >
> > I want it to display the following:
> >
> > Part Number | Description | Net Weight | On Hand Qty | Available
> > Qty
> >
> > This way, before the part is even added to a SO or Quote, the user in
> > our Sales Department can see if we have the part available.
> >
> > I have written a BAQ with the PART and PARTWHSE tables and can
> > sucessfully display the first 4 columns on my quick search/BAQ, however,
> > I am struggling to get the 5th column to display.
> >
> > Any help would be greatly appreciated.
> >
> > Regards,
> >
> > CHRIS THOMPSON
> >
> > [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]
> >
> > [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]