In setting up suiteanalytics I can't seem to find just amount or transaction total in the transaction table. I see fields like foreignamount, or foreigncreditamount, but not amount. Does anyone know what field from SuiteAnalytics connect would be the same as the Amount field in Saved searches? Thanks
t
trafalger
08/08/2023, 5:53 PM
Are you on Netsuite or Netsuite2?
trafalger
08/08/2023, 5:53 PM
And there should be an amount but it might be the original currency
trafalger
08/08/2023, 5:53 PM
Check the Transaction Line Account
n
nsAI
08/08/2023, 7:25 PM
im on netsuite2
nsAI
08/08/2023, 7:26 PM
so there is no overall amount from the transaction table? It has to come from the transaction line table?