Show TOC

Procedure documentationUsing the Open Interface: Israel Locate this document in the navigation structure

 

This procedure shows how to use the Open Interface to create income tax reports in standard format to submit to the Israeli tax authorities.

Prerequisites

To export data files containing Hebrew correctly, the SAP Business One display language must be Hebrew.

Procedure

  1. From the SAP Business One Main Menu, choose   Financials   Financials Reports   Accounting   Open Interface  . The Open Interface - Selection Criteria window appears.

  2. Select the required dates for the documents and journal entries, and choose the OK button.

  3. In the Browse window, select the location to which to save the file, and choose the OK button.

  4. The following settings are defined during report generation:

    • Currencies

    • Credit Cards

    • Countries

    If any of the settings require updates, an system message prompts you to open the required windows. After you update the settings, choose the Yes button to save the updates and to resume the report generation.

    Note Note

    • Currencies

      If the system message is displayed, choose the Yes button to open the Currencies – Setup window.

      In the ISO Currency Code column, select the code defined by the tax authorities.

    • Credit Cards

      If the system message is displayed, choose the Yes button to open the Credit Cards – Setup window.

      In the Internal Tax Code field, select the credit card company.

    • Countries

      Country information is updated automatically during an upgrade procedure.

    End of the note.

Result

In the event of a problem, SAP Business One displays a message notifying you that an error occurred, the report was not generated, and that the log file should be checked.

If the report is generated successfully, the application displays a message to that effect and a report summary appears. SAP Business One also generates the following two files:

  • INI.TXT

    This file contains one leading record and summary records. The leading record contains general data about the business and the data production process. A summary record is created for every type of record that exists in the BKMVDATA.TXT file. It contains summary data regarding the respective record type.

    This file also contains license information, indicating the number of software registration certificates in the tax authority's system. Each major SAP Business One release receives an updated license number from the Israeli tax authorities.

  • BKMVDATA

    This file is a compressed archive that contains business information. It has one opening record, additional records, as necessary, and one summary record.

    The first, or opening, record in the file contains general data about the file. The last record contains summary data and displays the total number of transactions recorded in the file.

    The BKMVDATA.TXT file is compressed into an archive named BKMVDATA using one of the standard compression software programs. The software used to compress the file determines the archive file extension.

    In operating systems where you cannot create the files directly in the specified path (such as LINUX or, UNIX), create them in another location and then transfer them to the required location in the following format: X:\OPENFRMT\99999999.YY\DDMMhhmm, where 99999999 is the federal tax ID and YY\DDMMhhmm are the time and date of the report generation.

The INI.TXT and compressed BKMVDATA files are saved, as follows, on the specified disk drive:

  • The OPENFRMT directory is created in the main directory on the selected disk drive.

  • A subdirectory is created in the OPENFRMT directory. The name of the subdirectory is created from the first 8 digits of the federal tax ID number and another 2 digits to indicate the year, as follows: XXXXXXXX.YY

  • A folder is created in the subdirectory and is named as follows: MMDDhhmm.

    For example, the folder created for a business with the federal tax ID number 002233445, and for which the data report was generated on 12 April, 2009 at 10:25, appears as follows: F:\OPENFRMT\00223344.05\04121025.

Example

A report summary is displayed in the following format and can be printed:

Federal Tax ID number: 999999999

Name of Company: XXXXXXXXX

The open format interface was successfully completed.

The data was saved in the following path: X:\OPENFRMT\99999999.YY\MMDDhhmm

Documents Date Range: From date DDMMYYYY until date DDMMYYYY

Journal Entry Date Range: From date DDMMYYYY until date DDMMYYYY

or, tax year in which data was generated YYYY

Details of the sum of each type of record created in the BKMVDATA.TXT file:

Record Code

Record Description

Total Records

A100

Opening record

XX

B100

Account transactions

XX

B110

G/L account

XX

C100

Document header

XX

D110

Document details

XX

D120

Receipt details

XX

M100

Inventory items

XX

Z900

Closing record

XX

The data was generated by SAP Business One software, license number:XXXX on date DD/MM/YYYY at time hh:mm.