Technical | Deepesh M Divakaran

Funny JDE Standard BSFN Comments ;-)

A funny code comment in a E8.11 Standard JDE Business function (BSFN) – B9600430 line 406. We need to empathize with the [...]

Calculate Begin and End Dates for Month/Year

By Deepesh Divakaran

Print This Post

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 [...]

BSFN to Get Install Path (for Import/Export)

By Deepesh Divakaran

Print This Post

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 [...]

Convert Julian Date to Gregorian Date (SQL)

By Deepesh Divakaran

Print This Post

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 [...]