Hello, is it possible to get the base currency amount for an invoice in suiteanalytics? We are looking to match what is returned for the amount in a saved search

Either you can join to

Transaction Line -> Transaction Accounting Line

and pull up the amount from there (add a filter for

Transaction Line: Main Line is true

) or you can use a formula

{foreigntotal}*{exchangerate}

thank you

I would actually recommend you use the explicit join because the formula can be different to the GL amount due to rounding. The actual GL impact is rounded on each line after FX conversion, but the formula is just looking at the total. Example case I came across today

thank you