Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
PreviousTransactionLineLink.nextline
Here's the query and output of my Netsuite suiteQL query
Query: SELECT * FROM PreviousTransactionLineLink ptll WHERE ptll.nextdoc = 5012317
Result:
[
{
"discount": "F",
"foreignamount": null,
"lastmodifieddate": "2021-08-26 15:43:14",
"linktype": "DropShip",
"nextdate": "2021-08-26 00:00:00",
"nextdoc": 5012317,
"nextline": 1,
"nexttype": "PurchOrd",
"previousdate": "2021-08-26 00:00:00",
"previousdoc": 5012315,
"previousline": 4,
"previoustype": "SalesOrd"
}
]
Yet, If I query
SELECT * FROM PreviousTransactionLineLink ptll WHERE ptll.nextdoc =5012317
AND ptll.nextline = 1
I get no results.
The only think that I added in the second query is AND ptll.nextline = 1
and there's definitely a row with that value as evidenced by the first query result.
Does anyone know why filtering by PreviousTransactionLineLink.nextline doesn't seem to work?