Hi,
We need to add created by user name into payment voucher report is acumetica.
We try to join ApPayment and Users Table.
ApPayment has CreatedByID and User table has username field.
Below screen shots attached for the reference.
ApPayment Table
Users Table
We join these table using report builder below like that.
After the report complied it shows below error. Because CreatedById is uniqueidentifier type and user name is nvarchar type.
Can you give the solution to get createdby name for the apPayment transactions is Payment Voucher Report.
Thank you