Skip to main content

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

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

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

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?

Reply


Terms & ConditionsCookie settings
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