Difference between revisions of "Import G/L Accounts"
(Created page with "=='''Overview of FW75UPD'''== Category:FundWriter") |
|||
Line 1: | Line 1: | ||
=='''Overview of FW75UPD'''== | =='''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: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 1.png]] | ||
+ | |||
+ | |||
+ | 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: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 2.png]] | ||
+ | |||
+ | |||
+ | You will see this screen: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 3.png]] | ||
+ | |||
+ | |||
+ | ===Mappings tab=== | ||
+ | |||
+ | |||
+ | To add a new table mapping, click the Add button on the toolbar. The fields will activate for editing: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 4.png]] | ||
+ | |||
+ | |||
+ | The following fields are available on this screen: | ||
+ | |||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! '''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: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 5.png]] | ||
+ | |||
+ | |||
+ | In the Position column, double-click the field row. The screen will enable like such: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 6.png]] | ||
+ | |||
+ | |||
+ | 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: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 7.png]] | ||
+ | |||
+ | |||
+ | 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: | ||
+ | |||
+ | |||
+ | [[File:Import GL Accounts 8.png | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
[[Category:FundWriter]] | [[Category:FundWriter]] |
Revision as of 18:15, 27 August 2012
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:
[[File:Import GL Accounts 8.png