Olivier Gagnon NC Red Ribbon

Yes, I have done this. There was just another thread with the same question a few days ago. You can't have overlapping periods, so you'll need to make sure to reduce the second period's size before increasing the other one. Should work out fine.

Customer PO# cannot be made to default from any other field. You have 2 options: a. Create a custom field on the SO, and on the definition pick which field you want to default from b. Create a script or workflow to set the value of Customer PO from the desired field Option A is simplest and I would recommend that.

No, that is not possible. You would need to void the check and properly create a new payment.

Open up SuiteAnswer and type "write off". You should find a knowledge base article describing step-by-step how to record a write-off using a Journal. Let me know if you have trouble funding those instructions.

A workflow or script is indeed the only way to accomplish this.

This would to some degree be possible with scripting.

Those seem to be unrelated questions, so here are two answers: 1. AP Aging not equal to BS: Are you reporting BS by date or by period? AP Aging is by date, so if BS is by Period, and your system allows date/period mismatches, this would be a common source of misalignment. The AP Aging could also be filtered to exclude some…

Fair pricing. Most of the ARM module is in regards to fair pricing. If you just need rev rec, then you're good. But if you need fair pricing, then most of ARM's functionality exists to support this. In a nutshell, let's say I sell you a server (hardware) with a software program and 12 months of support. And I say I'll sell…

If you want it to sit on A/R you just need to create an Unapplied payment. Since that seems odd from an accounting perspective, you might want that to sit in a liability account instead, so if that's the case, use a Customer Deposit.

NetSuite has no netting functionality. You must pay both separately.

Hmm. Did you change the mentionned settings AFTER the SO had been created (bill in advance in particular)? Sometimes setting changes don't kick in for existing orders. Otherwise, bit of a mystery here.

Ah, then you need to add a logic to your auto-allocation program to exclude certain invoices. Sounds like you would simply add a checkbox on Customers and edit your allocation code to filter out all such customers. Contact the person that created the auto-allocation code, or contact another Partner, and have the code…

Errr.. can you expand on your use case? I send an Invoice to a customer, he sends a check. You DON'T want to apply that check to the Invoice... why not? This clarification may drive potential solutions. Otherwise, I would say you need scripting to do that, but I don't understand the scenario.

Really. I wouldn't have expected that particular causality. Interesting. Although, yeah, that checkbox should basically always be ticked in, so that sounds like a good resolution.

Hello, You are correct, NetSuite does not handle this scenario. If you have simple needs that do not go beyond a few use cases such as above, I recommend getting a solution custom built for your needs. If you have general complex taxation needs, I recommend getting the Avatax 3rd party product from Avalara.

Hi John, If I remember all my settings correctly, Checkbox/Not checkbox is a US tax thing when you're not using advanced tax. I think the dropdown starts occurring as soon as you have multiple nexuses and/or advanced taxes. Getting the right tax code to default requires a lot of configuration involving many screens. It'll…

Hi Sue, I'm afraid I'm not knowledgeable about European taxes to fully answer this. I would say that it's possible that Poland invoice you with RC-PL, but that you may need to book it under something else in UK (and vice-versa). In the UK and Europe, tax codes are a little funky and there are many intricate settings that…

Hello Sue Melly, Please take a look at Help topics "Accounting ->Taxation-> United Kingdom Tax Topics-> Creating Tax Codes - U.K.". The biggest thing that stands out to me is that RC is not an EC code, so I imagine it would not appear in the Quarterly EC sales list.

This can only be achieved via customization (scripting).

Actually, sorry, may have misread this. You're talking about a new Polish subsidiary... but you're also talking about using the RC code... Are you trying to use UK tax codes for transactions belonging to the Polish subsidiary? Did you set up the Polish sub's tax settings properly first? In practice, there isn't really any…

You don't need a billing schedule to handle that. Just execute a "Invoice Billable Customers" run on the 15th and the last of the month, and you'll just pick up the time that's there and invoice it. A billing schedule would only be relevant if each project needed to be billed at specific intervals relating to it's own…

You could add a custom field on the Estimate and link it to SO that way. The only other option to to Allow Invoicing ahead of Fulfillmnent, but I got the sense the GL impact of the Invoice was not what you wanted.

Since the voiding Journal has a different date than the original Payment, was your report date range wide enough to pick up both?

Here is a recipe I've used a few times before: 1. Create a Credit Memo 2. For every item you want to credit taxes, add the item TWICE on the Credit Memo 3. The first copy of the item, leave the full Amount and leave the tax code on 4. The second copy of the item, set the Amount to be negative and remove the tax code, so…

I would recommend issuing Estimates, if you're not using them for anything, to collect the down payment. You can modify their Layout to make them look like invoices. You can then issue them to customers, and they will be non-GL affecting. You can then record the received funds as a Customer Deposit. If you are already…

Replace the Inventory Item(s) with a generic Non-Inventory item (call it "Misc Refund"), and then follow the rest of the steps described here.

Ok, I reread and I don't get the problem with SF.com. The Estimate in NS is just to make a piece of paper to collect the down payment. SF.com doesn't need it, so it shouldn't be a problem if it doesn't have it, right? Or are you maybe saying you don't want to create the estimate IN NS, that this has to be a record…

Not really. Not unless you want to edit the rev commit, set the Amount to what has already been recognized, then edit the rev rec schedule and set the start and end dates to the actual time passed, thus ending the recognition. An alternative would be to Hold Rev Rec on the schedules you want to stop, but that will generate…

It is NOT possible to give access to JUST JEs that do not have a blank Name. NS does not offer that granularity. They will have access to all JEs or none at all. However, they may not need access to the JEs. If you give them access to the AR Aging report that should give them visibility, in general, to what clients owe. If…

Vendor Payments are exposed via the CSV Import engine. Read the help for additional information