Error in Reports when printing or emailing invoices with tracking number

Overview

You want to include the tracking number when printing or emailing invoices to customers but it causes an Error in Reports. This happens on all workstations.

The error details are:

Error Number  : 588
Error Message : Error:722 Error in File C:\ProgramData\Everest\Temp\Mul5A44.tmp:
The rowset column could not be found.
Execute <PEStartPrintJob>

Error Source  : PrintDocumentDialog

Solution

This issue can be resolved by updating the FETCH_SHIPMENT_TRACKING_DETAILS stored procedure. To do so, please follow the steps below:

1. Open SQL Server Management Studio on your database server.
2. (Optional) Enable line numbers in the SQL Editor:
   1. Navigate to Tools > Options.
   2. In the Options dialog box, expand Text Editor > Transact-SQL and choose General.
   3. Check Line Numbers and click on OK.
3. In the Object Explorer panel, expand your company database, then Programmability > Stored Procedures.
4. Locate the dbo.FETCH_SHIPMENT_TRACKING_DETAILS stored procedure.
5. Right-click on the procedure and choose Modify.
6. Modify line 51 by adding  AND STATUS = @DOC_TYPE:
   
7. Also, make sure the ESTDATE as DELIVERY_DATE & DELIV_METH as DELIVERY_METHOD written in the select statement of line 51
8. To test the syntax, navigate to Query > Parse.
9. To save the modifications to the procedure definition, navigate to Query > Execute.

Testing

After updating the stored procedure, the error will not trigger when printing or emailing invoices with tracking numbers. If the issue persists, contact support.