Scary Olivier!

Hi Melissa. Ok, try this journal entry: Credit Cash (or whatever acct you use to hold the till cash) Debit A/R On the A/R line, make sure to put the customer's name in the "Name" field that will make it show on that customer's A/R. The customer should now be showing that they owe a balance in A/R. Use the Accept Customer…

Another suggestion is to do the billing outside of NetSuite and just import the results. I assume you are billing credit cards. If so, there is automated billing available in the Payflow gateway. You set up the amount and frequency and the gateway does it for you. Then you just export a file of the results, take that file…

Wow, Miguel, I did not know that nuiance!! Thanks for enlightening us!! A poor design. The reporting by date/period really should not be a user preference but rather a company-wide or subsidiary-wide preference. This is a constant problem to make sure all employees' preferences (and roles) are set correctly to the…

Hi Melissa. This is a complicated question! Ok, I did some fiddling. If you can go back to the original transaction (I assume a Cash Sale) where the gift certificate was purchased, and then you click "Refund", that will spawn a Cash Refund linked to the orig Cash Sale, with the exact same gift certificate code. This is the…

You can write a server-side script to loop thru all of them and mark the "closed" box. I did this to change Department on about 2000 txns and it worked great. You can find my other post with the Javascript code to change the Department. It is basically the same code except you will change a different field. Here's the link…

Hi Melissa, I edited my post again, so make sure to read the post from the usergroup site and not your stale email.

Hi Carrie, are you Reporting by Period, or Reporting by Date? (Note: each user has to set this in their User Preferences & gotcha: make sure every user is set the same way if they are running financial reports!). If you have transactions where the date and the accounting period are in different months, you will get…

Ok, Ted, you'll have to do a Journal Entry: Debit Monthly Store Fee expense $39.99 Credit Undeposited Funds $6.99 Credit Business Credit Card $33.00 Then go into Make Deposits and you'll see the positive $6.99 and the negative $6.99. Mark both of them so they net to zero. You'll have to deposit that zero dollar deposit…

Ted, use the "Cash Back" tab on the Make Deposits screen, and then allocate the cash back amount to the correct expense account for the monthly fee. The net of the two will be $33.00.

Hi Steve. Did you get this resolved?

Carrie, if you have any restrictions to block transactions by dept or class or location, and your role is restricted, you will not see the blocked transactions although they are in there and do affect the balance sheet. Rule this out first. Switch to an Administrator role so you are wide-open.

PayPal definately should be a bank account because it really is a bank account, i.e., it holds money, they pay interest, you make deposits & withdrawals. So it is properly put on your Balance Sheet as a bank account. Now for Amazon, yes having it as a Bank Account or even an Other Current Asset account would allow you…

You need to have the transaction in "Edit" mode, not "View mode". In "Edit" mode, you will get both a "Void" and a "Delete" button. From online help: If you do not see a Void button on customer sales or vendor bills, the preference to void transactions with a reversing journal entry has been enabled. For more information,…

I was not aware of the Use Credit Card not showing bank accounts. Do you have your Use Expanded Account Lists option enabled (that causes NS to show almost all of the G/L accts instead of a more limited subset)? Because there is a real use case for this scenario: when you take a cash advance on your credit card and deposit…

My pleasure! We can now wait 5 years for them to do the enhancement request so we can book cash advances!! :)

My help has been buggy lately, too. Have to try it several times to get it come-up, but then the search doesn't work!! Anyhow, yes I am sure about voiding Bills. I tested it. You have to shut-off the Use Reversing Journals option in order to get the Void button.

Can't you just VOID the Bill? You may have the Void button disabled on your role, but if you pick Administrator, you should get a Void button.

Or you can add the field "Amount Due on Invoice" to the invoice and it will show zero if it is paid. I think this prints at the bottom under the Invoice Amount line.

Malin, another suggestion with periods that bites me every year around New Years. Since you have to create the new periods each year, sometimes we are tardy and don't do this timely. So then comes the first week in January, and the clerks start entering transactions. There is no period yet created for Jan 2010, so NS uses…

If you have any security restrictions on the kinds of transactions that a user is allow to view, then that user won't see those in the register, and the register will appear totally wrong balance. Look at the register again logged-in as the administrator and see if the balance is different.

Hi Julian, you may have the wrong forms. You need to get the correct 2-Up laser forms (top & bottom) from NEBS or make sure the vendor you use conforms to the same specs as the NEBS forms. Some states require that you send 2 copies to the receipient; other states require 3 copies to be sent to the receipient. You need to…

You may have to print the 1096 separately from the 1099's (you can print just page 1 in Acrobat reader), and also you may have to fiddle with the Vertical and Horizontal offsets in your User Preferences even differently between the 1096 and the 1099's

That was an old complaint!! They added the 1096 enhancement request...finally!!! (Thx NS)

meatsju, when you import via WS, can you explictly import the CC fields with values set null or "" value? That should stop the copying of the CC info from the customer record over to the transaction record.

Hi Miguel, I did have to change my offsets for the 1099's from what I use for every-day printing of checks and forms, so this is the usual experience. Glad to hear you got it to work. Did you use non-NEBS forms successfully (i.e., Staples or Office Depot?)

Yes you must order the specific NEBS forms. And, yes, you must fiddle with the Fit to Page or No Scaling setting in the PDF printer window. And lastly, you can adjust the horiz and vertical offset in your user settings. You sometimes have to adjust the offsets. Remember these offsets are set on each user's preferences, so…

There are 2 different problems here: (1) You have received Inventory (debit asset/credit IRNB). But no one every keyed the Bill. So you are missing the (credit A/P, debit IRNB) piece. So the first thing you need to scan for is received stuff that hasn't had the bill entered yet. You can write reports searching for Unbilled…

you have to figure-out the "From" in those auto emails, and that "From" has to be on your faxaway account so faxaway recognizes who to charge for the outgoing faxes. I'm not sure if you can control the "From" on those auto-emails (you'll have to test). If you can't control it, then don't do it because you'll be charged for…

What about the other way around, i.e., make the intermediary the customer since they are legally liable for the debt, then make the ship to your customer. Or else you can do a parent/child relationship between the 2 customer records. I believe you can pick parent & children in the same chain in the ShipTo/BillTo boxes.