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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
IC Day end
- Thread starter Zak2009
- Start date
- Thread starter
- #3
Jay Converse
Programmer
Run RVSPY to diagnose, and make sure you have PU1 installed.
Hi,l'm running Accpac 55.l get the error below :Invalid po type(1710 POPORZ1.C)l have run RVSpy but and found that there was one Purchase order that had a header only and no detail. l then went into SQL run a query to get the PO number . l managed to get the PO number and then went into Accpac PO. l managed to pick up that order and really found out that the detail was missing and the PO type was wrong. l then deleted that PO from Accpac within PO's . l'm still receiving the same message . Could anyone assist because now l don't know what could be the problem . Below are the tables that where affected below and after deleting that PO it was not appearing within these tables aswell.POPORH1,POPORHO,POPORH2,POPORL Please please assist if you can guys.
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Check Out Our Whitepaper Library. Click Here.
ettienne (TechnicalUser) 24 Feb 11 15:59
Delete the first record in POPORI.
Thank ettienne
for this valuable post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
NKOS13 (TechnicalUser) 24 Feb 11 16:49
Thanks alot it worked.l really appreciate your support,For reference purposes tell me . Does what l did 1st help or only the deleting of the 1st record in POPORI.Thanks once again.
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
ettienne (TechnicalUser) 24 Feb 11 17:06
IC day end processes all POs in the POPORI table, if you remove the record from the POPORI table then it skips that PO. IC day end deletes the records from POPORI as it processes them, so that is why I said delete the first record.You fixed part of the problem, the last piece was in the POPORI table.
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Check Out Our Whitepaper Library. Click Here.
ettienne (TechnicalUser) 24 Feb 11 15:59
Delete the first record in POPORI.
Thank ettienne
for this valuable post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
NKOS13 (TechnicalUser) 24 Feb 11 16:49
Thanks alot it worked.l really appreciate your support,For reference purposes tell me . Does what l did 1st help or only the deleting of the 1st record in POPORI.Thanks once again.
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
ettienne (TechnicalUser) 24 Feb 11 17:06
IC day end processes all POs in the POPORI table, if you remove the record from the POPORI table then it skips that PO. IC day end deletes the records from POPORI as it processes them, so that is why I said delete the first record.You fixed part of the problem, the last piece was in the POPORI table.
- Status