Archive

Archive for the ‘AP’ Category

Cash Basis with Non-Stock PO’s

April 1st, 2011 Comments off

In a prior article on Cash Basis I covered how it should be setup.  Now for a real example.  When Standard Vouchers are paid and Cash Basis kicks in, it uses the voucher’s Expense GL coding for the debit, and cash account for the Credit.  Similarly in AR:  when cash is received, Cash Basis uses the invoice’s Income GL coding for the credit, and cash account for the Debit.

But what will Cash Basis do for non-standard vouchers?  For example, if the voucher is created via a 3-way match?  Where will the offset to the cash account come from?  To find out, I setup a test. Read more…

How To Prepare for 1099 Year End Processing in Accounts Payable

November 26th, 2010 Comments off

It’s almost that time again. In December, the IT departments typically download the latest ESU’s for 1099 processing.  And in January, AP managers struggle to remember what they did last year to generate those 1099′s.  Oracle provides plenty of documentation on the 1099 process, but Myoraclesupports.com website has published a quick overview article summarizing the setups and generation steps involved.  You can find it here. Read more…

Categories: AP, GL, JDEdwards, 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…

How to generate separate checks for the same Vendor in JDEdwards AP

April 20th, 2010 Comments off

You may have a requirement to generate separate checks for certain Vendors.  Taxing entities come to mind as a prime example.  If you have 5 approved vouchers in AP, a typical setup would combine them into a single payment.  But you actually need separate payments for the Government, State and Local tax authorities.  One method is to manually run the Create Payment Control Group and select individual Vouchers in the data selection.  This is cumbersome and potentially error-prone.  In the newer releases of JDEdwards, there is new functionality available to automatically accomplish this task. Read more…

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 differentiate between ACH and Wire Transfer Payments in AP

April 1st, 2010 Comments off

The requirement of differentiating between ACH and Wire Transfers can be fulfilled in a number of different ways.  This blog entry focuses on one possible method.  The assumption is that each Vendor can have both types of transactions.  If vendors exist that only do ACH or Wire Transfers, this technique can be streamlined by defaulting a specific Payment Instrument on the Supplier Master application. Read more…

Categories: AP, JDEdwards, linkedin Tags: , ,

How to prevent duplicate Invoices and Manual Payments in AP. What about Automatic Payments?

March 29th, 2010 Comments off

If you wish to prevent duplicate invoices and checks from being entered in the AP system, there are several settings available to accomplish that. 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…