Reports

To set up the Open Format branch ID:

1. Go to Setup > Company > Subsidiary.

2. Click Edit on the subsidiary record to issue the Open Format File for.

3. On the Israeli OF Details subtab, in the מזהה סניף / ענף field, enter: 0 (zero) for regular companies or 1 (one) for companies with branches.

4. Click Save.

To set up record type:

1. Go to Customization > Lists, Records and Fields > Record Types.

2. Click IL OF Auto ID Num Israel ILS, and then copy the value from the ID field (‘_il_of_auto_id_num_’ format).

3. Go to Setup > Company > Subsidiaries, and click the View link of the applicable subsidiary.

4. Copy the value from the Internal ID field, and add it to IL OF Auto ID Num Israel ILS, for example > il_of_auto_id_num_18.

To set up new custom records:

1. Go to Customization > List, Records & Fields > Record Types > New.

2. In the Name field, enter IL OF Auto ID Num XXX ILS (where XXX =company name).

3. In the ID field, enter _il_of_auto_id_num_5.

4. Mark additional parameters in the numbering category as follows:

   • Verify that the Include Name box is cleared.

   • On the Numbering subtab, verify that the Enable box is checked and that the Initial Number field contains the value 1.

5. Click Save. Repeat the procedure for any other subsidiaries which should be included in the Open Format File.

To map between NetSuite Transactions and the Israeli Tax Requirements:

1. Go to Customization > Lists, Records and Fields > Record Types, and then click IL OF Documents Mapping Number.

2. Add the mapping below:

   Name	IL OF Documents Mapping Number	Quantity Dependent	Document Mapping Dependency
   100	Sales Order	No
   200	Item Shipment	No
   210	Return Authorization	No
   305	Invoice	No
   320	Cash Sale	No
   320	Cash Refund	No
   330	Credit Memo	No
   400	Payment	No
   500	Purchase Order	No
   610	Vendor Return Authorization	No
   700	Bill	No
   710	Bill Credit	No
   810	Item Receipt	No
   810	Inventory Distribution	No	Negative Quantity
   820	Inventory Distribution	No	Positive Quantity
   820	Item Shipment	No
   830	Transfer	No
   830	Transfer Order	No
   840	Inventory Adjustment	No
   840	Inventory Worksheet	No
   900	WO Unbuild	No	Negative Quantity
   900	WO Build	No	Positive Quantity
   910	WO Build	No	Negative Quantity
   910	WO Unbuild	No	Positive Quantity

3. If the company does not have inventory and warehouse, from the Actions list, select Delete, and delete following lines:

   Name	IL OF Documents Mapping Number		Quantity Dependent	Document Mapping Dependency
   810	Inventory Distribution		No	Negative Quantity
   820	Inventory Distribution		No	Positive Quantity
   820	Item Shipment		No
   830	Transfer		No
   830	Transfer Order		No
   840	Inventory Adjustment		No
   840	Inventory Worksheet		No
   900		WO Unbuild	No	Negative Quantity
   900		WO Build	No	Positive Quantity
   910		WO Build	No	Negative Quantity
   910		WO Unbuild	No	Positive Quantity

To connect company payment methods to the Israeli Tax Requirements:

1. Go to Setup > Accounting > Accounting Lists, and filter Payment Method to view the company’s payment methods.

2. Go to Customization > Lists, Records and Fields > Record Types, and then click IL OF Payment Method Number to map the base payment methods to the Israeli Tax Requirements. Sometimes, the IL OF PM NAME field needs to be updated to the correct value according to the table.

   Name	IL OF PM Name
   1	Cash
   2	Check
   3-1	MasterCard
   3-2	Visa
   4	Discover
   4	Wire
   4	PayPal
   4	EFT

To update the software data for the Israeli Tax Authorities:

The certificate is updated annually.

1. Go to Customization > Lists, Records & Fields > Record Type.

2. Look for the IL OF SETUP for OW record type name and click List in the List column.

3. Click Edit to update the record or View to view it.

4. Make sure that the fields below bear the correct value:

   • System Tax Registration Number:176811

   • System Name: NETSUITE

   • System Tax Version Number: The latest year IRS certified NET Cloud for her Open Format (changes every year)

   • Provider Tax Reg. Number =513825752

   • Provided Name (In Hebrew): נטקלאוד בע"מ (NetCloud Ltd.)

   • Retained Earnings Account : 3030 Retained Earnings

To edit the IL Open Format Role:

1. Go to Setup > Users/Roles > Manage Roles, and then click Customize on the IL OF Role record.

2. In the Name field, enter IL OF Role XXX (xxx should be your company’s name).

3. In the Subsidiary Restrictions section, select All to mark all company books & Accessible Subsidiaries.

4. In the Accounting Books section, choose Primary And Selected, and then select Adjustment Book and Secondary Accounting book.

5. Go to Setup > Users/Roles > Manage Users to apply the role.

6. Go to Edit > Access > Roles and select IL OF Role XXX.

7. Select the user that will submit the OF file and apply the new role.

To run the Open Format file program:

Starting from the Israel Localization SuiteApp version 8.8, the option of selecting a book is available.

If the primary book is in foreign currency, and there are several books in ILS (tax book), in the "Book" field you will be given the option to select the relevant book. The program automatically creates a directory named OPENFRMT and saves the files in Library Location in Disc C.

1. Go to Reports > Israeli Reports > Israeli Open Format, and then click Download Open Format Client Application. The file IL-OpenFormat.exe downloads and saves to your Downloads folder.

2. Right-click the file and select Run as Administrator.

3. Log in to the system and enter the following:

   • E-mail: IL OF Role XXX user e-mail set up in previous step.

   • Password: user NetSuite password (up to 15 digits).

   • Customer code: go to Setup > Company > Company Information and copy the Account ID.

     Note:

     Account ID can be found in the URL, copy the numerals proceeding the app.netsuite.com.

   • Role: go to Setup > Users/Roles > Manage Users and copy the Role internal ID.

4. Set Sent to שלח.

5. Select the book ( ספר) and dates.