Conditional Style in Delivery Grid

Question

I am trying to get certain fields to change colors when the quantity being shipped is less than the quantity ordered. I am comparing screen values to SO values. It doesn't link the delivery line back to the proper SO line, so my formula only works on single line orders. What am I doing wrong with my formula? V12

Jeremy Rosenbaum · Answer

I think you want to evaluate the QTY on the screen of the shipment and compare it to the value in the sales order table. Try 
 [M:SDH1]QTY(NBLIG-1)<>[F:SOQ]QTY. Not sure if you want sale qty or stock qty (if you are using different units). Hope this gets you closer to your answer!

Jeremy Rosenbaum · Answer

I have been using X3 for 12 years and I still do not understand when to use what type of "line" reference. For me - it is a trial and error game. Try - [M:SDH1]QTY(nolign-1)<>[F:SOQ]QTY. This seemed to work for me after I saved the delivery. I was hoping it would change as soon as I changed the qty...... Good luck!

Sage X3

Conditional Style in Delivery Grid

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING