function getCurrentAccountBalance(account, amazonMarketplace, date) {
      let num_amount = 0;
      let first_date = date.slice(0, -2) + '01';
      log.debug('The first date is: ', first_date);
      log.debug('The date is: ', date);
      log.debug('Amazon marketplace is: ', amazonMarketplace);
      log.debug('The account is: ', account);

      //JE Search
      let transactionSearchObj = SEARCH.create({
        type: "transaction",
        filters: [
          ["systemnotes.type", "is", "T"],
          "AND",
          ["posting", "is", "T"],
          "AND",
          ["trandate", "within", first_date, date],
          "AND",
          ["account", "anyof", account],
          "AND",
          ["custbodyrsm_journal_type","noneof","5"],
          "AND",
          ["cseg1.name", "is", amazonMarketplace]
        ],
        columns: [
          SEARCH.createColumn({
            name: "account",
            summary: "GROUP",
            label: "Account"
          }),
          SEARCH.createColumn({
            name: "amount",
            summary: "SUM",
            label: "Amount (CAD)"
          }),
          SEARCH.createColumn({
            name: "fxamount",
            summary: "SUM",
            label: "Amount (FX)"
          }),
          SEARCH.createColumn({
            name: "currency",
            summary: "GROUP",
            label: "Currency"
          }),
          SEARCH.createColumn({
            name: "cseg1",
            summary: "GROUP",
            label: "Marketplace"
          })
        ]
      });

      let searchResultCount = transactionSearchObj.runPaged().count;
      log.debug("transactionSearchObj result count", searchResultCount);

      transactionSearchObj.run().each(function(result) {
        num_amount += parseFloat(result.getValue({
          name: 'fxamount',
          summary: "SUM"
        }));
        log.debug('The amount of the current account balance is: ', num_amount);
        return true;
      });

      return num_amount;
    }

This returns 0 results every time - any clues why? I have a feeling its the criterias...

Build the search in UI and then convert to code using chrome extension.

that's what I did

What's the point of the system notes criteria?

it get exact account balance this way -> systemnotes.type (create) = true also, I could but I built it in UI so I took the code as is

I'm not really getting the system notes part. Do you get a different balance if you remove it?

yes

it's not really related to your question but i'm struggling to understand why that is the case. what do you mean by exact?

so I don't know about you but if you ever wanted to get the amount in a specific account through a saved search, it can be challenging. for some reason, if you have this set of criteria, you get exact amounts per account (trick I learned a while back)

if you run the exported search from the ui you get results? I would log the filters object you create and compare it against that

You mean just hardcode the UI search and put it in there?

If you think its the filters, then start removing filters until you get results

yes just hardcode the UI search, confirm you are getting results, and then compare to your modified version

alright will do

i still don't get this need for the system notes filter

I vote the trandate filter first

alright ill report back

i tried a saved transaction search in my account with the only criteria posting = true, and grouped by account, summed amount

maybe I was mistaken !

if you were looking at system notes elsewhere in results/criteria i could understand why not having it there would cause results to be duplicated