There is a post I put in the "100 Ways To Use Formulas" thread with SQL formula to do exactly what you want (find a portion of a string within another string) https://usergroup.netsuite.com/users/showpost.php?p=64019&postcount=46 For example, this formula finds all zipcodes between 2 partial zips of 015xx thru 019xx:…

Evenry field change is logged in the System Notes table. It will have the date/time, employee, old value, and new value. So you'd have to run a query on the System Notes field, filtering for just that fieldname, then you'd want the sorted descending, and get the MAX date which should be the most recent. This would be easy…

Hey JM: NetSuite lacks the option to filter by Formula (Boolean), so I had to figure out how to make the filter work while being restricted to what NS does support, which is Formula (Numeric), Formula (String), or Formula (Date). This is an old basic programming trick that statements can evaulate to 1 or 0 to simulate true…

I just solved this problem in a different situation. You use the CASE to simulate a boolean. CASE WHEN ((dense_rank() over (partition by {internalid} order by {activity.completeddate} desc) = 1) THEN 1 ELSE 0 END Then use "Formula (numeric) is equal to 1 to filter

Evan does NS's Oracle SQL support the TOP 1 or BOTTOM 1 sql functions? Ususally in these situations in regular sql I will sort the list by date decending, and then get TOP 1 and those gets the most recent.

Yes that would be great. Like some of the MS products (Exchange Server for example), you can create friendly filters using menus, and then click a tab and it will show you the underlying SQL. If would be great if we could pass full SQL statements to NS's Oracle db and let them execute. If we could do that then we truely…

NEBS is the official forms supplier for NetSuite. Those deposit slips work (mostly). I did have some problems with alignment. You have to make sure in your PDF print driver, that you do NOT have "Shrink to Fit" chosen and also "rotate and center" turned off, i.e., you want the full page unaltered by the print driver. Also,…

Deposit slips not customizable. Must use Quickbooks-compatible deposit slips, or the NEBS approved forms specifically designed for NetSuite (which I think are QB slips in disguise)

No. The conversions never work. Don't even try it. Does your bank provide an OFX file? You can import the OFX (which is the generic OFX file spec [used by MSMoney]; whereas the QFX is an Intuit-customized OFX file [it has an extra header]). Also, QBO is the Quickbooks version of OFX. Tell what what file types they do…

Lynale, this sounds like you have a very intricate situation. I do freelance consulting. I have 10+ yrs experience as CFO of company using NetSuite. If you are interested, contact me offline nhorowitz@axeus.com. I would be happy to spend a few hours with you assessing your situation and recommending best practice and…

Or just do a Journal Entry: Credit the Credit Card Account (Increases Liability) Debit the Checking Account (Increases Asset)

No. There is a finite set of tran types in NS. Check results in a debit which is the goal. You can use the Check# field to put "S/C" or some other designator to yourself.

Open ticket with support. Those file types should work.

I think if you save/hold the recon, then they will show-up next time. But NS assumes that if you are keying the S/C that you are done with the recon and it just posts the entries into the checking account and marks them as cleared.

Unmatch it using Theresa's instructions, then match it to the correct txn using the manual match method

There is an option somewhere in NetSuite that will change the date on your checks to the date that the check is printed. This may solve your problem, too.

Ok, I been looking for 20 mins and can't find this setting. Does anyone know where this setting is located?

geosat, I notice you are in U.K. It's quite possible that the OFX format in Europe is different than U.S. OFX format. For example, the dates are probably different as Pierre found below. QFX is Quicken's varient of the general industry-standard OFX format. Open the QFX file in Notepad and look at the date format.

You are able to create non-posting accts in NS. Maybe you don't have sufficient security rights.

Make a zero dollar deposit with the debit & credit exactly offsetting each other. You'll have to deposit the zero dollar deposit into some bank account. So either create a phoney bank account for this purpose, or put it into your regular bank acct.

I'm not sure about this in Hold status, but I know after you have fully saved a recon, that if you go to the bank account register, you'll see that recon date stored in the recon date field. It's possible that the held recons store the hold recon date, but I'm not sure, so you'll have to test this theory. If not, you may…

Ok, then someone posted a renegade entry into the Undeposited Funds G/L account manually and some of those renegade trans won't appear in the Make Deposits queue. Look thru the Undeposited Funds register and search for a Journal Entry or some other type of renegade transaction. You want to be really careful NOT to post…

You have to put the same date into the recon date field that you used originally when you did the hold. It pulls-up the checked items by recon date. That field will default to today, so you have to change it. What we do, is our bank is setup to send statements the last calendar day of the month. So, I always put the last…

Go to the Reconciliation Screen. Change the Date to 1/31/8. That will pull-up all items flagged with that date. Now Uncheck all the items in that recon, so there are zero items flagged with 1/31/8. Now click Hold. That will essentially delete that errorenous held recon. Now start all over with the correct date (and year).…

Let me confirm I understand the problem: When looking at your Balance Sheet your Undeposited Funds account has a negative balance. But when looking at Make Deposits screen, there is nothing showing? (I think this is now an impossible situation as explained in next paragraph) Several versions ago, it was possible to post a…

This would be because you issued some type of refund to a customer. Usually this is a Cash Refund done on a credit card, and that will correctly create a negative undeposited funds entry, because your credit card processor will DEBIT you (instead of CREDITING you), so you want a negative deposit to hit the checking…

I just test this, and, YES, the recon date used in the Hold IS stored in the Reconcilation Date field in the bank acct register...so that's where you can look!

See https://usergroup.netsuite.com/users/showthread.php?t=5093

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…

I don't think so. But the check# does print on the deposit slip so maybe you could put alpha chars into the check# field (i.e., the customer name) and they would print on the deposit ticket then.