PatrickConrad Red Ribbon

The solution that worked for me was to create a custom field on the record, populate it with a formula in a workflow, then load that field to the email template.

I have a saved search with a couple of formulas that perform some string functions. How can I add these fields to the email template?

Richard, Thanks for checking. I was hoping to find a mapping table similar to the next and previous links. I am curious as to how NetSuite keeps track of these records.

I have a Support Case that is linked to a Sales order, and I can follow it through the UI. I need to be able to [resent it in a view and am working with Suiteql, but cannot see where they link. The id of the SO doesn't appear to be in any field in the SO and visa versa. Is there a mapping table that I haven't discovered…

Jervin, Thanks for the input. I have tried that and it only pulls the first line for all of the lines of the PO. When I try to use the lines {line.createdfrom.item} source it returns nothing. I believe that you are correct and that this is yet another failing of the Workflow system. That being the case, I am starting to…

Thanks Sho, I had already reached the conclusion that I will have to 'Grow my own' ship complete process to only look at the warehouse orders. I am now looking for information about where to look for the hooks to accomplish this without involving ACS.

Kind of. If the Ship Complete is unchecked, I can pick the items that are in stock. However, I want to hold the order until all warehouse items are in stock. If I have an order that has 1 drop ship and 2 warehouse items and only one of the warehouse items are available, I do not want to pick that item, and then fulfill…

Tigran, Thanks for the response. I've had to create several 'Custom' fields/flags to make NetSuite work properly for us, and I was thinking the same thing. If I create a flag, 'Ship Warehouse Complete", I would then need a way to only send the order to WMS if all of the warehouse items were available. How and where do I…

Luis, This looks promising. Thanks for the information.

Hi Niks, I have made it past the ability to manually create an order. There is a bug in Oracle's code that is preventing me from creating the orders with group items from a script. Thanks for your help.

Niks, Thanks for that information. I already have a similar script that I use to modify the lines, and it works for existing orders. The problem that I am having is that I can't even get an order created if it contains a group item. All I see is the error message, and no script activity.

I get this error with or without scripts running while creating a new order or copying an existing one with group items. When I review the Script Execution log, there is no activity. Steps: Create a new sales order and add a Group item. Save The order. See this message: You cannot edit the end of group line. You must…

Update: I have scripts that run properly on a regular order, but they do not fire for a new order that has a Group item. Does NS create a different type of order before creating a sales order?

Niks, Thanks for the information, but that points to using WMS, which we have, but not for our retail locations. It looks like it should be a simple configuration on the SCM Mobile app to select another field to scan.

I have a need to have the intercompany sales order screen changed to give more filterability to what is to be created. Issues requesting this form be made editable have been circulating since 2016. While there are few requests for this, how can this get on the Oracle's to-do-list? (Already voted for enhancements) Or How…

For those that are wanting this enhancement, what are some of the workarounds? We need to identify multiple orders from various channels to process and need to identify which of these to process.

Thanks for the suggestion. I have done this and their response was that it is not within their scope and referred me to Professional Services.

Thanks for your time & assistance.

Tigran, Thanks for that information. Merging columns might be the ticket, but still no joy. Maybe what I'm trying to do isn't possible. There is a locked suitelet that provides the fields for the picking table in the WMS mobile. Here are the keys: I'd like to pull a couple of fields (mpn, stock desc) information from the…

Tigran, Thanks for the info, but I have already gone through that, but it didn't provide information about how to pull/identify standard fields that are not appearing in the table. Where do I identify the key(s) to call for the fields that I want to see in the table or how can I link to the record with this value?

After some more research, I located WMS item Alias. With this, I can create the cross-reference that I need, and through my initial tests, I am able to perform WMA functions using the legacy (alias) items.

Thanks for all of the suggestions. I have created a saved search of items and pulled in the different fields to filter it by.

I know that I need to add the values to the item receipt and then add them to the label. What I need to know is how do I add (select) the price level for the item during this process? The standard process pulls the first up price level. I need a way to select a price level during the print process.

What I need is a way to print item labels for a received PO that will allow me to select the correct price level for those items.

This may help

Thanks! This provides the needed information. However, I'd like a simpler way to present it to the users. Is there a way to create a standard view or saved search from a dataset?

When Is this going to be possible?