Tom Dalton · Owner · Silver Medal

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

This did it... when {transactionlines.nextlinks.linktype} like '%Drop%' then 'drop ship' else 'Our Warehouse' end

I was doing this as a criteria in an analytics dataset. When I tried your idea, I got "Your formula contains a reference to an inaccessible field applyinglinktype". It is a formula field in the dataset.

We don't use special orders. Just regular drop-ship POs. How would you put it into a formula field to make a drop-ship flag... like: Case when {Applying Link Type} is 'Purchase Order' then 'drop ship' else 'Our Warehouse' end Obviously that isn't right, but what would be?

Lastly, is this happening across all users? .. Yes

Yes, the template is blank.

I confirm that I'm referring to font size of standard NetSuite emails. The emails we manually type to customers. What we're typing is very small. On the customer's end it might look bigger, but on our end we have difficulty reading what we're typing.

Receive Customer Replies in Case List Only WAS enabled. Any other ideas? Best Regards, Tom

I think it was a coincidence that made me think {custitem_weight} was being used. Like I changed the weight up +1 lb to test if it was the active field and then ran a test in the web store. At that same item UPS rates were adjusted upwards by UPS. So, it came back with a higher number and I made the wrong assumption that…

That wouldn't be a good Enhancement request to add us to unless it read "Enable capability to default a MAXIMUM package weight for the default package used in item fulfillments as it is currently hard coded at 150 lbs which gets hit with hefty UPS oversized fees".

I accepted the answer too soon. I go to Setup > Accounting > Shipping > Preferences > Rates > UPS Rates and I try all four types of UPS rates and they have ZERO impact on the rates displayed in our web store. I think those are maybe only for what is printed on the UPS label if you use an integrated label printed right out…

thanks So that you know the impact issue, we (and I assume everybody) gets hit with all kinds of upcharge fees from UPS when a UPS box is overweight. It used to be that a box of 70 lbs or more was overweight and got a +$70 fee. In the last year it was lowered and boxes of 50 lbs or more get a +$70 fee. So, if we had to use…

NetSuite help says: Note If you do not enter a maximum number of items, the package type maximum number of items is assumed to be unlimited until the total weight is equal to or greater than 150 lbs. So, where can we change the 150 lbs. max for one package to a lower number?

I know how to add a discount to a shipping item. UPS shows retail UPS ground costs (on our bill) like this... $27.09 UPS Ground Shipping cost <-- *It WAS pulling this into NetSuite for us to apply a discount to +$4.45 - Residential Surcharge +$18 - Length + Girth Surcharge +$3 - Peak Surcharge +$4.07- Fuel Surcharge TOTAL:…

I had already created a template and picked type = case. It had no impact on case responses. How do you specify that a specific email template be used on all case responses? You keep showing me how to apply templates to regular emailed messages sent out of NetSuite. We already know how to do that. In cases, you reply to…

How do you specify that a specific email template be used on all case responses? We already use the setting "Home > Set Preferences > General> Add Signature To Messages" and we have no signatures in our case responses.

I don't have a scriptable template for case responses

This worked.... We already had {custbodyshiptophone} on our sales orders and fulfilments and it lacked the need format. It takes the phone number from the shipping address and if blank it takes the main phone number from the customer record. Then our new custom phone field uses: CASE WHEN {custbodyshiptophone} like '1%'…