This procedure shows how to use the Open Interface to create income tax reports in standard format to submit to the Israeli tax authorities.
To export data files containing Hebrew correctly, the SAP Business One display language must be Hebrew.
From the SAP Business One Main Menu, choose Open Interface - Selection Criteria window appears.
. TheSelect the required dates for the documents and journal entries, and choose the OK button.
In the Browse window, select the location to which to save the file, and choose the OK button.
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
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.
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.
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.