Sage 500

My end user is getting error Task # XXXX is not defined in task definition tables.

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 anyone know if there are any Sage SQL DF to check for data consistency after SQL Crash Recovery? SQL Server was not committing records to MDF. MDF and LDF are no longer consistent and corrupt. Missing Batch Do you know Sage ever released a Data…

One of my users receives an error when they attempt an update Detail on a recurring invoice. Other aspects of the invoice can be updated, and Detail can be updated for the other companies in our system. This error is triggered on all recurring invoices…

Trying to run Schedule Generation for the first time and i'm getting a few errors. it was going through the steps and stopped at a work order. gave an "Error 5 occurred at frmmfzmn001 in Procedure cmdGenerateSched_Click. Invalid procedure call or argument…

Trying to post a Goods Receipt and get this message during matching. What would cause this?

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…

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…

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…

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…

Is there a way to rebuild tarCustStatus? I looked through a few stored procedures and did not find any that do it (though I did not do an exhaustive search). Our Open Order Amount is wrong for one customer. Thanks

Sage v7.4, Dec11Update A receipt of invoice batch is stuck at postStatus of 200 (module posting started) and batch status of "posting", postError of 0. tapVoucherLog records have status of 2 (pending). The batch is not accessible from Process Receipt…

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…

I've got an item showing QtyOnWO as -42, but don't have any open WOs or pending transactions. I seem to remember that there was a SQL SP to clean up this kind of situation. Any suggestions? thanks

Over the past year or so, I have been tasked with writing data fixes for AR Cash Receipt Transactions that do not have all their records created when they are posted. In all cases it is hit or miss as to what records are not created such as tarCustPmtAppl…