Sage 100

MAS 4.5 - Cleaning up the open PO file - Has anyone figured out a quick way of doing this? Client has open PO's dating back to 2009. Most of the lines are /misc lines that need to be received or paid for or the Qty for all three fields (ordered, received, paid) don't match. Prior to V4.4, I would import the PO #, flag it as completed and set the completed date via VI and everything would disappear during the close. Now the BF in VI won't allow this. Changing the fields via DFDM is not a productive use of time. Would anyone be willing to write a utility that would read a CSV file of PO #'s and completed dates that would work in the same manner as VI? Perhaps the group members would be willing to share in the development costs. Just a thought. LMK as I can't believe I have the only clients that don't process the PO's as Sage expects them to.

I mostly use the Purge Obsolete POs to clean it up.

I'm sure Randy has this in his bag of tricks...

If they don't have a lot of real open P/O's, you may wish to consider Reinitializing and having the client re-enter the real ones.

What is the definition of Obsolete? Based on a date? Yesm, I know, I could read the manual but too busy getting ready to go on vacation where I'll spend half my time on phone support................

I'm with Beth, wouldnt purge obsolete POs take care of it?

Ugghh. Did they just add this in v4.5, PU 3?

If it makes you feel better, I'll say yes. If t won't, then no.

LOL - let me check my 3.71 - YEP, it's there!

One thing to know about the Obsolete - it's not looking at just the Order Date. It looks at ROG and ROI dates, as well, so whichever is the most recent date is what it uses. WHICH means sometimes when clients call me after they've been trying to clean it up themselves, they have a bunch of old POs with recent ROG/ROI dates and it doesn't help clear those out.

And here I was willing to save him the embarrassment.

Don't worry Jeff I hassled with this same thing a few years back. Purchase clearing is an almost impossible thing to reconcile for many people. If you need help with support while on vacation send an email

Thanks. But isn't that what your smartphone is for? Never out of the office.................

Overview Use Purge Obsolete Purchase Orders to remove all obsolete purchase orders whose purchase order date, last receipt date, last issue date, or last invoice date are on or prior to the entered date to provide additional file space in the Open Purchase Order file. A purchase order is obsolete if the following date properties are on or prior to the purge date entered: Purchase order date Last receipt date Last issue date Last purchase order date Last invoice date