Skip to main content
Answer

Price code not showing in GI

  • June 9, 2025
  • 1 reply
  • 48 views
bigred1022
Jr Varsity II
Forum|alt.badge.img

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.

Best answer by dcomerford

​@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([ARSalesPrice.CustPriceClassID], [ARSalesPrice.CustomerID] )

1 Attachments

    1 reply

    dcomerford
    Captain II
    Forum|alt.badge.img+15
    • dcomerford
    • Captain II
    • Answer
    • June 10, 2025

    ​@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([ARSalesPrice.CustPriceClassID], [ARSalesPrice.CustomerID] )

    Dermot Comerford
    Chris Hackett
    bigred1022
    M
    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