Hierarchies in JD Edwards Automatic Accounting Instructions

Hierarchies in JD Edwards Automatic Accounting Instructions

Edward Gutkowski, Chief Architect – RapidReconciler

If you have used JD Edwards for any length of time, I’m sure you’ve run across the distribution/manufacturing automatic accounting instructions, more affectionately known as DMAAI’s. They are the roadmap between inventory related transactions and the company’s financial statements.

The setup is straight forward, as illustrated in the picture below. For each combination of company number, document type and general ledger classification, a general ledger account is specified for the debits and credits for every transaction.

One of the features JD Edwards has provided is the use of defaults, or as I refer to them “wildcards”. You can use company number ‘00000’ to represent any company, and GL class code ‘****’ to represent any classification. Because of this there is a lookup hierarchy built-in to find the exact entry to use.

Let’s use an example of an inventory adjustment transaction (IA) for an item in company ‘00001’ with a GL class of IN20. If the applicable DMAAI is configured as shown below, which entry will be used for processing?

In order to answer this question correctly, we must understand how the hierarchy works. Consider:

The first check if for an exact match of both company and GL class, followed by exact company and default GL, then default company and exact GL, and finally default/default. If none are found the system, then generates an error.

Armed with this knowledge, are you now able to answer the question above?

Yes, it’s number 3 as there is an exact match on the company number, but we need to use the default GL as there is no IN20 entry for company ‘00001’. I hope you found this helpful. Happy reconciling!

To find about GSI’s products or JD Edwards services, call us at 855-GSI-4ERP or click on CONTACT US to send us a request for more information.

Meet the Author

Edward Gutkowski