• Template Tables versus Temporary Work Tables
• Crystal Wrk template tables like SO_InvoiceWrk, IM_ValuationReportWrk, or GL_TrialBalanceWrk, etc. are empty templates used by Sage 100 ERP to create new temporary work tables.
• These new temporary files are created and populated after the Print or Preview button is clicked from a report or form task windows (e.g. S/O Invoice Printing, Inventory Valuation Report, or General Ledger Trial Balance, respectively).
• Crystal Wrk template tables or files remains empty. The new temporary work file use the following naming convention:
  • Format: [Work Table Name]+[Sage 100 ERP User Code]+[Month]+[Day]+[Decimal Time]+[.m4t]
    • Examples: SO_InvoiceWrkUSR123112840686.m4t, PO_PurchaseHistoryWrkJSM060509123456.m4t, etc.
• Once the report is printed, Sage 100 ERP sends a command to the operating system to delete the new temporary work table.

When creating custom Crystal Reports, either:

• Create a new form code or report setting from within the task window (e.g. in Sales Order Invoice Printing) and modify the Crystal Report, or
• Create a new report, but don't use a Crystal Wrk template table. Instead pull from source tables than hold the information desired:
  • Examples: Use SO_InvoiceHeader and SO_InvoiceDetail instead of SO_InvoiceWrk, use PO_PurchaseHistory instead of PO_PurchaseHistoryWrk, etc.)

Also:

• Verify that the table being used actually exists (if it is missing, that can be the cause of error).
• Example:
1. The Crystal Report table is GL_ChartofAccountsWrk
2. In Windows Explorer, open "..\MAS90\MAS_XXX\GLXXX" (where "XXX" is the company code)
3. Verify that GL_ChartofAccountsWrk.m4t exists. If it does not, then depending on the type of data file it is, consider copying in a replacement from another company code, or restore a copy from backup