We moved LinkedIn:  Follow our new page


HomeMain Search PageFinancials

"JDEtips on Financials"

Subscribers: After logging in  here, click on the title of the documents you want to view or download.

Not a Subscriber? Gain access to thousands of pages of invaluable articles on hundreds of JDE topics. View subscription options

Even if you are not a paid subscriber, you can read the first two pages of most JDEtips Knowledge Express articles to get an idea of our content.

Return to Search

Size: 621 KB, Version:1, Publication Date:10/5/2021
Ah yes, Integrity Reports! They are fundamental to the success of your JD Edwards installation, and too often are not understood or even ran consistently. This quick reference guide was originally created in 2006 and has been on our Top Ten Download list ever since! Of course there have been many enhancements since 2006 and Sarah does a fabulous job of not only bringing this quick reference guide up to date, but offering some of her best practice suggestions after working with this software for almost 30 years. There is a wealth of information and knowledge bundled up in this little package!  
Size: 707 KB, Version:1, Publication Date:7/1/2021
Ah yes, Integrity Reports! They are fundamental to the success of your JD Edwards installation, and too often are not understood or even ran consistently. This quick reference guide was originally created in 2006 and has been on our Top Ten Download list ever since! Of course there have been many enhancements since 2006 and Sarah does a fabulous job of not only bringing this quick reference guide up to date, but offering some of her best practice suggestions after working with this software for almost 30 years. There is a wealth of information and knowledge bundled up in this little package! Watch for Quick Reference Guides to other modules coming in future publications of KE.  
Size: 937 KB, Version:1, Publication Date:10/6/2020
Although the enhancement of Revenue Recognition in E1 has provided some of the functionality required by the new regulatory requirements, the software still needs to be enhanced in order to accommodate Schedules for Sales Orders, and the ability to include the COGS side. Scheduling provides for automating the calculation of the monthly recognized amounts for Revenue and COGS over the life of the product, and the ability to process all of the scheduled recognitions on a monthly basis. Depending on the life cycle of your product, and the number of sales orders processed in a month, this is a huge time saver. Read about this company's workaround and modification.  
Size: 437 KB, Version:1, Publication Date:4/1/2020
This article will present best practice for running the Annual Close (R098201) in JD Edwards. Carla will cover the base process and what it does, the process for rerunning the annual close and its impact, and the process for running the close for a single Job (or Business Unit). She will review the impact of this process on multiple ledger types, such as Job Budgets (JA) and Procurement (PA) not just the Accounting Actuals (AA) ledger.  
Size: 3.5 MB, Version:1, Publication Date:1/9/2018
This article is adapted from Jonnel Tenorio's 2017 InFocus presentation. Jonnel provides an overview of integrity reports, then goes into detail of what to look for in the reports in the various Financials modules. Note that there is also a JDEtips Knowledge Express article written by Mark Zinck called 'JDE Integrity Reports Quick Reference' that provides more detailed information.  
Size: 1.23 MB, Version:1, Publication Date:7/19/2017
This series of articles explains in detail how the Financial AAIs work and provides business examples of how the different AAIs can be configured. Part 1 provided a basic overview of how AAIs work, explained naming conventions, default AAIs, search sequences and best practices for maintaining AAIs, then continued by going through the AAIs at a detailed level by Module. Part 1 covered the General Accounting AAIs in depth. This part 2 covers the Accounts Receivable (A/R) AAIs. Read on to learn more about the A/R AAIs. Follow-up articles will cover the Accounts Payable, Fixed Asset and Multicurrency AAIs.  
Size: 1.54 MB, Version:1, Publication Date:3/28/2017
This is part 1 of a series of articles explaining the concepts of the Automatic Accounting Instructions in the Financial module, which are otherwise known as the "Financial AAIs". This article provides some business case examples of how the Financial AAIs could be further expanded to maximize their functionality, and help companies improve their processes and reporting.  
Size: 1.77 MB, Version:1, Publication Date:12/7/2011
There is a science to successfully mapping a newly acquired business, with different reporting requirements, into the acquiring business JDE environment. Lisa Walsh was recently tasked with this challenge and she's here to share what she found to be the most efficient way to complete this process using Global Updates. This article contains the steps you'll take, as well as the order in which you'll want to run your updates, the gotchas that Lisa encountered during her project, and her recommendations to avoid the same traps.  
Size: 6 MB, Version:1.0, Publication Date:5/3/2011
Here is the PowerPoint from the May 3, 2011 JDEtips Webucation event, presented by Andy Klee of Klee Associates and Cheryl Pierce of Amcor Packaging Distribution. An in-depth review of JDE's financial integrity jobs, advanced tips in Procurement, Sales Order and Pricing, including "Hierarchical Category Codes".  
Size: 170 KB, Version:1, Publication Date:1/5/2009
Are you ready for IFRS? In August of this year, the Security and Exchange Commission set in motion a plan that will likely result in all public companies reporting in the International Financial Reporting Standards (IFRS) framework by the year 2016. Some may have to switch to IFRS by 2014. That may seem like it's quite a while away, but in truth, it's uncomfortably close. The scope of such a transition boggles the mind, but Anurag Barua has bravely stepped forward to help you begin your research and planning. While not a JDE-centric article in nature, the information presented will provide you with a bit more background on a project that could possibly eclipse Y2K and SOX.  
Size: 485 KB, Version:1, Publication Date:7/10/2008
When it comes to Intercompany Settlements, a simple journal entry might keep the companies in balance, but it's not going to make your auditors too happy--especially if these companies are considered legal entities and an "arm's length" transaction has occurred. Bob DeMartino demonstrates how to take Intercompany Settlements to the next level and automatically create invoices and vouchers, so that your audit trail has a happy ending.  
Do you have any vendors who are also customers? Do you have both an A/R balance (they owe us), and an A/P balance (we owe them) with the same entity? Wouldn't it be nice if you could figure out who owes who and either collect or pay, but not have to do both? New features in E1 8.12 are explained by our ace financials expert, Bob DeMartino, along with Jan Stas.  
Size: 331KB, Version:1.0, Publication Date:11/23/2006
This is something JDEtips has wanted to do for a very long time; Mark Zinck simply dropped this in our lap one day recently. We think you will agree that the Integrity Reports Quick Reference he has created is one of the handiest documents you'll ever use. To say more would be simply gilding the proverbial lilly.  
Size: 493KB, Version:1.0, Publication Date:3/25/2006
Ah, the facts of life...of a business unit. It's time to listen up as Susan Stooksberry gives us the "talk" on how Business Units make their way into a Distribution AAI. (Are there birds and bees involved?)  
Size: 197KB, Version:1.0, Publication Date:7/21/2005
Changing horses in the middle of the stream can be painful and dangerous. One of those situations is when a company needs to change its fiscal year; from calendar to fiscal or from fiscal to calendar. This could happen because of an acquisition (either direction!) or restructure. This article should serve as a guide to the steps and considerations when undertaking this switch.  
Size: 782KB, Version:1.0, Publication Date:5/6/2005
Many of our best JDE tips are the result of recently-experienced (or long-remembered) "opportunities" encountered by consultants at a client site. This one is no exception! If you have never met WorldWriter and desire an introduction, see Marty Burns' article "WorldWriter Basics". If you are a developer seeking a sophisticated treatise on file unions and joins, see David Johnson's article "Joining on a Union - An Incredible Development Tool for Sales Reporting". But if you are in between - you already know the basics of JDE report writers and are a super user or functional consultant - you may want to circle this article.  
Size: 1201KB, Version:1.0, Publication Date:1/11/2005
There's nothing like experience to teach us life's important lessons...such as when a short cut winds up being the longer route, or in this case, when a time-saving conversion tool might not save us so much time, after all. Susan Stooksberry has gone down the path and felt the pain of converting reports from World to EnterpriseOne's ERW using the FASTR conversion tool. Read this article and decide for yourself whether this converter will be a debit or a credit in your migration from World to EnterpriseOne.  
Size: 1070KB, Version:1, Publication Date:11/9/2004
In our continuing efforts to keep you up to date with the latest EnterpriseOne enhancements, we present here a solid review of the 8.9/8.10 changes for Financials. Susan Stooksberry picked the ones that she feels will have the most impact and/or will be the most interesting and exciting. If you skipped EnterpriseOne 8.9 to move directly to 8.10, don't worry. The neat stuff that came with 8.9 will still be there!  
Size: 516KB, Version:1.0, Publication Date:9/1/2004
We felt we are close enough to the end of the calendar year that you are most likely starting to gear up for year-end processing. Consider this either a primer or a refresher course for deciding on your approach, getting your data prepared, tweaking your setup, and finally, gathering your data to ensure correct and proper reporting of this vital IRS requirement – the dreaded 1099 filing. This article reminds you of all the places you can shoot yourself in the foot and helps you avoid those traps and mistakes with both your data integrity and your legal position intact!  
Size: 325 KB, Version:1.0, Publication Date:11/1/2003
Talk about a useful tip! Susan shows you how, with a few minutes of effort, you can make data entry easier for often used programs like Invoice Entry. Taking this tip to the next level, you'll see that you can apply this to any OneWorld data entry form. Just be aware that any changes will need to be documented and applied again after future ESUs are applied.  
Size: 2.4 MB, Version:1.0, Publication Date:9/1/2003
In the interest of "equal time", we are publishing two articles on very similar topics. You can read Randall Foust's article in the newsletter to find out another approach to uploading budget information from a spreadsheet into OneWorld. Susan's article proves that there is always more than one way to take care of that proverbial cat.  
Size: 465 KB, Version:1.0, Publication Date:9/1/2003
There is nothing like years of experience to uncover the hidden tricks that save untold hours of time. Randall highlights one of the very few programs where you can cut and paste data directly into a OneWorld grid from Excel.  
Size: 721 KB, Version:1.0, Publication Date:7/1/2003
Dan's Back to Basics tip this month is one that could save you many hours of work. Take advantage of existing Excel skills in your organization to speed data entry in JD Edwards OneWorld. This is just one example of how Excel can be used in conjunction with JDE. See the September 2003 issue of JDEtips for more examples of using Excel with Budget Uploads.  
Roger's expertise is in multi-national financial implementations. These four tips add up to a wealth of time saving ideas. Plus you won't damage your forehead as much from banging your head against the wall when the integrity reports don't tell you what you need to know. This white paper should be required reading if you are one of the people that is supposed to know that debits go on the side nearest the window.  
Size: 420 KB, Version:1.0, Publication Date:7/1/2002
Learn the basics of how JDE's software finds the AAI to use. If you don't know how the Subsequent Business Unit field in the Business Unit Master is used, you might be surprised.  
Size: 105 KB, Version:1.0, Publication Date:3/1/2002
Anyone using General Ledger, Accounts Receivable, or Accounts Payable should read this tip from Brenda. Besides a good overview of what the integrity reports do, Brenda offers up solid advanced tips based on her years of consulting with JDE clients.  
Size: 140 KB, Version:1.0, Publication Date:3/1/2002
There are legitimate financial reasons to need to see pre-allocation account balances, even after allocations have been run. Learn how to do this in both WorldSoftware and OneWorld.  
Size: 426 KB, Version:1.0, Publication Date:1/1/2002
Blanca is a regular contributor to the Financials department of the JDETips Newsletter. In this White Paper, Blanca presents a handy, easy to follow, checklist of Year End Closing steps.  

Unable to find what you are looking for? Feel free to submit your topic as a potential article via our Request Information form.