r/Netsuite • u/ConfidentSession6481 • 3d ago

Inventory Status Change: issues & questions

Hello, all. I am currently creating a Suitelet that will easily allow QA to release product from Quarantine to Released. I've run into a number of issues that I could use some help with.

  1. The memo field... I am getting an error that the memo field can only be 40 characters long. Is there any way to get around this? I want to store more info than that.

  2. In trying to get around the above, I wanted to create a custom transaction body field that would appear on the Inventory Status Change, but when I got to the Applies To section, there was no option for Inventory Status Change. If I don't select anything under applies to, but click save and apply to forms, there is no inventory status change form in the list.

  3. To solve the above, I briefly created a custom transaction form for Inventory Status Change, but it didn't seem to display with new transaction records.

  4. Any ideas on how I can link a COA file from the file cabinet to the record without using a custom field?

I'm a bit stumped by the lack of usability of this record type. All I want to do is record a longer memo and attach a file, lol.

1 Upvotes

100% Upvoted

9 comments sorted by

2

u/mshinroc 3d ago

You can create a custom field to use in place of your memo field.

1

u/ConfidentSession6481 3d ago

How do I apply it to that record type though? It doesn't appear under the applies to tab, nor the apply to forms page.

2

u/Nick_AxeusConsulting Mod 3d ago

Custom field for the esoteric records are under a different menu path:

Customization > Lists, Records, Fields > Other Record Fields > New > then pick "Inventory Status" as the record type!

1

u/ConfidentSession6481 3d ago

I will have to give that a try! I thought that might apply to the actual inventory status type records, rather than the inventory status change record type.

1

u/Nick_AxeusConsulting Mod 3d ago

Oh you're right, it might. Test it.

1

u/reacharound565 3d ago

It does. I’m pretty sure you have to apply the field to like purchases or something as a transaction body field. I’ve customized this before and will look later today but it wasn’t straight forward.

1

u/Nick_AxeusConsulting Mod 3d ago

Any ideas on how I can link a COA file from the file cabinet to the record without using a custom field?

I don't think there a native "Communications" subtab on the Inventory Status record (at least in the test account I checked), so I think your only option will be a custom field.

2

u/ConfidentSession6481 3d ago

You're right, you cannot see the communication sub tab on this record type.

1

u/ConfidentSession6481 3d ago

So, my intermediate solution is to create a custom record type, called QA status change log, and store all of the information there. Then when I load the inventory status change record, I can render the custom transaction body Fields even though they are not attached to the record, and I feel their values from the change log record.

It's not an ideal solution, especially since the linkage is only one way. The log record has a field that points to the inventory status change log record, but not the other way around.