Knowledgebase
(10)OPERA (24)Downloads (1)Call Escalation Procedure (9)Vision for Opera (11)Material Control (3)E-Invoicing (FATOORAH) (1)Opera Reports (1)Opera Backup Office Interface OPERA Cloud (1)SolutionIP (14)Micros (2)Simphony VAT (3)Suite 8 (78)Sun Systems
SEARCH
Knowledgebase: Sun Systems > Sun 6.X
How to clear Allocation in Progress
Posted by Syed Qutubuddin on 09 December 2015 04:31 PM

use this sql statement to figure out what are the account are in progress

SELECT * FROM ZZZ_ACNT WHERE ALLOCN_IN_PROGRESS = '1';

then use this statement to release the allocation in progress

UPDATE ZZZ_ACNT SET ALLOCN_IN_PROGRESS = '0' WHERE ALLOCN_IN_PROGRESS = '1';
ZZZ= BU CODE

 

 

(2 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).