Sarah
03/06/2025, 7:52 PMCeligo AI
03/06/2025, 7:52 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems like the issue of the primary currency not pulling into the base amount could be related to the Consolidated Exchange Rate setting in NetSuite. In the first thread, it was suggested to switch the Consolidated Exchange Rate setting from Per-Account to None. The Amount field will show the base currency amount if this setting is set to None. If it's set to Per-Account, it will take your base currency amount times your consolidated exchange rate for whatever time period you're running the search for. In the second thread, it was mentioned that the Amount Paid (Foreign Currency) field is not exposed in the record browser/schema. A formula custom field was added, but the result was not matching the fxamountpaid (Amount Paid (Foreign Currency)). In the third thread, an issue was reported with the Amount Due (Foreign Currency) field in the AP aging report. The currency displayed in this field changes when the report is exported in Excel, which doesn't happen when exporting as PDF, CSV, or Word. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
03/06/2025, 7:52 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819388568
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818829119
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.813607872
Celigo AI
03/06/2025, 7:52 PM