Can someone help me if it's possible to retrieve t...
# suitescript
h
Can someone help me if it's possible to retrieve the amounts (75 and 106.65) on Payment column under the Apply subtab using Saved search for Credit Memos? I've tried literally everything but couldn't find a way to show correct amounts.
b
applied to link amount
h
still got blank 😞
b
what does your search look like
h
message has been deleted
message has been deleted
b
remove the main line filter
and tax line
h
ahh i got them thanks so much!
is there anyway to only return the first two rows?
message has been deleted
b
as in literally only the first 2 rows of search results
h
correct, just the first 2 rows of search results
b
or are you looking for an appropriate filter so you would only get apply lines
h
I just want to get all the values on Apply lines
b
you want a filter on the applied to link type
h
sorry did you mean Applied to Link Type under the Results tab?
b
not the one you labeled apply type
there is a column and filter named Applied to Link Type
its defines the type of the relationship of the join
h
ah i see what you're saying
set Applied to Link Type = Payment
@battk is it possible to retrieve "Amt. Due" on Apply lines? I haven't had any luck with it
message has been deleted
b
calculate it from the applied to transaction's amount remaining and applied to link amount
h
thanks battk
v
@Helena I think from the Invoice this is "Amount Remaining" or script name {amountremaining}