I have a scenario where we have to issue material from the main store to IQC dept and the R & D dept. I have made two different series say IQCREQ and RnDREQ and set the authorization of these for the users so that they can access only these series. Now, I would like to apply an authorization for these users whenever they add inventory transfer document, this document should go for approval. Now I have made this query which I am using for the IQC user;
SELECT T0.[DocNum], T0.[DocDate] FROM OWTR T0 WHERE T0.[Series] ='18'
The problem here is that, instead of sending the document for approval, the system is giving he message " Failed to commit Transaction". Could you please tell me what is wrong here or how do I map this in the system?
Thanks in advance,