Assumptions for Open Format File Generation for Israel

You must verify that these prerequisites are met before you proceed to open format file generation:

Data Access Set setups are properly set for the User and the Ledgers to be considered in the reports.
Legal entity setup is complete and necessary information required for Open Format Solution is entered in Legal Entity Registration.
Proper values need to be defined to all relative user defined standard lookups that identify the user related information depicted in the INI.txt file.
The user has defined the values of the balancing segment that is expecting to retrieve in the reports.
It is assumed that no transactions are carried out in the application while this data extract is generated.
It is considering only posted journals for information from General ledger.
Tax calculation will happen based on the definition in E-Tax.
On both report outputs, the data are displayed at Legal Entity Level.
It is mandatory that reporting for Open Format must be in ILS Currency
At least one out of all the ledgers created for the enterprise structure must be in ILS currency irrespective of its type – primary, secondary or reporting currency.
If ILS ledger is non-primary ledger, then currency conversion for it should be setup at subledger level.
Users need to have access to the ledger, legal entities, business units and all sub-ledger applications from where eligible content for Open Format for Israel files comes.

General Information about Open Format Report

Here are some additional details about open format report:

The open format for Israel files can be requested for any time interval. As this is an audit report, the periods when data is extracted must be closed periods. At any point of time, the file creation can happen only for particular year. If the requested time interval extends to 2 or more years, the files show the year of the Start-date parameter value.
The user must list all GL categories that has be omitted from the Open Format output including GL categories used by other subledgers and applications, and for manual GL entries.
The B110 record lines created does not include in their balances any amounts from journals that belong to GL Categories included in the ORA_JEIL_GL_CATEGORIES. They only include the amounts from the transactions depicted in B100.
The B110 record lines created depict balances of all the active bookkeeping accounts for the period defined by the Start-Date and End-Date parameters. The beginning balance must be calculated based on the difference between the debit and credit balances, the difference from the period balances given in GL balances, and the dates requested in the parameters.
The extract includes the Payable Invoice (Subsection 700 of the C100 and D110 report lines) that have accounting dates within the given time interval and are validated, accounted, and posted.
The extract includes the Payable Credit Memos (Subsection 710 of the C100 and D110 report lines) that have accounting dates within the given time interval and are validated, accounted, and posted.
The extract includes the Receivables standard transactions (Subsection 305 for the C100 header and D110 report lines) that have accounting dates within the given time interval and are completed, accounted, and posted. Also, the transaction type rule above is always in effect, filtering furthermore, the receivable transactions to be selected.
The extract includes the Receivable proforma transactions (Subsection 300 for the C100 header and D110 report lines), that have accounting dates within the given time interval and are completed and accounted. Also, the above transaction type rule is always in effect, filtering the receivable transactions to be selected.
The extract includes the Receivable credit memos (Subsection 330 for the C100 header and D110 report lines) that have accounting dates within the given time interval and are completed and accounted. Also, the above transaction type rule is always in effect, filtering the receivable transactions to be selected.
The extract includes the Receivable receipts (Subsection 400 for the C100 header and D120 report lines) that have accounting dates within the given time interval and are completed and accounted. Also, the receipt class rule above is always in effect, filtering the receipt classes to be selected.

The extract includes the Receivable donation receipts (Subsection 405 for the C100 header and D120 report lines), that have accounting dates that fall inside the given time interval and are completed and accounted. Also, the receipt class rule above is always in effect, filtering furthermore, the receipt classes to be selected.
The extract includes the Petty Cash Receipts (Subsection 410 for the C100 header and D120 report lines) that have accounting dates within the given time interval and are completed and accounted. Also, the receipt class rule above is always in effect, filtering the receipt classes to be selected.
The extract includes the bank (remittance) receipts (Subsection 420 for the C100 header and D120 report lines) that have accounting dates within the given time interval and are completed, accounted, and posted. Also, the receipt class rule above is always in effect, filtering the receipt classes to be selected.

The information for D120 records required receipts is extracted from the information defined in the setup of the relative customer bank:
If the GDF receipt type has the value (2) for Check, the system identifies all the required information for Bank, Bank Branch, and Account from the customer bank setup.
If the GDF receipt type has the value (3) for credit card, the system extracts information from the remaining attributes of the receipt regional information flexfield, for example Credit Card Deal, Credit Card name, and Credit Card Clearing House.
Miscellaneous Receipts and Unidentified Receipts are not extracted under Open Format audit file.