Angela Bayliss · Senior Solution Architect · Silver Crown

Hi Doreen, Go to home-set preferences-general under optimizing Netsuite, place a check box next to 'Show Quick Add Row on Lists' save. that should do the trick. :)

I'm crushed... :( No energy to type now. Ma...t.......t It's the valium, sunshine.:rolleyes:

I would get your Valium ready and put your ODBC hat on if I were you. While that sounds like so much fun, I wouldn't jump into it quite yet. I'm on beta, and so far, serials are pulling like you would expect(yee haw). Ill let you know when I can really dive into testing them, but the whole day job thing is keeping me…

JMU- do you have advanced analytics? This is possible to do within CR, or even excel, if you do. I was assuming that you did not....:o

sorry, haven't a clue. I drop them into excel and use vlookup. but then again, I doubt I deal with the volume you do. sorry, maybe someone else can help.

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…