Issue:
Receiving error when trying to close a job. Error received is “Error Checking for Parts Issued and Reconciled! 94 Invalid use of Null
Resolution:
Most commonly, this error is caused by missing part detail. You can usually see this in the Parts Reconcile screen of a job.
Take note of the parts that are missing their detail, go to Inventory > Parts.
Open the parts that are missing their detail and edit them. Add some kind of detail to the part and save the change.
Close the job and reopen it to allow the part detail to refresh.
You should now be able to close the job.
If you suspect that there are more parts in your system that are missing part detail and wish to find them before running into this error, you can run a script through the SQL Query tool in SedonaOffice.
Go to, either the button in the toolbar labeled SQL and click on it to open the tool,
Or, go to the option in the toolbar labeled Query and select the option SQL Query
This will open the SQL Query tool window.
Paste or type in the following query:
select part_id,part_code,description,detail from in_part where detail is null or detail = ''
Then either tap the enter key on your keyboard or use the green error to the far right under the query entry field.
If there are any parts in your system that are missing their detail, they will appear in the results window.
You can update the parts by going to Inventory > Parts. Select the parts that need to be edited to add detail.
Once detail is added, save the change.