Skip to main content
Solved

How to get created by user name for Payment voucher Report

  • 10 January 2023
  • 1 reply
  • 80 views

 

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

1 reply

Userlevel 5
Badge +1

Hi, 

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

Reply