Versions Compared

Old Version 11

changes.mady.by.user Noel Consulta

Saved on

compared with

New Version Current

changes.mady.by.user Noel Consulta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

...

Overview

The records and reports in the fixed assets cannot be mapped directly to the Lithuanian SAF-T. There are some information that are missing or we are unable to map to the SAF-T structure.

...

Here are the specific steps on how to populate the custom records:

LT Asset

The LT Asset import is the initial stage of the process. Prioritizing the import of the LT Asset is crucial, as both the LT Asset Transaction and LT Asset Valuation are contingent upon the availability of the LT Asset.

Preparing the list of LT Assets

See below steps on how to import the FAM asset records to the LT Asset records:

...

Note

Filter the saved search to show only the subsidiary that is needed for SAF-T. Additionally, filter the by date of acquisition to avoid importing LT Assets that are already existing in NetSuite. Then, download the file as a CSV. Verify the correctness of the file after download. Make sure that the date format in the CSV file matches the date format in NetSuite.

  1. The Supplier must be a valid and existing vendor in NetSuite. For this purpose, use the internal ID of the vendor to ensure accurate matching. An empty column named SupplierInternalID is added in the last column of the file from [STA-LT] SAF-T Assets (FAM Record). This is where the internal ID of the vendor must be added and mapped in the NetSuite import. To do this, open a Open a new excel file, then create 2 two sheets.

    Image Removed

    1. Create the First Sheet for “[STA-LT] SAF-T Assets (FAM Record)“:

      1. In the new workbook, you should see a sheet labeled “Sheet1“ (or similar).

      2. Right-click on "Sheet1" and select "Rename" or simply double-click on it.

      3. Rename it to "LT Asset" or any name that is easy to remember.

      4. Copy the data in this sheet from the saved search that was dowloaded named [STA-LT] SAF-T Assets (FAM Record).

    2. Create the Second Sheet for “Vendor Search with Internal ID"

      1. In the same workbook, right-click on the sheet tab of "Asset Transactions JEs" and select "Insert."

      2. A new sheet, typically named "Sheet3," will be added.

      3. Right-click on "Sheet2" and rename it to "Vendor Search" or any name that is easy to remember.

      4. Copy the data in this sheet from the saved search that was dowloaded named Vendor Search with Internal ID.

  1. Perform a VLOOKUP to ad add the internal ID in column J. To do this, add this excel formula in cell J2 of the original file: Create a VLOOKUP formula in (SupplierInternalID) of the LT Asset sheet for SupplierInternalID.

    1. Select the Cell in the "SupplierInternalID" Column:Go to the first cell in the "SupplierInternalID" column where you want to populate the data (In this case, it is normally cell J2).

    2. In Cell J2, enter the following VLOOKUP formula:

...

Code Block
=VLOOKUP(F2,'Vendor Search'!$A:$C,3,0)”
Expand
titleClick here to see the purpose of the excel formula:

  • F2: This is the "SupplierID" value in the first sheet for the current row.

  • 'Vendor Search'!A:C: This is the range in the second sheet where the VLOOKUP will search for a match.

  • 3: This specifies that it should return the value in the third column of the second sheet (which is the "TransactionJE" column).

  • 0: This exact match parameter ensures that only exact matches are returned.

  1. Copy the formula from cell J2 to the remaining rows in column J. There will be instances that the VLOOKUP formula will display #N/A. This happens if the Supplier in column F is empty or if the supplier ID does not exist in NetSuite. Make sure to remove the #N/A values in the file.Save the CSV file in the computer. The

  1. Create a new excel file. Copy the data from the LT Asset sheet and save the file as a CSV. The new CSV file will be used for import in NetSuite.

 

Import of LT Asset Records into NetSuite

To import the LT Asset records:

...

  1. Once complete, verify the import by typing “page: LT Asset” in the global search.

LT Asset Transaction

Preparing the list of LT Asset Transactions

Below are the steps on how to prepare the data for import into NetSuite:

...

  1. Create a VLOOKUP formula in Asset Transactions sheet for Transaction JE.

    1. Select the Cell in the "TransactionJE" Column:Go to the first cell in the "TransactionJE" column where you want to populate the data (In this case, it is normally cell S2U2).

    2. In Cell S2U2, enter the following VLOOKUP formula:

...

  1. Create a VLOOKUP formula in Asset Transctions sheet for Supplier.

    1. Select the Cell in the "SupplierID" Column:Go to the first cell in the "SupplierID" column where you want to populate the data (In this case, it is normally cell T2V2).

    2. In Cell T2V2, enter the following VLOOKUP formula:

Code Block
=VLOOKUP(G3G2,'Vendor Search'!A:C,3,0)

...

Note

  • Make sure that the date format in the saved CSV matches the date format in NetSuite.

  • As for the amounts, ensure that there are no commas.

 

Import of LT Asset Transactions into NetSuite

To import the LT Asset Transactions into NetSuite:

...

  1. Confirmation shall appear at the top of the page. Click on the Import Job Status to check the status of the import.

     

  2. Once complete, verify the import in the LT Asset Transactions list by typing “page: LT Asset Transaction” in the global search.

...

 LT Asset Valuation

Preparing the list of LT Asset Valuation

Below are the steps on how to prepare the LT Asset Valuation data for import into NetSuite:

...

  1. Download the search as a CSV.

...

  1. In column AK (ValuationDate), add the date of valuation. Verify the correctness of the file after download. Make sure that the date format in the CSV file matches the date format in NetSuite and the numbers must not contain commas.

  2. Save the CSV in local drive. The file will be used for import into NetSuite.

Import of LT Asset Valuation into NetSuite

To import the LT Asset Valuation into NetSuite:

...