Hi Sam, We provide collections and other related services directly in NetSuite, and saved searches, reports, etc can be setup so you can monitor collections issues. Feel free to contact me directly for a free web discovery meeting where we can review and discuss your specific needs.

Sara, Editing memorized transactions can be a bit tricky. Instead of going to a recent memorized bill, try the following: a) go to Transactions>Management>Enter Memorized Transactions b) click Enter on the bill which you'd like to edit c) edit the bill by adding the appropriate department, and if the $ amount has changed,…

Another option is to: a) open up a Bank account and call it something like "Contra Customer / Vendor Payments" b) go about Accept Customer Payments and Pay Bills in normal fashion, except select the bank account noted above c) ensure the bank account noted in a) above always nets to zero. For example, if you pay down a…

This is one suggestion that could be modified to suit: a) Transactions>Enter Vendor Credit - for amount of the loan, and apply to open Vendor Bills, and under Expenses tab, pick the Vendor Loan (under Liabilities) account (set up if you have not done so already) If you can only see Expense accounts, go to…

You may want to fine-tune this depending on some of your processes: a) when the NSF check is withdrawn from your bank account, you can go to Write Checks, enter the customer name in the Payee field, and enter the amount that was withdrawn from the bank account, and record to an Account that could be titled NSF checks (can…

Carrie, If you are still having issues with the AR aging (or other issues), please contact me directly, as I'd like to help.

Post #6 at the link below may be helpful: https://usergroup.netsuite.com/users/showthread.php?t=17&highlight=prepay+vendor

See link below: https://usergroup.netsuite.com/users/showthread.php?t=11335&highlight=inventory+billed

Try this: a) go to Home>Set Preferences>Reporting/Search b) if you have Accounting Periods turned on, a Report by Period field should show on this screen. c) this may be set to Financials Only or All Reports. Change this user preference to Never If this does not help, please provide more details. By the way, this change…

if you call or email me, we can schedule a web meeting to take a look for a resolution.

If you wish, contact me offline and I can take a look.

Hi Sukriti, I'll contact you offline so we can connect.

Logic? I'm an accountant - some believe we don't think logically :) I'm not a software developer, and don't know the logic of the database, however I do find some tricks that just happen to work.

I'd recommend you look at turning AR on, not only for these types of transactions, but others that may come your way in the future. For example, many companies miss out on significant sales if they don't offer any terms to deserving customers. Sure there is a risk, which can be managed, and some bad debts can occur,…

One option is to a) create a new "bank" account and name it something like "AR/AP Clearing". b) Then, go to the Bill or Invoice that is the lower amount, and pay that via this AR/AP Clearing account (in other words, make sure the Account is set to this new account, instead of the normal checking / operating account). For…

For the Generate Statement (Print Statement) screen, could a Customize button be easily added by NS? Then, the user could customize and add one or more filters (or additional columns), to filter which customers show on the screen. This would be very similar to what can already be done on a number of different screens,…

Switch from the Advanced to the Standard PDF format, and see if that works. Also, feel free to contact me for an initial free web discovery meeting where we can review that specific issue (and other Netsuite issues) and find a way to resolve.

For larger check runs, including many checks with many bill payments (that don't fit on normal stub size), is there a way to Print Voucher for all the checks, all at once? Print Voucher functionality came out in Version 11.0.3, so is Print Voucher functionality going to be expanded in the next release to include the…

You could do the following: a) Enter Bill and Pay Bill (or Write Check) to supplier for the advance amount (i.e $50,000), and code to Cost of Goods Sold or another COGS or Expense account b) immediately Enter Vendor Credit for same amount ($50,000), and code to same account as per a) above c) when Vendor Bill arrives,…

As another option, we have seen Canadian companies use either Ceridian or ADP as their payroll outsourcer, and then just enter a journal entry for each payroll. It can be quite effective and efficient, depending on your needs.

Any updates / references from anyone that integrates their NS system with CGI's Canadian payroll system would be appreciated. How has it worked for you, and what are the pros and cons to CGI's system, etc.

All good ideas above that may be a fit for what you'd like to do. In case you'd like another option, see below. Since importing most or all historical transactions will take considerable time and may not be 100% accurate, you may want to consider this briefly stated idea: 1) pick a starting date like say Jan 1, 2016, and…

Any updates on this requested functionality? If not available yet in NetSuite, could you provide options to resolve this via scripting, etc, and email to me at bboese@baacoffice.com

I understand that Credit Card Charges can be imported into NetSuite via SuiteScript. Please contact me directly via email for more details if you: 1) need help with this and would like this functionality. 2) if you've already designed this SuiteScript functionality and are interested in providing it to more companies on…

Is the Tax Agency set up correctly? There are other setup related issues that may need to be fine-tuned too. Feel free to contact me directly for a free web meeting to review with you.

I would highly recommend you log a support case with NetSuite to ask them to look at your account and provide a resolution.

Try this - go to the link below and at the bottom left click "Show Inactives" and then go to the accounts you noted and uncheck the Inactive boxes on each of these accounts and then click Submit button. https://system.netsuite.com/app/accounting/account/accounts.nl

I have set up FY 2014 for several accounts and have not had the issue noted below. However, as an option, you may wish to click on the FY 2014 link on the Accounting Periods and then under More Actions click Delete, and then if all references to FY 2014 (monthly and quarterly too) are gone, then click Setup Full Year and…

Under Make Deposits, go to the Other Deposits tab and insert details of the non AR payment there.

This could be related to one or more journal entries posted into your Fixed Asset account(s) or other specific accounting setup issues. If you'd like another set of eyes on this to help you resolve, feel free to contact me directly for a free web meeting.