My Stuff
Check out Oracle NetSuite upcoming events and conferences here
See All the Unlockable Badges
See All the Unlockable Badges
Comments
-
Thank you Dominica, I did some testing on that formula yesterday and it looks like I still get the same amounts prediscount.
-
Below is a screenshot of one of the orders. However, we have some customers that get multiple discounts so some orders have discounts both at the header level and line level. I pasted a copy of both as well as my search results.
-
Trying to use the "Last quarter to date" and get this error message. I can't seem to figure it out. : Illegal argument: Type mismatch error: Cannot match types to expression MINUS(TO_CHAR({trandate#RAW}, 'Q'), 1) (Error on line 1 column 34.) I'm also trying to figure out how to do YoY by quarter. So this quarter to date…
-
Thanks Jack! I appreciate the feedback here.
-
Sorry, The custom field is on the customer form using the Hyperlink field type.
-
Thank you so much! That did it, the rate field you suggested and the formula field fixed the 2 major errors I was running into.