Olivier Gagnon NC Red Ribbon

I'm not sure how you'd show that much info ON the P&L... you're basically talking about the Inventory Activity Detail report. I'd run it as a seperate report.

Yes, you can filter which accounts are shown. I don't know how successful you'll be without tagging your GL Impacts to specific Locations, though. Any particular reason you want to avoid doing that?

Your transactions must be tagged with the correct department for it to appear correctly in reports. You may need a script or workflow to set a default department for web orders and other automatically created orders.

OneWorld is a great product. It is the only multi-subsidiary product in it's price bracket, which is a big deal. Overall it works very well. There are still functional gaps, like interco transactions, and some other functionalities don't work on OW (such as Estimated Gross Profit). However, all the problems with OW are…

Hmm... I vaguely remember something like this, years ago. My gut feeling is Netsuite stamped it with a "As Designed" stamp at the time, but I really can't recall the details... Ok I actually went back and read a few notes from way back when. I think the problem is that the only time Netsuite actually has the foreign…

Drilldown in the lines correctly classified on the report to see where they come from. My guess is there are a few transactions that were manually created or updated with the correct department.

At the bottom of your report, you should see a dropdown called "Column" that should presently be set at "Total". Open that dropdown, select Department (or Department (Hierarchy) if you prefer) and hit Refresh. Is that what you were looking for?

You cannot customize drilldown reports. You would have to switch to using Saved Search, which would solve that problem but overall deteriorate the user experience. The only true solution would be to rebuild that particular report from scratch using Suitelets. That would be prohibitively expensive to do.

I played around with this just now, so want to add some clarifications: If you are using Coastal ACH, the Vendor bank info CANNOT be imported. Must be manually keyed in. If you are using the EFT bundle, the Vendor bank info (called Entity Bank Detail) CAN be imported.

SuiteBundler does not do what you think it does. A Bundle is just a packaging of customizations (scripts, custom fields) for distribution and installation into other Netsuite accounts. I recommend you review the help on customizing NetSuite in more detail.

Well the bundler wouldn't move over data - save for custom record and list values. If you bundled your stuff out using the SDF rather than SuiteBundler, then you could just store the customzation definitions on your hard drive, since it spits it out in XML. Note however that SDF isn't quite fully functional, so you'd…

When Ncompass was acquired by Tribridge, we migrated our old instance into our shiny new Tribridge instance. The latter didn't have anything and we basically wanted to do a 100% copy, so I used a configuration bundle to move over our account settings lock stock and barrel into the new instance. No obstacles, nothing that…

Yes you can

Hello, I recommend you begin by reviewing the Help documentation found under SuiteCloud (Customization, Scripting, and Web Services)-> SuiteBundler-> SuiteBundler Overview

All of them. Was doing an instance copy. Beyond that, no. I can try to dig up the case we logged, though. Edit: Here we go: Case 2408646, Defect 389745

I thought JCurve accounts did not allow any kind of scripting?

Unless you changed the Internal IDs of the fields, NS thinks they are the same. It will ask you if you want to Replace existing or make copies. If they haven't changed, just replace existing. It won't wipe out your data.

Good to know, thanks for posting your experience

Well, to answer your immediate question - no, you'll never be able to delete your items because they appear on transactions. Inactivating them is the best you can do. In regards to one-shot items, there are sometimes other ways to handle that than creating a new item over and over again. Sometimes you can use a single…

Good guidance, thanks Paul

Yes, this is a LONG standing bug with NS. These should be "Other Assets", not Expenses. You must recreate all the tax control accounts for PST on Purchase. This will cause NS to properly recreate the accounts as Other Assets.

I don't understand your question. In HST situations, in the Tax Group, put all the tax in the GST field and set PST to nothing. GST and HST are reported the same. If you are dealing with provinces not on HST, then enter PST and GST separately in the Tax Group.

I'm Canadian :)

QST is PST, not GST. Quebec also does not use HST so showing that would be wrong. Literally, the label needs to be changed from "PST" to "QST". NetSuite doesn't make relabelling very easy, but try these steps from Suite Answers: Rename PST/GST fields on Printed forms [FONT=Verdana !important]This solution is applicable…

You can find it under: Accounting : General Accounting : Working with Currencie

You'll need to edit the Item Receipt, so long as you don't receive the Bill so far away from reception that the Item Receipt now sits in a Closed Period. If that happens, you're SOL. You'll need to do an Inventory Adjustment to increase the value of your goods. Horribly messy. Otherwise, you edit the Item Receipt and…

Hi Toby, Reviewing the Working with Currencies Help topic should give you a solid start on everything you need to know. Please post back if you have any specific questions after reading through that.

I just right-click and open frame in new tab and grab the URL from there. Using direct links is actually not terribly recommended since NS may change them at any time

Did you check with our friends at OzLink? They may have Canada Post integration already.

allow us to sell our products in Canada, So far no problem, you can sell wherever work within Gov't regulations I assume you mean taxes, but perhaps you seel products with specific regulations. If it's just taxes, that's an out-of-the-box tax setup. Other regulations would need to be analyzed. and handle transactions…