Project Closing -- "There are unissued or open purchase orders against this project"

Question

When trying to close a certain project/job in Sage 500, my users get this error message: &ldquo;There are unissued or open purchase orders against this project. The project cannot be closed.&rdquo; 
 When they go into the PO module and look at the Open POs for the job, it says: &ldquo;There is no data to print for this report. Report processing canceled.&rdquo; 
 So we're stuck, unable to close the job. 
 Anybody have any experience with an issue like this?

Phil K · Answer

There must be a link in the project table. It could be to a purchase order that was deleted and somehow the update to the project did not occur. If you are familiar with the schema, run the relevant SELECT against the header and detail tables to find the referenced order. Perform an UPDATE to clear the field value. 
 If you run a SQL Profiler trace against the error message, you will be able to see the table queries. Contact your local support team if you need assistance identifying this.

Sage 500

Project Closing -- "There are unissued or open purchase orders against this project"

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING