Hi Everyone,
We have a business requirement where customer transactions are created in a foreign currency(Canadian Dollars), while the logistics/customs process requires the shipment documents to reflect the value in a different base currency(USD)
The transaction currency must remain unchanged for billing purposes. However, for compliance with shipping documentation, we need the invoice printout to display both the transaction currency and the converted amount in another currency, based on the applicable exchange rate on the transaction date.
We would appreciate your guidance on the following:
- Is there a standard/native way in NetSuite to print dual currency values on an invoice?
- Can this requirement be achieved using:
- Advanced PDF/HTML templates
- Custom fields sourcing the exchange rate and converted value
- Any Multi-Currency or other native functionality?
- Has anyone implemented a similar solution for shipping or customs documentation?
Any recommendations, best practices, or sample approaches would be greatly appreciated.
Thank you in advance for your support.
