|
|||||
|
 Does that title sound funny? Can you update your Primary Keys of a record in a table too? Ofcourse you can, SQL does allow it. But does that work in an ERP? Yes ERP’s are supposed to keep their data integrity well, and secure it too. But in JD Edwards you have an option to update the Primary Keys. Actually – Change the primary key values. You can achieve this feat by using Headerless Detail form. The secondary option . . . → Read More: Update Your Primary Keys from JDE *The article is rated Must read for Beginners/Novice There has been many a confusion with JDE freshers, on how to use the Internal Data selection, or called as ER Data selection and how to use them. Following are our assumptions for the scenarios (for REPORT DESIGN AID (RDA)) - There’s a Processing Option which takes inputs of Date range (F4201.DRQJ) for internal data selection. Scenario 1 Suppose we need to select all Sales orders (F4201) entered between (DRQJ=) 7/1/2011 and 7/31/2011 . . . → Read More: How Event Rule Dataselection Works in JDE Tools  Many a times we need to change the Business view of a Report/UBE, which requires re-validating the event rules code. Worse, if you had to change the input file name in a Table Conversion? You will have to actually re-write the whole code. Usually, for such table conversions, what we do is write wrapper UBE’s which would rename the input file to the path/file name of the table conversion, and then trigger the TC to run. All these options take huge amount . . . → Read More: Change FileNames in Table Conversion or Business View in UBE  If ever you had to open and save the path for a file in JD Edwards, following is a stunning way to do it. But, yeah, this works only on Windows OS. The screen above shows a Browse button, which on clicked gives the Browse for File dialog box. Once selected the file, the following screen appears The File Browse part is a simple BSFN - B9800005 - File Path Search. The BSFN does not need any parameters to . . . → Read More: Prompt to open File/Folder in Applications Have you ever wondered if you can do a wild card search for the file you want to upload into JDE tables? Like while you do an interface, where the files come in with Date/Time stamps, you can find the latest file, and then upload it! It used to be a crude way of doing where, you used to write a Driver program, which gets the file name using the Processing Options, and then rename it according to the . . . → Read More: Perform a File Search in JDE |
||||
|
Copyright © 2012 Deepesh M Divakaran - All Rights Reserved |
|||||
Recent Comments