Effective Dates in F4106 and F4072

[alzakkr]

Hi List,

I am having trouble writing a world writer identifying all my pricing that
is expiring.

Here is a typical scenario:

Bike 25.00 06/01/00 to 12/31/00
24.00 01/01/00 to 05/31/00
23.00 01/01/99 to 12/31/99

Bike2 30.00 01/01/99 to 12/31/30

How do I pull just the items that are going to expire on 12/31/00 and not
all the prior ones with it?

Kristin Alzak
(781) 324-8094 x2330

New England Coffee Company
www.necoffeeco.com

 

[scott_parker]

Cant you just use the data selection and say

Experation date EQ 12/31/00

?

Or even GE (greater than or equal to)

What is your based on file for the WW?

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5

 

[Graham_Aberdein1]

Hi Kristin,

I'm not that familiar with the data in the files you mention, however I
would think that the second date you indicate in your example would be an
expiry date (I notice that file F4106 has field BPEXDJ Expired Date). Once
you know the name of this field you would include it in your Data Selection
with EQ 12/31/00 (or GE 12/31/00 if you want expiry dates with 12/31/00 or
later).

I'm sure there are others on the list who can give you a more definitive
answer.

Cheers,

Graham G. Aberdein
Clarica
Email: [email protected]
Running A7.3 cum 11





alzakkr <[email protected]>@jdelist.com on 16/01/2001 10:46:35
AM

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:
Subject: Effective Dates in F4106 and F4072 ~~0:4045


Hi List,

I am having trouble writing a world writer identifying all my pricing that
is expiring.

Here is a typical scenario:

Bike 25.00 06/01/00 to 12/31/00
24.00 01/01/00 to 05/31/00
23.00 01/01/99 to 12/31/99

Bike2 30.00 01/01/99 to 12/31/30

How do I pull just the items that are going to expire on 12/31/00 and not
all the prior ones with it?

Kristin Alzak
(781) 324-8094 x2330

New England Coffee Company
www.necoffeeco.com





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=4045

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

 

[joeb]

Call out the value of the effective and expiration date. In file
F4106 there are two fields, BPEFTJ = the effective date and BPEXDJ which is
the expiration date. In your data selection criteria of the world writer
select field BPEFTJ = 01/01/99 BPEXDJ = 12/31/30


>

 

[alzakkr]

If I say EQ 12/31/00 that would work just for that day, but I am not sure if
there are prices that expired previously that I forgot to fix.

If I say LE 12/31/00 then I would get all the old prices that I already
fixed with it.

If I say GE to 12/31/00 then I will get all the prices that are still good.

I am trying to develop a monthly report that I can put in sleeper.

Regards,

Kristin Alzak
781-324-8094 x2330

 

[joeb]

these two fields are in F4106, BPEFTJ is effective date and BPEXDJ is
expiration date.

>

 

[joeb]

>