1. Using Financials for EMEA
  2. Open Format Files

Open Format Files

This document provides an overview of the features of the open format file generation for Israel, where transaction information details from the application are captured in a specific format required by the Israeli tax authorities.

The Open Format for Israel: Files Generation scheduled process selects all eligible document types to be present in the Open Format for Israel: BKMVDATA File and Open Format for Israel: Initialization Data File in prescribed formats.

These files include information from different modules presented in a unique sequence for each document type that helps identify information related to a module and document type:

  • Open Format for Israel: Initialization Data File:
  • Open Format for Israel: BKMVDATA File

Open Format for Israel: Initialization Data File

This document provides an overview of the features of the open format file generation for Israel, where transaction information details from the application are captured in a specific format required by the Israeli tax authorities.

The Initialization Data File for Israel contains this information presented in a prescribed text format:

  • The summary of the record count. The count is the same total of all the records processed by Open Format for Israel shown in the BKMVDATA.txt file, broken in each category depicted in BKMVDATA file.
  • A100 document type information before printing the counted totals. Details such as parameter values, company and legal entity information, are also depicted in this line.
  • The detailed analysis of the values and the position of each column in the report are available in the Appendix.

    Here’s the text format of the ini.txt file: 

    A100 000000000000008TIN9721000000000000000030000000034002 ERPCLOUD 11.13.0.0.0
    512200502ORACLE SOFTWARE 2 21TIN972100 __________VISION ISRAEL 100 IL TEST STREET
    __________TEL AVIV ________2014201406012014063020180205163501Winzip ILS0
B100000000000000348
B110000000000000052
C100000000000000054
D110000000000000654
D120000000000000023
M100000000000000000

Open Format for Israel: BKMVDATA File

This document provides an overview of the features of the open format file generation for Israel, where transaction information details from the application are captured in a specific format required by the Israeli tax authorities.

The Open Format for Israel: BKMVData File submission process automatically happens from the parent scheduled process - Open Format for Israel: Files Generation, after it is processed successfully.

This table lists the document types based on which output is displayed as a report:

Header Lines
Sales Invoice Header C100-300,305,330 Sales Invoice Lines D110-300,305,330
Sales Receipts Header C100-400, 405 Sales Receipts Lines D120-400, 405
Sales Receipts Remittance Header C100-420 Sales Receipts Remittance Lines D120-420
Purchase Invoice Header C100-700 Purchase Invoice Lines D110-700
Purchase Invoice Credit Header C100-710 Purchase Invoice Credit Lines D110-710
Journal Headers B100 Journal Lines (only lines without header) B110

The BKMVDATA file contains this information:

  • Legal Entity Registration Information
  • All the document types processed by the file’s generation scheduled process.
  • Z900 document type line, which provides count per document type included in the file.

The output of the file is being restricted to 1.5 GB due to the BIP limitation.

Upon generation of the BKMVDATA.txt file, to continue with interpretation of the processed content, the users use the information about the start and end position of each value type for each process category in the end user documentation.

For a detailed analysis of the values required for each column of the report, refer the Appendix.

The data is presented per category of records (C100 and B100) and subcategory where necessary (C100-700).

Here's an example of the output of the BKMVDATA.txt file. For your reference, the values are presented in multiple lines per report row:

A100000000001000004371000000000001516 
B10000000000200000437100048803950000303126213Purchase Invoic 000 000Journal Import Created 20150914201006301246 1ILS+00000000016000+00000000016000+00000000000 201509141013677
B1100000000600000043712520 State Sales and Use Tax Payable L State Sales and Use Tax Payabl IL -00000000027900+00000000000000+000000000000000000000000000 +00000000000000ILS 
B1100000000610000043711330 Standard VAT - Payables L Standard VAT - Payables IL +00000000544960+00000000000000+000000000000000000000000000 +00000000000000ILS 
C100000000102000004371700212264 201101200214SSI Supplier1 Advance Hungary 00000000020100401+00000000000000ILS+00000000200000+00000000000000+00000000200000+00000000010000+00000000210000+0000000000021 20100401 1013677 0212264 
C100000000103000004371700212201 201010250024SSI IL Supplier1 SSI IL Addres LIne1 SSI IL City 00000000020100815+00000000000000ILS+00000001000000+00000000000000+00000001000000+00000000050000+00000001050000+0000000000016 20100815 1013677 0212201 
C100000000107000004371700248312 201206172313SSI IL Supplier1 SSI IL Addres LIne1 SSI IL City 00000000020100401+00000000000000ILS+00000000100000+00000000000000+00000000100000+00000000016000+00000000116000+0000000000016 20100401 1013677 0248312 
D110000000108000004371700248316 0001700ERS-01-APR-10-1637560Mobile SSI IL Item +0000000000010000+00000000100000+00000000000000+000000001000001600 201004010248316231993 8348 
D110000000137000004371700211695 00017002010-000020 0999999 Description is null +0000000000010000+00000000100000+00000000000000+000000001000000500 201004100211695999999 999999 
D110000000142000004371700211917 00017002010-000010 0999999 Created for inventory +0000000000100000+00000000000500+00000000000000+000000000050000500 201005180211917999999 999999 
D120000000143000004371405VL100test 0001100000000000000000000000000000000000000000000020100401+000000005000000 0 201004010226489 
Z9000000001470000043710000000000015161111111 000000000000147