Sage 100

MAS200 v 4.40.0.1 and client has thousands of open PO's dating back to 2004 that are still open for various reasons. They do not want to purge them, but rather just mark them as complete. We attempted a VI Job to change the quantities (BO to 0, and Invoiced to equal Qty Ordered) to complete the line, and close out the PO but no luck, it doesn't appear the status can be changed with VI. Is there another method anyone has used to successfully change the status of a PO other than manually going in and changing it in DFDM?

Did you try doing the VI job and including the line numbers in a test company?

You might want to check with a Master Developer for some one-off code for this. Would surely beat DFDM...Randy M. may have some ideas for you.

You can do the PO lines stuff with BOI scripting. I've done something similar in SO before. But I'm pretty sure it can be done in VI if you pass it the line number too.

@RobertWood - Is there a way to just change the status to X with VI? The field is not read only in the back end (providex.dde), but it bombs when you run the import. Must be some vaidation logic preventing this on the VI job - is the only option custom programming?

@EricAnderson I don't think you can with VI because there is logic preventing it.

However the PO becomes complete, eventually it will be purged based on the # days to retain completed POs. I'm sure you know that bypassing reg. completion methods with VI will leave a reconciliation issue with purchase clearing/purchase variance accounts. Why not export the backordered POs detail and create imports to receipt of goods or invoice to complete them?