Olivier Gagnon NC Red Ribbon

You could use Approval on your PO. Until a PO is approved, it does not mark items as "on order".

Yeah, this is a good problem. No, you can't change the time at which the email is sent. You could perhaps change your criteria to be a relative value like "last 31 days", or use a formula so that if you are the 1st, send everything from last month else current month.

The 'Cost' of an Assembly is the sum of the components you used to make it. You can view that by creating an Assembly Build search and outputting the GL Impact information. If you want to record actual COGS entires, you should do like Kathy suggests and use Kits.

If you start using SOs, this will solve your problem. Just make sure to tick in "bill in advance of fulfillment" (or whatever it's called). You'll be able to generate your invoice as you do now and milestone bill, but your inventory won't be deducted. It'll say 100 to order.

I'm not sure what you mean. You want to check if the order has either Terms or Payment filled in? var terms = nlapiGetFieldValue('terms') var paymentMethod = nlapiGetFieldValue('paymentmethod') if(terms!='' && terms!=null && paymentMethod!='' && paymentMethod!=null){ ... }

It builds up forever unless you deal with it yourself. The problem usually occurs when your price on item receipt is different than the price on the Bill (POs are non-posting), so it's best to make sure your Receipt always has the same price as the Bill. Many use scripting to ensure this, otherwise you're looking at manual…

Hmm. My Use Credit Card has Categories. When I select a Category, it automatically selects the corresponding Account. Try hitting 'Customize' on the Use Credit Card form, and check under Screen Fields->Expenses if you see a column called "Category".

Perhaps it requires a script on the Sales Order form that doesn't allow a save unless the Payment information or the Terms box contains information? Such a script would indeed work. I have a customer where we have installed such a script. Has been working fine for over a year.

We have generic vendors, i.e. "Restaurant", "Hotel", etc.

Employee should use the "Use Credit Card" transaction, not expense reports. Expense Reports are for employee that paid for something with their own money, and are asking for reimbusrement from the company. If they used a corporate credit card, they should use "Use Credit Card".

If you don't, your friendly neighbourhood Partner can be contracted to code it :) The answer also implies you're asking for something not supported by Netsuite. Everything where the answer is "you can with scripting" also automatically has the answer "please log an Enhancement Request". Suitescript is simply a much, much,…

Hi sravan If you created a stand-alone Credit Memo (i.e. you created the CM without first creating a RMA and then an Item Receipt), your Credit Memo will affect inventory. If your CM does not have a Bin, this means items have been received in the Location directly, outside of the bin. Thus, Netsuite will indicate you have…

You will need to use scripting to achieve this.

You can use Netsuite's Gross Profit functionality. You can enable it under Setup->Company->Enable Preferences. You should also read all the documentation under the Help system to see how to properly configure and use it.

No it is not. You can read my blog post to see a few more details about Average Cost calculations.

Hi, Since I'm such a nice guy I've created a blog entry detailing how to get a basic item sales direct vs kits. In you case, if you want to add Class, just add it as a column with a Group on it. Cheers!

Well Class is just a field like others. You can add it as a column to your search, and really after that you can do anything you want. You could get total number of SKUs per class by Grouping on Class and placing Count on internal id. You could get total inventory value by class by doing Group on Class and Sum on inventory…

Hi, Under Setup->Accounting->Accounting Preferences, on the General tab, you can set "Customer Credit Limit Handling" to "Enforce Holds". I believe this will do the trick.

A simple transaction search on the item will give you only items sold directly. If you want to see kits, you'll have to build a search using the "is component of" (forget the exact name, something like that) filter. Or make a transaction search and use the "Member Item..." join to output the members of kits sold and make a…

Hiya I decided to write a blog post on how to do this. Hope it helps!

Hmm, how exactly do you go about creating your Cash Sales? When CCs decline, usually the Cash Sale is flat out not created. Do you first create the cash sale then tick in charge credit card?

Could you item pricing Volume Discounting to do this, or must it absolutely be a Discount Item?

Ok then that makes sense, if you use the stock to reconcile with actual time entries.

Okay I see. Yeah definately not 2 different SKUs, that means seperate inventory for the same item.. Yuk! I mean, I know this can be done with scripting, for sure. I'm just trying to think of a simpler customization. I'm not sure I really see anything, aside of course from manually tallying quantities and adding discounts,…

Most likely you had negative inventory, i.e. you had -1 on hand when you built (bring it back to above 0). This would cause an instant COGS adjustment.

The bill had a DATE in 2009 or it had a PERIOD in 2009? Dates are allowed, Periods should not be.

Yeah we just used it, it's freakin awesome. However, the search times out unless you have a VERY narrow selection. Like, it timed out to see deleted records in a day. We had to specify for which customer. But otherwise, it delivers bang on who deleted what :)

For the case of Assemblies, you don't need to use an Inventory Item, and you really shouldn't (since then you have to worry about creating stock for it). Adding a Service/Non-Inv/Other Charge is the way to go. For Kits, this doesn't work. For some reasons, Kits, when fulfilled/sold, do not receive an impact from anything…

The Auto-Apply has the very curious "sticky" behaviour. This means it remembers the lat setting YOU used. If last time you unchecked it, it should remain unchecked next time you go on the screen. If you check it, next time it will be checked as well. This is strictly on a per user basis. The only way to ensure it's always…

Run a saved search. You can output both of those fields and run through it. Note that Internal IDs are shared amongst all transaction types.