Welcome to the fun times of bins, picking tickets, and advanced pdf forms. The short answer is that NetSuite does not support those fields in the advanced forms. The workaround I've seen is to create a custom column field on the transaction that sources the preferred bin, and then printing that on the picking ticket form.…

Is there any update to this software? I gave up trying to make it work and uninstalled it. Now we're rolling out Office 2010 to new machines and I don't want to put this on if Outlook will be completely unusable.

I can't find the enhancement either - anyone else had any luck?

Do you have an enhancement number for it? I'd like to see this too, but I can't find it in the voting system. Right now we're getting around it by only allowing certain people access to inventory adjustments.

Bringing this up again. We're looking to enable lot numbers and expiration dates for our inventory, but we'd have to re-enter the parts we already have as new items and lose all history. Really wish NetSuite would take this more seriously.

Frustrating - I have a few items that I need to merge as well. Has this enhancement been re-added? I can't seem to find one right now.

Julie - we have similar issues with the commission calculations, which is why we don't process commissions inside of Netsuite. We have custom reports that give us the gross profit of all billed orders, including drop shipments, and we calculate commissions based on those reports. It ****s because NetSuite sold us on an…

Any examples of what a formula like that would look like?

Okay going even further down the rabbit hole... So I need to get the internalid of what I'm searching for, not just the name. But how do I get to something like this: custom_record_field.linked_record.internalid So, in other words, the internal id of a linked record? Here is a more thorough explanation: my custom record…

Heh, and I thought I had finally figured out all the tricks for saved searches. Thanks for the pictures - they help a lot!

Anyone noticing a change in functionality with this since the move to 2018.1? I know it’s not a documented feature, but we’ve been using it since day one and now we’re running into a weird issue: Essentially the display for the first line will be one more than the total number of lines on the transaction. So if there are…

Is this working for everyone? When I add a column with the source {linenumber} it adds a 1 to every line.

This function has become unreliable for us since moving to 2018.1. I wrote about it here: https://usergroup.netsuite.com/users/forum/platform-areas/customization/custom-forms-fields/393598-transaction-line-numbers?p=434314#post434314 Essentially the field will always display the total number of lines +1 in the first row,…

just create a custom field and set the value on before save userevent script. Next then you can carry the line value forward to order, fulfillment and invoice While that is one workaround it is not as clean as the previous functionality.

Didn't know I had to set the store value to false - it somewhat works now. Only issue is that in edit mode all of the line numbers are still "1". When viewing, though, it shows correctly. Is there any way for it to retain the numbers while editing?

Is the field in your Custom Record for sales rep is setup as List/Record where List = Employee? If yes, you can check the Apply Role Restrictions field on the Sales Rep field. Then set the Access Type of your Custom Record to Use Permission List. In the Permissions tab, add the role that will need to have access to the…

It is a List/Record sourced from "Fiscal Year", and the internal id is 3. However I still can't get it to work. But it looks like I was doing it the hard way anyway. All I did instead was set the defaults for that field on the record, rather than trying to script it. So I'm good now - thanks! :)

I'd like to use External ID, but the purchase order still needs to be assigned to a vendor (we can't put in a purchase order to nobody). But I may be a bit confused on the External ID bit - I was thinking that could be the purchase order number from our legacy system. But when I try to set that as the External ID the…

508297 is the Netsuite sequential vendor ID.

If the purchaser is paying for the PO at the time of executing, Bill in Advance of Receipt is the thing to do--why not do that? Evan Because then I have our purchasing department entering vendor bills, which is an accounting function. For security reasons (and as best business practices) we like to keep the roles to their…

I wonder if I could do that with a workflow instead of a script. Gonna check that out, thanks!

I think I didn't explain fully. Here's the scenario: Actual counted quantity on hand: 10 System displayed quantity on hand: 10 Quantity in Bin X: 75 So I need to bring the quantity in Bin X down to 10 without actually adjusting the inventory level, because the inventory level is correct. An adjustment will impact my…

That makes sense. I'll give it a shot, thanks!

I'd be interested in this as well. Making kit members obvious on the tickets would be nice.

That's better, and definitely eliminates a lot of the issues. I'm guessing there is no way to also filter out partially fulfilled transactions if just that item is fulfilled?

From Sales Orders, you can use fields from fulfillments and invoices: Fulfilling/Receiving Transaction Fields... Billing Transaction Fields... find the month of the transaction using SQL formulas, and then subtract them and if the difference is 1 then it matches. Not a simple search, but doable. One thing to watch for…

Track Messages - that's what I was looking for. Thanks!

Nevermind - I was able to get it. It was much simpler than I was making it out to be.

Faxaway seemed very shady when we went to set it up. Very happy with eFax so far. Just wish NetSuite would allow us to set a per-user fax account. Having all confirmations to a single account is annoying.

Old thread, but I find this extremely annoying to this day. I've voted on the enhancement, but it hasn't had any activity in a while. Barring NetSuite applying some common sense to this issue, does anyone have a workaround for this? I'm guessing a workflow for this is not available? What about a script?