User_BFLDA

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

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…

in How to calculate monthly running total of transaction amount grouped by subsidiary in a Saved Search Comment by User_BFLDA Jun 25, 2025 9:28AM
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'.

in How to calculate monthly running total of transaction amount grouped by subsidiary in a Saved Search Comment by User_BFLDA Jun 16, 2025 10:42AM
Unfortunately adding Full permission to Find Transaction did not help either. We still get the same error message.

in How to set up data extraction from Netsuite to BigQuery via Stitch? Comment by User_BFLDA Jan 27, 2025 10:38AM
We are using Stitch’s NetSuite integration, which replicates data using the NetSuite SuiteTalk API (v2023_1).

in How to set up data extraction from Netsuite to BigQuery via Stitch? Comment by User_BFLDA Jan 21, 2025 4:25PM
Actually it happens when we try to extract all records from the Transaction object in Netsuite.

in How to set up data extraction from Netsuite to BigQuery via Stitch? Comment by User_BFLDA Jan 21, 2025 3:14PM

MFA for Oracle Community

User_BFLDA Newbie

Comments