Import G/L Accounts
Overview of FW75UPD
DDI-Connect FundWriter allows you to import G/L accounts into your Chart of Accounts. You can use a variety of formats for your source document, including Comma Separated Values (CSV), excel spreadsheet, fixed width and others.
- From the DDI Connect main menu, double-click FundWriter
- Double-click General Ledger Setup
- Double-click Import G/L Accounts. You will see this screen:
In order to import a file, you will first have to configure the Import mapping. Click the button to the right of the Import mapping field:
You will see this screen:
Mappings tab
To add a new table mapping, click the Add button on the toolbar. The fields will activate for editing:
The following fields are available on this screen:
Field | Description |
---|---|
Mapping name | Enter a descriptive mapping name, such as "CSV Format" |
File format | Click the drop down arrow to select the file format that you are setting up |
Header row | If your file contains a header row, select this box |
Click the Fields tab.
Fields tab
When you click the Fields tab, you will see a screen like this:
In the Position column, double-click the field row. The screen will enable like such:
Enter the column position in your spreadsheet for each field listed. Click OK when you have entered the field position. Your screen now appears something like this:
Click Save to retain your changes. If you are done configuring mapping templates, click OK. You will be returned to the Import G/L Accounts screen:
Next, either type the network path and file name for the file you wish to import, or click the folder icon to the right of the field. Select the file you wish to import.
Once you have selected the file, click Load. The system will display the progress in the Import Results area of the screen:
When it is complete, you can click the View Results button to view the results of the import. You can then verify that the account numbers imported properly by searching the Chart of Accounts