Jobs are not being updated in the Project table

Below is a script which you could set up as an SAP Business One alert that is sent to a particular user to indicate the Job ID of a job where a valid project code does not exist.

SELECT EJ.JOBID AS [Job ID], EJ.JOBTITLE AS [Job Title], EJ.PROJECT AS [Expected Project Code] FROM ENPRISE_JOBCOST_JOB EJ WHERE EJ.PROJECT NOT IN ( SELECT PrjCode FROM OPRJ )

From a resolution perspective, the user will have to go and create the project code inside SAP Business One using the Expected Project Code value from the query above.

However, the above is just an interim workaround measure and is not intended to be a solution to this issue.

Please check the following tables:

ENPRISE_JOBCOST_NEWJOBS_TOFORMAT
ENPRISE_JOBCOST_NEWPROJECTS
ENPRISE_JOBCOST_SERVICECALL_UPDATES

These three tables should be empty – these are temporary tables which hold information for the creation of jobs.

If values are found inside these tables, please remove the records.

Check that the user has the correct authorizations: go to Administration > System Initialization > Authorizations > General Authorizations. Go to Administration > Setup > Financials > Projects and make sure that the user has full authorization.