Is the old legacy ODBC using Oracle 9i driver and Putty encryption client still going to be available with 2007? Or only the new ODBC that doesn't need Putty?

Thanks for the clarification, Brian. I retract my initial statement about not being PCI compliant.

I have been told that the old driver will be shut-off at anytime this year. So I am on borrowed time already! The old Oracle 9i driver is much more expensive to implement because they have to move your account onto a dedicated server with no more than 4 other customers. So there was a big setup fee because so much work was…

Brad, of course NS is not yet compatible with a beta version of OL2010. Are you kidding? Don't be on the bleeding edge. Do you really need to upgrade to OL2010 now? Let NS focus on other higher priority items.

Brett, I fiddled with the Mass Update. I tried Mass Updates > General > Contact record type. You are right that (Contact) Category is missing from the Contact - Mass Update Fields tab! This is a UI bug. You should report it to NS. I also tried Contact Management > Add Contact Category, but as you discovered, you can only…

Brett, sounds like you have the option enabled to show Employees as Contacts? If yes, then those aren't really Contacts, but rather they are Employee records that merely display as a Contact. In general, once a value is used on a record anywhere in the system, you cannot delete it because it is in use. Therefore, the…

This is where it pays to setup your segmentation correctly when you implement. There is Department, Class, and Location (and Subsidiary if you have OneWorld). Your situation probably is best suited for Class. Then you run your financial reports by class and you can see these two different channels.

pfund, where/what menu can I find this tool in 2010.1 release?

Mike, here is what NS is doing on the underlying G/L entries for the accounting. We you receive the PO: DB Inventory Asset (increase) CR Inventory Received but not Billed Liability (increase) When you bill the PO, i.e., when you finally enter the vendor into Accounts Payable for them to get paid for the products you just…

Cincotta, some of the problem may be the stand-alone Cash Refund. Stand-alone meaning you just entered a Cash Refund directly from the transactions menu as opposed to spawning it from another transaction. Instead, try opening the original Cash Sale or the original Sales Order (better), and then use the button for…

Can you maybe restrict the item to a phoney Dept or Class or Location? I just tested the leaving accounts blank (there are 3 accounts on an Inventory Item: COGS Acct, Income Acct, Asset Acct) and I did get the UI warning that the accounts were blank but you may want to leave them blank if you are using them for parent…

Steve, there is a checkbox labelled "Use as Category Only" that does exactly what you want. When you leave the accounts all blank, this box checks automatically, too...or you can just check it yourself. Well, I just found a UI bug!! This field does NOT appear if you are in Administrator role. It only appears in…

Does the COGS get whacked as indicated in the other post about Locations & whacked COGS?

Yes. You need to turn-on the "Enable Barcoding" option is setup, then the UPC code field will appear in the item record.

You need to set them up. I.E., scan them one-at-a-time into the Item Record UPC field! (Or possibly you could do some type of import, but you would have to fiddle with the import method)

Steve, I just ran into this same UI bug in 2009.2, so it's still not fixed!! I opened this Case on it with Platinum Support: Case# 963000 Created: UI Bug with "Use As Category Only" Field

Hmm...you're going to have to use the Inventory Transfer feature. Maybe write the Special Order PO from the Warehouse. Receive it at the Warehouse. And then do an Inventory Xfer from Warehouse to Store A. Then fullfill it from Store A. The warehouse essentially sells the item to Store A, which then sells it to the…

Word of caution: Drop Ships do NOT flow thru your Inventory Asset acct. Whereas Special Order DO flow thru your inventory asset account. The Drop Ship COGS will be recognized on the date of the Bill for that Vendor. The Revenue will be recognized on the date of the Invoice/Cash Sale to the customer. THEREFORE, THE REV &…

Yes, if you have a stand-alone Bill, or a stand-alone line-item on a Bill, it necessarily MUST update inventory or else your inventory would be wrong. The IR debits inventory for items initiated via PO (and credits Inventory received but not yet billing system account). And the Bill merely credits A/P (and debits the…

Lisa, I have a script that mass changes the Department. Search this User Group for my name "Nick Horowitz" and "mass department" and you should find it. You will have to change it slightly to update the class field instead. Basically you create a saved transaction search of the transactions you want to fix. You reference…

evan_goldberg has LISTAGG been added? I tried using today and got invalid expression. I need to be able to specify the delimiter (so I can import that multi-select field back in with CSV import wizard)

A work-around is to use the REPLACE function to replace the comma-space with pipe. Then that string can be re-imported back in as a multi-select field in CSV import wizard. This example gives you pipe-delimited string of all the subsidiaries selected on a record. REPLACE(NS_CONCAT({subsidiary}), ', ','|')

Just do a transaction saved search, where type=invoice or credit memo, and status=open or partially applied (or not "fully applied" I guess would work too)

Yes correct. No documentation. You just have to do trial-and-error. But a lot of them do work. Look thru the "100 ways to use formula fields" for some cool examples of complex SQL usage. Also note there are a few SQL functions that cause security problems so NetSuite will block them directly, BUT you can wrap them in a…

I am pretty sure there is a week function built into Oracle 10 which is what NetSuite uses. Do a Google search for Oracle week number function. You can use most of the Oracle functions in a formula field even though they aren't documented. http://forums.oracle.com/forums/thread.jspa?threadID=685308 This is a sample formula…

Correct. The security issue only occurs with to_date() function, not with to_char(), so you are good. Sorry for the confusion. Also make sure you understand the nuiances of how the ISO standard works for week numbering. Read the section "First Calendar Week of the Year" in this Oracle reference link:…

Note there is field security with the to_date() function in NetSuite. So you have to wrap your to_date() inside a case...end statement to bypass the field security. See this thread where Evan discussed this security problem and the work-around. https://usergroup.netsuite.com/users/showthread.php?t=23460

Try a transaction saved search with a filter of qty > 1. Then sort by customer. That should be a good list.

Ravi, instead of doing a Transaction Saved Search, you may try the Transaction Report under the Reports menu. The reports are more flexible and I think you can get subtotal by group that way. Give it a try and let us know if it works for you.

Perfect, Rick. Glad I could help.