We moved LinkedIn:  Follow our new page

Financials

Home → Main Search Page → Financials

"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

   Understanding Allocations Part 3: Advanced Variable Numerator Allocations

By Sarah Gavin  
Size: 1.42 MB, Version:1.0, Publication Date:4/12/2023
In this final of a three-part series, read all about setting up the more complicated Advanced Variable Numerator allocations including those very clever business unit overrides for the various basis ratios.  

   Understanding Allocations Part 2: Indexed Allocations

By Sarah Gavin  
Size: 2.76 MB, Version:1.0, Publication Date:1/11/2023
In this second of a three-part series, Sarah explains in detail the three different types of indexed allocations followed by the set-up of a multi-tiered approach. A definite must read!  

   Understanding Allocations Part 1: Recurring Journal Entries

By Sarah Gavin  
Size: 1.66 MB, Version:1.0, Publication Date:10/10/2022
In this first of a three-part series, Sarah explains in detail the three different types of Recurring Journal Entries, how to set them up, Compute & Print, and finally post. You'll understand the advantages and uses of each type, so you can align them with the specific requirements of your company.  

   9.2 System Integrity Reports Quick Reference Guide, Part 4: Fixed Assets

By Sarah Gavin  
Size: 625 KB, Version:1.0, Publication Date:4/1/2022
Our hugely popular Integrity Reports Quick Reference Guide, newly revised and updated by Sarah Gavin to include the latest 9.2 functionality. This final Part 4 covers Fixed Assets as well as best practice suggestions.  

  Expediting the Batch Approval and Post Process

By Beth Outtrim  
Size: 749 KB, Version:1.0, Publication Date:4/1/2022
Learn about a modification to expedite the approval and posting process for voucher batches. This may be a unique business case, but the core functionality could be quite useful in other situations.  

  9.2 System Integrity Reports Quick Reference Guide, Part 3: Accounts Payable

By Sarah Gavin  
Size: 750 KB, Version:1.0, Publication Date:1/4/2022
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!  

  9.2 System Integrity Reports Quick Reference Guide, Part 2: Accounts Receivable

By Sarah Gavin  
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!  

  9.2 System Integrity Reports Quick Reference Guide, Part 1: General Ledger

By Sarah Gavin  
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.  

  Revenue Recognition Scheduling for Sales Orders

By Thom Blake  
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.  

  Close Early, Close Often - Best Practices for JD Edwards Annual Close Process

By Carla J. Collinge  
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.  

   Relax, It is Just the Financial Integrity Reports

By Jonnel Tenorio  
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.  

   A Guide to Financial AAIs, Part 2 - Accounts Receivable

By Sarah Gavin  
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.  

   A Guide to Financial AAIs, Part 1 - The Fundamental Concepts

By Sarah Gavin  
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.  

   Mapping Old to New: Global Updates for Business Units/Accounts/Subsidiaries

By  
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.  

   Hidden Gems in Financials and Distribution - PowerPoint Presentation

By Klee Associates, Inc.  
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".  

   Making the Transition from U.S. GAAP to IFRS

By Anurag Barua  
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.  

  Creating Intercompany Settlements Invoices and Vouchers for World A9.1

By Bob DeMartino  
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.  

   Integrity Reports Quick Reference

By Mark Zinck  
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.  

   Where Business Units Come From

By Susan Stooksberry  
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?)  

  Changing the Fiscal Date Pattern

By Lina Hadi  
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.  

   GL Subledger Seeking Work Order Master: Soft Joins in World and EnterpriseOne

By Susan Stooksberry  
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.  

  FASTR Conversion Tool - A Cautionary Tale

By Susan Stooksberry  
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.  

  EnterpriseOne 8.9 and 8.10 Financials - Net Changes

By Susan Stooksberry  
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!  

  1099 Processing

By Bob DeMartino  
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!  

  Improving Productivity by Streamlining the Form Tab Sequence

By Susan Stooksberry, Klee Associates  
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.  

  The New Budget Upload Process in OneWorld

By Susan Stooksberry, Klee Associates  
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.  

  Uploading Budgets in JD Edwards

By Randall Foust, CD Group  
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.  

  Using Excel to Create a Journal Entry

By Dan Marsh, Dan Marsh Group  
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.  

   Back to Basics with AAIs

By Blanca Villasenor, SBI  
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.  

   OneWorld and World Financial Integrity Reports

By Brenda Wycoff  
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.  

   Reporting Pre-Allocation Account Balances after Allocations

By Susan Stooksberry, DTI  
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.  

   Year End Financial Close

By Blanca Villasenor, SBI  
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.