Features of Financial Elementz from ISC Software: General Ledger Code Import

Financial ElementzThis post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

The General Legder Code Import allows GL accounts to be imported from a CSV file into Microsoft Dynamics GP; it allows the codes to be imported into multiple companies from one CSV file reducing the need for running it multiple times.

The order of the columns in the file are preset, with the following order required:

GL Code import file format

The accepted values for the Posting Type are:

  • Balance Sheet or BS or 0
  • Profit and Loss or PL or 1

The accepted values for the Typical Balance are:

  • Debit or 0
  • Credit or 1

If any other values are supplied, the code will be rejected with a warning.

Once you have the data in the required format, the import is available from the menu in Microsoft Dynamics GP (Financial area page » Cards » Financial Elementz » General Ledger Code Import):

GL Code Import on menu

use the lookup to select the file, mark the First Row Contains Headers checkbox, if required, and click the process button on the action pane:

General Ledger Code Import window

The import will process and report the number of successful and total rows attempted:

Import confirmation

In the same location as the import file, with the same name but with the extension of rjt, an error log containg the accounts with an error along with the error reason will be created:

Error log

All of the successful accounts will have been created in the company designated on the import file; the Intercompany ID column is option; if it is not supplied, the accounts will be loaded into the company into which the user is logged.

GP Elementz from ISC Software

GP Elementz from ISC Software
What add-ons are available?
GP Elementz Portals
Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ
Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ [Video]
Features of PurchaseHQ from ISC Software: Secure access
Features of PurchaseHQ from ISC Software: Secure access [Video]
Features of PurchaseHQ from ISC Software: Configuration
Features of PurchaseHQ from ISC Software: Configuration [Video]
Features of PurchaseHQ from ISC Software: Setup images
Features of PurchaseHQ from ISC Software: Setup images [Video]
Features of PurchaseHQ from ISC Software: Granting users access
Features of PurchaseHQ from ISC Software: Granting users access [Video]
Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition
Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition [Video]
Features of PurchaseHQ from ISC Software: Enter a Purchase Order
Features of PurchaseHQ from ISC Software: Enter a Purchase Order [Video]
Features of PurchaseHQ from ISC Software: View my orders
Features of PurchaseHQ from ISC Software: View my orders [Video]
Features of PurchaseHQ from ISC Software: Workflow Integration
Features of PurchaseHQ from ISC Software: Workflow Integration [Video]
Features of PurchaseHQ from ISC Software: Document Approval
Features of PurchaseHQ from ISC Software: Document Approval [Video]
Features of PurchaseHQ from ISC Software: Receive Goods
Features of PurchaseHQ from ISC Software: Receive Goods [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Overview
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Overview [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) configuration
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) configuration
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) configuration [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Create Approvers
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Create Approvers [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Configure Delegation
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Configure Delegation [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) submit transaction for approval
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) submit transaction for approval [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) in portal
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) in portal [Video]
Features of PurchaseHQ from ISC Software: Free Trial Available
Features of PurchaseHQ from ISC Software: Free Trial Available [Video]
Features of CustomerHQ from ISC Software: Introduction to CustomerHQ
Features of CustomerHQ from ISC Software: Introduction to CustomerHQ [Video]
Features of CustomerHQ from ISC Software: Secure access
Features of CustomerHQ from ISC Software: Secure access [Video]
Features of CustomerHQ from ISC Software: Configuration
Features of CustomerHQ from ISC Software: Configuration [Video]
Features of CustomerHQ from ISC Software: Change images
Features of CustomerHQ from ISC Software: Change images [Video]
Features of CustomerHQ from ISC Software: Manage customer accounts
Features of CustomerHQ from ISC Software: Manage customer accounts [Video]
Features of CustomerHQ from ISC Software: Manage salesperson accounts
Features of CustomerHQ from ISC Software: Manage salesperson accounts [Video]
Features of CustomerHQ from ISC Software: Account Summary
Features of CustomerHQ from ISC Software: Account Summary [Video]
Features of CustomerHQ from ISC Software: View transactions
Features of CustomerHQ from ISC Software: View transactions [Video]
Features of CustomerHQ from ISC Software: View Statements
Features of CustomerHQ from ISC Software: View Statements [Video]
Features of CustomerHQ from ISC Software: Free Trial available
Features of CustomerHQ from ISC Software: Free Trial available [Video]
Features of SalesHQ from ISC Software: Introduction to SalesHQ
Features of SalesHQ from ISC Software: Introduction to SalesHQ [Video]
Features of SalesHQ from ISC Software: Secure access
Features of SalesHQ from ISC Software: Secure access [Video]
Features of SalesHQ from ISC Software: Configuration
Features of SalesHQ from ISC Software: Configuration [Video]
Features of SalesHQ from ISC Software: Change images
Features of SalesHQ from ISC Software: Change images [Video]
Features of SalesHQ from ISC Software: Manage customer accounts
Features of SalesHQ from ISC Software: Manage customer accounts [Video]
Features of SalesHQ from ISC Software: Manage salesperson accounts
Features of SalesHQ from ISC Software: Manage salesperson accounts [Video]
Features of SalesHQ from ISC Software: Account Summary
Features of SalesHQ from ISC Software: Account Summary [Video]
Features of SalesHQ from ISC Software: View transactions
Features of SalesHQ from ISC Software: View transactions [Video]
Features of SalesHQ from ISC Software: View statement
Features of SalesHQ from ISC Software: View statement [Video]
Features of SalesHQ from ISC Software: Inventory Lookup
Features of SalesHQ from ISC Software: Inventory Lookup [Video]
Features of SalesHQ from ISC Software: Price Lookup
Features of SalesHQ from ISC Software: Price Lookup [Video]
Features of SalesHQ from ISC Software: Add Prospect
Features of SalesHQ from ISC Software: Add Prospect [Video]
Features of SalesHQ from ISC Software: Create quote
Features of SalesHQ from ISC Software: Create quote [Video]
Features of SalesHQ from ISC Software: Create order
Features of SalesHQ from ISC Software: Create order [Video]
Features of SalesHQ from ISC Software: Create invoice
Features of SalesHQ from ISC Software: Create invoice [Video]
Features of SalesHQ from ISC Software: Free Trial
Features of SalesHQ from ISC Software: Free Trial [Video]
GP Elementz Add-ins
Features of Enhanced Notes from ISC Software: Introduction to Enhanced Notes
Features of Enhanced Notes from ISC Software: Introduction to Enhanced Notes [Video]
Features of Enhanced Notes from ISC Software: Individual notes
Features of Enhanced Notes from ISC Software: Individual notes [Video]
Features of Enhanced Notes from ISC Software: Categories/Subcategories
Features of Enhanced Notes from ISC Software: Categories/Subcategories [Video]
Features of Enhanced Notes from ISC Software: Assign tasks
Features of Enhanced Notes from ISC Software: Assign tasks [Video]
Features of Enhanced Notes from ISC Software: Available for reporting
Features of Enhanced Notes from ISC Software: Available for reporting [Video]
Features of Enhanced Notes from ISC Software: Free Trial
Features of Enhanced Notes from ISC Software: Free Trial [Video]
Features of Financial Elementz from ISC Software: Introduction to Financial Elementz
Features of Financial Elementz from ISC Software: Introduction to Financial Elementz [Video]
Features of Financial Elementz from ISC Software: Available imports
Features of Financial Elementz from ISC Software: Available imports [Video]
Features of Financial Elementz from ISC Software: General Ledger Code Import
Features of Financial Elementz from ISC Software: General Ledger Code Import [Video]
Features of Financial Elementz from ISC Software: Create General Ledger import
Features of Financial Elementz from ISC Software: Create General Ledger import [Video]
Features of Financial Elementz from ISC Software: Run General Ledger import
Features of Financial Elementz from ISC Software: Run General Ledger import [Video]
Features of Financial Elementz from ISC Software: Create Payables Transaction import
Features of Financial Elementz from ISC Software: Create Payables Transaction import [Video]
Features of Financial Elementz from ISC Software: Run Payables Transaction import
Features of Financial Elementz from ISC Software: Run Payables Transaction import [Video]
Features of Financial Elementz from ISC Software: Create Manual Payments import
Features of Financial Elementz from ISC Software: Create Manual Payments import [Video]
Features of Financial Elementz from ISC Software: Run Manual Payments import
Features of Financial Elementz from ISC Software: Run Manual Payments import [Video]
Features of Financial Elementz from ISC Software: Create Receivables Invoices import
Features of Financial Elementz from ISC Software: Create Receivables Transaction Import [Video]
Features of Financial Elementz from ISC Software: Run Receivables Invoices import
Features of Financial Elementz from ISC Software: Run Receivables Transaction Import [Video]

Features of Financial Elementz from ISC Software

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?





Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *