NElliott
12/17/2021, 10:03 AMSELECT
scriptid,
name,
fieldtype,
fieldvaluetype,
BUILTIN.DF( owner ) AS owner,
lastmodifieddate
FROM
CustomField
ORDER BY
scriptid, fieldtype
This custom field query, I'd like extend to filter where the fieldtype is COLUMN but failing miserably, I tried:
WHERE CONTAINS(fieldtype, 'COLUMN', 1) > 0
to no avail.
Does anyone know if it's possible also to filter based on the record type it's assigned to, for instance "Purchase" or the value of the property if not?
I think it's a specific field per record set as per the UI whihc the XML implies is "colpurchase"...Dmitry Masanov
12/17/2021, 3:37 PMSimon
12/18/2021, 11:35 AMSearch error occurred: Field 'QuantityAvailable' for record 'item' was not found. Reason: REMOVED - Field is removed
Field 'QuantityCommitted' for record 'item' was not found. Reason: REMOVED - Field is removed
Field 'QuantityOnHand' for record 'item' was not found. Reason: REMOVED - Field is removed
Field 'QuantityOnOrder' for record 'item' was not found. Reason: REMOVED - Field is removed
Where are those fields now ?Shai Coleman
12/20/2021, 5:26 PMburkybang
12/20/2021, 9:32 PMEntity.type != 'Employee'
, but it seems to ignore my filter. When I put Entity.type as a column, it returns "Employee", but when I apply the LOWER function to Entity.type, it returns "relationship field". This makes me think that when I try to do my filter Entity.type != 'Employee'
, it's not working because Entity.type
is actually returning "Relationship Field". How can I filter using Entity.type
properly?darrenhillconsulting
12/21/2021, 4:33 PMscriptexecutionlog
record ... is this equivalent to the ScriptNote
(If so, there's no time component in the ScriptNote
record)Shai Coleman
12/22/2021, 12:39 AMsubsidiary
table through the REST API. e.g.: SELECT id FROM subsidiary
. I'm getting the error table Record 'subsidiary' was not found.
I've added the LIST_SUBSIDIARY
permission, but I'm still getting an error. Other queries work OK. Any ideas?darrenhillconsulting
12/22/2021, 2:30 PMstrFirstName
.. the alias becomes strfirstname
. Thanks NetSuite!Dmitry Masanov
12/29/2021, 11:30 AMredfishdev
12/30/2021, 6:21 AMdarrenhillconsulting
12/30/2021, 6:08 PMJosh Godfrey
01/04/2022, 11:14 PMNickSuite
01/06/2022, 6:16 PMNickSuite
01/06/2022, 6:16 PMtdietrich
01/06/2022, 7:14 PMSELECT
Transaction.TranID,
BUILTIN.DF( Transaction.Entity ) AS EntityName,
BUILTIN.DF( TransactionAccountingLine.AccountingBook ) AS AccountingBookName,
Account.AcctNumber,
Account.Fullname AS AccountName,
TransactionAccountingLine.Debit,
TransactionAccountingLine.Credit,
TransactionAccountingLine.Posting,
TransactionLine.Memo
FROM
Transaction
INNER JOIN TransactionAccountingLine ON
( TransactionAccountingLine.Transaction = Transaction.ID )
LEFT OUTER JOIN TransactionLine ON
( TransactionLine.Transaction = TransactionAccountingLine.Transaction )
AND ( TransactionLine.LineSequenceNumber = TransactionAccountingLine.TransactionLine )
LEFT OUTER JOIN Account ON
( Account.ID = TransactionAccountingLine.Account )
WHERE
( Transaction.ID = 2808592 )
AND ( TransactionAccountingLine.Account IS NOT NULL )
-- AND ( TransactionAccountingLine.NetAmount <> 0 )
-- AND ( TransactionAccountingLine.Posting = 'T' )
ORDER BY
TransactionAccountingLine.TransactionLine
I hope that helps.NickSuite
01/06/2022, 7:51 PMtdietrich
01/06/2022, 8:22 PMSELECT
SalesOrdered.Transaction,
Transaction.TranID,
BUILTIN.DF( Transaction.Entity ) AS EntityName,
-- BUILTIN.DF( TransactionAccountingLine.AccountingBook ) AS AccountingBookName,
Account.AcctNumber,
Account.Fullname AS AccountName,
TransactionAccountingLine.Debit,
TransactionAccountingLine.Credit,
TransactionAccountingLine.Posting,
TransactionLine.Memo
FROM
SalesOrdered
INNER JOIN Transaction ON
( Transaction.ID = SalesOrdered.transaction )
INNER JOIN TransactionAccountingLine ON
( TransactionAccountingLine.Transaction = Transaction.ID )
LEFT OUTER JOIN TransactionLine ON
( TransactionLine.Transaction = TransactionAccountingLine.Transaction )
AND ( TransactionLine.LineSequenceNumber = TransactionAccountingLine.TransactionLine )
LEFT OUTER JOIN Account ON
( Account.ID = TransactionAccountingLine.Account )
WHERE
( SalesOrdered.Transaction = 460691 )
AND ( TransactionAccountingLine.Account IS NOT NULL )
AND ( TransactionAccountingLine.NetAmount <> 0 )
-- AND ( TransactionAccountingLine.Posting = 'T' )
ORDER BY
TransactionAccountingLine.TransactionLine
Note that the SalesOrdered table is really just a view on the Transaction table. You could clean this up a bit and eliminate the join to the Transaction table, but I'd leave it as is.NickSuite
01/06/2022, 8:39 PMCory Weiner
01/12/2022, 7:09 PMjen
01/20/2022, 8:11 PMehcanadian
01/21/2022, 4:42 PMCory Weiner
01/24/2022, 3:47 PMJake
01/24/2022, 5:41 PMjen
01/24/2022, 5:42 PMJake
01/24/2022, 5:43 PMSelect * from Entity
jen
01/24/2022, 5:43 PMjen
01/24/2022, 5:43 PMjen
01/24/2022, 5:44 PMJake
01/24/2022, 5:44 PMShawn Talbert
01/24/2022, 5:50 PM