Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53705 - 07/31/18 08:44 AM Purchase Orders
McPoirier
Member


Registered: 07/31/18
Posts: 2
Loc: Ottawa, On
I have someone who is has been using the PO module since 2006 and has about 40,000 old POs that are not completed.

When going to delete the old POs, one of the messages that comes up is unformatted item 1 does not exist. When checking the setup, they allow non inventory items. We logged in as admin and the icon for items is not in setup.

It is Sage 300 version 2018 with Product update 1 installed. They do not have inventory control installed.

Any ideas as to how to get rid of this message would be appreciated.

Top
#53706 - 07/31/18 08:46 AM Re: Purchase Orders [Re: McPoirier]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7664
Loc: Location, Location
Use a database editor, delete all the appropriate POPORH1 records, then run Data Integrity with Fix Errors on, and the Orphan records box checked.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53707 - 07/31/18 09:02 AM Re: Purchase Orders [Re: Jay Converse]
McPoirier
Member


Registered: 07/31/18
Posts: 2
Loc: Ottawa, On
Thank you.
Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: