3944633 Newbie

I would like to help. I don't have enough information in your post to give you the right answer. I'll give it a shot anyway. There are several things that I note: 1) Normally one would offset opening AR balance to an account other than AR. 2) When the opening Balance Sheet Journal Entry is made, the AR balance is posted to…

Quite possible. We have done this for many NetSuite instances. It involves setting up custom forms and possibly custom form layouts (Setup > Customization > Transaction Forms, Setup > Customization > Transaction Form PDF Layouts). Typically, the division is set up a a separate location (Setup > Company > Locations). This…

Perhaps set the main Customer/Vendor/Company email address as "ReplaceThis@WorldOfGood.com" so it goes nowhere. Employees are available in the CC list. Could also create a contact and attach to all customers Named "Internal" with the email address ReplaceThis@worldofgood.com. Users type over ReplaceThis and use the cc.…

You might try going back to the transaction in view mode (Transactions > Customers > Record Customer Deposits > List) select transaction and click "GL Impact" to see which accounts were posted. Hope that helps.

We have many clients using multiple locations and successfully running Balance Sheets. It does require JEs at the month end to correct control accounts: Cash, A/R, A/P, Undeposited Funds (Just make all deposits). JEs move from "No Location" to Location (Debit and Credit the same account). Also account "Inventory received…

Steve, I'm not sure what I missed. In version 2007, one can attach files to almost all transactions. Are you in version 11.0.6? If in v. 2007, are you perhaps in a role that does not have those permissions? I hope that helps. =r

I believe that plusbydesign is correct. Make two JEs that in total reverse or zero out all accounts at the end of the period in June 2005. This would be one entry for Jan and one for Feb 2007 transaction postings. Find the postings for each month by using a search or modified report (i.e. transaction date in Jan and post…

There is a setting "Pre-populate Contact Addresses" at Setup > Company > General Preferences that will accomplish this. Hope that helps. :)

Address label is the ID (not numeric) for addresses (has been for years) which we have used to add and update records via CSV and xml. Default Billing (true/false) and default shipping (true/false) is available on CSV and xml. If you are asking whether to determine which address is default shipping or default billing via…

You may also see this if the login password has a required change. The web query will deny access until the password has been change through UI login. Might also check the permissions on the report. Could have changed in the upgrade by mistake. ;) Hope that helps. =r

Not sure if this is completely related, but recently (since 2009.1) several clients who have multiple logins with the same email address have had difficulty when they have to change their password. I am having to reset passwords on both logins. Previously, when you set up a 2nd login for a user, you received a message…

Download a list of clients/leads/prospects from NetSuite. Use a lookup function in Excel to see if they exist in NetSuite. Otherwise, import them as Leads and use duplicate detection to (hopefully) find all the duplicates. Hope that helps. :)

I have recently seen other posts in this UG where the emails were captured in a spam filter. Not sure if this is the issue in your case, but you might start there. Good luck! :)

Are you using Customer Numbering? If so, you will get a new customer each time as the customer you are trying to update will be "number"(space)"name". Consider doing the imports with the Internal ID as a field in your Customer import (same for Contact), for testing. Then remove internal ID for your mass import. Internal ID…

Can you not use the marketing automation in NetSuite to find a defined group and create a mail merge letter tempate in envelope format that uses the address fields of the group? I'm sure I'm missing something.

There is not, unless you have the distance already calculated for each customer in a custom field. Look up the zip codes. Ther may be a way with scripting. See the thread: https://usergroup.netsuite.com/users/showthread.php?t=7170 =r

One other alternative..... If the leads/opportunities are in a spreadsheet you can use Excel to create the xml and the import into NS. Yes, Excel will create the xml and validate it, believe it or not. It requires creating either a schema or having a working xml document that represents the Opportunity for NS. Have done it…

Can you change the confirmation email to include "Total (included shipping)" or something like that? have a fun day! :)

I agree that this should be a part of the program. I have wanted to get fulfillment fields for some time without scripting. Thanks for your contribution to the UG. Best regards, :) p.s. Didn't mean to dis you earlier.

Just curious, what other platform(s) are you referring to that cost less and have these features? Hope your day is going well! :)

Yes, you can update them in a list view via list edit. Add the Shopzilla Feed, Yahoo Feed, Google Feed, etc fields to the list view/search. Remember you need to select an item type to enable list edit. Click on the first checkbox in a product feed column, scroll down and hold shift and click on the last checkbox in the…

Wiz, et. al. I'm not sure you can modify the Admin message. Only turn it on/off. Have a great day! :)

Better than 99% of other applications that don't send ANY alerts. Right?

I think that is Setup > Company > System Email Templates and/or if using the Web Site/Store, Setup> Web Site > Customize Text. Hope that helps. :)

Try going to Setup > Customization > Transaction Forms. Check "Show Inactives" and go to the Standard Statement form, check "inactive", and click Submit. Only active forms display in a dropdown. I hope that helps. :)

Mike, I believe you would do that by creating Webstore Categories and Tabs, unchecking "Display in Web Site" and assigning them to the appropriate Audience(s). Lists > Web Site > Tabs Good luck,:)

Did you try "salesorder" (all lower case).?

I guess I was talking about the way to get the price values for the price levels from NetSuite. Maybe I misunderstood the question. Yes, probably more applicable to client-side and server-side scripting although via web services the field references should be the same. Have fun!

The item price engine is not supported by NS but the following may help: item.getLineItemValue('price', 'pricetype', i) gets the price for a price level i where i is the line number of the price level on the Price Tab (not to be confused with the Price Level Internal ID). Base Price is always 1. Online price is 5 by…

Ray, Yea, Dan said you told him the same thing. I totally agree, but its an internal political thing. People generally believe since they spent money on something, they have to get their "moneys' worth" out of it. One dept. bought it without consulting the rest of the company (server, custom coding, software, etc.). Now…