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.

Thanks Nicole~ I'm a bit swamped with tasks at the moment but I'll get back to this and give it a go when I can. Thank you as always for the guidance.

Following this and the suite answer. The main cause for the issue was that the 'Document Number Prefix' field on the subsidiary records had been deleted. We've restarted the document numbering at 0 with a new prefix.

Sure thing! Here it is at the bottom of a Purchase Order with some example information on it. I'm hoping to be able to have it only show up on Item Fulfilment records.

Noticed it was the subsidiary in particular that wasn't working and it's the IS check that isn't valid, needed to be = instead. {subsidiary} = 'MPSL' AND LOWER({createdfrom}) LIKE '%purchase order%'

Sorry Jervin, still not I'm afraid. :( Gonna test the two check separately to see which if either works.

Hi Jervin, thank you for all your help with my forms over the months. When you want to find how to link to a particular field on your PDFs, workflows or elsewhere. Do you have particular methods that you go through to find the field and test that it works? I've used SuiteBuilder Advanced Templates Reference guide before,…

Thanks Pierre~🙏 Amazed you're able to remember so much detail surrounding the cause of the issue.

It's something to do with it going onto multiple lines, as soon as the text goes onto a second line it aligns left, but if it fits on the first line it aligns right.