My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
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.