On this same topic, can someone advise how we can take the "Inventory Activity Detail Report" and alter it so that it only shows the total number shipped (for of each item)? If you just need shipping quantities, you should be able to get what you need by customizing the Shipping Report found under the Sales section of the…

Although Bin Putaway Worksheets can't be imported, you can use SuiteScript or Web Services to create them. Therefore, an alternative solution is to import custom records with the required data, and use a script or web service app to create the Bin Putaway Worksheets accordingly. FYI, if you search for "SuiteFlex Supported…

It's possible your shipping methods were not properly set up. Go to Lists > Accounting > Shipping Items and check your USPS shipping method(s) to make sure they're not configured as UPS.

Pacejet is the newcomer compared to OzLink, as far as NetSuite integration is concerned. This is probably why there isn't much feedback on them yet. Although we don't have any customers who use their services yet, they definitely seem to have their act together. I would suggest to call both of them up, describe your needs…

We have multiple customers who use OzLink and very few of them (if any) have had any problems with them.

Did you consider using a group item? It has its own UPC, can be received as a single item and will give you the stock you need. Edit: Now that I tried it out, looks like you'd be receiving all the items individually, as NetSuite doesn't let you receive the group. Kits are also not an option since they can't be purchased.…

Your best bet is to create a custom Item field, fill in the shipping instructions directly on the Item Records inside this new field, and then create a custom Transaction Column field which will source the value from the Item record, and print it on your drop-ship PO form.

Yeah that can be a pain, though it could be easily automated with a client-side script. The script would look at the Item record, find the Preferred bin and set it on the Receipt.

Inventory Received Not Billed is affected both when items are received and not yet billed, but also if there is a discrepancy between your PO rate and your Bill rate. For example: [LIST] [*]You create a PO for an item with a rate of 5$. [*]You receive the item by creating the Item Receipt. NetSuite assigns the item a value…

Indeed if you're being billed for 20 items and not one carton, the assembly item route is not viable. As khultquist mentioned, a customization involving scripting and a custom record would do the job.

As far as I know there's no way to change this behavior with built-in preferences. However, using scripting you could have a User Event script trigger on creation of Sales Orders and reset the default address back to what it was before.

Hi Peter, How are you getting those fields to display on your printout? If you've included the field in the "Body Fields" of the PDF through the "Printing Fields" tab of the form, it should already wrap and display all characters. If you've added the field as a Custom Element through the PDF Layout editor, there is a…

The basic rule is if you can direct-list edit it, you can mass update it. Usually, the field also needs to be available on the preferred form of the record you're trying to mass update, just like CSV Imports.

Is there a csv import for transfer orders? There is currently no way to import Transfer Orders directly through CSV. Since the Transfer Order record is exposed to SuiteScript, you could import Transfer Order data through CSV into a custom record and then creating the Transfer Order using scripts.

Generally the dense_rank function is used when your data is already summarized/grouped. For example, if you have a search of sales orders grouped by year with a count of how many sales per year, total amount per year, etc. and you wanted to see on the same line the name of the customer who did the largest single sale for…

If you use DENSE_RANK() OVER (ORDER BY {shippingamount}-{actualshipping}) it should work in the columns, but if you try to sort using that column or if you try to use it as a search criteria, NetSuite will return an Unexpected Error. Normally that would be how you would do it. You can always try to file a case with…

This could be done by scripting: - Custom Suitelet that, when run, displays a list of orders (based on a Saved Search) and a potential batch number. - The user clicks "generate batch", which sets the batch number on the displayed orders and generates a PDF for picking. That's just an example of how it could work, but it…

It depends what you need exactly on the packing slip. If you only need the customer address, then adding a second page might be the solution. Go to Setup > Customization > Transaction Form PDF Layouts and click Edit on the Standard Transaction Layout. From there, you can change the Height of the layout to two pages instead…

Hi, Did anyone get the 2nd page approach to work? I created a new template with 22" height but it still prints as one page only. I just tested it out and it worked, but I did have to change some printer options before printing. With our HP printer, I had to change Page Scaling to Tile Large Pages.

I have heard that bins need to be manually updated with quantities. If a box has 10 jackets, and you sell all 10, a manual restock needs to be performed. With 3000 items, you would need to manually update an item every time the box gets refilled... That's not quite the case. The normal process when using bins is to specify…

We have been working on printing preferred bin numbers on item/rack labels also. Do you have a sample of this simple script? I can't post actual code, but here are some guidelines to get you started: - Create a custom Item field "Preferred Bin". - Create a User Event Script Before Submit on Item record. [INDENT]- Loop…

What about printing the preferred bin #? NetSuite supports multiple preferred bins (one per location), so it still wouldn't know which one you wanted to print. If you wanted to always print the preferred bin of a specific location, a simple script on the Item record could copy that bin number to a custom field, and that…

We are also looking for any solution to automatically send the PO to the vendor (hopefully as HTML) and also attaching our packing slip to the email (hopefully as a PDF). This is the holy grail for our solution and i need to do so for it to be automated. Any ideas? Please fire them at this thread..! Hi Ryan, So just to…

Unless they changed it in 2010.1, you can turn on Use Bins on an item after having created it. However, I would highly discourage turning on the Bins feature if you're not planning to use it right away. It may add hurdles to your processes that would otherwise be avoided, such as forcing you to associate item records to…

That could be done using scripting. Using a User Event script triggered on vendor creation, you could generate the needed HTML and PDF and send the email accordingly. It's not simple, especially the PDF generation, but it's definitely possible. We've done custom PDFs and custom HTML emails for customers before.

You can have multiple bins per location and per item. How would NetSuite know which one you want to print?

You could do this using a simple client script on the Item Fulfillment. The simplest solution would probably be a script triggered when the user saves the Fulfillment record: a prompt would pop up "You have entered overages. Are you sure you want to save?" with a Yes/No option.

Did you create Shipping Items (Lists > Accounting > Shipping Items) for each of the third-party shipping type you integrated? Are they marked "Display in Website"?

One of our largest clients use DotCom Distribution, and we implemented web service connectors with their system using Talend, and open-source data integration development platform. It's a pretty solid solution and has been working for over 8 months now.

Indeed, bins are somewhat limited in terms of that kind of customization. Could you please be a bit more specific as to what you're trying to achieve? Where are you trying to print item labels from?