Adam Birk Red Ribbon

@Tigran Shahnazaryan I just wanted to get back to you to let you know that created a new custom field appears to be the solution. Thank you.

Hi, appreciate the ideas here. That concatenated all of the items form the search into one long string in the custom field.

I've looked at all that and still coming up empty. When I don't summarize the results, I see a list of unique intenral ID's with the proper Items. Minimum Summary types has same problem. Group Summary type is not valid type for deriving value from saved search.

@Tigran Shahnazaryan See attached and thanks. Main Line = False

@Tigran Shahnazaryan Yeah, the Custom Field is on the Header. Yes, I have Internal ID of the Sales order as a filter. Scratching my head.

Hi @Judith Culanding-Oracle & @Able Wilson Yes, the soluation that @Able Wilson provided worked. Thank you. The onlyl problem was that I was using a Group Summary Type for the Item field instead of Maximum. Thanks, Adam

Hi @Judith Culanding-Oracle . Yes, I am able to reproduce @JohnCirocco 's answer above. However, I am unable to add the Item field or other fields to the results without it impacting the number of records returned. When I add Item (Summary Type: Grouped) it returns all Sales Orders and not just the ones with only one line.…

I know this is an old post, but I have used this for a similar purpose. I created a saved search to show sales oders that ONLY have 1 line. However, I want to add the item to the results. When I do this it returns records containing more than one line. Any thoughts? Thanks.

@Richard James Uri-Oracle Thank you for that detail. I am still hopeful that there is someone out there that has Cross-Subsidiary Fulfillment enabled who is receiving 945 documents. If so, please reach out to me. Thanks Adam

Here is more detail. According to SPS there is a limitation with the SOAP integration. From SPS Commerce: "Cross Subsidiary Fulfillment does not work if Inventory Location is populated on the Sales Order line Items. NetSuite needs the InventoryLocation field at the Line Item Level when importing the IF (in ordert to source…

@Jervin Nicholas Teopengco-Oracle , That did the trick. Thank you! Very helpful.

Hi, I noticed it would not let me add Netsuite's default "Subtotal" item like it would in the UI. So I created a new Subtotal Item called "Subtotal (RB)" and it did let me create that line. After this Create Line action, I added another Create Line to add a Discount Item. See screenshots below. Thanks Adam

ImeldaSanchez, I was just looking for this same thing more or less and I think I just figured it out. We need to automatically email invoices when the dialy billing schedule runs. Some customers require that we send the email to multiple recipients. We have a workflow that sets the transaction "Email" field to an specific…

For me, the "DISTINCT" function does indeed work in a saved search formula. I'm using it in this formula succesfully for example: NS_CONCAT(DISTINCT{item}) However, it does not solve the question I was trying to find an answer to. I'm looking for a way to add a value from a field on Item Fulfillment Records to a Sales…

I'm looking for the same thing. Old post, I know, but did you ever solve this?

@Keith Boatner Hi, Yes, we are using Supply Allocation. It has been a hairpulling experience but the business does like it. The business is highly seasonal and gets a lot of "pre-book" orders. For example, a big customer may place an order in January that does not need to ship until September. We want to make sure we have…

Hi @MarkCRobinson , We have not connected Amazon 3P to our Netsuite yet, but are considering it. It is "on the list of things to do". We ran into a slight roadblock because of how we are managing our FBM vs FBA skus in Amazon. Apparently our Amazon team has set up item numbers in SellerCentral to be different for FBA vs…

Hi @Kristoffer Viray-Oracle Yes, that is the same thing. Netsuite tends to use slightly different terminology depending on what page you are on. On the Sales Order form it is checking the "Commitment Confirmed" box at the line level. On the Allocate Orders Page it is called "Set Order Line to Firm". It would seem to be a…

I have this same question. What is the best way to handle this? Additionanly, it woudl be good if you could edite the Expected Delivery Date on the Inbound Shipment and it would subsequently update the Exected Receipt Date on the Purchase Order for the quantities on the inbound shipment.

@Kristoffer Viray-Oracle Thank you. I was afraid that was goiing to be the answer. That is dissapointing to hear. Allow me to better explain our scenario in hopes that a community member out there has found a way to handle this. We are using Supply Allocation AND Sales Channel Allocation. Our default Order Allocation…

@Kristoffer Viray-Oracle See screenshot below. Ideally we could use a custom sales order form where a different allocation strategy is defaulted within the form. Alternatively, I'd like to use a workflow to change the allocation strategy but having difficulty with both. Thanks, Adam

@Vikas Som Do you have Sales Channel Allocation enabled by chance?

Hello @Kristoffer Viray-Oracle Allocation Strategy is not a custom field. Supply Allocation is a feature we have enabled. When you enable Supply Allocation you can configure multile Allocation Strategies. But then you set one allocation strategy for Sales Order globally. You can use the UI to change the allocation strategy…

That was it Ivy. Thank you so much! Resolved.