My Stuff
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.
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…
-
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…
-
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…
-
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…
-
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…