Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
{amount} vs {fxamount} when in formulas?
We have subs in Australia and the UK, with the USA being the parent company (we do have oneworld)...
Essentially I am trying to produce a report showing amount collected by customer per quarter (IN USD) across ALL SUBSIDIARIES...
It is a transaction (payment) search, and grouped by customer... I can "sum" the "Amount" field, which works the way it should... However, when trying to break this up into quarterly periods (as columns) I seem to have a major issue...
CASE WHEN TO_CHAR({trandate},'YYQ')='091'THEN {amount} ELSE 0 END
Produces the amount collected in Quarter 1 of 2009 denominated in the base currency of the sub from which it was invoiced... What gives???