Sage 100

v2016 - Looking for the nuclear option for purging PO's. Client has lots of PO's that will not purge due to issues with ROG or ROI mismatches. In the good old days, one could import the complete flag and date so they would fall out the table naturally but this is not a framework option now. I tried purging obsolete PO's. That eliminated 26 records. Only have 150 to go. I would rather NOT DFDM. Data dictionary hack??? Thanks in advance.

How long are they retaining completed PO's? It's supposed to purge any PO's entered before the date entered.

I sometimes take the AP invoice check box off - then purge and see how many are left due to ROG. I am assuming you are doing old PO's that the AP check box would not effect the newer ones.

Use an appropriate date for your customer. I typically use VI to update the Purchase Order Date (11/11/2011), and the PO Last Received Date (11/11/2011), and the Order Status (X) on the PO Header. Then use the Utility to Purge Obsolete Purchase Orders with a Date on or before 11/11/2011. Works like a charm; even if the PO has been partially received.

I once wrote a 'dirty' BOI script that overwrote the Quantity fields for a PO range so that the system thought they were complete, but I like @MadelineStefanou's better.

@MadelineStefanou - Either old age has addled my mind or I am not seeing what you are saying. I am looking at VI for PO header. While there is a last received date showing in the file spec, it is not appearing in the VI list of available fields. PO Status and Completion Date are available. when I import just the status (X) and a completion date, the status is rejected as ""Invalid Order Status for this purchase order"". This is exactly the same outcome that I experienced back in v4.4 when PO was moved to the framework. Help!!

I've modified the Providex.ddf and Providex.dde files before to expose fields not available in VI, but I'd definitely keep a backup of the original in case of unexpected consequences.

I am starting to think that is the only way it can be done unless @MadelineStefanou can post her secret to the sauce. @KathrynForadori could you post the fields and changes necessary to do this? I am thinking order status and completion date should allow me to purge via the completed PO utility.

Not sure this will solve the Status validation issue, but it will allow you to access the PO Last Receipt Date the way Madeline's post describes. Step 1 - find the table Key 1.DFDM > Providex.ddf 2.Key No: ByName 3.Click on Key Scan 4.Find data table [Key] to change/modify: PO_PurchaseOrderHeader and select it 5.Change Key No. Primary Key 6.Write down the Key=[xxxxxx] Step 2 - modify the table Field 1.DFDM > Providex.dde 2.Click on Key Scan 3.Search = Key Value (from step 1, Line 6] 4.From the list select the Key to change e.g. LastReceiptDate Key=000365000046 5.Click on the Edit button 6.Field Number = 20, Starting Position = 1, Length = 15 (the field to be change will be display, so the value can be change to: 0 7.Change = from 1 to 0 8.Click on OK and close DFDM Step 3 - bring the field into VI 1.Create a new V/I import template 2.Select Table Name: PO_PurchaseOrderHeader 3.Go to Tab2 [Data] and notice the LastReceiptDate is now available.

Hmmm... sorry, I have been MIA. I thought I had a method to get around the ""X"" setting for complete, but can't find my notes now on how I got around that issue.