Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
Report on Foreign Balances for Commissions
I am trying to pull together a report for commissions by Partner where I can show the transaction & commission amounts in the local currency (eg USD) as this is what the partner is paid in. But as Base Currency set to GBP this is all I can pull through which is the calculated conversion.
I tried to pull through Exchange Rate to convert back but there are Decimal Precision issues where an exchange rate of 8 decimal places is rounded to 2 which is clearly no good. I even tried to create a custom decimal field that would source and "mirror" the full exchange rate but this is rounded to 4 decimal places (for some reason???). This is still not accurate enough.
Tagged:
0