BAQ for PO Suggestions

[system]

John,

BAQ within PO suggestions works fine. I just needed to get the key field correct to make it work. I set the BAQ as the default search when PO suggestions popped up and it works great. Additionally we are using the the filter on the grid to filter out records we do not want. I don't want to see records that are very small (.00000001) because that is how our engineers mark material that is not ready to be purchased at this time.

--- In vantage@yahoogroups.com, "mitchelljohn" <mitchelljohn@...> wrote:
>
> Joshua,
>
> You can use a BAQ within the PO suggestion screen? This would let us purchase just for our distribution center and not for our retail stores. Right now we are using Multi Plant, but I am trying to get rid of that simplify our system.
>
> --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> >
> > John,
> >
> > We are just reading the value. We did not need the SUGNUm for anything except to show the record.
> >
> > I see two ways to purchase for a specific warehouse.
> > 1. Create a BAQ that limits what you see in PO suggestions to only that warehouse.
> > 2. Make sure the warehouse is showing on the po suggestions screen. (i think by default it is not so you will have to create a new BAQ) then use the filter function on the grid to filter out all other warehouses.
> >
> > This would make me nervous if I had multiple warehouses and I was responsible for all of them because I would never see a suggestion for the other warehouses. This would include any mistakes that people made. For example maybe they setup the part in the wrong warehouse?
> >
> > If your only responsible for one warehouse then I would use one of the two above.
> >
> > Hope this helps..
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "mitchelljohn" <mitchelljohn@> wrote:
> > >
> > > Joshua,
> > >
> > > Are you trying to input a SUGNUM value or just read it?
> > >
> > > We are a distributor (we do not manufacture anything) and we have multiple warehouses. We only purchase for one warehouse, but we are not able to create suggestions for that one warehouse, only for the plant. If we could create a SUGNUM value based off a BAM then we could only buy for a specific warehouse. Or is my logic deeply flawed?
> > >
> > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > >
> > > > John,
> > > >
> > > > That worked!! I thought I had the SUGNUM in there but when I looked again it was not. Thanks!!
> > > >
> > > > --- In vantage@yahoogroups.com, "upworth" <Upworth@> wrote:
> > > > >
> > > > > I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.
> > > > >
> > > > > Hope this helps!
> > > > >
> > > > > Jonathan Tompkins
> > > > > Business Process Manager
> > > > > Alabama Specialty Products, Inc.
> > > > >
> > > > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > > > >
> > > > > > No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> > > > > > >
> > > > > > > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> > > > > > >
> > > > > > > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > > > > > >
> > > > > > > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > > > > > > >
> > > > > > > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > > > > > > >
> > > > > > > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > > > > > > >
> > > > > > > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > > > > > > >
> > > > > > > > Any help would be very much appreciated.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

[system]

I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.

For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.

I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.

Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?

Any help would be very much appreciated.

Thanks

[system]

The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.

Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.

--- In vantage@yahoogroups.com, "Joshua" <jgeske@...> wrote:
>
> I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
>
> For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
>
> I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
>
> Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
>
> Any help would be very much appreciated.
>
> Thanks
>

[system]

No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
>
> Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
>
> --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> >
> > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> >
> > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> >
> > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> >
> > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> >
> > Any help would be very much appreciated.
> >
> > Thanks
> >
>

[system]

I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.

Hope this helps!

Jonathan Tompkins
Business Process Manager
Alabama Specialty Products, Inc.

--- In vantage@yahoogroups.com, "Joshua" <jgeske@...> wrote:
>
> No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
>
>
>
>
> --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> >
> > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> >
> > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> >
> > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > >
> > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > >
> > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > >
> > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > >
> > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > >
> > > Any help would be very much appreciated.
> > >
> > > Thanks
> > >
> >
>

[system]

John,

That worked!! I thought I had the SUGNUM in there but when I looked again it was not. Thanks!!

--- In vantage@yahoogroups.com, "upworth" <Upworth@...> wrote:
>
> I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.
>
> Hope this helps!
>
> Jonathan Tompkins
> Business Process Manager
> Alabama Specialty Products, Inc.
>
> --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> >
> > No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> > >
> > > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> > >
> > > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> > >
> > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > >
> > > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > > >
> > > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > > >
> > > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > > >
> > > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > > >
> > > > Any help would be very much appreciated.
> > > >
> > > > Thanks
> > > >
> > >
> >
>

[system]

John,

That worked!! I thought I had the SUGNUM in there but when I looked again it was not. Thanks!!

--- In vantage@yahoogroups.com, "upworth" <Upworth@...> wrote:
>
> I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.
>
> Hope this helps!
>
> Jonathan Tompkins
> Business Process Manager
> Alabama Specialty Products, Inc.
>
> --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> >
> > No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> > >
> > > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> > >
> > > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> > >
> > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > >
> > > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > > >
> > > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > > >
> > > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > > >
> > > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > > >
> > > > Any help would be very much appreciated.
> > > >
> > > > Thanks
> > > >
> > >
> >
>

[system]

Joshua,

Are you trying to input a SUGNUM value or just read it?

We are a distributor (we do not manufacture anything) and we have multiple warehouses. We only purchase for one warehouse, but we are not able to create suggestions for that one warehouse, only for the plant. If we could create a SUGNUM value based off a BAM then we could only buy for a specific warehouse. Or is my logic deeply flawed?

--- In vantage@yahoogroups.com, "Joshua" <jgeske@...> wrote:
>
> John,
>
> That worked!! I thought I had the SUGNUM in there but when I looked again it was not. Thanks!!
>
> --- In vantage@yahoogroups.com, "upworth" <Upworth@> wrote:
> >
> > I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.
> >
> > Hope this helps!
> >
> > Jonathan Tompkins
> > Business Process Manager
> > Alabama Specialty Products, Inc.
> >
> > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > >
> > > No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
> > >
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> > > >
> > > > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> > > >
> > > > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> > > >
> > > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > > >
> > > > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > > > >
> > > > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > > > >
> > > > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > > > >
> > > > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > > > >
> > > > > Any help would be very much appreciated.
> > > > >
> > > > > Thanks
> > > > >
> > > >
> > >
> >
>

[system]

Hello,



I have a question on Crystal Reports. Is there any way to indicate on
the Job Pick List that there are more on hand qty records on the next
page for the same Assembly# and Material#.

Let's say Assy. 1, Mat'l. 15 has 5 different Lot Numbers which have on
hand qty. 3 out 5 Lot Numbers fit on page 7 and the last 2 Lot Numbers
print on page 8. We would like to indicate on page 7 to "See Next Page
for more...."



Mike Tonoyan / Natel EMS

mtonoyan@...

,___


______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

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

[system]

From Ken Hamady



Printing messages like:

"This Group is Continued on the Next Page" or

"This Group Continued from Previous Page"



There are two ways to let the user know that a group has crossed a page
break. The simpler one is

to set the group to "Repeat Group Header on each new page" and then place
the following formula

into the group header:



If InRepeatedGroupHeader

Then "This Group Continued from Previous Page"

Else ""



This notifies the user at the top of the next page. If you want to notify
the user at the bottom of the

prior page, you have to write three formulas that use variables as described
below.



Putting "Continued on next page" in page footers

This technique requires three formulas with variables. You can cut and paste
these formulas

without understanding variables if you place the formulas in the right
places. These three formulas

create a string variable and set the value to "Print" at the beginning of
each group and "Stop" at the

end of each group. A third formula in the page footer checks to see if the
variable is "Print" or

"Stop", and prints the message as long as the variable is still set to
"Print", meaning the group has

not ended yet.



This formula goes on the Group Header:

WhilePrintingRecords;

StringVar Control := "Print"



This formula goes on the Group Footer:

WhilePrintingRecords;

StringVar Control := "Stop"



This formula goes on the page footer:

WhilePrintingRecords;

StringVar Control;

if Control = "Print"

then "Continued on next page"

else ""





Scott

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Tonoyan
Sent: Wednesday, April 18, 2012 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - Details continued on the next page





Hello,

I have a question on Crystal Reports. Is there any way to indicate on
the Job Pick List that there are more on hand qty records on the next
page for the same Assembly# and Material#.

Let's say Assy. 1, Mat'l. 15 has 5 different Lot Numbers which have on
hand qty. 3 out 5 Lot Numbers fit on page 7 and the last 2 Lot Numbers
print on page 8. We would like to indicate on page 7 to "See Next Page
for more...."

Mike Tonoyan / Natel EMS

mtonoyan@... <mailto:mtonoyan%40natelems.com>

,___

__________________________________________________________
Notice: This email transmission may contain confidential information and is
intended only for the person(s) named. Any use, copying or disclosure to/by
any other person(s) is strictly prohibited. By accepting this information,
recipients confirm that they understand and will comply with all applicable
ITAR and EAR requirements.
__________________________________________________________

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





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

[system]

Thanks Scott, I'll try it shortly.



Mike Tonoyan / Natel EMS

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, April 18, 2012 1:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Details continued on the next
page





From Ken Hamady

Printing messages like:

"This Group is Continued on the Next Page" or

"This Group Continued from Previous Page"

There are two ways to let the user know that a group has crossed a page
break. The simpler one is

to set the group to "Repeat Group Header on each new page" and then
place
the following formula

into the group header:

If InRepeatedGroupHeader

Then "This Group Continued from Previous Page"

Else ""

This notifies the user at the top of the next page. If you want to
notify
the user at the bottom of the

prior page, you have to write three formulas that use variables as
described
below.

Putting "Continued on next page" in page footers

This technique requires three formulas with variables. You can cut and
paste
these formulas

without understanding variables if you place the formulas in the right
places. These three formulas

create a string variable and set the value to "Print" at the beginning
of
each group and "Stop" at the

end of each group. A third formula in the page footer checks to see if
the
variable is "Print" or

"Stop", and prints the message as long as the variable is still set to
"Print", meaning the group has

not ended yet.

This formula goes on the Group Header:

WhilePrintingRecords;

StringVar Control := "Print"

This formula goes on the Group Footer:

WhilePrintingRecords;

StringVar Control := "Stop"

This formula goes on the page footer:

WhilePrintingRecords;

StringVar Control;

if Control = "Print"

then "Continued on next page"

else ""

Scott

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Mike Tonoyan
Sent: Wednesday, April 18, 2012 3:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports - Details continued on the next page

Hello,

I have a question on Crystal Reports. Is there any way to indicate on
the Job Pick List that there are more on hand qty records on the next
page for the same Assembly# and Material#.

Let's say Assy. 1, Mat'l. 15 has 5 different Lot Numbers which have on
hand qty. 3 out 5 Lot Numbers fit on page 7 and the last 2 Lot Numbers
print on page 8. We would like to indicate on page 7 to "See Next Page
for more...."

Mike Tonoyan / Natel EMS

mtonoyan@... <mailto:mtonoyan%40natelems.com>
<mailto:mtonoyan%40natelems.com>

,___

__________________________________________________________
Notice: This email transmission may contain confidential information and
is
intended only for the person(s) named. Any use, copying or disclosure
to/by
any other person(s) is strictly prohibited. By accepting this
information,
recipients confirm that they understand and will comply with all
applicable
ITAR and EAR requirements.
__________________________________________________________

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

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




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

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

[system]

Scott,



The second technique with three formulas worked better for us. Thank you
very much for sharing it with us.



Mike Tonoyan / Natel EMS

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, April 18, 2012 1:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Details continued on the next
page





From Ken Hamady

Printing messages like:

"This Group is Continued on the Next Page" or

"This Group Continued from Previous Page"

There are two ways to let the user know that a group has crossed a page
break. The simpler one is

to set the group to "Repeat Group Header on each new page" and then
place
the following formula

into the group header:

If InRepeatedGroupHeader

Then "This Group Continued from Previous Page"

Else ""

This notifies the user at the top of the next page. If you want to
notify
the user at the bottom of the

prior page, you have to write three formulas that use variables as
described
below.

Putting "Continued on next page" in page footers

This technique requires three formulas with variables. You can cut and
paste
these formulas

without understanding variables if you place the formulas in the right
places. These three formulas

create a string variable and set the value to "Print" at the beginning
of
each group and "Stop" at the

end of each group. A third formula in the page footer checks to see if
the
variable is "Print" or

"Stop", and prints the message as long as the variable is still set to
"Print", meaning the group has

not ended yet.

This formula goes on the Group Header:

WhilePrintingRecords;

StringVar Control := "Print"

This formula goes on the Group Footer:

WhilePrintingRecords;

StringVar Control := "Stop"

This formula goes on the page footer:

WhilePrintingRecords;

StringVar Control;

if Control = "Print"

then "Continued on next page"

else ""

Scott

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Mike Tonoyan
Sent: Wednesday, April 18, 2012 3:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports - Details continued on the next page

Hello,

I have a question on Crystal Reports. Is there any way to indicate on
the Job Pick List that there are more on hand qty records on the next
page for the same Assembly# and Material#.

Let's say Assy. 1, Mat'l. 15 has 5 different Lot Numbers which have on
hand qty. 3 out 5 Lot Numbers fit on page 7 and the last 2 Lot Numbers
print on page 8. We would like to indicate on page 7 to "See Next Page
for more...."

Mike Tonoyan / Natel EMS

mtonoyan@... <mailto:mtonoyan%40natelems.com>
<mailto:mtonoyan%40natelems.com>

,___

__________________________________________________________
Notice: This email transmission may contain confidential information and
is
intended only for the person(s) named. Any use, copying or disclosure
to/by
any other person(s) is strictly prohibited. By accepting this
information,
recipients confirm that they understand and will comply with all
applicable
ITAR and EAR requirements.
__________________________________________________________

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

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




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

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

[system]

John,

We are just reading the value. We did not need the SUGNUm for anything except to show the record.

I see two ways to purchase for a specific warehouse.
1. Create a BAQ that limits what you see in PO suggestions to only that warehouse.
2. Make sure the warehouse is showing on the po suggestions screen. (i think by default it is not so you will have to create a new BAQ) then use the filter function on the grid to filter out all other warehouses.

This would make me nervous if I had multiple warehouses and I was responsible for all of them because I would never see a suggestion for the other warehouses. This would include any mistakes that people made. For example maybe they setup the part in the wrong warehouse?

If your only responsible for one warehouse then I would use one of the two above.

Hope this helps..

--- In vantage@yahoogroups.com, "mitchelljohn" <mitchelljohn@...> wrote:
>
> Joshua,
>
> Are you trying to input a SUGNUM value or just read it?
>
> We are a distributor (we do not manufacture anything) and we have multiple warehouses. We only purchase for one warehouse, but we are not able to create suggestions for that one warehouse, only for the plant. If we could create a SUGNUM value based off a BAM then we could only buy for a specific warehouse. Or is my logic deeply flawed?
>
> --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> >
> > John,
> >
> > That worked!! I thought I had the SUGNUM in there but when I looked again it was not. Thanks!!
> >
> > --- In vantage@yahoogroups.com, "upworth" <Upworth@> wrote:
> > >
> > > I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.
> > >
> > > Hope this helps!
> > >
> > > Jonathan Tompkins
> > > Business Process Manager
> > > Alabama Specialty Products, Inc.
> > >
> > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > >
> > > > No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
> > > >
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> > > > >
> > > > > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> > > > >
> > > > > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> > > > >
> > > > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > > > >
> > > > > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > > > > >
> > > > > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > > > > >
> > > > > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > > > > >
> > > > > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > > > > >
> > > > > > Any help would be very much appreciated.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > >
> > > >
> > >
> >
>

[system]

Joshua,

You can use a BAQ within the PO suggestion screen? This would let us purchase just for our distribution center and not for our retail stores. Right now we are using Multi Plant, but I am trying to get rid of that simplify our system.

--- In vantage@yahoogroups.com, "Joshua" <jgeske@...> wrote:
>
> John,
>
> We are just reading the value. We did not need the SUGNUm for anything except to show the record.
>
> I see two ways to purchase for a specific warehouse.
> 1. Create a BAQ that limits what you see in PO suggestions to only that warehouse.
> 2. Make sure the warehouse is showing on the po suggestions screen. (i think by default it is not so you will have to create a new BAQ) then use the filter function on the grid to filter out all other warehouses.
>
> This would make me nervous if I had multiple warehouses and I was responsible for all of them because I would never see a suggestion for the other warehouses. This would include any mistakes that people made. For example maybe they setup the part in the wrong warehouse?
>
> If your only responsible for one warehouse then I would use one of the two above.
>
> Hope this helps..
>
>
>
>
> --- In vantage@yahoogroups.com, "mitchelljohn" <mitchelljohn@> wrote:
> >
> > Joshua,
> >
> > Are you trying to input a SUGNUM value or just read it?
> >
> > We are a distributor (we do not manufacture anything) and we have multiple warehouses. We only purchase for one warehouse, but we are not able to create suggestions for that one warehouse, only for the plant. If we could create a SUGNUM value based off a BAM then we could only buy for a specific warehouse. Or is my logic deeply flawed?
> >
> > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > >
> > > John,
> > >
> > > That worked!! I thought I had the SUGNUM in there but when I looked again it was not. Thanks!!
> > >
> > > --- In vantage@yahoogroups.com, "upworth" <Upworth@> wrote:
> > > >
> > > > I was able to get a BAQ to show by using the SugPODtl table and selecting the SugNum field as a 'Like' column. I tried numerous other fields in this table, but the SugNum was the only one that would cause the BAQ to show.
> > > >
> > > > Hope this helps!
> > > >
> > > > Jonathan Tompkins
> > > > Business Process Manager
> > > > Alabama Specialty Products, Inc.
> > > >
> > > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > > >
> > > > > No luck. I cannot get any BAQ to show up in the Purchase Order Suggestion entry screen. Did you try to create a simple BAQ in your system to show up? We are testing on 9.05
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> > > > > >
> > > > > > The system checks the BAQ for key fields to decide it it will show up in a forms BAQ search.
> > > > > >
> > > > > > Try making a BAQ based on the PORel table that returns the PONum, POLin and PORelNum. That should show up.
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, "Joshua" <jgeske@> wrote:
> > > > > > >
> > > > > > > I'm trying to create a BAQ that will show up in the Purchase Order Suggestions Entry screen when I click on the Binoculars to do a search.
> > > > > > >
> > > > > > > For some reason no BAQ's will show up in this screen. Has anyone else seen this? To make sure I wasn't doing something wrong I created a simple BAQ for the Part screen. This showed up right away.
> > > > > > >
> > > > > > > I checked to make sure the fields were added in the "Like" column on the BAQ query manager and everything looks fine.
> > > > > > >
> > > > > > > Can someone else validate this is a bug/feature? Can anyone get any BAQ's to show up in the Purchase Order Suggestions Entry screen?
> > > > > > >
> > > > > > > Any help would be very much appreciated.
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>