By using this website, you agree to our Terms of Use (click here)
I need help with making a Generic Inquiry for discounts. I've already started on this. Getting the actual price resulted from the discount seems like it would be way out of my realm. So I just would like the percents and break points to be listed. My only issue so far, is that all of the percents are zero. Do i have the wrong relations, tables, or joins?
Try adding DiscountID as an additional column to your second join.
I found this in the Acumatica stackoverflow: https://stackoverflow.com/questions/50339146/generic-inquiry-of-discount-percent-or-prices/50630753#50630753
I couldn't get this to work. Could someone help me finish this. The person who answered didn't share all of their joins/relations.
thank you,
Richard
Try using Left instead of Inner - then review the results and where there are nulls instead of values (and you expect a value), look at the join to see why it failed.