Yep, we've got AA and ODBC access. Do you use CR much? If so, how do you like it? I don't, not much. Since my background is in accounting, I so much prefer Excel. The primary reason I don't like it is because I am very limited in my knowledge of it, and had not had it too high on my priority list to learn. (been a wee bit…

Hey JMU, how handy are you in excel? I can walk you through this relatively easily, if you like, but it is essentially done in excel..

Walter- are the items that should not be on the list sold or comitted? Try using the on hand = true, if the problem is that it returns sold serials.

you said criteria 2 isnt working- so what does it return? Can't help fix it if we dont know the problem.

ok, but can I first ask how you will know what serial will be shipped? I ask, because we also use serials, and do not know what serial will be used until the order is shipped. Since we cannot associate bin locations to serials, if a specific serial is sold, our warehouse guys would have to sort through lots and lots of…

The OnHand is a numeric as opposed to boolean. You can use it to list item with X Quantity On Hand. Is the ?Is Available is a boolean. Stumped. :) yep- your right. arrggghhh. what need are you trying to address? you want items available serials of items on hand. Does it have to be a search?

So- are you trying to eliminate the "inventory" sub tab in the item record? You want this information to not be visible at all? Or do you want to create a search that gives you the item and its cost all on the same screen?

May I ask the steps you are taking to 'clear' or 'reconcile' these? Specifically, what is the navigation path you are taking, and what steps do you follow? I'm a little confused on your process..... ~angela

Can you post some screen shots of the Reconcile Account's page you're looking at? ~angela

For example, if I have a unknown deposit in the bank which we have not posted in NetSuite, it will not show in the report as it is only meant to show NetSuite reconciled items. Hello, I'm a little confused- The Bank Reconciliation report shows both cleared and uncleared transactions posted in Netsuite for the bank account…

You can log these types of transactions by going to Transactions- Bank- Reconcile Bank Statement - page under 'New Deposits'. Simply enter the account, date and any memo, and it is added without fuss. Regards, ~angela

you can easily delete a uploaded bank statment. If you can clearly view the duplicated statement at 'online bank statement', shouldn't be that difficult. Even if both are deleted, you could simply reimport it. Although if you have matched transactions on one of them, you might consider that the second time you tried to…

May I ask what evidence you are seeing in your system of the duplicated import? You said you absolutely KNOW they are duplicates- how? I only ask because I cannot get NS to take the upload more than once without rejecting all items as duplicates. I was able to upload the same file into different bank accounts, just not the…

May I ask what cicumstances would require the edit of a cash sale? :confused: Isn't the point of a cash sale to be as it would if you had a storefront and the sale is final at the time it is saved? This is the model I use when describing cash sales- the customer plops own some moey- you ring itup, he then leaves- not sure…

You assume incorrectly. We are not using that function "reverse using Journal Entry" because when we first started using Netsuite it made HUGE issues for us. It was one of those "is it a fix or a feature" (spoken tongue in cheek) type items. I do not know if is working properly now but it wasn't back then. Our void…

Temple, I guess I am really confused here. Please clarify something for me, as I really am trying to understand. Let me know where my reasoningis going wrong, please. I am assuming that the preference of 'voiding with a JE' is used) Bank Rec's are normally completed prior to month end. Once month end is completed, the…

I am VERY new to NetSuite so please forgive me if this question seems simple to most of you. I have entered all of my bills, deposits, charges, etc and have checked them against the bank statement; everything balances and I am ready to print my month end reports for accounting purposes. How do I "close the month" to not…

Hi Ken, This is relatively simple, simply go into lists, accounts, new. If you type in 'creating an account' in help, it will provide you with step by step instructions.

Actually, from an accounting perspective, this is not a defect. Reconciling bank recs is a simple monthly function, ad one of the items in the month end check list. These should not be locked from updates until the period is closed. I'm going to go out on a limb here, and open mself up to catch hell. However, it is not a…

ahh ok, if I may ask one more queston- are you possibly charging for back order items on a cash sale? This is not that typical, but I could see where it could cause a problem, if you are.

You can't lock ANYTHING from the administrator- as they are the administrator,after all. (except private tasks, but I am talking of transactions here) It does give you a warning (as an admin) when you try and change something in a closed period.

have you ever had one print sucessfully? If not, you may want to check the set up of your transaction forms and your PDF layouts.

Evan, you're expending resources fixing the sort order on the deposit slip which seems like nice-to-have fluff. Yet I can't get you to fix a more fundamental problem that the PDF doesn't align to the deposit slips forms. I've opened an issue on it yet support hasn't even crossed the psychological line yet of accepting that…

not sure. You can export the summary to excel, print it, and attach it to the deposit slip. I don't think the actual deposit slip form is customizable, but I could be wrong...

We use the ODBC tool and Crystal reports to pull the information from NS, and populate our report that figures in historical, current, and prospective figures. In using Crystal, we don't have to reenter or export info. I believe that ODBC will allow you to do the same thing using Excel. This will at least cut down on the…

I have good news and bad news for you. This can be fixed in such a way that it will have no effect on your books- easily. However, you will have to start your Rec over again, from scratch. Open the rec with the wrong date- unmark all debits and credits- Plug the beginning and ending balance of your misdated rec to match…

I cleared all of ours out by simply creating a reconciliation at month end, netting to zero. I dated it the first day of the month, so it would not interfere with the other rec.

Is it possible to add the Customer Name to the columns on the bottom part of the deposit ticket (the one that gets filed with the check stubs)? Right now it is not very helpful because it only has the check number, date and amount... Once you save the deposit, do you see the button that says 'print summary'?

When you open the Bank Rec's, it brings you to the last account you reconciled and either held or saved. There is no actual default view that I am aware of.

I would suggest you take a look at the Netsuite User Guide for Administrators. There is a section in that guide that discusses custom forms, setting preferred custom forms, etc. It sounds like you may have the preferred form set by role, but it's hard to guess without more details. Customer status's are set on the forms…