JDE - List Question 2017-12-13

How you can setup Hyper exit security?
You need to run P00950 and click on the row menu Set Up Security ==> Hyper Exit


You need to fill the two application fields with P0030A and search.





Check out the Run security checkbox!
You need to drag and drop the items you want two secure from unsecured items to secured items!

JDE Julian Date Converter in EXCEL Formulas

Formula to convert a date to JDE Julian date:
 =CONCAT(YEAR(A1)-1900,RIGHT(CONCAT("000",DAYS(A1,DATE(YEAR(A1),1,1))+1),3))

Formula to convert JDE Julian date to a normal date:
=DATE(LEFT(A1,3),1,1)+(RIGHT(A1,3)-1)