Olivier Gagnon NC Red Ribbon

I'm not sure I understand. You can close a period at any point, yes. I'm not sure I get why you want to create a new period? Can you expand a little on this?

Well this is an involved topic, so I'd probably recommend you enlist the help of a consultant to help you get this right (and perhaps avoid the previous owner's misuse problems), but I'll try to answer what I can - You can certainly change the Account Numbers from you Chart of Account. You can do that anytime whithout any…

Hmm. No, haven't seen that one. I suspect this has something to do with Shipping Integration. I would review those settings and see if anything jumps out. You could also file a Case, I'm sure NS could quickly let you know the root cause of that error.

Actually, now that you mention it, something seems off here. Building an Assembly should be deducting Inventory Asset of the parts and increasing Inventory Asset of the finished good. Those are both Balance Sheet hits. The P&L Impact should be occurring when COGS hits, which is at Item Fulfillment time and thus should be…

This is not possible out of the box. You would need to manually post Journals to make the proper adjustments (back out the original impact, post it back when desired). Scripting would likely be necessary here to keep on top of things, as manually handling this seems pretty daunting.

Can you apply the same discount on the credit?

Normally you would import the transactions and then import a reversing Journal entry to neutralize the GL impacts. Considering this is an AR affectation though, you'll need to be extra careful about applying the reversals to the Invoices to close them off. While not something necessarely done often, you may also consider…

I'm having a flashback, did you already ask about this a few days ago, or was it coincidentally someone else? In any case, this is not possible. The proper mechanism is to use an Work Order. Work Orders are non-posting and do not affect inventory. You can place an approval process on these, and when approved, generate the…

You would need scripting in NetSuite to automatically assign the correct department based on pre-defined logic. I don't know enough about Concur to say if such rules could be otherwise defined there.

It is not possible to filter standard lists and there is no preference in NS (that I can think of, anyway) to filter out Prospects. What you would need to do is create a custom dropdown field with appropriate filters, showing only Customers. Then, use a script or a workflow to transfer the selected value into the "real"…

Same answer for me :)

I have to admit I'm a little rusty on the WIP module. Job costing I can tell you won't do this, no. WIP... maybe, but I don't think so, from memory. I don't think there is any module that does this.

Mhm... that's a little tricky. One idea might be to swap out the Expense Account on your items for a Deferred Expense account (Balance Sheet ledger). That way when you consume the items in a build, they go to the balance sheet. Then, when you close up your project, you would need to manually post a Journal to flush the…

Haven't come across any Import Tax functionality like that, but here is the trick I normally recommend: On your bill, add a Non-Inventory item called "IMPORT TAX". You're going to apply normal HST tax code to this item. Since you want XXX$ in HST, figure out what the base value of the line item needs to be to his that…

There are not specific throttle mechanisms in place, but there will be a practical limit due to simple performance considerations.

It's in the Help: Accounting -> General Accounting -> Working with the Chart of Accounts

Seperate processes will, to some degree, be possible. There isn't a straight answer, it will really depend on what those processes are. In general though, OneWorld is recommended for businesses where all subsidiaries do not have dramatically different workflows. Some settings will be global, and so won't allow per-sub…

Can that be done automatically or does a script need to be written for that? I believe the Account selector is a "sticky" and will remember what your last selection was. Could be wrong about that. Otherwise, you could always use a script or workflow to control it, yeah.

When creating Refunds, it asks you for Account, up in the header. Select Undeposited Funds here.

NetSuite does not come standard with account number, so there is no "typical" number for Undeposited. It is an Asset though, so 9998 would not normally be correct, but that numbering scheme sounds like a "I don't know" kind of number, so who knows... Probably best way to find out is to create a Cash Sale. They have the…

Hi Bill, I think you just need to go to Setup->Accounting->Set Up Taxes, click on Canada, and untick "Enable Tax Lookup On Sales and Purchases". Make sure the default tax code is set to "." and I think that ought to do it. Maybe also make your Tax Schedules all say your provinces are set to "." as well.

Are your Journals approved?

Yeah I just don't think you can, like, entirely yank the whole functionality out. I think you can just tell it to sit down and be quiet, but that's it.

No, that concept is incompatible with the design of OneWorld. You will need to edit every report and every search to exclude that sub. You'll also need to make sure never to eliminate as that would create nonsensical consolidated entries as well. Basically, the product is really not designed to support that.

Hi Wes, Netsuite will not automatically update your rates, but I also seriously do NOT recommend updating them as per the above instructions. You don't want to *update* the rates because then, if for whatever reason you ever need to edit a past transaction for any reason (maybe edit the memo, maybe correct something), then…

Another option, quite possibly cheaper than an export, is purchasing a "parked" or "archived" NetSuite access. This gives you 1 user with read-only access to NetSuite. So, you get to keep all your data without the hassles of exporting.

You can either create the Vendor at that time, but if it truly isn't important, then yo can create a generic Vendor you can use in these situations. You could call the Vendor "Misc Restaurant" or even "Misc Expense".

Why do you need to reverse it?

This is a frequent request, but NetSuite does not yet allow consolidated invoicing. A simulacrum of this functionality can sometimes be achieved using scripting, depending on your exact requirements.

No, you don't want to do it that way. A/R should be set/imported via the transactions themselves (as you're doing). However, you should NOT then reverse them and set them with the opening balance. What you want to do is "carve out" any AR impact from your opening balance file. So, you only ever import AR impacts once, not…