Export Data to Hashavshevet Accounting Software

In order to export general ledger data from the system to Hashavshevet, the data must be converted to a format compatible with Hashavshevet.

To execute the conversion process, perform the following actions in consecutive order:

  1. Create the travel file accounts file in the system

  2. Create the transactions file in the system

  3. Convert the travel file accounts file using the tsv2dat_heshin utility

  4. Convert the transactions file using the tsv2dat_movein utility

The files created in steps 3 and 4 will be exported to Hashavshevet.

 

When exporting data to the general ledger in sales and purchases mode, the first reference for the supplier invoice document is the document number and the second reference is the voucher number.

 

Additionally, the document name (DOC TYPE) representing VAT has the same name as the document relating to it. For example, a VAT line relating to a supplier invoice is named SIN, and a VAT line related to invoice is named INV.

  1. Create the travel file accounts file in the system

    1. Go to Financial – Export Data to General Ledger - General tab - Travel File accounts section.

    2. Select Separate account for Travel File.

    3. Select Create new travel files accounts file.

    4. Click Create File.

      5. The My Company Name dialog box is displayed:

    5. Click Continue.

    6. Save the file named Booking_account_file.txt on your computer.

      		7.

      The travel file accounts file includes records with two fields: travel file number and last name of first passenger in travel file.

    7. The My Company Name dialog box will be displayed again.

    8. Click Close.

    9. The last travel file number in Booking_account_file.txt will be displayed in the Last travel file account file number field.

  1. Create the transactions file in the system

    1. Go to Financial – Export Data to General Ledger - Account transactions tab.

    2. Click Refresh.

    3. Define the parameters by which to perform a search for accounting transactions.

    4. Click Find.

      The following message is displayed:

    5. Click Yes.

    6. Select the accounting transactions to export and click Export TSV File.

      The My Company Name dialog box is displayed:

    7. Click Continue.

    8. Save the file named Exported_<batch out number>.tsv on your computer.

    9. The My Company Name dialog box will be displayed again. Click Close.

  2. Convert the booking accounts file

    1. Open tsv2dat_heshin.exe. The TB Heshin Formatter will be displayed.

    2. Click Select input file.

    3. Locate and select the file named Booking_account_file.txt.

    4. Click Select output folder.

    5. Locate and select the directory in which the converted file will be saved.

    6. In the Select output sorting code field, enter the relevant value.

    7. In the Select output sorting code field, enter the relevant value.

    8. Click Convert. The progress bar will fill to completion after the conversion has been completed.

    9. The converted file, Heshin.dat, will be saved in the selected output folder.

    10. Close the TB Heshin Formatter.

  3. Convert the transactions file

    1. Open tsv2dat_movein.exe. The TB Hash Formatter will be displayed.

    2. Click Select input file.

    3. Locate and select the file named Exported_tsv.tsv.

    4. Click Select output folder.

    5. Locate and select the directory in which the converted file will be saved.

    6. Click Convert.

      The progress bar will fill to completion after the conversion has been completed.

    7. The converted file, movein.dat, will be saved in the selected output folder.

    8. Close the TB Hash Formatter.