Solution Properties
Solution ID:
222924450019960
Last Modified Date:
Thu Mar 23 19:05:46 UTC 2023
Taxonomy Path:
Case category//How do I...
Author:
sageadmin
Error: "Failed to retrieve data from the database" when printing commitments in Job Cost or Project Management
Description
Cause
Resolution
To update your Crystal report design, click the link below. To change the descriptions on the header of your purchase orders, follow the steps below.
  1. From the Job Cost Tasks or Project Management Contract Control menu, select Commitments.
  2. Enter a Purchase Order ID or select one from the List.
  3. Click Header and review the Misc fields. The default descriptions should read:
    • Ordered By
    • Terms
    • Ship Via
    • Free on Board
    • Misc Alpha 5
    • Delivery Date
    • Misc Date 2
    • Misc Date 3

    If the field descriptions do not match those listed above, click Change Desc to change the field descriptions.

  4. Click OK, then Save Commitment, then Close.

DocLink: How do I use the Set Location and Verify Database features for Crystal reports or subreports that use an ODBC DSN?
DocLink: Error: "Failed to retrieve data from the Database" (Troubleshooting)
Defect ID
Steps to duplicate
Related Articles