Skip to main content
Question

Referencing a relatable but differnent price class

  • July 14, 2026
  • 1 reply
  • 23 views

Forum|alt.badge.img+1

I am developing a GI where I need to change pricing of items on sales orders based on customer price classes. 

For example: 

If a customer has a customer price class of CUSTOMER, I need to reference the price of an item associated with COMPCUSTOMER. COMPCUSTOMER will never be a customer price class that we actually designated to a customer, but it’s more of a reference.  I’ve been trying to create a reference GI for my main GI to use but because you can’t use formula fields as relation link I’m a little stuck. 

1 reply

lauraj46
Captain II
Forum|alt.badge.img+9
  • Captain II
  • July 15, 2026

Hi ​@SBaldwin ,

You can add the ARSalesPrice DAC to the GI twice, and use a join similar to this:

ARSalesPrice.CustPriceClassID=CompSalesPrice.'Comp'+[CompSalesPrice.CustPriceClassID]

See screenshots below.  Hope this helps!