3941962 Green Ribbon

I created custom records - the shipping person has to fill it in. I put it on the sales order, on the delivery tab, so you can see the price the customer paid and the actual cost of shipping the order. Being on the sales order also allows this to be input just prior to fulfillment I then have a weekly report that goes out…

I would also like more information about how this is working out for you and the script you are using... We've been using NS for about 4 years now, just now getting to the point where we are going to use the inventory feature. Unfortunately, many of our current non inventory items for resale are actually partially…

Thanks to all of you for replying... Chris, I have the class field checked on the transaction forms but removed the label, so the class field populates but is not ever seen-until the Invoice, where I left the label-so accounting can see the reason for the commission being generated. I haven't had any luck with mass update…

I have the same issue, I've set up everything correctly, I think, but on the commission schedules page the in use column says no for all schedules. I've assigned to plans and to sales reps. All reps have the eligible for commissions box checked. **I found that it didn't work because I had the class field hidden on all…

Thanks for your input. this is exactly what I think I'm going to do! I was hoping there was a better way. There will be 2 of the search fields on the page. I hope it doesn't affect the speed of loading and saving... I guess I'll test in in the release preview account! Thanks again Olivier Gagnon NC

I have done this, what information are you trying to retrieve? Mine returns the value of all items that have a check box marked per transaction. So I get a total for the checked items and can print this on transaction forms

I have a text field on a custom form and for the first time noticed this week that the change says # of chars now. This is not the way it was prior, and we have not been upgraded yet. Almost forgot, this is a long text field from the beginning. No solution, just wondering also.

If you choose multi select, do you still get buttons from creating the entity record? Why would this be used?*** Nevermind, I just found my answer! I misunderstood!

It is suitecommerce advanced. They are sending out the standard emails. If this can be done with a saved search, that should be sort of easy. Any hints? I've never done anything with the suite commerce side of the program.

thanks, I actually needed to get the correct class from the search. What I did instead is I created multiple searches, each one giving me results for only 1 class, then updated a class at a time, using the method you describe. It was just much easier than trying to get the field from the joined record in my search to…

I tried to go about it another way: function updateLines(type) { var records = nlapiSearchRecord('transaction', 318, null, null); for ( var i = 0; records != null && i < records.length; i++ ) { var record = nlapiLoadRecord( records[i].getRecordType(), records[i].getId() ); var setclass = records.getValue('class'); var…

PLEASE HELP!! :confused: This dilemma was supposed to be solved with the update last week. While testing the preview release, I found that because my fields were text fields, they did not show up in the CSV import screen no matter the hoops I jumped! This has been fixed, however, i still can't import values into a text…

:( Ok, my excitement was premature! because these are transaction line item fields, I can't do an import-even w/ specialized forms. Line items do not have a unique key# unless you join two columns (the internal id or trans# with the line#) At least as far as I can tell, this is not possible. Anyone else?? please?? I've…

:D THANK YOU SO MUCH!!! I don't know why I didn't think of doing that but that is genius. :)

The rate on the employee record i was talking about is another problem. It is checked to show on the time entry form, and used to show, but has dissapearred. There was also a box that said "lock rate" which was to prevent the rate from changing in the labor area, if the rate on the item changed. I think these dissapeared…

The service items, should they be actual "labor" items only?? (so they are not sold) What about the accounts? which do you post to? I'm trying not to cause problems somewhere else down the line. The report you mentioned does not work because, I think, the labor is being charged against service items that are sold, and…

One more addition to this... I set up a field called Ship-in cost. This is for shipping we pay for goods coming in. Is it possible to get this to use in COGS calculations, or is trying to do that futile? :o Another issue I'm having is getting a custom field to show sales orders filtered by customer. I've tried every…

Actually, I think we don't get something. Do you use the same item that is sold to customers when tracking time?? only service items? Inventory/non inventory? I think this is why the rate doesn't always show and I can't get it to calculate rate x hour to give a total! I've been looking for answers, but am hoping someone…

Thank you so much for your help. I'll set up a custom field, which I was considering anyway... you saved me much time and headache!

Sorry for the duplicate post...

I had this error, it is actually referring to a column you need to have in the import CSV. (according to the documentation) You need a matrix type column and then list for each item, either "Parent Matrix Item" or "Child Matrix Item". You have to have that complete phrase, as i tried it first with only parent and child in…

A tip for anyone coming back to this thread... As long as the related items you are importing are all the same type, you don't have to look up the proper (or legal) value to use. In the field mapping area of imports click the type field and then instead of mapping to a field in your CSV, select from the default list by…

Go into accounting preferences, order management, and down in the fulfillment section check the box that says "Default Items to Zero Received/Fulfilled". This will allow you to check only the items that are received rather than having to uncheck all the others.

I've had nothing but trouble with merging anything in NetSuite. Today I thought I created 3 effective collection letters, but when printed, no merged info was included. I let word add the fields like the instructions indicate, and no luck.. I also tried to create mailing lables from a search. I was able to have an entire…

I figured it out, finally... not sure why this was so hard to see, but I had to edit each column to give me the date period, as this is where the compare to last year was set.

Did you ever hear anything on this subject?

A much easier way to do the same thing is to edit the transaction form, (invoice) and type the address portion of the header as you want it to appear in the address box at the top of the page. then go to the Printing fields tab and deselect from the header any information you already have up above. It's worked for use for…

This has been an issue even before the upgrade, but I'd like to know the answer if anyone has it... Why is it neccessary, with a drop ship PO, to not only receive the PO, even thought the items are received by the customer, AND have to fulfill the order? Why can't receiving a drop ship PO auto fulfil the order?? A drop…

We are also struggling with this problem and were wondering how others dealt with change orders. In general, do most vendors accept the same PO with differnent quantities/items?? what if something is removed? I think what we are going to require, is if a SO needs to be changed, the original order should be cancelled,…

I have a ticket # 610758 which is supposed to be about the issue with the box on the check stub. I can't find anything to edit to get rid of the black background behind the column labels. I didn't even mention the slight offset, thinking, maybe foolishly, that I could do a quick adjustment and fix that!! Any more progress??