Show TOC

Procedure documentationImporting Maarechet 1000 and Mivzak Files Locate this document in the navigation structure

 

You can import files received from the Israel Tax Authority into SAP Business One to update relevant values. There are three types of files you can import:

  • Maarechet 1000 (updates data in SAP Business One)

  • Mivzak (updates data in SAP Business One)

  • Error Report for Mivzak (does not update data in SAP Business One)

Prerequisites

To import 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 Import   Import Maarechet 1000 or Mivzak  . The Import from Maarechet 1000 / Mivzak window appears.

  2. Select one of the following report types:

    • Maarechet 1000

    • Mivzak

    • Error Report for Mivzak

    Caution Caution

    Make sure you select the appropriate report type for the file to be imported or the file import will fail.

    End of the caution.

    Note Note

    For Mivzak only.

    In the Mivzak Company Reference ID field, enter a company ID.

    End of the note.
  3. In the File Name field, do one of the following:

    • Type the path to the file to be imported

    • Click the Browse (Browse) button to navigate to the file you want to import, then choose the Open button.

  4. Choose the Execute button.

Result

If the file is imported successfully, the following field values are updated during the import of the Maarechet 1000 or Mivzak file in the Withholding Tax Determination — Setup window for each Shaam Group option:

  • Valid From

  • Valid until

  • Deduction %

  • Maximum Total

The Last Update Date field is updated according to the Certification Date value in the imported file. For each record in the error report, the business partner code is displayed together with the corresponding error message.

Note Note

Mismatches during the file import (such as data inconsistency, vendor not found, missing detail, and so on) are tracked and displayed in an error log window. The file import continues but the problematic vendor details are not updated.

End of the note.