Skip to main content
Answer

Demad Sales Generic Inquiery

  • May 19, 2025
  • 5 replies
  • 51 views

Forum|alt.badge.img+3

Hi, All I have created 3 GIs and then using that 3 Gis in one to show the maximum of all three. All three Gis are working fine but on the main one where i want to show maximum is not shwoing me any records.

Can anyone guide me please. For inquiry Demand-Sales, I need a column that will show the maximum of W1, W2, & W3. I am attaching all GIs below

Best answer by tahayabali

@Chris Hackett Basically i changed that formula and then calculate subtraction. 

5 replies

Forum|alt.badge.img+3
  • Author
  • Captain I
  • May 19, 2025

This is max formula that is not working fine “”=Max( [DemandSalesW1.ARTran_Formula13bfa5591de24380bcd5cdb1f24fe59a], [DemandSalesW2.ARTran_Formulaa0b3cfd923094f969a59fb9fa0093818], [DemandSalesW3.ARTran_Formula07567adb968540ba95a4e8dd42fa0655] )”


Forum|alt.badge.img+3
  • Author
  • Captain I
  • May 19, 2025

I am trying to add subtract column using max*2 - qty in hand but its says that we cannot use caption name we need to assgin field to subtract it. Anyone can help me in this regard?

 


Forum|alt.badge.img+3
  • Author
  • Captain I
  • May 20, 2025

thanks all its done


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • May 20, 2025

Hi ​@tahayabali - Can you share your solution? Thank you!


Forum|alt.badge.img+3
  • Author
  • Captain I
  • Answer
  • May 21, 2025

@Chris Hackett Basically i changed that formula and then calculate subtraction.