r/SuiteScript | reddlx

Record doesn’t exist error

Hey everyone,

I’m getting a record doesn’t exist error when using record.load in a suitelet script

var rec = record.load({
type: record.Type.SALES_ORDER,
id: 12345,
isDynamic: false
});

I tried (type: “salesorder”)

The record is right in front of me through UI, deployment has run as administrator, all roles, all employees

I tried searching for the record through the same script and I’m getting nothing, any idea what to try next?

I also checked my user, I have admin access and no location and the sales order has no location as well and there doesn’t seem to be any restrictions my user and the sales order have the same subsidiary as well and the script also doesn’t work with different subsidiary sales orders, not sure if that makes a difference.

reddit.com

u/bissar98 — 2 days ago

▲ 4 r/SuiteScript+1 crossposts

SQL Reporting query

Using Tim's SuiteQL tool and trying to add the 'Name' and 'Department' fields that are on a journal line i.e. an 8 line journal can have four different Names and Departments, but struggling!

So how do I find these fields as we have some customising too - looked at Records Catalog and searched name (or entity.id according to ChatGPT) but it doesn't really help - is there somewhere else I should be looking to find these? My code is below, if anyone can help?!

SELECT

Transaction.ID

Transaction.TranID,

Transaction.TranDate,

BUILTIN.DF( Transaction.PostingPeriod ) AS PostingPeriod,

Transaction.Memo,

Transaction.Posting,

BUILTIN.DF( Transaction.Status ) AS Status,

BUILTIN.DF( Transaction.CreatedBy ) AS CreatedBy,

BUILTIN.DF( TransactionAccountingLine.Account ) AS Account,

TransactionAccountingLine.Debit,

TransactionAccountingLine.Credit

TransactionLine.entity.id

FROM

Transaction

INNER JOIN TransactionAccountingLine ON

( TransactionAccountingLine.Transaction = Transaction.ID )

Transaction

INNER JOIN TransactionLine ON

( TransactionLine.Transaction = Transaction.ID )

WHERE

( Transaction.Type = 'Journal' )

AND ( Transaction.TranDate BETWEEN TO_DATE( '2026-01-01', 'YYYY-MM-DD' ) AND TO_DATE( '2026-07-31', 'YYYY-MM-DD' ) )

ORDER BY

Transaction.ID DESC

u/n0145421 — 4 days ago

▲ 8 r/SuiteScript+1 crossposts

How to match bank data in Netsuite using only specific word from the memo?

Hello dear community!

Almost all our transactions in NS fail to auto-match because the bank data's memo field contains the invoice number alongside other text. In the settings of the Reconciliation Rules there are only 2 operators available: Equals, Equals (ignore prefix), there is no "contains" operator. So a memo like "WIRE TRF REF# 111111 DRC-22222 INV-333333 BENEFICIARY..." cannot be matched to invoice DRC-22222 or INV-333333. Any suggestions how this can be resolved?

reddit.com

u/Substantial_Bet3252 — 8 days ago

▲ 9 r/SuiteScript+2 crossposts

Salesforce.com (SFDC) Data Cloud to ingest Oracle NetSuite (beta) - anyone succussed in testing this?

Usually we discuss sending data to NetSuite and using the Oracle/NetSuite platform to process data (like in NSAW). Recently I started working on an SFDC Data Cloud/Agentforce project that need NetSuite data. There is a BETA connector, but the authentication there (in SFDC) makes no sense... it's "basic" (username/password)... and fails.

Salesforce.com Data Cloud to ingest Oracle NetSuite (beta) - anyone succussed in testing this?

u/Emotional_Gate_8087 — 10 days ago