@charithalakshan49  You can use UUID() type in the MySQL 

Link: https://www.aspsnippets.com/questions/185273/Solved-How-to-use-UniqueIdentifier-data-type-in-MySql-database/

@Naveen Boga Thanks I will check and will update here. Could you please tell me what is the data type I should use in mysql (Not in microsoft sql server)?

@charithalakshan49   Here is the issue with DAC field (User ID). 

Please change it from String to PXGUID() in DAC  and

nvarchar() to uniqueidentifier in the database

Then it is working fine.

DAC field

  #region Userid
    rPXDBGuid()]
    ]PXUIField(DisplayName = "Userid")]
    public virtual Guid? Userid { get; set; }
    public abstract class userid : PX.Data.BQL.BqlGuid.Field<userid> { }
    #endregion

@Naveen Boga Yes It works for SOOrder.OwnerID and also it works for Contact.UserID.

Yes, for User ID field @me will not work I guess. Please check the OwnerID field from SOOrder table and check

@Naveen Boga Yes, it works fine for deafult acumatica tables. But not for my custom table. I’m storing 

Base.Accessinfo.UserID as UserID column of my custom table.

@charithalakshan49  I have checked the DAC and table script and it is bit different and I’m not what is the data storing in the User ID field.

I have checked for the Default Acumtatica SOOrder with @me and it is working with the OwnerID field. You can refer Owner ID field and verify.

For SOOrder → OwnerID field with @me is working fine.

Hi @Naveen Boga , here is the DAC and db script

@charithalakshan49  It seems that you are using the custom table, can you also share the EmployeeDetails DAC file as well.

Or 

You can share the customization package, if possible. 

@Naveen Boga Yes, here it is

Hi @charithalakshan49  Can you please share the XML format of the GI here? 

@Naveen Boga Thanks for the response. But I could not see the expected results when I am running the GI. It does not show any resulting records.

Hi, @charithalakshan49  You can provide the value as @me and run the GI. The system will not validate it as it is a dynamic variable.

You can click on the VIEW INQUIRY and check that are you getting the proper results or not.