By using this website, you agree to our Terms of Use (click here)
Hello,
I'm wondering if you may kindly assist I am currently creating a Generic Inquiry, I have got the basic done however I need to create a formula on order qty and shipment qty. So basically it would be order qty minus shipment qty and I am struggling to get this right.
I would greatly appreciate your advise.
Thank you
Mandy,
What exactly appears to be the issue? On the results tab, add a new row, select an appropriate Object, use the formula editor on the Data Field then use the Fields selection to select the 2 required fields. The formula needs to be like this:
=field1 - field2
Where fields look like this: [objectname.fieldname]
Use the validate button to verify the syntax.
Assuming you're looking at Sales Order Lines, go to your results grid for the inquiry, open a new result line, the object doesn't matter here, but I used SOLine for mine as I like to keep it cohesive. For the value, select the pencil icon to go into the editor. Select your fields and set an equation. For mine I used:
=[SOLine.OrderQty]-[SOLine.ShippedQty]
Of course you can type these out by hand as well if you're comfortable with your field names.
Let me know if you're pulling different fields or looking at a different table level (Like SOOrder instead of SOLines) and I'll post another example solution.