Sage 200 Manufacturing - Dupicate Entries in Works Order List and SQL script to remove them

Solution Properties

Solution ID:

200427112427509

Last Modified Date:

Wed Nov 29 14:38:54 UTC 2023

Taxonomy Path:

Case category//How do I...//governmental/legislative compliance

Author:

[email protected]

Sage 200 Manufacturing - Dupicate Entries in Works Order List and SQL script to remove them

Description

Cause

Resolution

These duplicate entries are caused by duplicates in the Calendar table in Microsoft SQL.

Every time the program is opened it checks to ensure it has entries in the Calendar table and if not it populates the Calendar.

On rare occasions, the software fails to read the Calendar table successfully and populates the table with an extra duplicate set of dates. As the Manufacturing list views rely on information from within the Calendar table the entries within them get duplicated.

To resolve the problem:

Get everybody out of Sage 200.
Take a backup of the live data.
Run the SQL script below:
```
DELETE FROM Calendar
```
Open Sage 200 as normal.

Sage Business Partners can now log new cases online!

If you're unable to find the help you require from our online resources, log a new case with us without having to use phone or email. Simply select 'Manage your cases' from the dashboard or visit my.sage.co.uk/cases.

Steps to duplicate