Data Selection for Pick (R42520)

kread

Active Member
Does anyone know a way to put the current date into data selection criteria? We would like the pick process (r42520) to only select orders with a scheduled pick date equal to or less than the current date. I haven't found a way to use current date in data selection and want to avoid making a mod to the application.

I appreciate any help...

Regards,

Kelly Read
Chiquita Brands Int'l
B733.2 SP 11.2 NT SQL Server
 
Kelly,

I agree, that would be a great feature. Unfortunately such an obvious selection escaped the JDE Developers, so to do what you want requires a mod to the application.

Regards,

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
Have you tried using scheduled pick date = *Today? This works in World, and
is supposed to work in OneWorld as of the Xe version.

Andy Klee

Klee Associates, Inc.
J.D. Edwards Certified Professional
Phone: 970.856.4811
Cellular: 303.591.7344
www.JDETips.com
 
I suppose you know that this is standard in World?

Entering LE *TODAY + 1, *MONTH, *YEAR etc in the Data Selection will give
you all orders with a date of less than or equal to tomorrow, this month
etc.

Perhaps it would be worth check the programming in World and create a
similar routine for your One World programs.

Alec
 
Re: RE: Data Selection for Pick (R42520)

Actually I didn't know that this was standard in World (*TODAY).

Since this forum is about OneWorld and the described WORLD functionality does not exist in ONEWORLD I don't suppose it makes a difference.

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
Kelly,
Larry is right as usual.
You have to make some ER design on the version or on the template to append your selection to the "user" selection using System Function calls (Set Selection Append Flag, Set Selection), a new date variable and using the date_today() date function in the expression manager.

Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Back
Top