Skip to main content
Answer

How to get created by user name for Payment voucher Report

  • January 10, 2023
  • 1 reply
  • 103 views
J
Jr Varsity II
Forum|alt.badge.img

 

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

Best answer by andriikravetskyi35

Hi, 

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

1 reply

andriikravetskyi35
Jr Varsity I
Forum|alt.badge.img+1

Hi, 

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

https://blog.zaletskyy.com || https://acupower.co.uk/posts
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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