Celebrating  25 Years

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

  Interactive Integrities and Updates

By Jennifer Linton  
Size: 5234 KB, Version:1.0, Publication Date:4/4/2025
Ahh yes, the dreaded integrity reports! Or in other words, "S#*t happens!" But at least somewhere along the 9.2 way, Oracle released a new menu, G09221 with some very helpful Interactive Applications to aid you in identifying and clearing up integrity issues. In this article, with her years of experience working in the JDE financial applications, Jenn provides a wealth of information and some great insight to help you with the challenges associated with this task.  

  Unlocking the Mystery of Unapplied Receipts

By Michelle Ennis  
Size: 1.44 MB, Version:1.0, Publication Date:7/8/2024
Ahh yes, unapplied receipts! There is an amazing amount of data involved in something that sounds so straightforward. Understanding not only the flow but the tables that are affected every step of the way is critical. Michelle does a great job of laying it out for us.  

  Finance and Fixed Assets - Tips & Techniques for Reconciliation Issues

By Beth Outtrim  
Size: 688 KB, Version:1.0, Publication Date:4/12/2023
Every year-end requires financial reconciliations of varying degrees, and we love to share new and unique solutions that are available with the increased usability of JD Edwards. Think outside of the proverbial box and you might even consider using Orchestrator to enter and reconcile large amounts of data.  

   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!  

  Demystifying Multicurrency in JD Edwards

By JDEtips, Inc  
Size: 1.16 MB, Version:1.0, Publication Date:10/10/2022
After reading this article, you will fully understand both the accounting requirement for the valuation process and how the process actually works in JDE. After all, reporting unrealized gains and losses are a critical component of your month-end close.  

   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.  

  Lessee Accounting

By Elizabeth Outtrim  
Size: 3.56 MB, Version:1, Publication Date:10/2/2019
Beth explains the implications and steps necessary to become compliant with the new Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) regulations regarding placement of Capital Leases and Operating Leases in your organization's financial statements.  

  Understanding ACA - Part 2, ACA Assignments for Product Group Reporting

By Laurey Godard  
Size: 1.53 MB, Version:1, Publication Date:4/2/2019
Often companies have complex reporting requirements and rely on Excel spreadsheets, third-party reporting tools or a very complex Chart of Accounts. At times, they will use the JDE Allocation tool, but it won't quite meet their needs. The solution to these complex reporting requirements, and the need to get a little more out of the allocation tool, just may be Advanced Cost Accounting. In this article, the second in a series of two, Laurey Godard explains how ACA can help you resolve these challenges.  

  Understanding ACA - Part 1, A Case Study for Product Profitability Reporting

By JDEtips, Inc.  
Size: 2.08 MB, Version:1, Publication Date:1/8/2019
Advanced Cost Accounting is commonly thought of as a Financial tool, but it can be so much more. By using data from JDE modules outside the General Ledger, such as Procurement or Sales, ACA allows JDE to be more than a Financial Accounting tool. This article provides an explanation of the ACA module's capabilities, allowing you to consider your reporting requirements and how you might use the ACA module to meet those requirements.  

  A/P Reconciliation

By Jim Vigeant  
Size: 2.27 MB, Version:1, Publication Date:10/2/2018
The AP 'As Of' date generation file is a critical step when reconciling the AP subledger to the General Ledger. In this article, Jim Vigeant reviews the ins and outs of the 'As Of' date generation file, and then provides helpful tips on what reports are available and how to run them to help you with this important reconciliation.  

  Fixed Assets Transactions and Data Integrity

By Laurey Godard  
Size: 1.88 MB, Version:1, Publication Date:10/2/2018
Maintaining integrity between your Fixed Asset Module and the General Ledger can be a daunting task and is often left out of balance. In this article, Laurey Godard provides ten (plus one!) suggestions on how to keep these two modules reconciled.  

   A Guide to Financial AAIs, Part 3--Accounts Payable

By JDEtips, Inc.  
Size: 2.30 MB, Version:1, Publication Date:7/12/2018
This series of articles explains in detail how the Financial Automatic Accounting Instructions (AAIs) work and describes business examples of how they can be configured. Previous articles in this series provided a basic overview of AAIs, including naming conventions, defaults, search sequences and best practices. General Ledger and Accounts Receivable AAIs were covered in depth. In this article, Sarah Gavin explains how to use and set up the Accounts Payable AAIs. Future articles will cover Fixed Asset and Multicurrency AAIs.  

  Alternate Chart of Accounts--COA APPENDICES

By JDEtips, Inc.  
Size: 1.28 MB, Version:1, Publication Date:7/12/2018
This document includes Appendices A, B, and C as discussed in the article, "Alternate Chart of Accounts, Setting Up a COA for Governmental Reporting," by Beth Outtrim.  

  Alternate Chart of Accounts--Setting up a COA for Governmental Reporting

By JDEtips, Inc.  
Size: 1.58 MB, Version:1, Publication Date:7/12/2018
All organizations have a need for financial reporting and regulatory reporting. Depending on the size of your organization, these reporting structures can be quite complex, at times even requiring an alternate chart of accounts for international reporting. This article explains how you can use category codes on the Account Master and the existing functionality within JD Edwards to help simplify international reporting requirements.  

  JDE Multi-Currency Overview and Modifications

By Beth Outtrim  
Size: 2.54 MB, Version:1, Publication Date:4/4/2018
Take a journey through the land of Balance Restatement vs Detailed Restatement. This article will guide you through the decision process and setup required to arrive at accurate restatement.  

  AP Scanning -- Vendor Options and Processes

By Lisa Tran  
Size: 1.5 MB, Version:1, Publication Date:1/9/2018
In very general terms, AP scanning lets you automate the processing of incoming invoices by automatically capturing data, putting the data into the appropriate fields in JDE, processing voucher matching, and posting the associated transactions while at the same time storing the documents electronically and allowing for streamlined approval processes. Most systems are capable of handling various types of invoice processing including non-purchase order based expenses, two-way and three-way voucher matching to purchase orders. This article first goes over the AP process in general terms and then explains in detail about the different types of products.  

   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.  

   Revenue and Profit Recognition Updates

By Beth Outtrim  
Size: 4.03 MB, Version:1, Publication Date:1/9/2018
In 2016 we published two articles by Beth Outtrim on the subject of Revenue Recognition. This article now brings us the extensive updates and improvements to the application that Oracle has provided since those articles were written.  

   Global Updates

By Beth Outtrim  
Size: 3.66 MB, Version:1, Publication Date:10/3/2017
This is a start-to-finish guide for configuring and running Global Updates in your Financials, from Changing Business Units to Calculating Fiscal Year. This is a topic for which we have long been receiving requests, so we are happy to deliver this to you.  

  How to Configure and Process Web Payments in JDE

By Kris Olson  
Size: 2.96 MB, Version:1, Publication Date:10/3/2017
Many utility providers do not accept EFT (Electronic Funds Transfer) payments because of the difficulties involved in trying to match payments received to the correct customer accounts, so Web Payments are the alternative, as explained in detail in this article. This solution is specific to a particular Canadian banking provider and Canadian utility companies; however, Kris believes the approach or something similar could be applicable in many other countries.  

   Life Cycle Controls, Part 3 - Accounts

By Laurey Godard  
Size: 2.94 MB, Version:1, Publication Date:10/3/2017
This article focuses on Accounts and is the last in a three-part series describing JD Edwards tools and best practices for making maintenance of GL master data (companies, business units, and accounts) slightly less painful.  

   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.  

   Life Cycle Controls, Part 2 - Business Units and Jobs

By Laurey Godard  
Size: 1.03 MB, Version:1, Publication Date:7/19/2017
This article focuses on Business Units and Jobs, and is part two in a series of three articles describing JDE tools and best practices for making maintenance of GL master data (companies, business units, and accounts) slightly less painful.  

   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.  

   Life Cycle Controls, Part 1 - Companies

By Laurey Godard  
Size: 1.02 MB, Version:1, Publication Date:3/28/2017
This article focuses on the Life Cycle of JDE Companies, and is one of a series of three articles describing JDE tools and best practices for making maintenance of GL master data (companies, business units, and accounts) slightly less painful.  

  Automatic Intercompany Settlement Part 2

By Sarah Gavin  
Size: 1.95 MB, Version:1.0, Publication Date:10/3/2016
In her previous article, 'Automatic Intercompany Settlement Part 1', Sarah discussed the first two Automatic Intercompany Settlement methods - Hub and Detailed. In this Part 2, Sarah covers the Configured Hub method, also providing an overview , sample business cases, transaction examples, and multicurrency considerations. She additionally discusses a 'gotcha' with this method that existed in earlier releases of EnterpriseOne. Finally, Sarah concludes the article and this two-part series with a discussion about the considerations for changing the Automatic Intercompany Settlement method post go live.  

  Automatic Intercompany Settlement Part 2

By Sarah Gavin  
Size: 1.95 MB, Version:1.0, Publication Date:10/3/2016
In her previous article, 'Automatic Intercompany Settlement Part 1', Sarah discussed the first two Automatic Intercompany Settlement methods - Hub and Detailed. In this Part 2, Sarah covers the Configured Hub method, also providing an overview, sample business cases, transaction examples, and multicurrency considerations. She additionally discusses a 'gotcha' with this method that existed in earlier releases of EnterpriseOne. Finally, Sarah concludes the article and this two-part series with a discussion about the considerations for changing the Automatic Intercompany Settlement method post go live.  

  How to Configure Automatic Bank Reconciliation

By Kris Olson  
Size: 3.27 MB, Version:1.0, Publication Date:10/3/2016
Auto Bank Reconciliation has been available since release 8.11, but has not been widely implemented. This article offers an overview of the functionality that currently exists in 9.2, which has not changed greatly since 8.11. It provides an overview of the process, including what it does and does not do, then details the setup steps and walks us through the process soup to nuts.  

  Revenue Recognition Part 2 - Contract and Service Billing Invoices

By Elizabeth Outtrim  
Size: 4.35 MB, Version:1.0, Publication Date:10/3/2016
This article is the follow up to Part 1 that discussed the setup and processing for Accounts Receivable Invoices and Sales Order Invoices. In this article, we will lay out the details necessary for Contract and Service Billing Invoices as well as updating information in Oracle's July updates for Accounts Receivable in 9.2 not yet published for Part 1.  

  Revenue Recognition Part 1 - AR Invoices and SO Invoices

By Beth Outtrim, Smartbridge  
Size: 4.41 MB, Version:1.0, Publication Date:7/5/2016
With E1 9.2, Oracle has provided some new functionality to address the evolution of regulations regarding the point at which revenue can be recognized. This article covers the functionality regarding Accounts Receivable and Sales Order invoicing. A follow-up article will address Contract and Service Billing invoicing.  

  Variable Numerator Allocation Functionality

By Kris Olson, City of Brantford  
Size: 1.95 MB, Version:1.0, Publication Date:7/5/2016
As of E1 9.0, there is a new method for configuring and using Variable Numerator Allocations. This article steps through the process of creating Advanced Variable Numerator Allocations, then offers a couple of variations on the theme; i.e., using business unit overrides, and using different basis ratio methods. All of this functionality saves untold time in manual processes  

  Automatic Intercompany Settlement Part 1

By Sarah Gavin  
Size: 1.43 MB, Version:1.0, Publication Date:3/30/2016
In this first of a two-part series on General Accounting Automatic Intercompany settlement, Sarah will walk through the automatic intercompany settlement methods Hub and Detail, explaining in detail how these different methods work, and how you would use them in your organization. In part two, Sarah will delve into the Configured Hub method.  

  Automatic Intercompany Settlement Part 1

By Sarah Gavin  
Size: 1.43 MB, Version:1.0, Publication Date:3/30/2016
In this first of a two-part series on General Accounting Automatic Intercompany settlement, Sarah will walk through the automatic intercompany settlement methods Hub and Detail, explaining in detail how these different methods work, and how you would use them in your organization. In part two, Sarah will delve into the Configured Hub method.  

   Planning and Executing a Chart of Accounts Conversion Pt 2

By Kris Olson  
Size: 958 KB, Version:1.0, Publication Date:6/26/2015
The first article in this series gave you many things to consider when planning for and structuring a CoA project. The initial planning stage is of critical importance to the success of your project and the thought and energy you invest at this stage will pay off many times over during the design and implementation stages. This second article focuses on CoA design, account mapping, and discusses various issues that are typically encountered during the technical conversion of the CoA. It finishes with a discussion of strategies for testing and training, then some thoughts on what to expect after go-live.  

   Planning and Executing a Chart of Accounts Conversion Pt 1

By Kris Olson  
Size: 676 KB, Version:1.0, Publication Date:4/1/2015
Eat Dessert First! Or, in this case, design your reports first. But even before that, there is a lot of planning to be done before you dig into a CoA conversion project. This very thorough article is Part 1 of 2, and it illustrates and explains where all the stones are that need to be turned over and inspected. Some project planning guidelines, things to consider when you analyze your current CoA, then some design principles for the new one.  

  EnterpriseOne 9.1 Forecasting and Planning Part 2

By Lea Dutton  
Size: 2.78 MB, Version:1.0, Publication Date:9/29/2014
In this second of a two-part series on Financials Forecasting and Planning, we generate and revise forecasts and then apply them to an account balance ledger. Part I covered steps one through four in Figure 2 below.  

  EnterpriseOne 9.1 Forecasting and Planning Part I

By Lea Dutton  
Size: 4.36 MB, Version:1.0, Publication Date:7/1/2014
In this first of a two-part series on Financials Forecasting and Planning, we walk through the processes of defining Growth Patterns and assigning them to Business Units, then show you how to build Basis Accounts and Balances, then revise and lock Forecast Basis. Part 2 will delve into the forecasting process.  

  Subcontract Management

By Ross Copeland  
Size: 812 KB, Version:1.0, Publication Date:3/6/2014
In this article, Ross Copeland presents a solid business case for using Subcontract Management, then provides a demonstration through setup instructions, screen shots, and other illustrations to walk us through the process from contract through completion. You will see how to process holdbacks and holdback releases, and how to handle tax requirements along the way.  
Have you ever seen a system hiccup in the Accounts Payable (A/P) module of JD Edwards? By a system hiccup, we are referring to an incomplete update of the database tables for an action the system user has performed correctly in JDE. If you have experienced one or more consistent A/P hiccups, this article will assist you in smoothing things out going forward. If you have never experienced any hiccups in Accounts Payable, maybe you can leverage this strategy as a solution for other JDE system modules if updates do not occur correctly.  

   Accruing Accounts Payable

By Robert M. DeMartino - Consultant  
Size: 932 Kb, Version:1.0, Publication Date:9/27/2013
Bob shows us two methods of accruing expenses, the Journal Entry method and the Accounts Payable method. Read on for step by step directions and results for both methods, and more.  

  How to Correct Fixed Assets Integrity Errors

By Bob DeMartino  
Size: 900KB, Version:1.0, Publication Date:2/12/2013
Chasing down Fixed Assets integrity issues takes a two-sided approach. There are two reports involved - Fixed Assets to G/L, and G/L to Fixed Assets. Running both of these reports will give you the whole picture. This article will walk you through the process of running these reports and show you what to look for on them  

   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.  

   JDEtips Training Manual Sample - Fixed Assets

By Bob DeMartino  
Size: 582 KB, Version:1, Publication Date:7/21/2011
Get a quick overview of Fixed Assets Entry with a chapter from our Fixed Assets Training Manual.  

   Multi Country Implementation Strategies - Video Recording

By Klee Associates, Inc.  
Size: 33.8 MB, Version:1.0, Publication Date:5/24/2011
Zip file for the May 24th, 2011 JDEtips Multi Country Implementation Strategies Webucation event recording. Please note--this is an MP4 file. You may need to update your video player or download Apple's QuickTime video player to view.  

   Multi Country Implementation Strategies - Webucation PowerPoint

By Klee Associates, Inc.  
Size: 5.3 MB, Version:1.0, Publication Date:5/24/2011
PowerPoint presentation from the JDEtips Webucation event on May 24th, 2011. Doing a multi-country rollout of JD Edwards can be a massive undertaking. Will you use a centralized or decentralized approach? How will you get a grip on the legal/tax requirements, localizations, and cultural differences in each country? All while trying to meet your implementation schedule and project budget. Learn from Steltix, a European-based Oracle Platinum Partner, with over 15 years experience running multi-country rollouts of JDE. We'll cover best practices, a proven methodology, and hard won tips--specially designed for JDE clients involved with multi-country implementations.  

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

   JDEtips Training Manual Sample: Overview of Procure to Pay

By Bob DeMartino  
Size: 564 kb, Version:1, Publication Date:12/22/2010
Get a quick overview of Procure to Pay with a chapter from our Accounts Payable Training Manual.  

   JDEtips Training Manual Sample - Indexed Allocations

By Stephen Kuemper  
Size: 341 KB, Version:1, Publication Date:10/28/2010
Get a quick primer on Indexed Allocations with a chapter from our General Ledger Training Manual.  

  Accounts Receivable Deduction Management

By Susan Stooksberry  
Size: 2 Mb, Version:1.0, Publication Date:8/31/2010
Short pays becoming a way of life for your Accounts Receivable team? You're not alone...it's a growing problem and one that can be managed in EnterpriseOne with the help of Accounts Receivable Deduction Management. Susan Stooksberry demonstrates how you can use this functionality to better manage those partially-paid invoices. In this article, you'll find an overview of this solution, examples of when you'll want to use it, and the setup steps to put it to work with your A/R application.  

   Creating Depreciation Projections

By Bob DeMartino  
Size: 450KB, Version:1.0, Publication Date:8/31/2010
A good budget analyst knows that all expenses need to be considered; and that includes depreciation expense. There happens to be a program in JDE (R12865) that will help you calculate your Depreciation Projections. This article takes us through the preparation,the depreciation computation, the projection calculation, and final steps to get the projections into your budget, and helps you understand the results.  

   Budget Scenarios Using Indexed Computations and User-Defined Ledger Types

By Sarah Mills  
Size: 702 KB, Version:1, Publication Date:6/29/2010
Budgets change year after year, but that doesn't mean you need to reinvent the wheel each time. Sarah Mills demonstrates how you can use standard functionality found in JDE Financials to roll amounts forward year after year and adjust according to the upcoming year's budget. In this article, she'll cover Ledger Types, Indexed Computations, and Allocations, then ties it all together with an example of a budget rolled forward with an increase.  

   Using Bank Reconciliation to Reconcile Other Types of Accounts

By Susan Stooksberry  
Size: 955 KB, Version:1, Publication Date:6/29/2010
In a previous article, Susan Stooksberry demonstrated how to reconcile the Received Not Vouchered account using Excel Macros. In this article, she presents another option for reconciling this account, as well as other types of accounts, using the JDE Bank Account Reconciliation process. Focusing on the RNV account, and using the JDE Manual Account Reconciliation program, Susan steps us through this process, including options for reconciling vs. unreconciling, and using this in combination with Excel Macros.  

   Using Excel Macros to Reconcile the Received-Not-Vouchered Liability Account

By Susan Stooksberry  
Size: 1.38 KB, Version:1, Publication Date:4/30/2010
Looking for a simpler way to reconcile your received-not-vouchered liability account? If you're familiar with Excel and standard JDE Account Reconciliation, we have a solution for you. Susan Stooksberry demonstrates how Excel macros can be used to determine which General Ledger transactions are resulting in open balances. Added bonus: She's included an Excel spreadsheet that includes the macros discussed in the article so you can get started right away.  

  Change Management and Job Cost Budgets

By Bob DeMartino  
Size: 970 KB, Version:1, Publication Date:2/10/2010
We all know that any project is subject to changes throughout its lifecycle. And those changes need to be made, approved, and tracked so that they provide a detailed audit trail. Fortunately, we have people, like Bob DeMartino, who can provide us with an approach to track such changes using the Change Management module. Bob steps us through what this module is capable of and how it can be applied to Job Cost budgets, including a sample scenario to illustrate the effectiveness of this approach.  

  Interoperability Lite - Importing Fixed Assets from Excel

By Betty Townsend and Susan Stooksberry  
Size: 1.11 MB, Version:1, Publication Date:5/11/2009
Fixed Assets interoperability in EnterpriseOne works well, provided you have fat client access and lots of IT support. But even if you do, it's easier to use Excel to import fixed assets into JDE, according to Susan Stooksberry and Betty Townsend. As a bonus, they've also included an Excel spreadsheet template; you can download this zip-file separately (Interoperability Lite - Importing Fixed Assets from Excel.zip)  
As a bonus from our "Interoperability Lite - Importing Fixed Assets from Excel" article, here is the spreadsheet template discussed in the article for you to use for your own Fixed Asset imports.  

   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.  

  Budget Forecast Setup and Processing EnterpriseOne Versions 8.10 and Up

By Bob DeMartino  
Size: 1.24 MB, Version:1, Publication Date:11/11/2008
You asked, and Bob delivered. We recently received feedback about the need for more content on Budgeting in the JDEtips General Ledger class. Bob DeMartino takes us on a tour of the new budget forecasting feature available in EnterpriseOne Versions 8.10 and higher, including the setup, steps to generate a forecast, and its application to the Budget Ledger. Along the way, he'll discuss how to create "what if" scenarios using different revision numbers, and much more to help you get a better grasp on the big budget picture.  

  How to Re-Scale a Foreign Currency and Get Away with It

By Tim Ene  
Size: 782 KB, Version:1, Publication Date:9/17/2008
At JDEtips, we love a good can-do story. It's always great to hear about a problem solved by ingenuity, by a team that stepped outside the box and decided to "Think JDE". This case study, shared by Tim Ene, is one of those stories. Tim describes how he and his team solved a real "pickle" of a problem for a multi-national company faced with trying to convert years of peso transactions after Mexico revalued their currency and changed the definition from a whole unit calculation to a two-decimal system. Their unique approach offers learning lessons for any company faced with a similar scenario in a global economy.  

  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.  

   Project Reporting - Job Cost vs Work Orders and Subledgers - What to Consider

By Hartley Farmer  
Size: 144 KB, Version:1.0, Publication Date:7/10/2008
Job Cost vs. Work Orders? Which of these methods is most likely to meet your project's reporting needs? To help you sort out the best solution, Hartley Farmer provides an overview of both methods, then lists the decision points you'll need to consider before you select. So whether your project is very large or very small, this article will help you determine which is right for you.  

   Multi Currency Tips

By Ravi Adhi with Lina Hadi  
Size: 1.01 MB, Version:1, Publication Date:6/2/2008
From a session at Collaborate 08, we'll show you how to eliminating Inter-company balances and reconciling A/R in the "AC" Ledger. We go on to explain of a few basic concepts, the "big picture", and detail steps with screen shots.  

   Received Not Vouchered: Discover Hidden Incremental Profits

By Nadine Alexander  
Size: 439 KB, Version:1, Publication Date:6/2/2008
It's not somewhere that you would necessarily think to look, but there are most likely some hidden, incremental profits in your balance sheet that could result in anything from a few extra dollars to millions in "found" money. The key here is to understand what's in the Received Not Vouchered General Ledger account. Nadine Alexander demonstrates her "treasure hunting" techniques for bringing to light those hidden dollars; the end results could ultimately make a difference in your bottom line.  

  Tips on A/R and A/P Netting in EnterpriseOne

By Bob DeMartino with Jolynne Whitney  
Size: 439 KB, Version:1, Publication Date:6/2/2008
Session # 35800 from Collaborate 08.  

  Expense Management: An Overview

By Dipesh Mandalia  
Size: 1.06 MB, Version:1, Publication Date:4/4/2008
Whether it's travelling to a meeting, dinner with a client, or home office expenses,every company has to account for a certain amount of employee expenditure--which equals the dreaded "expense report". It's a time-consuming process if done manually. Of course, the Expense Management module in JD Edwards can make it so much more efficient--and by that we mean automated. If you haven't discovered this functionality, let Dipesh Mandalia take you on a tour.  

   Order to Cash Overview

By Julie McNight  
Size: 1.21 MB, Version:1, Publication Date:2/6/2008
You're in the A/R department at your company, and you see Invoices coming over from the Sales Order system. You'd like to know more about how Sales generates Invoices, and the interface between A/R and Sales, but you can't spare a few days to attend a Sales Order class. What do you do? How about reading this white paper (written in "training manual" style)? Then you'll be ready to amaze your co-workers, and perhaps even explain A/R to the Sales Order folks.  

   Automated Cash Receipts Setup and Processing

By Bob DeMartino  
Size: 619 KB, Version:1, Publication Date:10/16/2007
You ship 'em, you bill 'em, they pay 'em (hopefully). That's the cycle of commerce. Where it gets to be "fun" is when you have multiple receipts coming to pay multiple invoices per customer. Can anyone say "match game?" Bob DeMartino, our Financials Expert, can help you make ease of this task--he takes us step by step through the setup and processing of Automated Cash Receipts so that JD Edwards (and not you) can match the correct payment to the invoice and keep your customer records accurate!  
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.  
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.  

   Automatic Intercompany Revaluation/Elimination

By Susan Stooksberry  
Size: 621KB, Version:1.0, Publication Date:1/28/2007
Ah, the joy of multi-currency (said tongue-in-check). Can there be an easier way to balance inter-company accounts? How about restating and revaluing them in a common currency for elimination? Susan Stooksberry offers up a GREAT workaround using "Post Balances by Currency" that takes some of the "fun" out of balancing inter-company accounts.  

   Account Reconciliation from the CA Ledger

By Susan Stooksberry  
Size: 971KB, Version:1.0, Publication Date:11/23/2006
A reconciliation tip just for end of year accounting "fun" (we use that term loosely). If you're a company dealing with multicurrency, and wish to view the transactions in the payment currency rather than base currency when reconciling a monetary account, this must read tip is as sweet as the icing on a gingerbread house! Enjoy!  

   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.  

  How to Set Up A/R Credit and Collection Work Centers and Workflow Messaging

By Mark Zinck  
Size: 1.3MB, Version:1.0, Publication Date:9/21/2006
Credit and collection departments already have a tough job: determining who's a bad or a good credit risk is a science unto itself. It's one that takes good departmental coordination, good information, to make a decision that, if wrong in either direction, can have a negative impact on a company. But, things are getting easier from an EnterpriseOne perspective. Mark Zinck joins us for the first time to highlight a workflow feature for Credit and Collection that sends the message, literally, about a given customer's credit risk, thus making that difficult job a tad easier.  

  How to Set Up A/R Credit and Collection Work Centers and Workflow Messaging

By Mark Zinck  
Size: 1.3MB, Version:1.0, Publication Date:9/21/2006
Credit and collection departments already have a tough job: determining who's a bad or a good credit risk is a science unto itself. It's one that takes good departmental coordination, good information, to make a decision that, if wrong in either direction, can have a negative impact on a company. But, things are getting easier from an EnterpriseOne perspective. Mark Zinck joins us for the first time to highlight a workflow feature for Credit and Collection that sends the message, literally, about a given customer's credit risk, thus making that difficult job a tad easier.  

   Profit Recognition with Costs Charged Directly to Profit and Loss Account

By Richard Berry  
Size: 288KB, Version:1.0, Publication Date:9/21/2006
When Richard Berry first wrote about Profit Recognition, he gave us a detailed view from the "normal" setup, which included charging project costs to the Balance Sheet. But for some users--"normal" just wasn't going to cut it; they needed a way to charge directly to the Income Statement. So, Richard's back, this time to compare both methods, and the when and where you'll want to use the "alternative" method.  

  Accounts Receivable Statement Processing with Added Flexibility

By Jeanne Robbins  
Size: 483KB, Version:1.0, Publication Date:7/18/2006
We used to take for granted those detailed monthly statements highlighting our account history, payment plans, etc. Not any more. It's no longer as easy as filling the paper bin in the printer and hitting the print button. With all the options offered by EnterpriseOne, there's a science to setting up and processing statements. Jeanne Robbins takes us through the various options and setup procedures so that statements sail out the door, with at least a little more ease.  

   Job Cost Projections

By Richard Berry  
Size: 642KB, Version:1.0, Publication Date:5/20/2006
The Job Cost module generates projections automatically and dynamically. Projections are required for profit recognition; actual amounts are compared with projections to compute percent complete at the detail Job chart line and also for the Job as a whole. But projections can also be used as valuable management information. In this article, Richard explains in detail, using practical examples and illustrations, how the various methods of computation work and the situations in which they might be used.  

   Reconciling Fixed Assets

By Bob DeMartino  
Size: 1mg, Version:1.0, Publication Date:5/20/2006
In the world of Sox, integrity issues, especially with Fixed Assets, can certainly pose a serious problem. And there is not exactly an obvious auto-correct within this application. Fortunately, we have Bob Demartino to thoroughly take us through the steps needed to research and correct any Fixed Assets integrity issues (and keep the auditors at bay! (NOTE – while this article was written using EnterpriseOne, the functionality is the same in World.  

  A Technical Approach to Implementing A/P Wire Transfers for World

By Paul Hanson  
Size: 402kb, Version:1.0, Publication Date:3/25/2006
Save money by changing the way you spend it. This article describes the process for working with your bank to complete automated payments so you don't have to spend your time (and money) printing paper checks and mailing them. This article should help you get on your way along the road to that Utopian paperless society we hear so much about. For EnterpriseOne users, please refer to "A Technical Approach to Implementing A/P Wire Transfers", in the Accounts Payable Category.  

   Integrated AR Purge

By Jeanne Robbins  
Size: 160 KB, Version:1.0, Publication Date:3/25/2006
Phantom Receipts. Nobody wants them. Everybody's got them. But guess what? You really don't have to live like that. At least, not if your phantoms are the result of purges gone awry. This article explains how these can come into existence, then gives us some great pointers to modify your purge programs to nip this problem in the bud.  

   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?)  

   Consolidations

By Stephen Kuemper  
Size: 754KB, Version:1.0, Publication Date:1/19/2006
Consolidations are pretty much a fact of life in today's market, where mergers and buy-outs are the name of the game. This white paper explores two methods of consolidating financials through JD Edwards - both for smaller organizations and larger ones. Steve gives step-by-step instructions for both scenarios. Learn more about this and other GL functionality in the JDEtips General Ledger class - this paper will give you a taste of the details included in this class.  

   Discerning G/L Dates Within Unposted Batches - Crystal Ball or Custom Report?

By Susan Stooksberry  
Size: 979KB, Version:1.0, Publication Date:1/19/2006
The JDE standard reports are a powerful tool. But sometimes you need just that one thing extra - something to ensure your integrity and help reflect your reality. One example is the standard unposted batches report, which shows the batch date, but not the GL date of the transactions. What to do? Susan Stooksberry once again comes to our rescue with a full description of the problem - and why it's a problem - along with the full solution. Look for some great "tips" along the way.  

   Reconciling Vertex Register with the General Ledger

By Morley Fulgencio  
Size: 904KB, Version:1.0, Publication Date:11/10/2005
We've waited five years for someone to come along and explain Vertex to our audience. This is an excellent introduction to using Vertex with JD Edwards Sales Order Management. Going beyond the setup and execution, Morley also explains how to use Flex Accounting to easily reconcile the Vertex generated amounts--before those all-important state tax filings.  

  Special Voucher Matching Processes

By Bob DeMartino  
Size: 807KB, Version:1.0, Publication Date:11/10/2005
This white paper is a sample chapter of the JDEtips Mastery Level Accounts Payable Workshop, to be introduced in March 2006 as a public course. Please see our full course listing for the JDEtips Workshops and an outline of this outstanding Mastery Level course. Please inquire about its availability as a custom course.  

   Do You Want Receipt Routing with That Third Currency?

By Susan Stooksberry  
Size: 1180KB, Version:1.0, Publication Date:9/10/2005
If you use the JDEtips Document Library search engine and enter "Receipt Routing" as your key word, you'll find that we've covered both the basics and the advanced aspects of this subject. But here's something we'll bet nobody anywhere has written about before! Susan Stooksberry has educated our readers in the past about the intricacies of multi-currency, but this time she's outdone herself. She takes us through the process of adding a third currency to an existing receipt routing scenario.  

  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.  

   Sarbanes-Oxley Compliance - A Round-Table with Four Compliance Experts

By Jon Reed, Klee Associates  
Size: 186KB, Version:1.0, Publication Date:5/18/2005
An interview with David Ashley, Quaker Chemical Q1W Core Team Member, JDE SOX specialist Nadine Alexander, SAP Technical Compliance Manager Ken Asher, and SAP-HR Compliance Manager Greg Robinette. This round-table discussion spans the technology and logistics of accomplishing SOX compliance. We think you will both learn from and enjoy the thoughts put forth here.  

   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.  

   Voucher Logging with Multiple Voucher Types

By Jan Stas  
Size: 1233KB, Version:1.0, Publication Date:5/6/2005
The who, what, why, when, and where of Voucher Logging. This article presents a complex business scenario with multiple business branches where each branch needed its own set of voucher numbers. Even in a less complex business environment, this article can be a great handbook to walk you through your decision of whether to use Voucher Logging and then how to get it going. Jan shows us how to set up and implement this solution without any modifications to the system. And you don't need to be a "techie" to understand it!  

   Segregation of Duties to Comply with Sarbanes-Oxley

By Laura Jackson  
Size: 243KB, Version:1.0, Publication Date:3/20/2005
Laura Jackson reports on her recent engagement with Hamilton Sundstrand to identify employees who have access to programs that create a potential conflict of interest. For example, an employee should not be able to enter a voucher and cut a check. The project covered Financials, Distribution, and Manufacturing, and used a combination of technical and non-technical methods of discovery and analysis. Hamilton Sundstrand agreed to let Laura share the discovery process with our readers.  

  Automated Cash Application

By Roger Avrit with Bob Demartino  
Size: 6310KB, Version:1.0, Publication Date:3/14/2005
The order to cash process can generate large volumes of invoices--at least we all hope so! That in turn requires a fast, efficient method of applying receipts of cash to open invoices. This requires some method of collecting and depositing cash receipts in a central location and importing that information into the A/R system. This article explains how to do auto-cash application with and without lockbox processing.  

   Job Cost - Profit Recognition

By Richard Berry  
Size: 482KB, Version:1.0, Publication Date:3/14/2005
Continuing his series on Job Costing, Richard tackles the subject of Profit Recognition. The subject is broken down into sections covering accounting principles and legal requirements, the concepts that lie behind the PeopleSoft approach (whether you like their approach or not), the setup required, and the month-end profit recognition process.  

  Closing the Gap with a Bank Reconciliation Interface

By Paul Hanson  
Size: 510KB, Version:1.0, Publication Date:3/11/2005
In prior issues of JDEtips, Paul Hanson has written about the Positive Pay Interface and A/P Wire Transfer Interface. This gets the bills paid in the first place. Now, he wraps up this thread by showing us how to bring the data back in from the bank for an automated check reconciliation. It doesn't take that much tweaking once you get straight with the bank and get the ball rolling. You can use the JDEtips Document Library Search Engine to locate "Developing a Positive Pay Interface" and "A Technical Approach to Implementing A/P Wire Transfers".  

  A Technical Approach to Implementing A/P Wire Transfers

By Paul Hanson  
Size: 369KB, Version:1.0, Publication Date:1/11/2005
Save money by changing the way you spend it. This article describes the process for working with your bank to complete automated payments so you don't have to spend your time (and money) printing paper checks and mailing them. The features described here are built in to your EnterpriseOne software, but there are still some chores you have to do to make it work for you.  

  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.  

   Job Cost - Chart of Accounts Design

By Richard Berry  
Size: 366KB, Version:1.0, Publication Date:1/11/2005
Although this subject may seem basic, it is one of those areas where many Job Cost users struggle. The concept of chart of accounts design may seem straightforward at first sight, but the PeopleSoft Job Cost module is capable of great sophistication. The Job Chart is the heart of the system and it is critical to get it right. There are many acceptable alternatives, but he main objective is to design a chart that will quickly display critical cost management information and be sufficiently succinct.  

   Re-Opening G/L Periods During the Month-End Close Process

By Lorin Schultz  
Size: 815KB, Version:1.0, Publication Date:1/11/2005
Yes, you CAN be in two places at once, and first-time contributor Lorin Schultz proves it! Using the technique described in this article, you can set up one or more users in such a way that they can continue to make adjustments to a prior period while the rest of the team marches forward into the next. While the primary focus of this article is on EnterpriseOne, we have also included some notes for World.  

  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!  

   Introduction to Project Costing

By Richard Berry  
Size: 316KB, Version:1.0, Publication Date:9/15/2004
This is the first of a series on Project Costing. In this article, you will learn about more than just the software. The approach is to present the concepts and business requirements surrounding Job Costing, then to explain how these are addressed by PeopleSoft EnterpriseOne. Whether you already use Job Costing or are just now considering its implementation, be sure that you will learn plenty from this installment.  

   Challenges and Advantages in Meeting Sarbanes-Oxley Compliance

By David Ashley, CISA, CISM  
Size: 324KB, Version:1, Publication Date:9/5/2004
It isn't all that hard to find information about Sarbanes-Oxley. Do a Web search, and stand back! You could be overwhelmed. David Ashley has been there and done that and survived to tell about it. In this article, he does just that - he boils much of the legalese into language we can digest and gives us advice and pointers for beginning our own compliance efforts - all based on his personal experience in "SOX" compliance projects.  

  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!  

   Activating Multicurrency after Go-Live - Overview

By Susan Stooksberry, Klee Associates  
Size: 217KB, Version:1.0, Publication Date:7/15/2004
Susan Stooksberry wants to make it perfectly clear to us that moving to multicurrency is not a thing to be taken lightly. In this article, she gives us the background to plan ahead before taking this "fork in the road", as she puts it. Lots to think about, and Susan gets us started here, then fills in the blanks in her detailed article, Activating Multicurrency After Go-Live: Details, which is available in the JDEtips Document Library.  

   Employee Time Entry with Equipment

By Richard Berry  
Size: 541KB, Version:1.0, Publication Date:7/15/2004
In this article, Richard fills in with the details on time entry with equipment. An employee may spend time on a job using one or more pieces of the company's equipment, perhaps for testing, repair, or construction purposes. The time entry module allows both the employee's own time and the equipment time to be entered using the same screen.  

   Restating Budget Balances into Another Currency

By Richard Berry, Klee Associates, Inc.  
Size: 1330KB, Version:1.0, Publication Date:7/15/2004
The uncommon denominator! Richard Berry explains why and how a company doing business in multiple currencies may want to restate their budget as well as their actuals into another currency. This offers step-by-step instructions with tips along the way and shows you how to interpret the results.  

   Activating Multicurrency after Go-Live - Details

By Susan Stooksberry, Klee Associates  
Size: 5454KB, Version:, Publication Date:7/14/2004
This in-depth article goes into the details of implementing multicurrency after you have already gone live without multicurrency turned on. When you change your mind - or your business practices - so do the rules for implementation. Susan provides a step-by-step instructional piece, with tips and gotchas along the way.  

   Turning Off Multi-Currency

By Susan Stooksberry, DTI  
Size: 364 KB, Version:1, Publication Date:5/5/2004
We all "know" that everyone should just turn on multi-currency and leave it on, even if you do not have any international customers or vendors now. Right? Well, not so fast! Susan has found valid reasons why it should never have been turned on. But her client has already turned in on and now, needs it turned off. Easy? No! Doable? Yes, with the advice in this excellent article.  

   AR to Account Balance by Account ID Integrity - R03B707

By Sharon Steiner  
Size: 413 KB, Version:1.0, Publication Date:5/1/2004
It's one thing to know how to fire off an integrity report – it is another matter entirely to understand how to get the report to give you what you really need. In this case, "Where do I have an integrity problem, and how to I chase down its source?" Sharon Steiner shows us step by step how to set your processing options, then how to follow the report results back to the source.  

   Standalone Employee Time Entry

By Richard Berry  
Size: 1.3 MB, Version:1.0, Publication Date:5/1/2004
Many customers might use this module if they knew that they had it. There was a time when JDE used to deliver Standalone Time Entry along with the Project Management suite. Many clients actually have the software but do not realize it. If they know they have it, it may not be very clear what the module is actually supposed to do and how it can help them. Richard Berry takes the mystery out of this useful tool and shows you how to put it to work in your environment.  
Susan Stooksberry presents an outstanding review of the ins and outs of managing overpayments and underpayments in Accounts Receivable. This is a must-read if you are currently spending too much time and effort either chasing after or manually writing off minor amounts owed.  

   Principles of Software Validation and 21 CFR Part 11 Compliance

By Dan Bolland and Justin Miller  
Size: 211 KB, Version:1.0, Publication Date:3/1/2004
This article addresses the ever-increasing requirements for accountability in our enterprise applications. Daniel and Justin discuss the regulations for both automated and manual procedures and give us an introduction to the mechanics of EnterpriseOne's Audit Management features. Food for thought - This EnterpriseOne feature is useful to meet Sarbanes-Oxley requirements. For that matter,the audit functionality is useful to serve standard audit practices that existed prior to all the recent legislation. While this article addresses the audit functionality in EnterpriseOne, it should also be noted that there is an equivalent audit feature for World users.  

   Treasury Management

By Richard Berry, Klee Associates  
Size: 180 KB, Version:1.0, Publication Date:3/1/2004
This article could save you countless heartaches! Are you about to acquire third party treasury software? Have you really considered the alternatives within EnterpriseOne and World? Richard Berry has experienced this question from both angles - with and without specialized software. Richard presents an analysis of 14 areas of treasury operations and for each area, points out where your existing software investment can be leveraged as a treasury management tool.  

   Advanced Cost Accounting

By Susan Stooksberry, Klee Associates  
Size: 3.0 MB, Version:1.0, Publication Date:1/1/2004
Ever wish you could really analyze your customer and product line profitability? Ever want to allocate indirect costs such as Admin and Marketing to customers, product lines, or sales marketing channels automatically, based on a driver that makes sense, such as number of lines on sales orders? Ever wish you could do this without putting an incredible amount of detail into your General Ledger? In her Advanced Cost Accounting article, Susan Stooksberry shows us how to attain both of these goals through existing JD Edwards functionality. Not only that, but she shows us in a clear and very readable style, from setup through reporting and online views.  

   EFT Processing in Accounts Payable - A Voyage of Discovery

By Rita Nygren, Erdman  
Size: 190 KB, Version:1.0, Publication Date:1/1/2004
Rita Nygren's article on EFT processing in Accounts Payable should help you setup automatic payments to your vendors. If you are about to embark on an EFT project, this article will save you time, money, and probably a few headaches as well.  

   Fixed Asset Additions

By Richard Berry, Klee Associates  
Size: 500 KB, Version:1.0, Publication Date:1/1/2004
Richard gives us the benefit of his many years of consulting experience by covering the Fixed Asset acquisition process from Purchase Order through Accounts Payable and General Ledger and finally into the Fixed Asset module. Along the way he covers Asset Master Information, Adjustments to Asset Costs, how Fixed Assets work with subledgers, integrity, and separating asset capital cost from consumables expense.  

   Sarbanes-Oxley Compliance Tools - Help or Hype?

By Eric Krell  
Size: 60 KB, Version:1.0, Publication Date:1/1/2004
Here's the first of a series of articles on the impact of the Sarbanes-Oxley Act on our readers. We hope to follow this excellent introduction with JDE-specific articles.  

  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.  

   Understanding and Using Subledger Accounting

By Hartley Farmer, Westbrook Systems  
Size: 300 KB, Version:1.0, Publication Date:11/1/2003
Subledgers are one of the JDE Financial Suite's best kept secrets. Used well, they can add whole new dimensions to your reporting and perhaps even defer the need to implement Job Cost, Contract/Service Billing, or Activity Based Costing. Hartley draws upon his 20 years of JDE experience to give you rock-solid advice on Subledgers.  

  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.  

   As Of Reporting in Accounts Receivable and Accounts Payable

By Randall Foust, CD Group  
Size: 330 KB, Version:1.0, Publication Date:7/1/2003
Randall scores again with another excellent article that applies equally to World Software and OneWorld. The reasons for needing an "As Of" report are explained along with how to do it. So, stop tearing out what's left of your hair when the auditors show up, and read this tip instead!  

  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.  

  Accounts Receivable Interest in OneWorld

By Richard Berry, Klee Associates  
Size: 180 KB, Version:1.0, Publication Date:5/1/2003
In his quest to serve clients better, Richard Berry has investigated the relatively new Delinquency Fees module in OneWorld. Find out everything you need to know to get started using this new functionality, including a page of test results. Once again, save valuable time with JDEtips.  

   Designing, Implementing, and Maintaining a Chart of Accounts

By Roger Avrit, Avrit Consulting Group  
Size: 3.3 MB, Version:1.0, Publication Date:5/1/2003
The Chart of Accounts is crucial to the efficient and effective capture and display of your organization's financial information. If the Chart of Accounts is set up correctly, your online inquiry and reporting tools will give you the information you need to understand what is happening in your business. Roger Avrit does an admirable job conveying a wealth of tips and knowledge, gained from nearly 25 years of working with financial systems. As an added bonus, Roger's sample Chart of Accounts is included. This white paper applies to both World Software and OneWorld.  

   Changing a Year End for a Company

By Randall Foust, CD Group  
Size: 200 KB, Version:1.0, Publication Date:3/1/2003
We asked Randall to write an article on this topic because questions on changing fiscal date patterns often come up in various user forums. Randall's expertise and his ability to simplify a complex issue shines through. Consider this required (and beneficial) reading if you are contemplating changing your fiscal date pattern.  

  Soft Coding Smart Field Column Headings

By Dan Marsh, Dan Marsh Group  
Size: 375 KB, Version:1.0, Publication Date:3/1/2003
Another winner from Doctor Dan, the Financials Man! This is a great tip-it will save you a lot of time changing Financial Report column headings in OneWorld, especially when the year changes, and you want your reports to reflect the current year in the title. In the true JDEtips style, Dan takes you through every step in detail.  

   Advanced Payment Terms

By Dan Marsh, Dan Marsh Group  
Size: 260 KB, Version:1.0, Publication Date:1/1/2003
Learn how to do terms like 4% 30, 3% 60 Net 61, or Prox Days with a Discount. It's easy, with this relatively new piece of functionality! Available in both OneWorld Xe and WorldSoftware A8.1.  
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.  

  Tips on OneWorld Financial Reporting

By Randall Foust, CD Group  
Size: 300 KB, Version:1.0, Publication Date:1/1/2003
Benefit from this author's eight years experience writing Financial Reports with JDE's software. Read these before you sweat the details on your critical reports.  

   User Defined Depreciation -- Simplified

By Randall Foust, CD Group  
Size: 730 KB, Version:1.0, Publication Date:11/1/2002
The author has eight years experience implementing JDE's Fixed Assets module, and gives a great step by step introduction to User Defined Depreciation. This works in both OneWorld and World Software.  

   Top Ten Tips for Fixed Assets

By Randall Foust, CD Group  
Size: 200 KB, Version:1.0, Publication Date:9/1/2002
Randall specializes in Job Cost and Fixed Assets along with core Financials. If you are implementing Fixed Assets, or even just wondering if you did it the best possible way, this document is an invaluable tool. Every tip applies equally to World Software and OneWorld. Ten tips for the price of one!  

   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.  

   Top Ten Tips For Job Cost

By Randall Foust, CD Group  
Size: 150 KB, Version:1.0, Publication Date:7/1/2002
What can you say about a consultant who is willing to share his Top 10? Thank you, Randall! Reading this will undoubtedly save clients a great deal of aggravation later. Do it right the first time.  

   Back to Basics - Voiding AP Vouchers and Checks

By Blanca Villasenor, SBI  
Size: 200 KB, Version:1.0, Publication Date:5/1/2002
In one of our Back to Basics features, Blanca leads Accounts Payable users through the proper steps to void a voucher and/or a check. She handles all four combinations of Paid/Unpaid, Posted/Unposted, with clear step-by-step directions.  

   Comparing OneWorld and World Accounts Receivable

By Brenda Wycoff  
Size: 310 KB, Version:1.0, Publication Date:3/1/2002
If you are contemplating a move from WorldSoftware to OneWorld, undoubtedly you've heard that the Accounts Receivable module has been seriously rewritten. Get a jump on the implementation by finding out all the major differences here. Brenda does a great job with this 11 page overview.  

  Improving FASTR Performance

By Colin Hugill  
Size: 50 KB, Version:1.0, Publication Date:3/1/2002
Want your FASTRs to run FASTER? Read this White Paper!  

   Multi-Currency Without Multi-Currency

By Dick Satchell, MSS Technologies  
Size: 50 KB, Version:1.0, Publication Date:3/1/2002
If you don't operate in multiple countries, you probably need to see your financials in one currency. If you don't want to get into full-fledged dual currency, consider using this creative alternative. It might be the solution you've been looking for.  

   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.  

   Procedure for Clearing and Reconciling Received Not Vouchered

By  
Size: 125 KB, Version:1.0, Publication Date:3/1/2002
One of the most difficult reconciliation processes for JDE clients is to reconcile open purchase orders to the received not vouchered account. As you probably know, these should balance, but often don't. Many customers struggle with this issue. In this article, we present some great tips on how to figure out where the discrepancy comes from.  

   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.  

   Changing Your Domestic Currency (Euro Conversion) - 670 KB

By Steve Shipp, TDG  
Size: 670 KB, Version:1.0, Publication Date:1/1/2002
This White Paper emphasizes conversion to the Euro, but it can be used by any client needing to change its domestic currency. Screen shots are done with WorldSoftware, but the concepts apply equally to OneWorld.  
Krista is an expert at both Allocations and the ERW. In this White Paper she explains how she goes beyond the boundaries of the JDE Variable Numerator (which allows ratios based on Business Unit Category Codes) to a much more flexible calculation.  

   Eliminate Potential Duplicate Payments in Accounts Payable

By Roger Avrit, Avrit Consulting Group  
Size: 25 KB, Version:1.0, Publication Date:1/1/2002
Sometimes you read something and think, "Wow, that is a great idea!" We think you'll be "wowed" by the simple excellence of this White Paper. Source code is available for this tip.  

   Getting More Value from Miscellaneous Subledger Entries

By Roger Avrit, Avrit Consulting Group  
Size: 2.6 MB, Version:1.0, Publication Date:1/1/2002
JDE's powerful subledger capability is made even more powerful by implementing the concept explained in this White Paper. Another simple, but beautiful idea, ably explained by Roger Avrit.  
Another winner from one of our favorite contributors, Roger Avrit! We feel your pain when it comes to reconciling the G/L and the Procurement Receipt details. Learn to write a custom report to solve this integrity issue - OneWorld code is included.  

   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.  

   Alternate (Dual) Currency - Transaction Method

By Richard Berry  
Size: 660 KB, Version:1.0, Publication Date:1/1/2001
Many international companies require their subsidiaries to report to headquarters in a different currency than their domestic currency. Learn the ins and outs of Alternate Currency processing with this White Paper by our Singapore based consultant.  

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