but i still don't get why when i log onto a different role, the sales drops to zero. when i click into the sales to see more in details, it shows all the sales. but KPI sale shows zero.

I cannot get YTD column to show up on the portlet. it works for FY, but not YTD.

no solutions yet

nvermind. the date selector works. i was just confused how it was set up

my quick date selector use to have like a bunch of selection including " " to date now it's missing over half...and all the YTD is gone. where did it go

just a simple report that shows sales by rep 1st column rep 2nd column amount, relative to today's date - this fiscal year to date 3rd column amount, relative to today's date - last fiscal year to date everything is fine when i view it on the report. but when i put that in a portlet. the amount columns disppear

i feel your frustration Aaron. whenever i try to build a report...all i get is Report Execution Error: NetSuite has encountered an error while generating your report. Please click here to notify support. Report Execution Error: NetSuite has encountered an error while generating your report. Please click here to notify…

YesCondor, How far are you with this? are you done with this KPI?

I'm trying to put it on a dashboard using a custom portlet. as for now, i have created a custom record, and manually re-enter the budget by month.

wow, i am also trying to pull budget by month....cannot do it either....5 years later.

I have a similar problem. I have a report with all the customer name (grouped). I want to only post the top 10 customer. right now, i can't figure out how to just post the top 10 and not all the customers. i dont want to vote on an enhancement. that's not a solution. i could do save search, but i would need to use the…

Today, I asked Netsuite Support about CSV Import for Inbound Shipment. Netsuite does not support CSV Import for Inbound Shipment. Enhancement # 465181 Summary: Inbound Shipment Management= T > Ability to add Inbound Shipment records via CSV import

this seems like a big problem for the warehouse.

I checked and I could not find a conversion rate. There is a Quantity in Transaction Units field you can use that gives the actual quantity in whatever UOM you used in the transaction. With that, you can derive the conversion rate using this formula: {quantity}/{quantityuom} this works well....until you get quantityuom of…

It saved us a couple of things. 1) I don't need to do an inventory transfer to a separate location 2) I can do the fulfillment from either the preferred bin or from the storage bin. When you have the inventory in a seperate location, you would either need to move the inventory or do a separate fulfillment from that…

Hi Guys, What made you guys decided to create an overflow/storage bin? Why not create a location for storage instead of bin? I have a storage, and I want to figure out which method I should use. location as storage or just add a bin for storage.

yes of course. support linked me to enhancement request.

This would be a very useful function. After we print out a picking ticket, warehouse may not have the stock (it's not 100% accurate). We then back order it. When the goods is available, we need the warehouse to print it again. Currently we have to manually email warehouse to print it again. If we could just change the…

i have the exact same problem here.

fils = [['systemnotes.field','anyof','custrecord296']]; this works

'custrecord296' is the id of the field 'estimated sales'. it is what i want to filter.

just trying to do this, but suitescript keeps failing. fils = [[['systemnotes.type','is','Create'],'or',['systemnotes.field','anyof','custrecord296']],'and',['systemnotes.date','onorbefore','endofthisweek']]; :( Notice (SuiteScript) [TABLE="border: 0, cellpadding: 0, cellspacing: 0"] [TR] [TD="class: text"] An unexpected…

i wish netsuite would fix the line sequence number. i hate that nlapiSetLineItemValue doesn't work with line seq number & assembly items on your sales order

sorry ignore this post

nevermind it works.

i want to group then count the in the same column. not two different ones. for example, CASE WHEN {type}='item fulfillment' THEN {createdfrom.number} ELSE null END I want to group this, then count. I want to know # of Sales Order from these item fulfillment records. it doesn't seem to let me use GROUP for sql. it's a pain…

field that tells me if this ship to address is a hospital a school a casino etc

the employee who set pending approval to pending receipt into a custom field.

good idea. ill try it. thanks guys. how would i look it up the address ID? it's a field within a record. without knowing the internal ID to the record, would i need to do a search filter? *update* thanks, it works. i used nlapiCreateSearch

Here's how you can do it: function beforeLoad(type, form, request) { var addressList, aCustomField; addressList = form.getSubList('addressbook'); if (addressList) { aCustomField = addressList.addField('custpage_something', 'checkbox', 'My Checkbox'); } } I tried it, but nothing gets stored. it creates the field everytime i…