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)

Row security for a company

What fields i suggest to you setup:

• CO
• KCO 
• KCOO

You need to modify the DD item of KCO and KCOO.
You need to enable the ROW security.

1. P92001 - Data Item Specifications

You need to deploy this to the servers!



P00950 - Work With User/Role Security
Form ==> Row security

You can find the JDE tables here.
Write to the Column field: CO and KCO and KCOO.
Setup the tables which are in use at your company. 

 

 

Default century in JDE - Year date problems

When you type a date in JDE, and you don't type the first two digits of the year (century - CTRY in JDE) the system complements the date.

Example:
You type the next value: 05/15/16 ==> system translate as May 15, 2016
You type the next value: 05/15/98 ==> system translate as May 15,1998

You can change this setup if you want:

P92001 - Work with data dictionary Items - Work with data items

There are two data items:
- CENTCHG
- DCYR

 

You need to change the default values of this items:

In this case the system work in the next way:

39 ==> 2039
40 ==> 2040
41 ==> 1941

You need to deploy this DD items on servers.

Problems, errors with a new year in JDE - What can be a problem? - Solutions ideas

What you need the check when you open a new year in JDE.

1. P0010 - Work with companies

Check out the date pattern of your company,

2. P0008 - Work With Fiscal Date Patterns

Check the existence of the previous fiscal date patterns for the new year, 

3. TAX - 4008 - Work With Tax  Rate/Areas

Check the Explanation date of the tax rates.

4. P00146 - Work with Due Date Rules

Check out the calendar values of the due date rules.

5. P00071 - Work With Workday Calendar
Check the existence of the work day calendar. (previous business units in the calendar fields)

6. NN - P0002
Form ==>  NN by CO/FY

Check out your next numbers.

7. R098201 - Annual Close report

Creates account records in the F0902 table for the new fiscal year, and updates balance forward fields and prior year-end net postings fields. Calculates and posts retained earnings.

8. R12825 - Asset Account Balance Close

Have you problems with depreciation calculation?

Run Asset Account Balance Close to create the next year's balance records with cumulative and net balance forward amounts. The Asset Account Balance Close program also carries forward depreciation information to the next fiscal year. You must run Asset Account Balance Close for the current year before the system can generate depreciation journal entries for the next fiscal year.