https://netsuiteprofessionals.com logo
Join Slack
Powered by
Cross-posting from the suiteql channel. Any ideas ...
# suitescript
e
Cross-posting from the suiteql channel. Any ideas on the below? I see FulfillmentRequest but lines are inaccessible via N/query. Besides, I don’t see a line link back to the original Sales Order regardless, even in the Records Catalog. Any ideas welcome!
b
the link is at the transaction line level
the next and previous transaction links exist at both the transaction and the transaction line level
e
you rock; checking this out, though… thanks
I ran a query and only PurchOrd, ItemShip, CashSale, CustInvc, RtnAuth exist in the PreviousTransactionLineLink table for previoustype = ‘SalesOrd’……????
Copy code
SELECT nexttype
FROM  PreviousTransactionLineLink ptll 
WHERE previoustype like 'SalesOrd'
GROUP BY nexttype
b
build the query in the ui first
e
query in ui - meaning via WorkBooks?
or Saved Search?
b
yes
using workbooks
e
gotcha. crossed paths. but can i access prev/next links in the wb?
or, how, rather?
b
message has been deleted
e
it doesn’t seem like the linkage is properly there. it’s weird
message has been deleted
it’s quite odd but it seems the linkage is not in the standard line linkage table
b
oh weird, its different than a saved search
try the created from join instead
e
success, but this is header information. i can see the SO. I need line level IDs to get the equivalent of the orderdoc and orderline
i also tried not a transaction dataset but a fulfillmentrequest dataset, but i get no links (prev/next) in that dataset
b
meh, might have to do a saved search instead
e
Saved Search doesn’t typically expose orderline/doc.
those are only avail on record.load. hence the use of n/query in the first place! to get to the prev and next links
b
its actually common for them to expose order line and order doc
though the order line is just expressed as a normal line id
and the order doc is more the id of the applying or applied to transaction
e
great point; from the SO, the Applying Transaction is what I am looking for. Filter: Main line is false; Applying Transaction : Type is FFTREQ; this gets me to the request. I can’t get to the line, but need to assess whether i really need the FFTREQ line, or just the request is fine for my purposes. Thanks, @battk - if anyone could figure this out, I knew whom it would be!!!
b
you should be able to get the line too if you start at the right transaction
for example, you should be able to guess which sales order line is linked from these results
e
i think i am ok with just the header, thank you!!! i tried upwards from the FFTREQ (Applied to) but that didn’t yield the results i was expecting
yea, you’re right, i think. well, i know you’re right - ALWAYS! thanks again. perfecto
2 Views
Open in Slack
PreviousNext
Powered by