I am trying to access these fields in a saved tran...
# suitescriptc
c c
11/24/2021, 10:17 AMI am trying to access these fields in a saved transaction search. But i cant seem to find them in the search, i tried to use formula's and the NS field explorer to access them but without any luck.
I need them for my script code
b
battk
11/24/2021, 10:55 AMbasic approach should be to make a transaction search in the ui that only returns the transaction you are looking at
battk
11/24/2021, 10:55 AMthen add every single quantity related column to the search to find what you are looking for
battk
11/24/2021, 10:55 AMkeep in mind that search columns and record fields dont need to have the same id to refer to the same data
c
c c
11/24/2021, 1:58 PMI want to filter on manufacturing workcenter, but aparently i cant make multiple joins.
When i set the mainline to false, i can accesss the values on the above picture easily.
But whenever the mainline is false i cant get the manufacturing workcenter joined. And Vice Versa.
c c
11/24/2021, 1:59 PMI want to look at a lot of transactions, the reason why im using a search, to see multiple transactions, not just one
b
battk
11/24/2021, 3:50 PMyou can make your search return multiple transactions, its just that its easier to identify which columns match fields when you are only looking at one transaction
battk
11/24/2021, 3:50 PMdont expect to be able to do multiple joins
battk
11/24/2021, 3:50 PMgraduate to N/query to get that functionality