Moving this post to the Sage 50 Canada Support Group since it was posted in the incorrect forum.

Thanks,

Derek

MLEWIS27 said:

"One or more Projects on line 1 have been removed".

Whether intentionally, by accident, or by random data corruption, the Project is missing.

I haven't had the problem, but I can tell you that Projects are linked by ID from the transaction back to a list of Projects.  If a project had been deleted, re-creating a project with exactly the same name won't reconnect it because it will have a different ID

MLEWIS27 said:

We did not remove the allocation.

It may be necessary to restore a backup of the data from before the error started to show up.   It may also be possible to do data repair on your current books to re-insert the Project name back into the company data, but then it would be very helpful to have a backup of the 'prior' books to reference.   There are some companies providing data repair on Sage 50 Canadian books as a service.

Running Database Maintenance (after making a backup) may get it back as well, or it may just permanently remove all the Project transactions that don't reference a valid Project.

I hope that helps, please post back.

Thank you RandyW.

There were a few projects affected but they were not deleted only renamed.  We did Data Maintenance and it did not correct it.  We had to manually correct each entry.  For entries from the prior year, we could not correct the "Unknown Project" allocation that were payroll items which is a problem.   

We found all of the "Unknown Project " allocations by running the Journal Entries report for year and used the Find on this page option to find all of the errors.  Now, it seems that since you cannot print a report for :"Unknown Project:  codes, I will have to run the  Journal Entry report in addition to the Unallocated Report each time we do a billing.  This error concerns me.

Thank you for your assistance!

MLEWIS27 said:

For entries from the prior year, we could not correct the "Unknown Project" allocation that were payroll items which is a problem.   

The only way to correct all entries without re-entering everything is by doing 'data repair', by which I mean putting the missing project back onto the list, and re-creating any missing entries.  If you're familiar with vLookup in Excel, Project data is looked up by ID when a report is run, just as in Excel, it is 'looked up' in a master list.

MLEWIS27 said:

Now, it seems that since you cannot print a report for :"Unknown Project:  codes, I will have to run the  Journal Entry report in addition to the Unallocated Report each time we do a billing.

The only way to get that information would be from a backup or a custom report,

The only way to completely fix it is by having the data repaired, or starting over with re-entering transactions since the last backup where it was intact.

Depending on how you do your report, you may be able to set up the starting balances in a new Project record from a prior report (although that may not give you the detail you need) and / or set up your Excel report to use static prior years' data.

MLEWIS27 said:

We did Data Maintenance and it did not correct it.

The Data Maintenance tool is a brute force way of removing invalid information.  If only the master record was damaged, it can remove all the detail records connected with it (sounds like it didn't, or they would be 'unallocated' rather than 'Unknown Project'.

By the way, I'm not with Sage Software, their technical support may be aware of additional technical issues / solutions.