Skip to main content

Hello,

I am trying to have a GI show the value for ARSalesPrice.PriceCode and I keep getting no results.

We have two codes (Default and Westcoast). 

 

The “Sales Prices” screen (AR202000) shows them perfectly fine.  But it requires the user to choose from all of the filters.

 

I have tried all kinds of joins and conditions, yet they just will not display.  I have attached the GI and any help would be greatly appreciated.

​@bigred1022 That field does not exist in the database you would need to add the CustomerID and the CustPriceClassID as columns or use a Switch to maybe show them in one column

=IsNull(uARSalesPrice.CustPriceClassID], DARSalesPrice.CustomerID] )

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