It's working if I only have one line of information coming in. So it's managing to add them to the int variables that start assigned at 0. And it prints them off as numbers and not strings. It's also still producing an error if there is no information in the fields that I'm trying to add together.

Thanks for the update Jervin~ Yea I haven't managed to make any more progress on this in the last few days, I'm quite stuck. I'm in no rush for this, it's meant to be used to automatically calculate the total weight of all packages, but I have a separate field for the user to add it themselves for now. Though this will be…

I believe this is what you might be looking for. We use a similar method to set up the various purchase prices of items between our subsidiaries as they buy from one another. I then update the prices from a CSV upload along with the rest of the item data. Or you can have them separate for item data and costing to make it…

Oh dear... another simple feature in the SuiteIdeas graveyard. 😔 Thanks for the update Jervin~

Well, it's certainly a string at least. The whole data usually comes in looking like this I think.

It just doesn't want me touching the data in col4 for whatever reason. Even though it appears to be printing as an ordinary string, I can't seem to use ?interpret or ?eval or anything and it keeps printing the same error. Also considered it might not know what to do if the column has empty data and the value is null so I…

Trying to use freemarkers ?number to convert but having issues. Always frustrating that the error logs are just UNKNOWN ERROR -_-;; Did also first try just customrecord_assign.col4?number but that produced the same error.

Ok! So a number things to go over. Here is the finished output, my custom packaging records added and stored on an Item Fulfilment being printed on our packing list to show what items are in what boxes. This used to print out all packaging records from all IFs but now targets only the current IF. In order to filter down to…

Just need to debug this last bit. Working on creating a workaround for when the record doesn't contain any information. On the item fulfilment, if there are no existing packaging records and I go into edit mode, then this error comes up. TypeError: Cannot read property "0" from null (Packages PDF Print$10855#28)

Solved! I will update with the answer tomorrow, off home for now~

I'll try adding the other column and get back to you. Thank you 👍️ I did, but I don't think I understand what you're trying to point out, sorry. So the search is actually returning the ID of custrecord2 and not the tranID. So in order to only get records that match the one I'm working on, I also need to use the ID and not…

Sorry, I'm a little confused as to why yours works and mine doesn't. The error I'm having ("Filter expecting numeric value was removed, as non-numeric value 'Test10' was provided") comes from trying to add the currentRecord variable as a parameter in the filter. If I get the id of the field (green), that works because it's…

Yea perhaps, but if it wants an id, I don't think I have any way of using that on my packaging record. These are what the packaging records look like. They're joined to a particular item fulfillment record through a custrecord whose value is taken from the transaction. And I don't see any way to do this using the ID, the…

I managed to get a script working, but the filter doesn't seem to be doing what I expected and is still returning all packing records. It seems to be removing the filter because it's not a numeric value. Not sure why it's expecting a number, most of the examples I've seen of these search filters use strings. I've tried…

So I'll need to concatenate "Item Fulfilment" onto the tranid and match that against the columns to only return similar results. I'm not really sure how to write that check to only return those results. I think it'll be something in the filters array using the nlobjSearchFilter but a lot of the links to example links in…

From looking at the packing records in a saved search, I think I at least now know that I'll need to use the Item Fulfilment value to refine my search, this is the field I'm using as the parent join on my sublist record. Just need to work out why it isn't being set on all of them (they might just have been test IFs that I…

It doesn't seem to work, sorry. It shows me all the main fields, the fields of the item lines and the NS tracking fields (I think). I can't see information from any of the sublists or subtabs like billing, accounting, related records or my custom one, packages. Perhaps because I need to tell it to look at that subtab in…

That's super useful to know, thank you! I'll keep at it for now~

Oh right, cause it's searching for the packing record that's related to the IF, not the IF. I need to get the ID of the packaging record related to the IF. Not the ID of the IF. But I'm not sure how I would go about doing that or figuring out what field ID to use to get that info.

Halfway there! I am managing to get the ID of the record now thanks to your suggestion, but I'm getting this error when I try to use it as the parameter for the search.

All good for now, thank you~

@Dominica Sevilla-Oracle Could I ask, is "Line is 1" similar to main line? or what's the difference? I'm not sure I understand what exactly it's doing. I'm assuming that line 1 is the main line, line 2 is whatever comes after? But if that's the case then what exactly is line 2? Been playing around changing the numbers and…

Thanks Lyka~ I suppose the best solution for now then would be to put it on its own subtab, I can at least control which subtabs appear on the records isn't that right?

Quoted at 3.5k for a 9 month contract, for those curious.

Looks great for now, I'll take this and keep using it to develop the search further. Thank you for the new knowledge!

Ok, it seems to not be showing any of the data as long as main line is set to true. But I'm not certain how to narrow my results if I don't have main line enabled. Tried setting mainline true and billing transaction to not none, returned no results. What field on a PO is the Billing Transaction? Perhaps I can make a custom…

Oh it's another paid thing? Nevermind then... thanks for pointing that out~

Ah, I had to remake the works order, not just the assembly build. Thanks!

Sorry, I tried both the master default and various locations but the fields are still un-editable on the assembly build.

Yea, but that will remove it from all records, including the item fulfilment record that I still want it to be displayed on.