You would probably have better luck posting in the Marketplace forum: https://usergroup.netsuite.com/users/forumdisplay.php?f=108

This would be a very touchy operation that requires meticulous planning. I wouldn't recommend you do it on your own, but the steps would look something like this: - Full CSV Export of all orders that require update, for backup purposes. - If you want all your incorrect items to be converted to the correct one, a script…

There's a preference "Default Sales Order Status" under Setup > Accouting > Accounting Preferences > Order Management Tab. However, in your case since it's based on a certain value, you'll just need a simple script or maybe even a Workflow.

Hi Darrin, We have clients that have requested the same thing, and there doesn't seem to be any built-in way of doing it. A workaround would be to use SuiteScript to generate the statement PDF. That would allow you to do pretty much anything you want.

Ouch, I've never seen that happen before. Do you have any Client or User Event scripts deployed on Sales Orders?

I've noticed that sometimes it can take a few minutes for those values to reset themselves. If the issue is still present on your record, I would do as joachim suggested and file a case with NetSuite Support.

The new release of Netsuite allows for the partial fulfillment and partial receipt of transfer orders. From my recent experience with Transfer Orders, you can fully receive a partial number of lines, but you can't partially receive a line. Therefore, you should never have to edit lines that have already been…

Did you try editing the Summary report, and in the Edit Columns adding a new Amount column and changing the "Alternate Period Range" at the bottom?

I see what you mean. I was not aware that turning off "Use Item Cost as Transfer Cost" allowed for partial line fulfillments/receipts. In our case, we're doing Transfer Order integration using Web Services, and in the event of an over or under-receipt, since it is most likely a picking error as you mentioned, we flag the…

You would need a summary criteria Maximum and a formula field along the lines of "CASE WHEN {name} LIKE '%MEDIATYPE2%' THEN 1 ELSE 0 END" and filter using "is 0". EDIT: Oh and group your results by Parent : Name.

Yup Melissa. Welcome to the once-a-year headache. I have 10 clerks who will often key dozens of transactions which go into the wrong period before anyone notices that the 2010 periods haven't yet been opened!! I've asked NS to add a warning message to stop this. Pain every year!! Yeah, we have several clients who forget to…

What kind of transactions are we talking about? A fairly simple scheduled script should be able to change the account on those transactions to another account.

I was able to display the tracking number field on a custom Invoice form as you mentioned, but the tracking numbers still don't print on the invoices, whether it's PDF or HTML. Note that I don't have OzLink or Worldship on my demo instance. Did you customize your Transaction Form HTML Layout to show the tracking numbers?…

Gotcha. OK, so let's say you only want to print the first tracking number, you don't need scripting for that. Here's what you can do: - Create a custom Transaction Body field, call it "First Tracking Number" or whatever else you'd like; - Make the type Free-Form Text; - Uncheck Store Value; - In the Applies To tab, check…

Are tracking numbers usually displayed on printed Invoices? I'm not seeing them in my demo instance. Are you using a specific Shipping Integration module? If you have multiple tracking numbers, aren't they each for a separate package? Wouldn't the client want to see all of them?

Hi Ravi, The unit cost you're asking about, do you mean the item's selling price? The determined price depends on which features are enabled on your NetSuite instance. Go to Setup -> Company -> Enable Features -> Transactions tab. In the Sales section, the Multiple Prices and Quantity Pricing checkboxes will affect how…

We've done some barcode scanning for a few clients and the scanner we use is the Symbol LS 2208. Note that as long as the scanner emulates keyboard presses (most scanners do from what I understand), you should have no problem integrating it into NetSuite. Making it work exactly the way you want isn't always as simple,…

Hi Grace, Those are indeed default NetSuite accounts. The list of default accounts is hidden pretty well, but you can find it by searching for "Merging Accounts" in NetSuite Help. I'm not sure why NetSuite didn't want to delete the transactions themselves, but I would assume it's because if they say yes to one request like…

Sounds like some serious customization with lots of scripting to me. We're working on something similar for another client. You could implement something like: 1) On the Sales Order, enter the subscription start date, end date and pro-rated date. A client script would calculate the pro-rated amount for you. 2) When you…

A client asked us about the same issue. In their case, the culprit was multiple currencies. If you use multiple currencies, The Aging Report will never really match the Trial Balance, since Exchange Rate Variance is never reflected on the Aging Report.

One of our clients has mentioned that fuel surcharge is not added to his shipping charges as well. I will mention it to NetSuite Support next time I speak to them.

We've run into a similar request where a client wanted to prorate a child subscription price based on when the parent subscription was billed. I created a client script that calculated the prorated amount based on the start date, end date and subscription length. Here's a snippet: //Find the difference in days between the…

Did you consider making a Summary report, and when the user clicks on the summarized amount, show a detail report with additional info on each individual invoice? That would give you the sorting you're looking for.

I just tried it out and it does indeed looks like NetSuite doesn't let you group by Date on reports. The one I tested was Sales by Customer Detail. It's definitely possible via Saved Search. Maybe you could create a Saved Search instead of a Report? What kind of report were you trying to achieve?

Strange, I did exactly what you mentioned in your last post in a demo account and I got the customers sorted Descending by total sales. I double-checked and the first customer had total sales of ~400k with his highest single sale being about 4.5k. The second customer had a total sales of ~380k with a highest single sale of…

It may not be the easiest way, and the data won't be in a portlet, but you can create two or more identical reports with Allow Web Query turned on and load them into Excel. That way, each report can have different date filter and with a little Excel magic, you can have a Comparative version of pretty much any report.…

The issue where merge field names appear instead of the data after a merge happens to us a lot. Usually, copy-pasting the entire template document into a new file and using that one solves the problem. However, we do have one file right now that just always displays the field names instead of merged data, even after…

Unfortunately in our case, the files that require merging are legal documents such as NDAs and contracts which include headers, images and locking. I think we're stuck with the Word file.

Hi, Assuming the API has changed since you last posted this, I've been trying to get this to work with my own code and I always get this error: [code] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: com.netledger.common.schemabean.NLSchemaBeanException:…

I did some troubleshooting with the bundle and I think I found the problem. The bundle runs using custom records. One of those, "Search Pivot Layout", is generated when you click "Pivot Report" in a search and includes a field called "Saved Search Type". I tried creating a Transaction saved search and it did create a…