SAP Business One enables you to generate two types of reports with vendors details to submit to the Israel Tax Authority:
Maarechet 1000 (up to 1000 vendors in the company database)
Mivzak (more than 1000 vendors in the company database)
You only need to submit one type of report, depending on the number of vendors with recorded transactions in your company database.
To generate a report, follow the steps below.
To generate data files containing Hebrew correctly, the SAP Business One display language must be Hebrew.
Vendors in the company database are correctly defined for withholding tax.
From the SAP Business One Main Menu, choose
. The Maarechet 1000 / Mivzak — Selection Criteria window appears.Select the appropriate report type:
Maarechet 1000 (if you have up to 1000 vendors in your company database)
Mivzak (if you have more than 1000 vendors in your company database)
The Vendor Count field displays the number of vendors in your company database.
Note
Relevant only when Mivzak is the selected report type.
In the Mivzak Company Reference ID field, enter an ID for the company. This is a unique 9-digit number provided by the Israel Tax Authority, and the default number is . 999999790.
If needed, contact the tax authority to confirm your company ID is valid.
In the Vendor Code From…To… fields, specify a range of vendor codes to display only vendors that fall within this range.
In the Vendor Group field, select the group whose vendors you want to include in the report. To include all vendors in the selection criteria, select All.
Choose the Properties button.
In the Properties window, specify the required business partner properties by selecting their check boxes, then choose the OK button.
Note
Business Partner – ‘D’ Type
Relevant for Mivzak reports only.
Repeat steps 4 — 6 for the fields in the Business Partner – ‘D’ Type section.
Vendors that have been deleted from the tax authority's database are marked with D.
In the Path for File Creation field, click the (Browse ) button to select the directory where you want to store reports.
When you have finished specifying the selection criteria, choose the OK button.
If the report is generated successfully, a report summary appears. SAP Business One also generates the one of the following two files according to your definition:
For Maarechet 1000, Maarechet_YYYYMMDD.TXT
For Mivzak, GM52.PROD.XXXXIN.TXT
You can edit these default file names. These files contain vendor details (vendor code, tax ID, tax ID2) to send to the tax authority.