Olivier Gagnon NC Red Ribbon

You would need the Advanced Financials module to be able to recognize revenue differently. You'll need to speak to your NS account manager for pricing.

Are there client scripts deployed? Buggy client-side scripts could cause this

NetSuite enforces an arm's-length relationship between subsidiaries, so one sub cannot pay another sub's bills - this is currently by design. There are many ways to handle these situations, depending on how you want the accounting to come out and how much paper trail you want. If this is a frequent problem, once you have…

The new SuiteGL functionality might be a direction to look into, though I haven't had hands-on with it yet. Typically, though, if it's a New Install versus a Change Order, you really should be using different Items.

You can't add an export button on this specific screen, but you could call this view as an independant saved search and then export it. If you wanted to be fancy, you could add scripting that would call this search pre-filtered and then export to CSV, giving you a prompt to download.

Indirectly answering, try checking out this SuiteAnswer in regards to handling vendor prepayments in NS: https://netsuite.custhelp.com/app/answers/detail/a_id/11174/kw/vendor%20prepayment (you will need to be logged into Ns to follow that link)

It's not a configurable option, but it can be achieved with scripting.

Mmm. Nasty. Any opening balance remaining on transactions can either be applied to each other (open credits to open debits), or applied to a write-off journal (see the Help for details on making write-off journals). The commission is a bit more ugly. I've never run across this so am unsure exactly what would work. My…

You can use the Write Check functionality to make a miscellaneous cash disbursement. You do need to create a receiving entity, though, so you would need to create a Vendor. This could be a Vendor called "Miscellaneous" or perhaps something a little more specific like "Restaurant" or whatever the heck it is.

Yes, which is fine. You get the 14% bit, which is fine, and then the piggyback is pre-calculated and built into the 2.28% rate. Mathematically this is the same.

What you have found is correct. Tax codes must point to Tax Control accounts created via that functionality. No workaround exists.

NS will automatically, without you even needing to Close any Period, transfer over to retained Earnings when you switch Fiscal Year. NS just does it. No special step required. To be clear, of course, only P&L accounts move to retained earnings. BS accounts keep going.

This is called piggy-back taxation, where the VAT applies to the post-Tax amount. This is how taxes work in Quebec, for instance. I know that in the Canadian edition, when you set up your tax groups, there is a simple checkbox called Piggy Back that you can tick in to have the PST apply on top of the GST. I do not know if…

That is perplexing. I can only think of a script or a workflow running that would cause this. NS should certainly be defaulting the Terms to those of the Vendor. Do you see the terms changing when you're entering the order, or are you saying you have found saved POs with different terms? If the latter, could it just be a…

That sounds pretty normal. Balance Sheet accounts do not reset every fiscal year like Profit & Loss accounts do, so I would indeed expect that the BS portion of the TB show Dec 2013+Jan 2014. There are no year end proceses to complete in NetSuite. You should go through the Period Close checklist as usual, but there is…

You might be able to get away with it without opening periods, depending on your exact problem. You're a little light on details here. I assume what you're saying is that your AGING report doesn't agree with your GL, insinuating you have more open orders than the GL would indicate. What you need to figure out is if you…

I just checked, so the Piggy-Back checkbox is not available for India, and I assume not for Sri Lanka either. So, the workaround for now is to calculate the piggy-back into the base taxation amount. So if it's 2% piggy-backed on 14%, you actually need to create the tax code as 2% + 2%*14% = 2.28%.

I can confirm I discovered this a while back as well. Yeah, you need to create an Item. I don't see any way around it.

Yeah SO approval ought to work well. If for some reason it won't, a workflow or a script should be able to block further progress as well. You have several options.

Peter, this is more easily handled by using Assembly items. You can create an Assembly Item that contains part A and B. Buy the finished good from the Vendor, then use the Unbuild Assembly transaction to extract the two subcomponents from it.

There is no quick method, unless you automate it. You have to create a Journal hitting A/R and whatever write-off account you want. Then, you need to create a Payment to associate the write-off to the Invoice (or Payment, if you're killing off over-payments). While you can create a single Journal with a bunch of…

I think it should be possible via CSV Import. You need to Close each *line*, so yeah, you would need the order's internal Id but also the ID of each line so you can target them and tick in the Closed checkbox.

There is no standard feature to disallow this. There is no standard search that clearly spells it out, though it should be simple to run a Saved Search to pull this information and generate an error report. Alternatively, you could automate the synch with a script - when you save the Invoice, update the Fulfillment's date…

You want it to figure to COGS how? Just in general hit the COGS account or you want it to correctly be tied to the COGS of THAT item, so if you pulled an item profitability report, it would factor in the rebate?

Custom GL is available to all NetSuite accounts for free and can be enabled under Enable Features->SuiteCloud. Note that you will need a SuiteScript developer to write the custom code necessary to define your desired new GL Impacts.

No, that will not be possible. I think we should continue the conversation on your other thread first. You need a business process solution before you need a technical one.

Barry, I'm curious about your solution. Aren't you still just paying and receiving payment seperatly for both? Where is the netting aspect of it? Or is it just designed as a balancing method to make sure you did not make any errors? Also, how do you then get the money (positive or negative) to hit the actual bank account…

You could give users the ability to cause non-GL affecting changes in closed periods.

When you say "run a credit card", do you mean Verify the funds, or do you mean actually charge it? If you just want to Verify the funds, making sure the CC is good for what you intend to charge it, then this is fine as this happens at Sales Order time, which does not cause a GL Impact. There is no way to charge the card…

Ok, I see. Thanks