Importing Invoices Into Peachtree

To complete the transfer of invoice information from Job Manager to your Peachtree system, you must start the Peachtree application and import the formatted text file exported from Job Manager. Invoice files may be imported into Peachtree via the Select Import/Export window, which can be accessed from the File menu. For more information on the import mechanism and procedures used by Peachtree, please consult your Peachtree documentation.

Importing invoice information into Peachtree

1. Back up your Peachtree database. For information on backing up Peachtree databases, please refer to your Peachtree documentation.
2. From the File menu, choose Select Import/Export. This will open the Select Import/Export window.

1. Select "Sales Journal" from the Accounts Receivable import/export templates listing, then click IMPORT. This will open the Sales Journal window, which allows you to specify the format of and then import text files containing invoice information.

1. Under the Fields tab, specify the format of the invoice information exported from Job Manager. 'Check' the 'Show' checkbox corresponding to each Field that appears in the table below, make sure no other Show checkboxes are 'checked', then use the Move Up and Move Down keys until the values in the "Col #" column match those in the table below.

1. Under the Options tab, click the expander button in the Import/Export file section. This will open a standard Open dialog, allowing you to specify the file you would like to import. In the dialog, locate the formatted text file containing the Job Manager invoice information you would like to import and click Open.

1. 'Check' the "First Row Contains Headings" checkbox in the Import Options section of the window if it is not already 'checked'.
2. To save the file format information and import options you have specified for later imports of Job Manager invoice information, click SAVE, then specify a name and description for the import template and click SAVE in the Save As dialog. The name "Sales Journal - JM" is suggested.

NOTE: The saved import template will be available in the Accounts Receivable import/export templates listing of the Select Import/Export window. To use it, select the import template and click IMPORT to open the import window, then select the appropriate Job Manager formatted text file using the Options tab of the import window and click OK.

1. Click OK. This will import the invoice information from the formatted text file into the Peachtree system.

NOTE: The Peachtree Invoice/CM # field for each invoice exported from Job Manager is set to the Job Manager Invoice Number prefixed with "JM-". Upon import of invoice information, Peachtree uses the Invoice/CM # field to determine whether to use the invoice information in the formatted text file to update a pre-existing invoice or to create a new one. When updating an invoice record, Peachtree deletes all of the previously defined invoice information and replaces it with the information in the formatted text file. The "JM-" prefix eliminates the risk of invoices created in Peachtree being overwritten with Job Manager.