Correct Import and Posting Errors

If errors are encountered while importing or posting transactions during the Send to Accounting process, an error message displays in the Sage Timberline® Office Background Tasks dialog, such as "Completed with Errors," as shown:

To correct errors and reprocess the reject files:

The Send to Accounting dialog displays an error message in red, such as completed with errors.

1. Click the View Invoice Import Report link in the lower left side and the appropriate Sage Timberline Office Import report for Budgets, Purchase Orders, or Invoices will display to screen.

2. Verify what type of errors have occurred by browsing in the preview screen, or select File > Print to print a hard copy to the printer.

3. Click Close to exit the preview.

4. Click the View Post Report link in the lower left side of the Send to Accounting window and the appropriate Sage Timberline Office Post Report for Budgets, Purchase Orders, or Invoices will display to screen.

5. Verify what type of errors have occurred by browsing in the preview screen, or select File > Print to print a hard copy to the printer.

• • Click the Close button at the bottom of the screen to exit the preview.

  • If the error is relatively simple such as attempting to post to a future period or attempting to post to a closed period, leave the Send to Accounting window open.

  • Open or close periods in Sage Timberline Office as necessary.

6. Click on the Reprocess the Rejects link in the lower right corner of the Send to Accounting window, and verify the rejects processed without errors.  

7. If the error requires editing the data in the reject file, click the View Reject File link in the lower left corner of the Send to Accounting window. The rejects file will open in a text editor as shown.
   
   
   
    

8. Edit the data file in the text editor.

9. Click the Save button, then click Close to exit the text editor.

10. Click the Reprocess the Rejects link in the lower right corner of the Send to Accounting window.  

11. If the reject file imports and posts without errors, follow the steps outlined above for budgets, purchase orders, or invoices.

• If the reject file still contains errors, and more research is required, clickClose to exit.

Reprocessing Reject Files at a Later Date

If the user is absolutely certain that the Send to Accounting process was not run after the creation of the reject file, the user may use the Reprocess Last Reject option.

To reprocess the most recent reject file:

1. Click on the Budgets, Purchase Orders, or Invoices tab.

2. Click the Reprocess Last Reject icon in the toolbar.

This process will reprocess the following files:

1. • Budgets - WMS.JCE located in the Job Cost Transfer directory

   • Purchase Orders - WMS.JCC located in the Job Cost Transfer directory

   • Invoices - WMS.TXT located i the Job Cost Transfer directory.

Each time the Send to Accounting process is run, the existing reject file will be saved to a separate backup directory, and a new reject file (if applicable) will overwrite the last existing reject file in the Job Cost Transfer directory that is designated in Send to Sage Timberline Office Accounting Options .

To process a file other than the most recent reject file (backup file):

1. Click the Reprocess Reject File icon in the toolbar.

The Reprocess Invoice Reject dialog will display the existing backup reject files for the data tab that is currently open within the Send to Accounting screen (Budgets tab, Purchase Orders tab, Invoices tab).

1. • Budgets - Backup files will be located in the \JobCostTransfer\JCEBackup directory, and the backup files will be named in the format of date_time_WMS.JCE.  Example: 06-13-05 05-41-49p WMS.JCE

   • Purchase Orders - Backup files will be located in the \JobCostTransfer\JCCBackup directory, and the backup files will be named in the format of date_time_WMS.JCC.  Example:  06-13-05 05-41-49p WMS.JCC

   • Invoices - Backup files will be located in the JobCostTransfer\INVBackup directory, and the backup files will be named in the format of date_time_WMS_REJECT_Invoices.txt.  Example:  06-13-05 05-29-37a WMS_REJECT_Invoices.txt

2. Click on the reject file name to reprocess.

3. ClickOpen.  

TheSend to Accounting screen processes as normal. Based on the results of the reprocess, follow the steps outlined above for successful import/posting or for correcting additional errors.

If the Send to Accounting Process does not Finish

If the Send to Accounting process takes longer than 30 seconds to process a confirmation message will display. A confirmation message may display multiple times as a result, "BuilderMT has detected that the send to Timberline Accounting process has not completed. Do you wish to continue waiting for this process to end?" Larger files will take longer to process.

To attempt to continue and complete the Send to Accounting process:

1. Click Yes.

2. • If several attempts have been made to complete the process, the user may choose to abort the process. In this case, click No.

If the process was aborted, the Send to Accounting error message appears.

2. Click the Retry the Send to Accounting link in the lower left side of the window to retry the process.

3. Click Close to exit the process.

4. Verify the import files are in the correct format.

5. Verify the data paths used by the Sage Timberline macros are correct.

See Manually Creating Timberline Macros for the Send to Accounting Application for more information on researching and correcting macro issues.

Related Topics

Send to Sage Timberline Accounting

Send Budgets to Sage Timberline Accounting

Send Purchase Orders to Sage Timberline Accounting

Change Supplier for Purchase Order

Delete Purchase Order in Send to Sage Timberline Accounting Screen

Send Invoices to Sage Timberline Accounting

Un-approve an Invoice

Correcting Import and Posting Errors

Manually Creating Timberline Macros for the Send to Sage Timberline Accounting Screen