In the Export Invoices Summary, you can conveniently extract invoice data for external accounting software 'Oracle JD Edwards EnterpriseOne' as shown in the figure below.
The authorised users can access and extract this report.
How to Access this Report?
To access the Oracle JD Edwards EnterpriseOne Report:
-
Click Reports → Invoice → Export Invoices Summary - Accounting
How to Generate this Report?
In the pop-up window:
- Select Period Ending, and Client Group
- Click Report and the data is exported successfully for the selected Period Ending
Sample Figure of the Downloaded Report
The Oracle JD Edwards EnterpriseOne Period Ending Report is saved and downloaded in the CSV format as shown in the figure below.
This report summarises all invoices generated within the selected period (e.g., Week Ending 29 Jul 2025).
It allows the accounting team to import data directly into JD Edwards, avoiding manual data entry and ensuring consistency between payroll/invoicing in Entire OnHire and finance systems.
Column Explanations
| Column Name | Description |
|---|---|
| Invoice Number | The unique invoice number automatically generated by Entire OnHire. Each number identifies one client invoice record. Example: N10003759. |
| Office Number | Represents the office or branch within the organisation responsible for generating the invoice. This helps distinguish financials across different business units or locations. |
| Client Number | The unique client identifier in Entire OnHire, used to link invoices back to the correct client record (e.g., CLT0004125). |
| Client Department | Identifies the department or sub-division of the client the invoice relates to. Useful for organisations with multiple departments billed separately. |
| G/L (General Ledger) Date | The accounting date that determines which financial period the transaction falls into. Used for reporting in JD Edwards and reconciling monthly or quarterly accounts. |
| Date Invoice Processed | The internal processing date from Entire OnHire — when the invoice was created and finalised within the system. |
| Invoice Amount | The base (pre-tax) amount of the invoice. This value represents the total of all billable shifts or services. |
| Invoice Sale Tax | The GST or applicable tax calculated on the invoice amount. |
| Due Date | The date by which payment is due, calculated based on the client’s payment terms (e.g., 7, 14, or 30 days from invoice date). |
| Invoice Type | A code or classification representing the type of invoice — for example, standard invoice, credit, debit, or adjustment. It helps the accounting system categorise transactions correctly. |
Usage Notes
-
This file is primarily for integration with Oracle JD Edwards EnterpriseOne.
-
It contains essential financial mapping data, such as client IDs, GL codes, and tax information.
-
The export ensures consistency between Entire OnHire invoicing and your organisation’s accounting system.
-
Accounting teams should not manually edit the exported file, as this may affect reconciliation accuracy.