Every day at Deft Flux, we are mapping unique paths from problem to solution, and we like to share them with you from time to time. Today, our question is a common one -- "How can I automatically run and e-mail a Crystal Report?" Let's consider this case where you want to schedule a report […]
During an upgrade to JDE EnterpriseOne you will need to list any changes that have been made to your data dictionary, and using SQL or even a UBE, most developers would have no problem coming up with a way to compare the pristine data dictionary with the latest version. We thought, however, it might be nice […]
I know since we posted the JDE date to real date function, everyone has been wondering where the real date to JDE date function is. Well, "ask and you shall receive."
As long as we are discussing JD Edwards running on DB/2. Here's another potentially useful function. This one converts a value from one unit of measure to another based on the F41002 table. It does this by converting the FromUOM to the primary UOM and thence to the ToUOM.
During nine years of blackguarding the J. D. Edwards date format (also known as JDate, also misnamed Julian Date), I have resisted learning to write DB/2 stored procedures because the need to use them while developing OneWorld applications is minimal and OneWorld is the only context in which I have encountered DB/2. Well, I have […]
If you have ever used the JDEdwards cross-reference facility in an attempt to find where a certain table column is used, you understand that it can be difficult, especially when the alias for your column is common. Let's say you have a custom table [F550001] that has a column [URRF], and you need to find […]