I do not see anyone asking this question so let me give it a shot
What is NetSuite's logic for CLOSED Vendor Purchase Orders ("VPO's")?
1) We create a Vendor Purchase Order
2) For whatever reason the item(s) on the VPO are no longer needed
3) We do not want to delete the VPO because if anyone needs to go looking for it later, they will not find any information.
4) Therefore, we add a note to the SPECIAL INSTRUCTIONS field explaining what happened and why. Then we click the CLOSE button on the VPO.
5) The VPO remains intact, the "On Order" fields are zero'd out the Inventory item(s). It is all good.
6) EXCEPT: The REPORTS>PURCHASES>OPEN PURCHASE ORDERS report continues to show these CLOSED VPO's. No matter what date you put in the "On or Before" date field. The VPO's never drop off the report. The report remains bloated with CLOSED Purchase Orders.
7) Yes, I could customized the standard report by adding a filter to remove the CLOSED VPO's. But that kind of defeats the purpose. Users then have to know to go looking for a Custom report vs. the built-in NetSuite report that is easy to find and use.
So again, my question is, what am I missing? What is NetSuite's best practices for handling Vendor Purchase Orders that are CLOSED?
Thank you for reading.