Really, we're doing this to fulfilments in two "Packed By" fields. {packed_by_pulldown_list} ...... type = list/record {packed_by_text} ...... type = freeform text The pulldown {packed_by_pulldown_list} might have this list of names... PACKER NAME: INTERNAL ID: Joe 1 Mike 20 Tom 30 The text field can be any text and one…

Lets say I have two fields. {color_pulldown_list} .. type = list/record {color_text} .. type = freeform text I want to do a mass-update to a bunch of records and make it pick the correct value in the {color_pulldown_list} field when matched to the same value in the {color_text} field. I used colors as an easy example, but…

We do already default fulfilments to "picked". So, it has no packages at that point. When their system changes it to "packed" OR straight to "shipped".. it gets hit with a number of empty boxes created by NetSuite. We don't want those boxes created... but, we can't prevent them from being added.

I got an answer from PaceJet. I highly recommend them to anyone looking to make their shipping more efficient and/or give accurate LTL rates through your web-store. Their helpful answer... Netsuite will automagically create a package when the status is flipped from picked to shipped. A few ways to avoid that, I think, is…

I get: ERROR: Field 'internalid' Not Found It's used in a transaction search of fulfillments that were drop-shipped. The formula is in a rich text transaction body field applied to purchases and = '<a href="/app/accounting/transactions/purchord.nl?id=' ||{internalid}|| '&whence=">' || {tranid}||'</a>' I found a fix. I was…

Well, using a standard Transaction name field gave me something long like "Purchase Order #PO123456" and it linked it to the PO. I'm trying to shorten it for screen space to just "po123456". I know how to make it give me the text "po123456" in my formula, but I can't build the dynamic link to the POs without a field that…

It is a saved search of purchase orders. I know one way to have a column with the PO# that is linked, but I needed different formatting on the characters displayed in that link. -Tom

I was going to do the same for our drop-ship POs. How do you reference the internal ID of POs to build your link? {internalid} doesn't work. This gives an error... '<a href="/app/accounting/transactions/purchord.nl?id=' ||{internalid}|| '&whence=">' || {tranid}||'</a>'

Actually, I don't remember. I think we messed with it long enough to get it close enough. We use boxes in NetSuite and I'd have to go back and do some tests to see what transpired. I believe we just had to play with the markup until it charged enough to cover the fact that it was pulling the wrong amount. We're moving on…

Used '<a href="/app/accounting/transactions/salesord.nl?id=' || {createdfrom.internalid} || '&whence=">' || {createdfrom.tranid}||'</a>'

Even better, is there a way to wipe out old price levels and start over? So, an import where qty 1, 20 ,50, 100 all gets overwritten with qty1, 2 , 5, 25.

Yes, it is resolved. Thank you

PM sent

Thanks for that info. In our case we want to hide the entire field on the drill-down... but still have it show in the shopping cart. So, on the drill-down, would we just add a style like "custcol9{display:none;}" to our CSS? It is a text box field that we're wanting to hide. I tried that (using our field ID and not…

I did get an assembly matrix item to display in our web store. The first one I made was just defective I guess. It had about 5 different matrix option pull-downs. I created a smaller test assembly matrix item with only 1 pull-down option and it worked... so, I just have to rebuild the larger one again. So, can we make…

Does "ADVANCED BILL OF MATERIALS" have to be turned on in "enable features" before an assembly item can be added to the shopping cart?

Questions From Linked Solution 1. Both Parent and Child Matrix's Display in Web Store must be checked. YES 2. Both Parent and Child Matrix record must have Online/Base Price set. YES 3. Transaction Item Option must be setup correctly. Check both Parent and Child record > under Custom tab > Item Options: make sure that…

I add the parent to our web store. It shows up, it just won't add a child from the matrix to our cart. This is our first assembly matrix item, but we have a bunch of "regular matrix items" in our web store.

Also, can we turn it ON and not actually use the feature for BINS or SERIAL NUMBERS? Like, can it be set to always use the same bin and the bin is our entire warehouse? Or, can we leave it OFF on all items and still be able to see their components items on fulfillments?

Thanks Ivy, To turn on this in our NS account... ALLOW PURCHASE AND SALE OF INVENTORY USING UNIQUE SERIAL NUMBERS. We have to turn on this... ADVANCED MANAGEMENT OF SERIAL/LOT INVENTORY ITEMS OR BINS. When clicking it, it came up with cautions about script issues and stuff breaking. The notes did say v2011.2 ... so maybe…

the GL impact from the fulfillment only shows these 2 lines.... Cost of Goods Sold : Widgets, Amount Debit $123.45, Amount Credit $__, Posting = Yes Inventory Asset : Widgets, Amount Debit $__ Amount Credit $123.45, Posting = Yes So, yes.. it shows a dollar value for the COGs. Should it also show a quantity removed from…

Ok, I set it up like you have it, but it only shows the sales of each item in it's inventory item form. So, if item XYZ sold 3 times as an inventory item and 2 times as a kit called XYZ-10-PACK I would want to have the results showing item XYZ Sales = 23. What I'm getting is XYZ Sales = 3. We don't set fulfillments to show…

Matrim, how do you get the grey and white rows on you forms?

In the above solution, you'll also want to click to apply to Store and hide in Store.. otherwise orders coming in through your WebSite won't display properly with the "*" by the real items.

I found a fix. It isn't exactly what we needed... but helps out a lot. I added a field that is a custom "transaction line field" of type = text. See field settings below. I set the field to have a default to the value of "*". It now shows lists of items like this on sales orders and packing slips... * Bicycle XYZ456 ... x1…

We can't get this into a form because we don't have advanced forms set up. We did make a "kit component flag" field that is a custom "transaction line field" of type = text. Can anyone think of a way to make that field = "-" when the line item is a kit member and "*" on all real line items? I tried the formula ..... case…

Thanks Matrim, Based on your success, I tried just making a custom text field that we could put off to the left side on sales orders and packing slips (in it's own column). It is set to don't save value. It is a transaction line field and has a formula based value. formula = case when {item.kitlevel} is null then "*" else…

could the packing slip be made to show numbers for the actual lines and not put a number off to the left on component lines? Like this... 1. Bicycle XYZ456 ... x1 Steering Wheel ... x1 Frame x1 Wheel x2 Bicycle X ... x1 2. Bicycle ABC123 ... x1 Steering Wheel ... x1 Frame x1 Wheel x2 Bicycle X ... x1

NVM. Found it. Use the "insert before" feature.

bump I just re-noticed this bug our reports. Then I remembered this fourteen year old thread on the issue. What is the current consensus on the best work-around? -T NOTE: In 2007, mhuffman (NetSuite Employee) said: this is something we will look at for future releases