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!

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

Clearing Incomplete PO Requisitions and PO Orders for 4yrs

Status
Not open for further replies.
phillipnc

phillipnc

IS-IT--Management
Mar 8, 2008
15
ZW
What is the best way of clearing Incomplete PO Orders and Requisition which date back to 2007? Currently the client is on 6.0A and they started accumulating Orders and Requisitions when they were on 5.4
 
Sort by date Sort by votes
Write a simple macro that loops through them and either deletes them, or sets quantity ordered to zero.
 
Upvote 0 Downvote
Can you give me an example or the tables which I have to delete from without leaving orphans
 
Upvote 0 Downvote
What if I write an SQL script to update (POPORH1 & 2)tables where ISCOMPLETE = 0
 
Upvote 0 Downvote
Maybe, but I wouldn't do it. Make sure you run DIC for PO to delete orphans.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Raphyy
  • Locked
  • Question
Sage 300 2019 Error Printing Completed PO with popor01.rpt file
Replies
1
Views
273
ettienne
ettienne
vbdbcoder
  • Locked
  • Question
Day End Error (POLINEZ table)
Replies
3
Views
615
vbdbcoder
vbdbcoder
vbdbcoder
  • Locked
  • Question
"Ship All" function does not work for 1 customer
Replies
2
Views
363
vbdbcoder
vbdbcoder
asleypatricia
  • Locked
  • Question
Education: Engage, Learn, and Share Knowledge
Replies
0
Views
177
asleypatricia
asleypatricia
vbdbcoder
  • Locked
  • Question
Can VB6 screen with OCX look like Sage 300 native screen with color theme and flat text box ?
Replies
3
Views
346
vbdbcoder
vbdbcoder

Part and Inventory Search

Sponsor

Back
Top