Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Receiving Inspection Setup - Open PO's work around using SQL?

Status
Not open for further replies.

JBHILLS

Technical User
Nov 9, 2012
15
US
We had success on a new Company DB using receiving inspection. We wanted to migrate this process to a another DB. The Setup requires that there are no Open PO's! We have 10's of thousands open. Many we can't move to history or delete because they were maintenance parts and we did not have any receipts, but were referenced when we paid on them.
What is the best practice in this case for a SQL work around? (Obviously We don't want to mess up the GL with novice SQL scripts and will work with our third party provider) Just looking at what is the Level of Effort and scope at this stage? Macola 9.6.500
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top