E1

When JD Edwards ported AR from World to OneWorld (now E1)  it was one of the few modules that was rewritten to be fully normalized (click >>> for definition). However, taking advantage of a more normalized database structure has unfortunately caused many problems in reconciling AR.

 

 

Consolidated AR inquiries (for example, a single screen showing all invoices, cash and adjustments) can't be found in standard E1 and many customers are trying to use spreadsheets to reconcile invoices, receipts and adjustments. The reason for this is that JD Edwards split the old master file "F0311" in World into three files in E1.

 

Open Items

Cash Received

Invoices

 

There was no way of assessing all these transactions in one place, until now.

 

The GL Company has developed a consolidated online inquiry that gives you all this information on one screen. What's more you can then drill down to the details with a simple mouse click.

 

 

 

During the busy month end process the general ledger period remains open for two to three days after the month end close. However, the AR system rolls over on a daily basis, which means that the open items will have moved on before the GL period has been closed.

 

In order to reconcile the AR control account in the GL to the list of open items in AR, E1 users have to print out, or export to a database, all of the open items and details that make up these balances at the end of the GL period end.

 

With Really Real Time ® Inquiry Suite for AR you can now roll back the AR system to any date you want. What's more you are working over the live JD Edwards system, which ensure, the integrity of the data. You can also drill down to the underlying transactions.
 

Click on image for bigger screen image (Please note image quality has been reduced in order to load quicker)

 

 

In JD Edwards there is an end of day process that can give you a batch aged debt report. This has a number of fixed columns normally just giving you some basic aging periods, unallocated cash and future periods.

 

With Really Real Time ® Inquiry Suite for AR you can now define you own aging buckets and run live aged debts reports for Due Date, Invoice Date, GL Date, Statement Date... in fact any date where the invoice has a date stamp against it.
 

 

 

With The Really Real Time ® Inquiry Suite Configurator module, you can inquire on AR by virtually any dimension in the address book.

 

Click on image for bigger screen image (Please note image quality has been reduced in order to load quicker)