Summary
Importing IDI General Ledger transactions into NetSuite is a process that allows you to transfer your accounts receivable data into your NetSuite Financials environment. This allows you reconcile all your accounts and generate financial reports for your enterprise.
To import IDI General Ledger transactions into NetSuite, a CSV file of your transaction data is exported from IDI’s General Ledger module. This file then cam be easily imported using NetSuite’s Import Assistant.
Exporting IDI General Ledger Transactions
IDI’s General Ledger module contains a library of reports that help you manage your accounts receivable. All these reports can be accessed at CostGuard->BackOffice Management->General Ledger->Reports.
The best report for importing into NetSuite is the General Ledger Journal Entries – Details report. This report provides details by G/L category for transactions that occurred during account posting, invoicing and other day to day financial activities.
Running the report provides the user with options to filter the results by date, G/L category, or G/L code. The most common export scenario is to generate transactions detail for a calendar month after the G/L for that month has been closed within IDI. Once the report has been run, the option to export the transactions to a .CSV will be displayed. The .CSV file will be created at the location specified by the user.
General Ledger Export Fields
These are the fields exported in the General Ledger Journal Entries – Details report:
Field | Description |
|---|---|
Posted Date | Date the journal entry was posted |
Entry Type | Type of GL journal entry (Default, Accrual, Revenue Setup, Tax Setup, Accrual Reversal) |
Journal Entry Description | Text of the GL journal entry |
GL Account Code | Unique code representing the general ledger account |
GL Account Description | Description of the GL account code |
GL Subcode | Name of the GL Subcode that further defines the GL Account Code |
Debit Amount | Dollar amount debited under the GL account code |
Credit Amount | Dollar amount credited under the GL account code |
GL Category | Grouping of general ledger accounts (Asset, Liability, Revenue, etc.) |
GL Subcategory | Lower level grouping of general ledger accounts within a GL category (Accounts Payable, Accounts Receivable, Expense, etc.) |
GL Subcategory Type | Type of GL subcategory (Billing or POS) as of today |
Created Date | Internal system date of the journal entry creation |
Posted Year | Year the journal entry was posted |
Posted Month | Month the journal entry was posted |
Modified Date | Date and time of the last change |
Journal Entry ID | ID number of the journal entry |
Importing Transaction in NetSuite
NetSuite’s Import Assistant can be used to easily import the IDI G/L transaction data into your environment.
NetSuite Applications Suite – Importing CSV Files with the Import Assistant (oracle.com)
For IDI G/L transaction data, select an Import Type of ‘Transactions’ and a Record Type of ‘Journal Entry Import’.
The available import fields may vary depending on the NetSuite ledger form you are using.
For more information on importing ledger journal entry records in NetSuite you can refer to:
NetSuite Applications Suite – Journal Entry CSV Files (oracle.com)
For more information on mapping fields during the CSV import process in NetSuite you can refer to:
NetSuite Applications Suite – Step Four Field Mapping (oracle.com)