Need help in Generic Inquiry with Customer field

  • 31 July 2023
  • 3 replies

Userlevel 2

Hello, in Sales Order GI, the customer CD and Customer Name are displayed from the SOOrder Object.

Object:SOOrder and Data Field:CustomerID this gives us customer cd, but when we use same in if condition it is giving us customer DB ID. Can someone please help us. We know we can join BAccount table but can i get customer cd without joining BAccount table.

=IIf([SOOrder.CustomerID] >0 , [SOOrder.CustomerID], '0') here the result is Customer DB ID


Best answer by darylbowman 31 July 2023, 15:29

View original

3 replies

Badge +12

The correct way to do this would be to join the Customer table and use Customer.AcctCD. Is there a reason why you do not want to join extra tables?

Userlevel 2

Hello @darylbowman, no reason,  just want to make sure that not making any mistakes by joining extra tables.

Badge +12

Then I would join Customer on SOOrder.customerID = Customer.BAccountID and use Customer.AcctCD in your conditions.


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