Skip to main content

 

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

Hi, 

you need change “Child Field” to PKID value, it is Guid type column in Users table


Reply