How can I bulk delete or close Purchase Orders?

Question

We have recently started using Sage Inventory Advisor and it has shown us we have some data integrity issues. One area in particular is purchase orders. 
 We have roughly 200 Open purchase orders that have 0 line items on them. From what I've been able to find is that someone started to create a purchase order, left their workstation to so something else, and forgot to finish working on it. How can I simply delete these all at once? 
 The 2nd problem we have is we have roughly 600 purchase orders in backorder status. Some go all they way back to 2002. There's obviously no way that we will fill these backorders. What can I do with these PO's to remove them from backorder status so that they do not appear to be past due? Can I do the process in bulk? 
 
 We are sage 100 advanced (2014)

Mas90Geek · Answer

Matt, there is a utility under Purchase Order | Utilities called Purge Obsolete Purchase Orders. This utility allows you to input an "as of" date. If a purchase order does not have any transactions prior to that date, it will get purged from the system. Be aware that performing this utility does not make any entries to the PO Clearing Account on the General Ledger so once you clean up your PO system and run the Purchases Clearing Report, you will need to perform a journal entry to balance that account to the report.

Mas90Geek · Answer

If the POs were not cleared using that utility that typically means there was a transaction that falls after the cutoff date you input. In those cases, yes, you need to deal with the orders 1 by 1 or expand your cut-off date using the utility. To clear backorder POs the goal is to make the quantity received and quantity invoiced match. You can use receipt of invoice by using a positive or negative quantity at zero dollars. This will achieve the desired result and post a GL entry to PO variance. If a quantity remains in the backorder column, you can perform a receipt of goods entry, answer NO to receive the entire PO then change the backorder quantities to zero. Hope that helps.

Sage 100

How can I bulk delete or close Purchase Orders?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING