RE: World Writer using Today's date

[Karen_Collins]

RE: World Writer using Today\'s date

Mike,

What we did to was to create a file that contains one record with a date
field. We created an RPG program that updates this record on a daily basis
with the system date; this program runs at 12:01am every day. In our World
Writers (or Query), we join the applicable file to this date file by the
appropriate date field. I know it's not slick, but it works.

Karen S. Collins
Systems Analyst
Huffy Bicycle Company
513.704.5987
[email protected]

 

[Guest]

RE: World Writer using Today\'s date

Did you know that there already is a program and a file in JDE that already
does this?

It's called P00365 and F00365. You can run it once a day after midnight and
it populates the system date into the file where you can use it for
reporting. Optionally, you can purge the file every time the program runs
so that it only contains the current system date. I use it to report on
sales orders that get "stuck", for example, orders that with a ship date
more than 3 days ago that have not yet invoiced.

Maybe I'm missing something, but it sounds like what you did is already in
the base JDE product. I guess great minds think alike!



Andy

Andy Klee
Klee Associates
JD Edwards Certified Professional
Tel: 970 856 4811

www.JDETips.com

 

[scott_parker]

Re: RE: World Writer using Today\'s date

Interesting use of the F00365 but I always thought that file needed to have more then just 1 record in it? We have our F00365 populated from 1/1/1987 till 12/31/2030.

The use of this 2nd file I presume is to only have 1 record in it with Today’s date. So that you could link to it and pick Today (or today -1 etc) like you can do with a Dream Writer.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)

 

[tpayne]

RE: RE: World Writer using Today\'s date

There is a JDE white paper covering this and how to set it up.
It describes how to create a copy of F00365 with only 1 record and how to
use it.

 

[Graham_Aberdein1]

Re: RE: World Writer using Today\'s date

We use the F00365 which has only the current date in it (this date is
updated daily at midnight). We then use a join in Worldwriter between the
F00365 and the G/L date in the F0911 file. This allows us to extract
current-date transactions from the F0911 without having to manually update
the G/L date in Worldwriter.

As a point if interest, we also use the F0010 file to join on company,
reporting period and year to the F0911 company G/L period and fiscal year.
This allows us to extract F0911 transactions for the period based on the
current reporting period defined in the F0010 file. Again, without having
to update the Worldwriter manually.


Graham G. Aberdein
Clarica
(519) 888-3900 x-4293
email address: [email protected]







"scott parker" <[email protected]>@jdelist.com on 06/12/2000 08:39:12
AM

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:
Subject: Re: RE: World Writer using Today's date ~~2225:2240


Interesting use of the F00365 but I always thought that file needed to have
more then just 1 record in it? We have our F00365 populated from 1/1/1987
till 12/31/2030.

The use of this 2nd file I presume is to only have 1 record in it with
Today's date. So that you could link to it and pick Today (or today -1
etc) like you can do with a Dream Writer.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=2240

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

 

[scott_parker]

Re: RE: RE: World Writer using Today\'s date

Right a copy OF the F00365. I can see doing that. But are they saying that the F00365 they use only has 1 record?
I thought that file was used in other places?

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)

 

[Susan]

Re: RE: RE: World Writer using Today\'s date

Scott - you are correct about F00365. It is valuable to have multiple dates populated because it is a nice way to pick up additional information about each date (name of month spelled out, etc.) as well as providing the ability to select data based on non-Julian criteria such as month. I don't think any standard JDE programs use this file but it is great for WorldWriters.

A solution I've used is to create another file for the current date with one record. In addition to having the current date, the record also contained additional dates such as next ship date.

Susan A. Vowels
SAV Solutions, LLC
P.O. Box 100
Hartly, DE 19953

 

[scott_parker]

Re: RE: RE: World Writer using Today\'s date

Yep thats what I just did.
I went and got the white paper for created this 2nd file. and have set it all up.

Seems to work slick.

Thanks

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)

 

[scott_parker]

World Writer using Today\'s date The JDE White Pape

Title: Set up multiple versions of F00365
Abstract: For reasons why you may want several versions of this file, see How to select on today's date

Product World
Suite Technical
Release A5.2 - A8.1
Document ID WST-99-0205
Date Created 11/08/1999
Date Reviewed
Date Revised

--------------------------------------------------------------------------------

HOW TO SET UP MULTIPLE VERSIONS OF F00365
These steps will create F00365A, P00365A, J00365A and R00365A. You will then be able to use both F00365 and the newly created F00365A populated with different dates. Repeat these steps, using a different naming convention, if further versions of the data translation file are needed.

You will need to have JDE Source Library and your custom object library in your library list. You also need to have a CASE profile set up.
(If you do not have a custom library, use CRTLIB command to create one. Use CRTSRCPF to create JDESRC in the custom library. Go to Menu G92, selection 6 to set up a CASE Profile. Make sure the Source File and CL Source File is JDESRC. The Source and Object Libraries should be your custom library name. The SAR Number field should be *NONE.)

When you are asked to compile the objects, make sure each one completes successfully before continuing to next step.

F00365A: Go to SVR, inquire on F00365. Use option 3 to create F00365A. The Source Library is your custom library; the Object Library is the name of your data library. Then do an option 2 to edit the File Design. Change the I00365 to I00365A. Exit and save the change. Use option 14 to create the new file.
R98COVER: Go to SVR, inquire on R98COVER. Use option 3 to create R98COVER in your custom library.
R98RPTH: Go to SVR, inquire on R98RPTH. Use option 3 to create R98RPTH in your custom library
R00365A: Go to SVR, inquire in R00365. Use option 3 to create R00365A. Both the Source and Object library is the name of your custom library. Use option 14 to create the new file. Go to Vocabulary Overrides (G90/16). Inquire on R00365 and add R00365A.
P00365A: Go to SVR, inquire in P00365. Use option 3 to create P00365A. Both the Source and Object library is the name of your custom library. Then do an option 2 to edit the program. Change all references of 00365 to 00365A. Exit and save the change. Use option 14 to create the new program.
J00365A: Go to SVR, inquire in J00365. Use option 3 to create J00365A. Both the Source and Object library is the name of your custom library. Then do an option 2 to edit the program. Change all references of 00365 to 00365A. Exit and save the change. Use option 14 to create the new program.
Now setup a DREAM Writer Version to run the new program. Go to Menu G81/3. Inquire on P00365 and add P00365A. On the same menu, take selection 2 and enter P00365A as the form. No version will display. Use option 3 to create a new version. Name the version. On the Version Identification screen, give the version a version title and a report title.
On the Additional parameters screen, the Based on File and Based on Member should be *NONE. The Job to Execute is J00365A. **

On the Processing Options screen enter the beginning range in number 1 and the ending range is number 2. Numbers 3 and 5 should be blank and number 4 should be 1. **

** If your version is going to be setup in SLEEPER so that the file is populated with today's or yesterday's date, the Mandatory Processing Options on the Additional Parameters screen should be N. On the Processing Options screen, numbers 1, 2, 3, and 5 should be blank and number 4 should be 1.



Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)