Is there a way to show the consolidated currency on every invoice. For example if our consolidated currency is USD and the invoice is GBP, we want a field to show the amount in USD.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can show the consolidated currency on every invoice by creating a custom field and using a formula to calculate the amount in the consolidated currency. Here's how you can do it: 1. Create a custom field on the invoice record. This field will hold the amount in the consolidated currency (USD in your case). Let's call this field 'Amount in USD'. 2. Use a formula to calculate the amount in USD. The formula should take the amount in the original currency (GBP in your case) and multiply it by the exchange rate to get the amount in USD. For example, if the amount in GBP is 100 and the exchange rate is 1.3, the formula should calculate 100 * 1.3 = 130 USD. 3. Set this formula as the default value for the 'Amount in USD' field. This way, every time you create an invoice, the 'Amount in USD' field will automatically calculate the amount in USD based on the amount in GBP and the exchange rate. 4. Make sure to display the 'Amount in USD' field on your invoice form. This way, you can see the amount in USD on every invoice. Please note that this solution assumes that you have access to the exchange rate at the time of creating the invoice. If the exchange rate changes frequently, you might need to update the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******