JDE

JDE is Cashbook’s newest ERP system that we have integrated with. We have been integrating with major ERP systems since 1992 and have become Oracle Tier 1 partners since December 2007. We have a huge value proposition for all companies using both JDE World and Enterprise 1.

JDE Versions Supported:

JDE World: A9.1, A8.1, A7.3
Enterprise One: 8.12, 8.11, 8.10, 8.9, 8.0, XE

AR Value Proposition:

Cashbook enhances the AR cash application functionality in JDE. We offer a single entry point for all cash processing that gives users the ability to quickly and easily enter cash. JDE limitations in the AR space include:

No ability to apply cash across multiple JDE companies or in multiple currencies.
Deductions/Debit Notes/Credit Notes are not easily created and applied as a part of the cash application process
Cannot post directly from a bank statement to AR, AP and GL.
No tracking of bank statement opening and closing balances
No tracking of bank statement numbering
Draft Management not fully complementary to bank reconciliation process
No integration with bank reconciliation of AR cash application process
Direct Debits functionality in JDE not integrated with European banks
Customer Hierarchy is limited to two levels.

Cashbook looks directly at a number of JDE files to find open invoices and customer information examples include F03B11, F03B13, F03B14. Cashbook takes information from a bank statement or bank lockbox file and automatically matches that information with open invoices and deductions. For those not containing enough information, Cashbook shows the AR Clerk the open amounts and available details with the open invoices for easy selection. Once matched, the information is then fed back into JDE updating files such as F03B13, F03B14, F0911Z1 via the Z file process. Cashbook ensures JDE is populated as if it JDE is processed using standard JDE functionality however we include additional reference information such as Cashbook Journal & Line information and Bank Statement or Lockbox information.

AR Credit & Deduction Management Value Proposition:

We are partners with a company that provide credit and deduction management solutions. The limitations with JDE financials for credit collections & deductions include:

No ability to put notes on customer accounts.
No ability to re-print invoices quickly & easily.
No facility to rapidly send fax/pdf/email to customers detailing invoices outstanding and cash required for collection.
Not a user-friendly order-hold process.
No method of tracking collection agent’s accounts & DSO achievements.

Our partner’s solution views files such as F0311, P03013,F0301(2). Additionally our partners product views order files so that users can place orders for late paying customers on hold or release holds that have been instigated. We have many customer references showing how customers have reduced their DSO by over 10%. For many companies that has generated a ROI of €100,000’s.

Bank Reconciliation Value Proposition:

Cashbook has given JDE customers bank reconciliation functionality because every time a Cashbook journal is posted our bank reconciliation solution is updated. This means when you use Cashbook you only need to add our Bank Statement Upload module and you have all the information you need to do bank reconciliations.

For people who do not use Cashbook we offer the bank reconciliation solution as a standalone solution that can reconcile relevant GL accounts with incoming bank statements. Our Cash to GL reconciliation compares GL accounts with incoming bank statements. Cashbook Bank reconciliation product features:

Auto-matching of bank statements to cash balances
Simultaneous post of GL entries directly from bank statement e.g Interest received, Bank Charges.
Search/Sort capability of both cash and bank transactions.
Cash and Bank balances stored within Cashbook
Unpresented cash transactions functionality
Bank Statement transactions can be coded to specific ledger accounts
Many to One, One to Many, Many to Many transaction matching
Undo reconciliation option
Reconciliation Reporting

JDE System Updates:

To ensure the integrity of the JDE system Cashbook purposely avoids performing direct updates to JDE tables. We utilize full functionality of the Z file processes for AR, AP and GL updates. To ensure real-time information in JDE Accounts Receivable, Payable and the General Ledger, Cashbook executes the Z file processes in real-time.

Z-files in JDE are used for temporarily records. During a Z file post process a receipt batch (type RB) gets posted via report R09801 and this will make entries in the General Ledger (F0911) as well as in the account balances files (F0902). It will also update the F03B13 and F03B14 (giving it a posted code) and it will update the F0011 (Batch header file), giving it a posted status.