3949466 Green Ribbon

What I am trying to get a list of the invoices paid on the checks and EFTs deposited/received in a given period. So I am looking to draw the information based on the deposit date of the payments. Does that help?

Basically for us payment dates are equivalent to deposit dates - almost all of our customers pay via EFT. That being said, I tried to use the advice given on your last post. A transaction search with criteria as follows: Type - any of Customer Deposit, Payment, Deposit (you said customer payment - I didn't see that as an…

The AR Payment History by Payment report seems to pull in a meaningless Payment #, and the format was difficult to work with - the payment appearing as the first line and the following lines as negative - even exporting to Excel it was ugly to work with. Maybe there was another trick that I could have used to customize,…

Just got it by changing the result to "Applied to Link" amount. So, now an easy one for you, how to you get subtotals in searches?

I was using the correct account. I did work with support - and using a Webex, she also saw the issue that was occuring. This call took 45 minutes. Later in the day, the functionality returned and Support notified me this morning that they could not replicate the problem that we were having yesterday. I don't know what was…

The populated GL account number will change for me as a user (I am using an adminstrator role), I believe based on the most recent application I was in (expense reporting or accounts payable). I understand that the field is hidden on the expense reports unless accounting approval is checked - and I understand why you would…

Unfortunately, I have had no responses at all. I thought for sure someone would have a solution for this - I don't think the request is that unusual. Maybe your post will get things moving again.

I am trying to bring this data into a spreadsheet that I usue to summarize inflows/outflows to my Operating Cash account activities by categories that don't tie to Netsuite. This report gives my management team a daily column view of the bank activity including a calculation for availability of funds on a revolving credit…

Nick - I have the "Void transactions of reversing journals" option activated so that we aren't backdating to previous periods when we void checks. This often occurs across accounting periods - and I don't want my previous financials changing - especially cash that has been reconciled. And I think that not having this…

Nick - This got a little bit odder. All but one had the bills under the "Applied To" tab. The tab was completely empty for the other one. The bills showed both checks on their payment tabs, but the voided checks were show with a zero for amount. We had cut new checks on all of these bills. Four of the seven checks were…

I'm glad you're getting the correct total (though probably not as glad as you are!). Nick's guess is correct: just cut a check for each vendor with all the +'s and -'s that net to 0. I always delete the check# field to make sure NS doesn't grab a check# it shouldn't, but this could well be whistling to keep away pink…

I wouldn't filter by transaction type. Let NetSuite do its thing. I can think of three things that could make them be off: [LIST=1] [*]Journal entries with names (or other transactions) that aren't showing up in your aging report because you've got them filtered. [*]Journal entries without names - I believe these won't…

Do any of the items pull-up, or none of them? Did you make sure to go add the Vendor Name in the Name field on the J/E's first? There must be the Vendor Name on the J/E's or else the J/E's definately won't pull up. None of them pull up -and the vendor name is in the JE automatically since the JE was created when the checks…

Purchase Order is non-posting transaction. Although there is a GL impact, it will not have any effect on your General Ledger. Expense/COGS is recognized when the PO is billed. Enhancement # 112522 tracks the ability to recognized expense at the item receipt level. So a GL Impact will show, but not really take place for…

In the GL Impact screen, pay attention to the Posting column. If 'No' then it doesn't post to that account. - Miguel Now that's useful to know - never even noticed that - will certainly pay attention to that in the future! Thanks so much :)

These are non-inventory items. They are consumables purchased for immediate use on a project.

But that will take away the notice on duplicates for a same vendor. My problem is that on an import, invoices get rejected if there is that invoice number for any vendor in Netsuite.

I have to do bank and finance reporting based on the true invoice dates, so I have to maintain the original invoice date - I am an accountant - not a techie - have never written script - yet. I wondered if there was some way to script an invoice term and how hard it would be to do - if it could be done.... I am not doing…

I have to use the actual invoice date - or the auditors will have my head! Just dreaming of a simple solution....guess a manual adjustment will have to be done. Thanks for the thoughts :)

The process has changed, I'm still learning the new process myself, but I believe you have to do it from the checklist, and then go to task. Is that what you are doing?

We have had the same experience and have had to just use the credit function. I do not have a "void button" and I am using an administrator role.

B, does the balance column match the value in the balance column when you look at the register UI for the same item row? You may need to put a formula field and do the sum calculation in your search, rather than pulling the balance field out of the table. Nick - I'm just a simple accountant - I don't know what a register…

You can make the older accounting periods inactive and not show inactives - and that cleans up the managing of accounting periods ... But I believe my problem with that solution was that if you made a period inactive it would not show up in the drop downs as a parameter for financial reporting. I agree with the other…

I did it by creating a vendor search. You can choose to have 1099 eligible as a criteria item. That is OK if you are confident that your users are making the correct choice when setting up vendors. If you are not very confident - you might not want to use this criteria for filtering your list, you may be able to use vendor…

I just want folders and descriptions for saved searches. We've been waiting 5 years and counting for this one. I also asked for this capability - Do you have an enhancement # we can vote on?

You bet! Vote now, vote often. #101497 Enhancement # 115393 is requesting the same for saved reports

Is this happening when you export to Excel? A similar defect has been reported and has been numbered 161456. The formula calculating % of Income is incorrect in the Excel spreadsheet. I have been told it will not be fixed until the next version is released. I told support that I found that unacceptable - that was on…