Technical | JDE Source

Calculate Begin and End Dates for Month/Year

By Deepesh M Divakaran, on December 10th, 2009

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

BSFN to Get Install Path (for Import/Export)

By Deepesh M Divakaran, on December 3rd, 2009

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 [...] . . . → Read More: BSFN to Get Install Path (for Import/Export)

Send Email with PDF Output

By Deepesh M Divakaran, on September 21st, 2009

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

Pop up Report/UBE after Processed

By Deepesh M Divakaran, on September 16th, 2009

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 Processing

Convert UTC Time Format to Local Date and Time format

By Deepesh M Divakaran, on September 14th, 2009

UTC stands for Universal Time Coordinate and is a long integer containing the elapsed minutes since Midnight on January 1, 1970 in Greenwich, England. Lets try some ER which would help converting timezones, from and to. Similarly use UTC time zone and its format effectively for Multi-Location Projects/softwares. . . . → Read More: Convert UTC Time Format to Local Date and Time format

Using BSFN to Delete All Records from a Table

By Deepesh M Divakaran, on September 10th, 2009

BSFN – B8000002 (Delete All Rows From Table) does a delete * from tablename. The B8000007 and the B8000002 business functions must be used together to delete all the rows in a table. They will not delete the table specifications or the physical table in the database. B8000007 must be called first to get the environment handle, with the handle only then B8000002 is able to delete all records from the specified table. B8000007 must be called again to free the handle. . . . → Read More: Using BSFN to Delete All Records from a Table

Identify UBE Versions with Overrides

By Deepesh M Divakaran, on August 27th, 2009

There is not a standard report or simple inquiry that can be performed to see all versions with overrides. The easiest way to determine this information would be to look at the F98761 table in the central objects data source and find all records with a specific version name that have record types other then just 1. This would indicate some type of override was performed on the object. Depending on the value in the record type field (RSRCRDTP) you can determine what type of override exists for the version. . . . → Read More: Identify UBE Versions with Overrides

Categories

Recent Comments

Links