Olivier Gagnon NC Red Ribbon

Deletions very little evidence. You might be able to figure out deleted records by looking at internal ids and transaction numbers to spot a gap in the sequence. That won't tell you WHO deleted it though.

Check out Setup->Accouting->Invoicing Preferences. Any option you can make is in that screen. If that cannot handle your requirements, you can use scripting to build a custom PDF that will be able to do whatever you want.

No, you cannot do this easily. Since a few versions ago Netsuite allows you to select a filter for the line items of a particular form, the filter cannot be dynamic. So you would hjave to create 1 form per vendor, which is almost certainly not an option. You could make this work using scripting. You would be able to add a…

There is still no out-of-the-box way to view total cost of Kits if they have other kits as members. Custom solutions, using a bit of scripting, exist however.

Hey Jonjack This is a pretty common question, so I finally got around to immortalizing one solution on my blog. Here's a direct link. Let me know if that helps any.

Under Setup->Accounting->Accounting Preferences, at the bottom of the screen, if "Make Locations Mandatory" ticked in?

Can you use the Department field? This will tag GL impact effects to specific departments. You can then just filter your reports to show only the department you want. Unless there are other complexities to your problem, this is the standard method to use to track Departments in Netsuite.

Sales Orders don't have specific income accounts... Unless you are talking about changing the Income Account set on the items. In which case the answer is no. If you want the same item to post to different income accounts, you'll need to maintain 2 seperate items. Of course then you'll have inventory headaches. Can you…

I don't understand. Why don't you just sum your discount and use that? I.e. 41% and 43%?

Well learning suitescript has many steps. Read through the Suitescript Developper's Guide to understand script types, deployments, the APIs, etc. Once you've done that, you should find in the API functions to grab the current user's ID and role. At that point, you can code a beforeLoad script that reads the current user or…

Hi Jocelyn, The Reminders can be set up to show RMAs to Approve. However, the out-of-the-box behaviour is to default ALL RMAs to either need approval or not. You could use scripting to selectively decide if a RMA needs approval or not based on the Amount (or any other criteria). This is relatively simple. It becomes more…

The problem with POs created by Drop Shipping is that they do not trigger scripts like normal orders. It's a huge pain. There are workarounds but they are much more complicated than the above.

Ok right, this is the easiest case, so good. var VENDOR_EXCEPTION = xx; //enter vendor internal id here var VENDOR_EXCEPTION_FORM = xx; //enter custom form internal id here function pageInit(type){ if(nlapiGetFieldValue('entity')==VENDOR_EXCEPTION) { nlapiSetFieldValue('customform',VENDOR_EXCEPTION_FORM); } } I didn't test…

For perpetual billing, you are even better off looking at Memorized Transactions. This doesn't require you to buy additionnal modules. Though, if you do need more fine tuning, you may need Advanced Billing as Paul suggested. But overall, recurrent billing can be implemented in Netsuite pretty well.

Hmm... Can you elaborate on the relationship between the Vendors and the forms? How many vendors require a specific form? Is it always the same form? Do you forsee a future need to expand and have a varied multitude of vendors requiring a multitude of different forms?

I think this is simple enough for me to give to you here, if you think you are capable of doing the setup. It also involves creating custom fields. Do you feel comfortable doing that?

Price can always be set on the fly, so that's no problem. The other fields perhaps just be custom line item fields for you to write in. Alternatively, you can add a Description item to add these details seperatly. It depends a little on how you use this information later on. If, say, you need Weight for Shipping later on,…

It is possible with a simple script, but not otherwise.

The exact translation of that script, with no other logic to determine when to show it or not (so it will always show), would be: function pageInit(type) { alert('Customer is on hold. Please refer to Credit Control.'); } Deployed as a client-side script, on the page init trigger.

This script is if you want the message to pop up on VIEW mode. In edit mode it is different.

Using a bit of scripting you can achieve this. I do not believe it can be done via other configuration.

Create a Return Authorization, transfrom that into an Item Receipt and do NOT check the "restock" checkbox on the line items, then transform it into a Credit Memo. Cheers

Next time, please do not post the same message in about 50 threads. That was very annoying.

No, it will be what will show from now on. Aside for displaying on printouts, I do not believe there are any functionalities linked to it. So you should be able to change it no problem.

Darren, I ran your scenario in one of our demo accounts and came up with the same results as you. Inventory increased but inventory value did not. The Return was indeed without value.

If you create Invoices, Bills, Credit Memo or Cash Refunds as standalone transactions (i.e., create them just like that rather than creating a SO/PO/RMA/etc) they will affect inventory.

If a customer return is initiated from the invoice, the current system model this as a return of goods to an actual internal warehouse. The actual receipt of the transaction has an inventory asset accounting transaction associated with the item receipt. That's a little heavy to read, but if you're saying that if you…

No, that does not exist. The proper method is to create a Return authorization with an adjusted price of 1$, transfrom that into an Item Receipt, making sure to leave the "Restock" checkbox unchecked, and turn that into a Credit Memo, then turn that into a Cash Refund.

Basically, yes. That's not terribly realistic, but that's how it stands.

I've been thinking about that. What I found is that A) the Item Receipt actually does have a Rate recorded on it (the field is hidden). So it seems hardcoded in the Item Receipt to ignore the rate when dealing with Drop Ship returns. The information is there, Netsuite is just ignoring it. B) Using Journals will not work.…