Purchase direct Requirement suggestions

Yahoo Archive
1
I just confirmed in our test system that if a PO is generated for a
purchase direct requirement for LESS THEN the requirement, when PO
Suggestions are generated again a suggestion will be created for the
entire job requirement. This will result in ordering more than
required. If you order more than the required amount, there is no ill
effect.



8.03.404A

Has anyone else encountered this issue?



It came about when the quantity for the job was increased and thus
generated a suggestion for the total required amount without considering
what has all ready been ordered.



Regards,



Andrew Best



[Non-text portions of this message have been removed]
2
We are trying to create a BAQ for a dashboard that will display any SO
Line Releases that do not have a Shipdate entered. We can not find a
valid criteria to use that will work to filter for a null date. Has
anyone tried this before?

Thanks
Gail
3
Compare to an unused DateXX field

--- In vantage@yahoogroups.com, "gailr999" <gailr@...> wrote:
>
> We are trying to create a BAQ for a dashboard that will display any
SO
> Line Releases that do not have a Shipdate entered. We can not find a
> valid criteria to use that will work to filter for a null date. Has
> anyone tried this before?
>
> Thanks
> Gail
>
4
ShipDate = ?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of gailr999
Sent: Tuesday, May 13, 2008 8:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - Filter for Null Dates



We are trying to create a BAQ for a dashboard that will display any SO
Line Releases that do not have a Shipdate entered. We can not find a
valid criteria to use that will work to filter for a null date. Has
anyone tried this before?

Thanks
Gail







[Non-text portions of this message have been removed]
5
Thanks alot!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Podlin, Michael
Sent: Tuesday, May 13, 2008 9:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ - Filter for Null Dates



ShipDate = ?

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On Behalf Of gailr999
Sent: Tuesday, May 13, 2008 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQ - Filter for Null Dates

We are trying to create a BAQ for a dashboard that will display any SO
Line Releases that do not have a Shipdate entered. We can not find a
valid criteria to use that will work to filter for a null date. Has
anyone tried this before?

Thanks
Gail

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







[Non-text portions of this message have been removed]
6
In the BAQ Phrase Builder we have tried comparing to the Date01 field in the OrderRel table with the criteria below:
OrderRel.ReqDate = OrderRel.Date01
but it does not return any results in testing. We also tried to use the Shipdate = ? criteria but there
was no place to enter the ? that would allow us to save. There seems to be limitations on what can be entered for a date.

Is there anything else that someone has used successfully?

Thanks
Gail

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of bw2868bond
Sent: Tuesday, May 13, 2008 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ - Filter for Null Dates



Compare to an unused DateXX field

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "gailr999" <gailr@...> wrote:
>
> We are trying to create a BAQ for a dashboard that will display any
SO
> Line Releases that do not have a Shipdate entered. We can not find a
> valid criteria to use that will work to filter for a null date. Has
> anyone tried this before?
>
> Thanks
> Gail
>







[Non-text portions of this message have been removed]
7
It isn't a very good way, but the only way i could get it work was by
writing a customization that whenever the date changed from a null
value to a date value, a checkboxXX would be checked. Then, in my
BAQ, i know that when checkboxXX = false, there is a null date.


-
-- In vantage@yahoogroups.com, "Gail Robinson" <gailr@...> wrote:
>
> In the BAQ Phrase Builder we have tried comparing to the Date01
field in the OrderRel table with the criteria below:
> OrderRel.ReqDate = OrderRel.Date01
> but it does not return any results in testing. We also tried to use
the Shipdate = ? criteria but there
> was no place to enter the ? that would allow us to save. There
seems to be limitations on what can be entered for a date.
>
> Is there anything else that someone has used successfully?
>
> Thanks
> Gail
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of bw2868bond
> Sent: Tuesday, May 13, 2008 9:46 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ - Filter for Null Dates
>
>
>
> Compare to an unused DateXX field
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"gailr999" <gailr@> wrote:
> >
> > We are trying to create a BAQ for a dashboard that will display any
> SO
> > Line Releases that do not have a Shipdate entered. We can not find a
> > valid criteria to use that will work to filter for a null date. Has
> > anyone tried this before?
> >
> > Thanks
> > Gail
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
8
8.03 (311 thru 404) doesn't support the null date constant in BAQs. (Only the braintrust at Epicor can explain this ridiculous lapse.)

You can get around it by comparing your date field to an unused (and therefore Null) UD date field (table.Date01, Date02, etc.,...)

Rob Brown

--- On Tue, 5/13/08, gailr999 <gailr@...> wrote:

From: gailr999 <gailr@...>
Subject: [Vantage] BAQ - Filter for Null Dates
To: vantage@yahoogroups.com
Date: Tuesday, May 13, 2008, 9:44 AM






We are trying to create a BAQ for a dashboard that will display any SO
Line Releases that do not have a Shipdate entered. We can not find a
valid criteria to use that will work to filter for a null date. Has
anyone tried this before?

Thanks
Gail
9
Rob,

We have tried this comparison and not been successful. Are you using a Progress backend or a SQL backend?

Thanks
Gail

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Robert Brown
Sent: Tuesday, May 13, 2008 1:21 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ - Filter for Null Dates



8.03 (311 thru 404) doesn't support the null date constant in BAQs. (Only the braintrust at Epicor can explain this ridiculous lapse.)

You can get around it by comparing your date field to an unused (and therefore Null) UD date field (table.Date01, Date02, etc.,...)

Rob Brown

--- On Tue, 5/13/08, gailr999 < gailr@hardigg. <mailto:gailr%40hardigg.com> com> wrote:

From: gailr999 < gailr@hardigg. <mailto:gailr%40hardigg.com> com>
Subject: [Vantage] BAQ - Filter for Null Dates
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Tuesday, May 13, 2008, 9:44 AM

We are trying to create a BAQ for a dashboard that will display any SO
Line Releases that do not have a Shipdate entered. We can not find a
valid criteria to use that will work to filter for a null date. Has
anyone tried this before?

Thanks
Gail







[Non-text portions of this message have been removed]
10
Did you call Epicor about this problem and report that it wasn't working? Are you using a SQL or Progress backend?

Thanks
Gail

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of laidig.systems
Sent: Tuesday, May 13, 2008 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ - Filter for Null Dates



It isn't a very good way, but the only way i could get it work was by
writing a customization that whenever the date changed from a null
value to a date value, a checkboxXX would be checked. Then, in my
BAQ, i know that when checkboxXX = false, there is a null date.

-
-- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Gail Robinson" <gailr@...> wrote:
>
> In the BAQ Phrase Builder we have tried comparing to the Date01
field in the OrderRel table with the criteria below:
> OrderRel.ReqDate = OrderRel.Date01
> but it does not return any results in testing. We also tried to use
the Shipdate = ? criteria but there
> was no place to enter the ? that would allow us to save. There
seems to be limitations on what can be entered for a date.
>
> Is there anything else that someone has used successfully?
>
> Thanks
> Gail
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On
Behalf Of bw2868bond
> Sent: Tuesday, May 13, 2008 9:46 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BAQ - Filter for Null Dates
>
>
>
> Compare to an unused DateXX field
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"gailr999" <gailr@> wrote:
> >
> > We are trying to create a BAQ for a dashboard that will display any
> SO
> > Line Releases that do not have a Shipdate entered. We can not find a
> > valid criteria to use that will work to filter for a null date. Has
> > anyone tried this before?
> >
> > Thanks
> > Gail
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







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

BAQ's do not allow this for this type of functional filtering.
You need to pull the BAQ into a dashboard. From here you can filter
on the date field and set the Value = Constant:NullDate (scroll down
to the very bottom option)
Thanks
Patty Buechler



--- In vantage@yahoogroups.com, "Gail Robinson" <gailr@...> wrote:
>
> Did you call Epicor about this problem and report that it wasn't
working? Are you using a SQL or Progress backend?
>
> Thanks
> Gail
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of laidig.systems
> Sent: Tuesday, May 13, 2008 10:39 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ - Filter for Null Dates
>
>
>
> It isn't a very good way, but the only way i could get it work was
by
> writing a customization that whenever the date changed from a null
> value to a date value, a checkboxXX would be checked. Then, in my
> BAQ, i know that when checkboxXX = false, there is a null date.
>
> -
> -- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com, "Gail Robinson" <gailr@> wrote:
> >
> > In the BAQ Phrase Builder we have tried comparing to the Date01
> field in the OrderRel table with the criteria below:
> > OrderRel.ReqDate = OrderRel.Date01
> > but it does not return any results in testing. We also tried to
use
> the Shipdate = ? criteria but there
> > was no place to enter the ? that would allow us to save. There
> seems to be limitations on what can be entered for a date.
> >
> > Is there anything else that someone has used successfully?
> >
> > Thanks
> > Gail
> >
> > -----Original Message-----
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf Of bw2868bond
> > Sent: Tuesday, May 13, 2008 9:46 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BAQ - Filter for Null Dates
> >
> >
> >
> > Compare to an unused DateXX field
> >
> > --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com,
> "gailr999" <gailr@> wrote:
> > >
> > > We are trying to create a BAQ for a dashboard that will display
any
> > SO
> > > Line Releases that do not have a Shipdate entered. We can not
find a
> > > valid criteria to use that will work to filter for a null date.
Has
> > > anyone tried this before?
> > >
> > > Thanks
> > > Gail
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
12
Progress back end. I've got a 1/2 dozen BAQs using this technique that work just fine.

One note: They were written prior to going to 404. I seem to recall reading something in the UG mail about there being issues with writing new queries like this in 404.

Did you check the knowledge base for any threads?

Rob

--- On Tue, 5/13/08, Gail Robinson <gailr@...> wrote:

From: Gail Robinson <gailr@...>
Subject: RE: [Vantage] BAQ - Filter for Null Dates
To: vantage@yahoogroups.com
Date: Tuesday, May 13, 2008, 1:45 PM






Rob,

We have tried this comparison and not been successful. Are you using a Progress backend or a SQL backend?

Thanks
Gail

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]On Behalf Of Robert Brown
Sent: Tuesday, May 13, 2008 1:21 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ - Filter for Null Dates

8.03 (311 thru 404) doesn't support the null date constant in BAQs. (Only the braintrust at Epicor can explain this ridiculous lapse.)

You can get around it by comparing your date field to an unused (and therefore Null) UD date field (table.Date01, Date02, etc.,...)

Rob Brown

--- On Tue, 5/13/08, gailr999 < gailr@hardigg. <mailto:gailr% 40hardigg. com> com> wrote:

From: gailr999 < gailr@hardigg. <mailto:gailr% 40hardigg. com> com>
Subject: [Vantage] BAQ - Filter for Null Dates
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Tuesday, May 13, 2008, 9:44 AM

We are trying to create a BAQ for a dashboard that will display any SO
Line Releases that do not have a Shipdate entered. We can not find a
valid criteria to use that will work to filter for a null date. Has
anyone tried this before?

Thanks
Gail

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

Thanks for the information. We tried it with the filter in the dashboard for the date and that works for us. We actually have 2 criteria with an "or" statement rather than an
"and" statement. It looks like the filter will only work for "and" in the dashboard filter. How do you use the "or" criteria with a null date and another criteria?

Example//

OrderRel.ReqDate = NullDate or OrderRel.OurReqQty=0


Thanks
Gail

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of bpbuechler
Sent: Tuesday, May 13, 2008 3:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ - Filter for Null Dates



Gail;

BAQ's do not allow this for this type of functional filtering.
You need to pull the BAQ into a dashboard. From here you can filter
on the date field and set the Value = Constant:NullDate (scroll down
to the very bottom option)
Thanks
Patty Buechler

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Gail Robinson" <gailr@...> wrote:
>
> Did you call Epicor about this problem and report that it wasn't
working? Are you using a SQL or Progress backend?
>
> Thanks
> Gail
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On
Behalf Of laidig.systems
> Sent: Tuesday, May 13, 2008 10:39 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BAQ - Filter for Null Dates
>
>
>
> It isn't a very good way, but the only way i could get it work was
by
> writing a customization that whenever the date changed from a null
> value to a date value, a checkboxXX would be checked. Then, in my
> BAQ, i know that when checkboxXX = false, there is a null date.
>
> -
> -- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com, "Gail Robinson" <gailr@> wrote:
> >
> > In the BAQ Phrase Builder we have tried comparing to the Date01
> field in the OrderRel table with the criteria below:
> > OrderRel.ReqDate = OrderRel.Date01
> > but it does not return any results in testing. We also tried to
use
> the Shipdate = ? criteria but there
> > was no place to enter the ? that would allow us to save. There
> seems to be limitations on what can be entered for a date.
> >
> > Is there anything else that someone has used successfully?
> >
> > Thanks
> > Gail
> >
> > -----Original Message-----
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf Of bw2868bond
> > Sent: Tuesday, May 13, 2008 9:46 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BAQ - Filter for Null Dates
> >
> >
> >
> > Compare to an unused DateXX field
> >
> > --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com,
> "gailr999" <gailr@> wrote:
> > >
> > > We are trying to create a BAQ for a dashboard that will display
any
> > SO
> > > Line Releases that do not have a Shipdate entered. We can not
find a
> > > valid criteria to use that will work to filter for a null date.
Has
> > > anyone tried this before?
> > >
> > > Thanks
> > > Gail
> > >
> >
> >
> >
> >
> >
> >
> >
> > [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]
14
Here is what I would do:
I would place the OrderRel.OurReqQty = 0 as a filter in the BAQ
And place the OrderRel.ReqDate = NullDate as a filter in the dashboard

Thanks
Patty Buechler

--- In vantage@yahoogroups.com, "Gail Robinson" <gailr@...> wrote:
>
> Patty,
>
> Thanks for the information. We tried it with the filter in the
dashboard for the date and that works for us. We actually have 2
criteria with an "or" statement rather than an
> "and" statement. It looks like the filter will only work for "and"
in the dashboard filter. How do you use the "or" criteria with a
null date and another criteria?
>
> Example//
>
> OrderRel.ReqDate = NullDate or OrderRel.OurReqQty=0
>
>
> Thanks
> Gail
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of bpbuechler
> Sent: Tuesday, May 13, 2008 3:19 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ - Filter for Null Dates
>
>
>
> Gail;
>
> BAQ's do not allow this for this type of functional filtering.
> You need to pull the BAQ into a dashboard. From here you can filter
> on the date field and set the Value = Constant:NullDate (scroll
down
> to the very bottom option)
> Thanks
> Patty Buechler
>
> --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com, "Gail Robinson" <gailr@> wrote:
> >
> > Did you call Epicor about this problem and report that it wasn't
> working? Are you using a SQL or Progress backend?
> >
> > Thanks
> > Gail
> >
> > -----Original Message-----
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf Of laidig.systems
> > Sent: Tuesday, May 13, 2008 10:39 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BAQ - Filter for Null Dates
> >
> >
> >
> > It isn't a very good way, but the only way i could get it work
was
> by
> > writing a customization that whenever the date changed from a null
> > value to a date value, a checkboxXX would be checked. Then, in my
> > BAQ, i know that when checkboxXX = false, there is a null date.
> >
> > -
> > -- In vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com, "Gail Robinson" <gailr@> wrote:
> > >
> > > In the BAQ Phrase Builder we have tried comparing to the Date01
> > field in the OrderRel table with the criteria below:
> > > OrderRel.ReqDate = OrderRel.Date01
> > > but it does not return any results in testing. We also tried to
> use
> > the Shipdate = ? criteria but there
> > > was no place to enter the ? that would allow us to save. There
> > seems to be limitations on what can be entered for a date.
> > >
> > > Is there anything else that someone has used successfully?
> > >
> > > Thanks
> > > Gail
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com
> [mailto: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com]
> On
> > Behalf Of bw2868bond
> > > Sent: Tuesday, May 13, 2008 9:46 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BAQ - Filter for Null Dates
> > >
> > >
> > >
> > > Compare to an unused DateXX field
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com,
> > "gailr999" <gailr@> wrote:
> > > >
> > > > We are trying to create a BAQ for a dashboard that will
display
> any
> > > SO
> > > > Line Releases that do not have a Shipdate entered. We can not
> find a
> > > > valid criteria to use that will work to filter for a null
date.
> Has
> > > > anyone tried this before?
> > > >
> > > > Thanks
> > > > Gail
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [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]
>