My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
Comments
-
Hi @Cherry Eunice B Licyayo-Oracle , The formula shared by @Tigran Shahnazaryan gives me the amount only for transactions from the current month, and 0 for all others, which is not what I needed. What I needed was a solution to calculate the cumulative sum of the monthly Amount over multiple months not just the current…
-
Hi everyone! Thanks for the comments and questions! I've added screenshots of the Criteria and Results tabs. The expected output is the same as the current saved search provides plus a new column containing the cumulative sum of 'Amount' over 'Period' and partitioned by 'Subsidiary (no hierarchy)' and 'Account'.
-
Unfortunately adding Full permission to Find Transaction did not help either. We still get the same error message.
-
We are using Stitch’s NetSuite integration, which replicates data using the NetSuite SuiteTalk API (v2023_1).
-
Actually it happens when we try to extract all records from the Transaction object in Netsuite.