Angela Bayliss · Senior Solution Architect · Silver Crown

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…

savethepennies, you are ever so right. I spent too much time trying to work out where I was going wrong and hoping that it was just me and not NetSuite that had the problem. Alas, it is not so. Will try reducing extra space, et al and see how I go. Thanks for posting a reply. Let us know if you don't get anywhere.....

I am trying to add a field (list/ drop down) to the customer page/forms. I am not finding where I do that since it is not the same as adding a custom field to transactions. Where do I go for that? Thanks Online, free, Netsuite Help Center Rocks. A wealth of info. :D As copied directly: Custom Entity Fields topicAlias4 >…

Angela... Is that you?? In the flesh my railroad loving friend.:cool: like a bad penny, I just keep showing up.......

JMUnderwood fingered the crux of the issue: NetSuite seems out of touch with the real world in many ways. Evan has said how NetSuite works closely with some customers to get their feedback, but from my perspective this isn't working very well. Angela, the problem is that item fulfillments and invoices are both linked only…

Another reason why an Item Fulfillment wouldn't/shouldn't update the sales order with data entered on a custom field is because you can have multiple fulfillments per Sales Order. There isn't really a good way to logically update the SO given this structure if you end up invoicing each fulfillment on a single Invoice. It…

So here's the reason you're having a problem. The fulfillment process is stricly and inventory/warehousing process and has nothing to do with an invoice or sales order. It makes sense that if you are populating at the fulfillment stage that you are adding data to a record that is different than the SO or Invoice. If…

I don't know where this is described in the documentation, if at all. There may be a reply from Evan or another employee to one of my postings in this user group site, or the previous one, confirming my assertions. I speak primarily from my intuition about the inner workings of the NetSuite database architecture based on…

In case the invoice is for multiple item fulfillments I guess. We were in a rush at the time that we came across this problem and chose to punt by allowing our warehouse employees to edit the sales order to enter the needed data (notes and serial numbers). I'm afraid I don't have a clear explanation for the reasons why it…

** Order Confirmation Email sheet ?> (The sheet that gets auto sent to Customer w/ Order has been fulfilled.) I Setup-accounting- customize fulfillment e-mail. Do not confuse this with the order confirmation e-mails (from web orders).