Use this table to configure the GL items table for invoice export.

This tab is available only when the Active setting is selected on the DB Export Settings - Main tab.

DB GL Items Table

The name of the database table where general leger account line entries are written.

DB GL Items Key

The name of the column in the general ledger export database table, that along with the header level key, represents the key field for each general ledger record. This is typically set to the general ledger item number, such as 1, 2, 3, and so on.

The following buttons are available for the above settings.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.

DB GL Item Mappings

This table lists the GL item mappings for database export and has the following columns.

Field Name

The name of the field.

DB Column Name

The database column that represents the field when exported to a database.

The following button is available to edit table entries.

Edit

Opens a selected entry in the table so that you can make changes as needed.

Click to open the DB GL Item Mapping - Edit window.