Archive

Archive for the ‘Financials’ Category

How to upload Job Cost budgets from Excel in JD Edwards

February 24th, 2011 Comments off

The GL module provides standard functionality to easily upload budgets via the Z-table.  Unfortunately the Job Cost module can’t use that Z-table.  And there is no equivalent process to quickly upload budgets from Excel.  Is a user then stuck with manually entering budgets on the grid, or is there a way to upload budgets from Excel?  Read more…

Entering single-sided Journal Entries

September 6th, 2010 Comments off

Sometimes you may come across a situation where the only way to fix an issue is via a single-sided Journal Entry. Maybe a Company or a batch is out of balance, or a system glitch has posted only part of the transaction. Whatever the reason, this blog entry will show you how to enter a single-sided Journal Entry, and then post an unbalanced batch. Read more…

US adoption of IFRS remains highly uncertain

August 10th, 2010 Comments off

Survival of the International Accounting Standards Board as originally conceived has been put in question by the uncertainty over the adoption of global accounting standards in the U.S., said Tommaso Padoa-Schioppa, newly appointed chairman of the IASB trustee group. Read more…

Categories: Financials, linkedin Tags:

Cash Basis in JD Edwards

June 29th, 2010 Comments off

Introduction

The Cash Basis accounting method is straightforward, and more intuitive to a non-accountant than the Accrual Basis method.  In Cash Basis, income is recognized when cash is received, and expense is recognized when a debt is paid.  While Cash Basis accounting is rarely used in industries like manufacturing or distribution, it’s common in real estate, government and non-profit industries among others. Read more…

Leases Headed for the Balance Sheet

June 7th, 2010 Comments off

Lease accounting for property and equipment will soon get a lot more complicated, according to this CFO.com article (found here).  The new FASB recommendations are to be released some time in June. Read more…

Categories: Financials, GL, linkedin Tags: , ,

IFRS For SMEs-U.S. GAAP Comparison Tool Available Online

April 22nd, 2010 Comments off

From the Journal of Accountancy:

IFRS For SMEs-U.S. GAAP Comparison Tool Available Online While the SEC moves toward a 2011 vote on whether to require U.S. public companies to report using IFRS, a more compact version of the international standards is already an option, subject to state board approval, for U.S. private companies. Now there’s a free online tool to help preparers understand how that streamlined standard compares to U.S. GAAP. Read more…

Categories: Financials, JDEdwards, linkedin, Reports Tags: ,

How to upload large quantities of Vouchers in AP

April 15th, 2010 Comments off

Companies often have the need to enter large quantities of Vouchers/AP Invoices at a time.  They may need to use it once for a one-time import, such as Open AP migration, or an ongoing process, like weekly imports of vouchers.  Read more…

How to setup Recurring Vouchers in AP

April 5th, 2010 Comments off

Setting up Recurring Vouchers in Accounts Payable can be a great time-saver.  They are perfect for situations when vouchers need to be entered at specific intervals and the amounts and G/L Distributions are always the same.  Examples might be:

  • Monthly mortgage and car payments
  • Quarterly subscription dues
  • Annual life insurance payments

The process is similar to entering a Standard Voucher, with just a couple of extra fields to enter, and 1 report to run.

To view the rest of this article, the system might ask you to sign-in or register.  It’s free and you will get access to all articles in this blog. Read more…

How to drive multi-line Service PO’s to a single AP Trade/single bank account during a 3-way voucher match

March 28th, 2010 Comments off

A common scenario encountered at clients using multiple Companies is the desire to enter multi-line PO’s with each line referencing an expense account in a different Company.  During vouchering, all the lines must hit a single AP Trade account.  All the lines also need to go to the same default Bank account.  Standard JDE setups typically spread the lines into different AP Trade and Bank accounts.  Is there a way to force all the lines to go to the same AP Trade and Bank account?  The answer is yes!  To view the rest of this article, the system might ask you to sign-in or register.  It’s free and you will get access to all articles on this blog. Read more…

Financial Report tweaking – consolidations

March 27th, 2010 Comments off

The existing Financial Reports that come standard with JDEdwards are not pretty, I must admit.  They tend to get very long due to 0-balance accounts printing.  Sometimes it’s hard to figure out which accounts are listed, because only the Account Description prints, not the Account Number.    And how do you get them to print the balances for specific Business Units, vs. rolling them up to the Company level, or maybe even using a category Code to consolidate?  The last topic is the focus of this article:  report consolidations. Read more…