• Error Sage

    My end user is getting error Task # XXXX is not defined in task definition tables.
  • Sage 500 KB Datafixes Download

    There are a few KB on Sage's support site. That indicate a Data Fix but no download file is available for download. Is there a link anywhere to download all?
  • Does MRP Generation look at Purchase order tables?

    When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…
  • Missing primary key constraints on tciCarton.CartonKey

    Can somebody take a look at their database, and verify the following? I'm on Sage 500 2016 January 2018 MU (i.e. 7.70.6.0). tciCarton contains CartonKey, but it is NOT a primary key, nor are any constraints. As a result, I've got a few duplicate…
  • Invalid characters in Item and SO ids

    We are running into issues where a user copies a part ID from an excel sheet only to get a space at the end of the item ID or SO tranno. Sage support didn't have a good suggestion to keep this from happening. Has anyone else run into this? If so what…
  • v7.4 Sales Order - Phantom Line - Exists but Blank

    I have a Sales Order that I'm trying to close but cannot. There are two lines in the SO. You can see this correctly in all Inventory Transaction Tables and Explorer View (Sales Order Lines). However, on the enter Sales Order screen. It shows three Line…
  • Inventory Discrepancies

    I'd like to start some discussion around inventory discrepancies and how to identify and correct them. I've searched around and seen various threads, but thought we might be able to aggregate some information here. We're looking at doing a periodic correction…