Importing Invoice Numbers

Docx > Importing Invoice Numbers

Importing invoice number to G/L records

Overview:

The purpose of this process is to enable Docx to perform a mass update on the general ledger records.  The user will supply an Excel file containing a list of check numbers and their related invoice numbers.  The system will then mark each check (G/L side) in the bank reconciliation system with the appropriate invoice number.

The user will supply an Excel file for the import process containing:

Check number (numeric only)

Invoice number (alphanumeric)

Importing a file:

From the main menu 'Import', then 'Update checks with Invoice #'s'.

Using a standard 'point and click' file selection box, the user will select the Excel file to import.    The system will trigger the update process (next).  The user will import one file for each account.

Update process:

The system will take each check number in the Excel file and attempt to find a match in the Check Number field of the General Ledger records.

Once a matching record is found, the system will enter the appropriate invoice number.

Reporting:

The invoice number will be contained in the 'Follow up' field.

Notes:

--Either the 'Invoice' or 'Text1' field may be used to import the invoice number.  The invoice number will reside in the 'Follow up' field of the G/L transaction.

--Only the invoice (or text1) and Check Number field should be mapped.

Page url: http://www.treasurysoftware.com/custom_users/docx248/index.html?paid_checks.htm