Solved

How to get created by user name for Payment voucher Report

  • 10 January 2023
  • 1 reply
  • 71 views

Userlevel 3
Badge

 

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

icon

Best answer by andriikravetskyi35 10 January 2023, 09:11

View original

1 reply

Userlevel 5
Badge +1

Hi, 

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved