megaphone
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
No Limits. Just possibilities. Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Discover what's next at SuiteConnect Tour 2026.
Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

Hooblue Red Ribbon

Comments

  • The exchange rate is a field available on invoices. So yes, it's just a standard formula - multiply the two fields together. Not sure that will work. Let me give an example: So I have an invoice which is in GBP. It has a subtotal of £24,500, tax of £4,900 and a total of £29,400. The exchange rate on the invoice (under the…
    in Saved search invoice tax amount Comment by Hooblue May 18, 2018 11:13AM
  • Indeed there isn't a straight-up field that tell you. But, to resolve, just multiply the tax amount by the exchange rate. Thanks! However the invoices may be in multiple currencies (GBP, AUS, EUR, NZD) so I'd have to use a different exchange rate for each currency depending on what the invoice currency was. Can that be…
    in Saved search invoice tax amount Comment by Hooblue May 18, 2018 8:27AM
  • When I've had this problem, it's because I didn't tell the import I was using an internal id. Use the pencil to tell the import you're sending an internal and not the name. Be sure to use the internal id for both the item and the subsidiary. It resolves a lot of problems. Thanks for this. I've used exactly the same csv…
    in Invalid Item Reference when doing CSV Import Comment by Hooblue Nov 29, 2017 9:00AM
  • I recently did a similar for a UK customer needing to print other details depending upon the destination country and currency. I put my formula into a Do Not Store custom field on the transaction record. On the PDF layout I just displayed this field, not the content. In your formula bring in the {taxamount}. Would it work…
    in VAT rate displayed on invoice PDF Comment by Hooblue Apr 11, 2019 9:48AM
  • The line item(s) on the invoice should have the taxrate at the time of the transaction. Assuming there's only one tax rate on the line you could just grab the tax rate from the line item. [CODE] <#assign taxRate = ''> <!-- in the template block where you iterate the item sublist --> <#if !taxRate?has_content> <#assign…
    in Display VAT rate on invoice PDF template Comment by Hooblue May 3, 2018 4:52PM