Hello, is anyone aware of how one can match Sales ...
# suitescript
k
Hello, is anyone aware of how one can match Sales Order Item line ID with Revenue Arrangement's Revenue Element line ID? For reference, I am looking for something like
orderline
in Item Fulfillment/Invoice that aligns with
line
in Sales Order so that the lines in 2 records can be matched against each other?
question not answered 1
d
have you looked at the record catalogue page for Revenue Element? Never used the Revenue Arrangement transaction myself, but I was looking at the SQL join for
nextLinks
and
previousLinks
(Related Transaction Line Link)
k
I just checked that but I couldnt find anything that would link a certain item in Revenue Element with the corresponding ones in Sales Order other than item id. But if a Sales Order has same item id more than once, it would not work.