Achieve an unprecedented level of transaction automation with JDE
Proven JDE solution
- JDE World:3, 9.2, 9.1, 8.1, A7.3
- JDE EnterpriseOne:1, 8.12, 8.11SP1, 8.10, 8.9, 8.0, Xe
Functionality & Files
- Automated Cash Application:
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.
- Automated Accounts Payable:
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.
- Automated Bank Reconciliation:
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.