You’re offline. This is a read only version of the page.
207
I want to purge several old projects but when I run analysis I get message the projects contain record(s) in the invoice detail table (PJINVDET) with a selected or unbilled status. These projects were started in legacy system with summary information imported into DSL. Checking the detail shows offsetting entries resulting in -0- balance. Can I change the entry values to -0- through SQL? If so, what other tables would I need to adjust?
DSL version 7, SQL 2009 R2.
Jeanne Fischer
*This post is locked for comments
I have the same question (0)
Dear Jeanne,
You can update the Pjinvdet.Bill_status field to B (indicating that the item has been billed.
You can update the Pjinvhdr.inv_status field to PO
the where clause on the sql statement should include the draft_num of the invoice in question.
Share
Report
All responses (
Answers (
