Since 2009 we have been helping organisations who use JDE to achieve spectacular levels of automation in Cash Application, Accounts Payable and Bank Reconciliation. We have been Oracle business partners since 2010. Get the capability and features to empower your finance department like never before.
Cashbook is a proven, JDE compatible solution, that’s easily tailored to your unique needs, quick to implement, works globally, works with all major banks, supports 50+ languages and it is easy to use.
As an example Cashbook maps or copies JDE customer data from F03B11 Customer Ledger, F03B13 Receipts Header File, F03B14 A/R Check Detail File, F03012 Customer Master, F0101 Address Book Master, F0116 Address By Date, F0013 Currency Codes, F0015 Currency Exchange Rates. Cashbook then imports bank statements which may be BAI, MT940, CAMT053 or from any number of customer remittance sources such as EDI, PDF, Excel. Once we have these 2 data sets in Cashbook tables our standard matching algorithms are used. Users review the auto-matching and then complete the posting back to the source ERP system. This is where Cashbook creates z tables in JDE in a real-time manner ensuring automatic cash application and seamless integration.
The Z file process is done by creating a receipt batch via report R09801 which makes entries in the F0911 file as well as the F0902 files. Updates occur in F03B13, F03B14 and F0011 files.
Cashbook can select invoices from the F0411 Accounts Payable ledger File across companies, banks and payment types in one selection run. Multiple payment batches are created in Cashbook and then transmissions can be sent by Cashbook to any bank in any payment format. The advantage of Cashbook is we are always up-to-date with banking changes such as IBAN, SEPA, ACHCTX, ISO 20022. Having a single solution for all banking interfaces is simpler, smarter and saves on customer development. We can be a single gateway from JDE to your banking world.
Cashbook looks directly at the F0911 files extracting general ledger transactions specifically for bank account control ledgers. Having a specific tool for bank reconciliation that is ERP and bank independent ensures greater control and more flexibility.
We’ve worked with multiple enterprises who use JDE, from a variety of sectors, operating in the United Kingdom, USA, Ireland and South Africa. Some, who operate multiple ERP’s, enjoy the added benefits of Cashbook’s cross platform ERP integration.JDE clients include: Bibby Distribution, Exide Batteries, MPACT, Alamo, TDG