We provide web site management services which may be of interest to you. Please contact us directly for a free web discovery meeting to discuss your needs.

Training courses, manuals, the NS UG, etc can help you learn NS, to some degree. However, NS users may, at times, not have the skills / aptitude to carry out all the functions in NS, because of the "I'm a ......, not an accountant" scenario mentioned earlier. At those times, NS users should have an accountant available…

One of the contacts noted below could be a fit for your projects. All the best, Barry Boese [EMAIL="bboese@baacoffice.com"]bboese@baacoffice.com[/EMAIL] www.baacoffice.com Full Name: Ray Tetlow Company: Skyytek Business: (305) 672-7240 x101 E-mail: [EMAIL="rtetlow@skyytek.com"]rtetlow@skyytek.com[/EMAIL] Web Page:…

Another option is to insert the short payment in the Disc. Taken column on the Accept Customer Payments screen for those invoices that are shortpaid. This will then also highlight how much is shortpaid on your Income Statment, under your Sales Discount account or other account attached to the Discount column.

See more recent solution to this issue at link below, called SuiteSolution - Shared Vendor Bills, and check with your NetSuite Account Manager for details. http://www.netsuite.com/portal/pdf/suitesolutions-shared-vendor-bills.pdf

I've seen a number of your posts related to opening balances, etc and feel free to contact me for a free web discovery meeting so I can review your specific opening transactions. We can then find a way to help fix these for you, and provide other suggestions and recommendations on how to proceed forward with accounting…

Sometimes if there are numerous transactions (like the page listing pull down at the right top side of all the transactions shows# of 10000), there are too many to clear on one transaction. If you go back and filter date range so that if the # of 10,000 currently appears for you, if you filter the date range to an older…

You can go back to the check (or bill payment) and Edit it and uncheck the To be Printed box, and then insert the manual check # if you issued a manual check, or you can enter something like "Online pymt 2014 04 11 Rent" in the check number field if you paid via your online banking system.

Try this: a) go to the Make Deposits screen and if the old customer payments are still on that screen (or if they are filtered out, make sure "All" is selected), Select All, and date the transaction something like 12 31 2013 (or different date of your choice) b) since a) will place an uncleared transaction into your bank…

There are a number of questions to answer prior to proceeding with this "clean-up" effort. See questions and suggestions below, however please note that as with any new "clean-up" effort, tread carefully and only process one or two transactions initially and see how they've impacted the financial statements, and if the…

The dreaded reference to "journal entries" again:) To rid yourself of No Vendor or No Customer transactions showing up in your AP or AR reports, avoid using JEs wherever possible. For example, see solution at link below which avoided the use of JEs. If you believe you have a situation which requires a JE, feel free to post…

Another option would be to enter vendor bills (either directly or linked to POs) and then make payment via the credit card account, instead of the bank account, as is done with normal accruals for vendor bills and payments. In other words, direct Enter Credit Card charges only allows for one date, whereas Enter Bill and…

See an option of how to pay AR and AP amounts for customers who are also suppliers, per link and text below. This maintains AP and AR integrity and allows for viewing of AP and AR transactions, and how they were paid, etc. As noted in e) below, it's strongly suggested to stay away from Journal Entries unless absolutely no…

Try this solution below. There is some initial setup as noted below, however once set up, future similar transactions can be looked after very quickly. If you need help with this, please let me know. 1) create an invoice for this customer for the amount of the deposit, and at the line level add an Item (either Other Charge…

Credit memos sounds like it could be workable, and since it looks like you have a few variables, it's hard to keep the answer short here. If you wish to review this during a free web meeting with me, where I could walk you through one or more options, please let me know.

Olivier, You are correct that transactions for both the customer and vendor side are separately recorded via this option. b) and c) below show the way these transactions are netted against each other. Yes, c) ensures it all balances. Once those steps are completed, if the vendor is still owed a balance, it can be paid…

Another option could be to 1. open up the periods back to those transactions 2. then enter the Vendor Name into those JEs 3. then clear them off on the Pay Single Vendor screen with a current dated transaction (may need to post a current dated bill or credit memo to offset the old transaction), so that you don't change the…

I'd also suggest if you go this route, when you Accept Customer Payment, additional scripting, etc will be required, since the Accept Customer payment screen currently only allows for 1 AR type account to be picked, so that payment can be applied to the correct invoice(s). I'm also interested in the use case, since there…

We've developed saved searches (SS) too, with email alerts, for the AR collection processes for a number of companies. This can be done without the need for spreadsheets, and can be done at the customer level, so that it's not as time intensive as it would be at the individual invoice level. The SSs can be shared to others…

If you want another set of eyes on this issue, to see if this can be resolved, just contact me directly for a free web meeting.

Hi Mike, Another option is: a) don't process invoice from SO, until after SO fulfilled - see e) below when to invoice b) record customer deposit for payments received in advance of fulfillment c) customize SO form to say something like "Proforma Invoice" instead of Sales Order and save that as a form you can use and print…

Hi Natalie, You can post invoices to those customers with credits, and then apply the credit memos to the applicable invoices, and then the credits will disappear from the AR reports. Ideally you can post the Invoice amounts to the same Item or Accounts as the credit memo. However, if it's an Inventory Item, you likely…

I'd suggest adding a new Other Charge for Sale item called something like "Clear AR Credits" and choose an Income Account on that Item such as Freight or Cost of Goods Sold or Purchases. If you can't select a COGS or Expense type account from the pull down, it can help to go to Setup>Accounting>Accounting Preferences and…

Hi Tom, We may be able to help you with this, and if you are interested in discussing further, please contact me directly.

The decision to use or not use Sales Orders is a critical issue. If you and your Controller would like to discuss this in more detail with me during a free web / phone discovery meeting, please let me know.

You can customize the Estimate (or Sales Order) form to say "Performa Invoice" or "Proforma Invoice" at the top right, and save it as a form and select under Custom Form pull down, then print, fax or email to customer, with no GL impact

To help with these questions: a) you can determine which Account is involved when billing (invoicing) to customers, by inserting that account in "Track Billable Expenses in" field in the Account where you track these expenses, such as Travel, etc. So, you can either set this field to a Revenue account, or directly to the…

Hi Cheryl, Just wanted to suggest to your Accountant that NS and ACCPAC are different worlds. ACCPAC and the world of batch posting transactions and reversing entries has long been surpassed by NS's real time processing. NS also has an audit trail (see link below) and under the History>System Notes tab of each transaction…

Yes, those details are also included with the remittance, so it makes it easier for the vendor to record which invoices were paid in their system, etc.

We work with many companies that regularly use Online Bill Pay, and it normally works quite well, and we've mostly heard just positive comments and results. Some things that you may wish to consider, but should not override the positive aspects of online bill pay, include: a) the 3rd party mails the checks out, so…