Skip to Content
0
Former Member
Feb 11, 2010 at 04:41 AM

Scenario

13 Views

Hi All,

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,

Joseph