Show TOC

Procedure documentationGenerating Maarechet 1000 and Mivzak Reports Locate this document in the navigation structure

 

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.

Prerequisites

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.

Procedure

  1. From the SAP Business One Main Menu, choose   Administration   Data Import/Export   Data Export   Export Maarechet 1000 or Mivzak  . The Maarechet 1000 / Mivzak — Selection Criteria window appears.

  2. 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.

  3. Note Note

    Relevant only when Mivzak is the selected report type.

    End of the note.

    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.

  4. In the Vendor Code From…To… fields, specify a range of vendor codes to display only vendors that fall within this range.

  5. 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.

  6. 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 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.

    End of the note.
  7. In the Path for File Creation field, click the Browse (Browse ) button to select the directory where you want to store reports.

  8. When you have finished specifying the selection criteria, choose the OK button.

Result

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.