Mark Derrick Red Ribbon

These are forms customers fill in to make a request, often it's to open a trade account, or to register for an event, etc.

Adding files to Marketing Forms has been available for a while, don't recall when it was released.

Try this; REGEXP_REPLACE({custitem_ca_images_csv}, '([^,]+)', {custitem_ca_images_url}||'\1')

It's confusingly called "Customer Category" Hope this helps.

Have you looked at just creating a Saved Search to gather the data you need for the statement and then letting that create the Excel file?

Might need some context for this, how did you get the Test Drive account? There are specific departments in NetSuite which handle the provision of Test Drive accounts, and the additional modules connected to them - however, this will vary depending on whether you're a customer or a Partner. As far as I recall, SCA cannot…

is there a reason you're not storing the 'End User' sourced custom field?

This is a remarkable issue, in Dec 2012 CyberSource notified everyone that their validation was to be changed - did no one at NetSuite even bother to check whether this would break anything??? For anyone suffering this issue - I contacted CyberSource support and they removed our account from the new validation until we're…

Mark and Darren, We are currently on getting case updates (review outcomes) into NetSuite, which closes the loop if using DM to manage review orders. I can't comment on the availability date yet but we are actively working on it and optimistic it can be released in the short term. Darren, as part of our working…

Here's how we handle changing the value of the authorised order (upwards) Refund the original order onto a Credit Note, create a new Invoice transaction, pay for this with with the credit note plus a Customer Payment for the difference. Bit messy, but it saves playing around with the already authorised amount.

To be honest, I don't ever recall an option called "Uncheck Charged Credit Card" There have always been two options; [1] Get Authorization - this tells NS to bill the card [2] Credit Card Approved - you'd check this to tell NS to not Bill the card, but to indicate that you've billed it externally (this would also be…

Still there on mine, although it's called "Get Authorization"

NetSuite have actually provided this exact report in some of their vertical-specific versions. The basic outline is this; Saved Search on Transaction Criteria limits type to Sales Order and remove all lines not needed. Results then simply calculates Item Price from SO, times the quantity on the Item Fulfilment (Via…

What did you need to enable? Not seeing anything in "Enable features" relating to this.

Ah yes, sorry had brain slip for a moment there. I recall looking at this previously, but then realising that I'd have to update 80,000 products with their cycle count data - with no obvious means for doing a Mass Update, etc.

So, is there any way to pick a location, and then assign a cycle count period to everything in that location?

Eventually we had to go with a scripted solution. We now have a custom button on the form which prints to a different PDF layout

Yeah, we've been using that one for a while - but would really like to be able to specify a different PDF layout for a single user to use when printing from within the Item Record. Been looking to see if we can specify a PDF layout on a User Role, but this feature only seems to cover forms, not layouts. Mark.

Does anyone know whether it's possible to add the PDF Layout ID into the URL which triggers the label print? https://system.netsuite.com/app/accounting/print/barcodeprinter.nl?itemid=XXXXXX Mark. Is anyone from Netsuite able to help with this? As the "print labels" page allows different layouts to be selected, I'm assuming…

Does anyone know whether it's possible to add the PDF Layout ID into the URL which triggers the label print? https://system.netsuite.com/app/accounting/print/barcodeprinter.nl?itemid=XXXXXX Mark.

Well I have two layouts working very well together. [1] The Default layout looks after the bulk label printing when items are received [2] The new layout looks after printing single labels However, I still have to go to the "Print Item Labels" page to print off a single label - when I really need to be able to do this…

I've used a SuiteExtender from BlueBridgeOne previously to do this - worked really well. http://www.bluebridgeone.com/SuiteExtenders/Recently-Added/NetSuite-Promo-Item

Home > Set Preferences > Reporting/Search Then check "Show List When Only One Result"

Anyone doing anything like this?

If you use Date, rather than DateCreated this won't display the time.

Just been looking at the results for some of the searches I've built using this. Using "NEXT_DAY({today}-365,'SUNDAY'))" gives the Date for the NEXT Sunday, rather than the current one if {today}-365 = SUNDAY, which then causes the report to include 14 days in the reported week. 2012 being a leap year also seems to be…

Great, thanks very much - I needed to change a few lines to get it to match our weeks, but this is working perfectly for me now. CASE WHEN ({trandate} >= TRUNC({today},'IW') and {trandate} <= NEXT_DAY({today},'SUNDAY')) THEN {netamount} ELSE 0 END 1] Using IW rather than W, as this guarantees the accuracy of the week…

A transaction search will already contain the Line Items. Is your search set with the Criteria "Main Line = T"? This will then cause the search to only return summary data about the order.

OK, try using a simple formula to take away the net amount from the amount - that should then show you the discount value.

Do you need to know the discount used, or simply the value? If it's just the value, you could also do a Amount - Net Amount sum to see the value of the discount. Mark.