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!
Wednesday, December 13, 2017
Sunday, December 10, 2017
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)
=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)
Subscribe to:
Posts (Atom)