Sage 100

 View Only

  • 1.  v4.5 - Cash Receipts Report Standard report setting is corrupt for one user in multiple companies.

    Posted 04-05-2022 19:37
    In SY_ReportSetting, I found a  matching record, which I deleted, but when I logged in with her and asked her to launch the report, the "bad" record appeared.  I did a data dump of SY_ReportSetting for the Cash Receipts reports and that record is no longer present.  I can tell which one it was because the Description is a "phantom" description for her and her workstation was associated with it.  Where is it pulling that record?  Is there another file I missed?

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------


  • 2.  RE: v4.5 - Cash Receipts Report Standard report setting is corrupt for one user in multiple companies.

    Posted 04-05-2022 19:40
    See this Sage City post where I listed the different tables to go through for something similar.
    Link

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: v4.5 - Cash Receipts Report Standard report setting is corrupt for one user in multiple companies.

    Posted 04-05-2022 19:51
    Thanks Kevin, I was searching for that list of files.  I had already searched SY_LastFormUsed, which is only forms, and SY_ReportOptions, but didn't find anything in them, or in the rest of the files in the list.

    The only report setting in all companies is STANDARD.  I'm wondering if it's safe to delete all records for that report in SY_ReportSetting, SY_ReportOption.

    Thoughts?

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 4.  RE: v4.5 - Cash Receipts Report Standard report setting is corrupt for one user in multiple companies.

    Posted 04-06-2022 11:17
    Generally speaking, I consider it "safe" to delete any records with a workstation / user key / non-zero company key. The others may be needed as system defaults.
    What's corrupted?  Is there an error?  Perhaps something is misconfigured with ODBC security?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


  • 5.  RE: v4.5 - Cash Receipts Report Standard report setting is corrupt for one user in multiple companies.

    Posted 04-08-2022 11:16
    There is no error.  The description that shows up on the STANDARD form code is something other than "Cash Receipts Report" and the Collate button is unchecked.  When run, the results are inaccurate (I think it's something like only 1 invoice appears - the newest invoice - for each customer).  I searched folders for a report template (other than MAS90\Reports), but there are none.  I created a new report setting , but I'd sure like to figure out what's going on.  A strange one.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


Related Content