|
|||||
 
|
 Calculate the Begin and End dates from a given Period/Year combination or to calculate the month’s begin and end dates from a given date. Like if you are given Period=3, Year=9, the Begin and End dates will be 03/01/2009 and 03/30/2009 respectively. Similarly if you were given a date say – 2/17/2009, the return Begin & End dates will be 02/01/2009 and 02/28/2009. . . . → Read More: Calculate Begin and End Dates for Month/Year Most File based transactions or JDE Applications, need to have access to the Import and Export directory of the Install Path. For most Live installations, the workstations will be on Windows OS, and the servers may be either AS/400 or Linux/UNIX environments. The path’s to the environment install directory will be entirely different in each case. Typically for an JDE EnterpriseOne Windows based Local installation will have path – “C:\Exxx\DVxxx\” or “C:\Bxxxx\PDxxxx\”, If you notice the above, not only the file path is different, but also the directory separator. The following C BSFN helps get the Install Path, the Separator, if its Client/Server. I’m not sure if a similar BSFN exists in the latest versions of JDE, one thing I’m sure Oneworld XE does not have it, and that’s why the Business Function was created. The “BuildPathFromEnvDataX” API is used to retrieve the complete install path. You can get the Continue reading BSFN to Get Install Path (for Import/Export)  Leave a comment  EnterpriseOne, Technical  Access, API, BSFN, BSFN for Complete Install Path, BuildPathFromEnvDataX, Business, business functions, Bxxxx, C BSFN, dir, directory, download, DVxxx, EnterpriseOne, environment, environments, Export, Exxx, File, filespace, Function, import, Install path, Installation, JDE, Linux, OneWorld, Path, path installed, PDxxxx, Separator, server, target, UNIX, Windows A problem with SQL over JDE Data is the way Dates are stored in JD Edwards. JDE stores dates in Julian Format. The following SQL snippet can convert the Julian date into Gregorian Date format or Normal date. . . . → Read More: Convert Julian Date to Gregorian Date (SQL)  E-Mail the output of your UBE using this simple functionality, by retrieving your JobNumber and simple JDE setups. Uses BSFN – B0500190 (SendEMailHRM) for Xe until 8.10, or B0500725 – Email Merge Letter for other versions. . . . → Read More: Send Email with PDF Output There are many instances where we do Report Interconnects from Interactive Applications, like print the Order from an order screen, or process something from an interactive application button. But, in all those cases, the report fires on the Server, and you need to go visit the Work Submitted Jobs to check the output. Every User asks for the same convenience, if they can get the output direct on the screen without going to the WSJ. Here is a crude way of popping up a UBE output onto the screen, without going to the Work Submitted Jobs. This makes life easy for the users. . . . → Read More: Pop up Report/UBE after Processed 3 comments EnterpriseOne, Technical Audit, BSFN, business functions, Database, database path, DatabaseServerName, DS OVERRIDE, Executable, form, interactive application, Job, job number, Job Queue, JobstatusOW, JOBSTS, Mapping, ocm mappings, OneWorld, output, pdf, pop, Pop up, report, ReportName, server, UBE, WSJ |
||||
|
Copyright © 2010 Deepesh M Divakaran - All Rights Reserved |
|||||
Recent Comments