File Doctor deleted records with one of the following errors:

Note: The negative number may be any negative number, not just -1 in the examples below.

• "Field "Sequence Number" with "-1" invalid: Negative valued not allowed. Record deleted. Primary key field has a critical error."
• "Field "Sequence Number" with "0" invalid: Zero value not allowed. Record deleted. Primary key field has a critical error."
• "Field "Run Number" with "0" invalid: Zero value not allowed. Record deleted. Primary key field has a critical error."
• "Field "Run Number" with "-1" invalid: Negative valued not allowed. Record deleted. Primary key field has a critical error."
• "Field "payment id" with "0" invalid: Zero value not allowed. Record deleted. Primary key field has a critical error."
• "Field "payment id" with "-1" invalid: Negative value not allowed. Record deleted. Primary key field has critical error.

1. Review the File Doctor journal to confirm the issue.
2. Restore data to a backup before File Doctor was ran then get a file fix before running File Doctor again. When restoring to a backup, the entire company data folder must be restored (not just AP). Refer to How do I restore my data files? for more information.
3. Contact Sage 300 Construction and Real Estate Support to request a file fix.

If you are unable to restore to a backup prior to the File Doctor, you will still need a file fix although it may take longer as the deleted transactions will need to be recreated. Please provide the File Doctor journal for the file fix.