3942279

I just tried to do a simple update to a text field in some contact records, but I just cant get it to work. I tried mapping the company, contact and free-text field, but the problem seems to be that the CSV import is whinging about the fact that some of the contacts already exist, and other cannot be found ..... the UPDATE…

We would just like the option to allow overrides in the UK. We are the ones responsible for our own adherance to UK laws and restrictions...... i waffle on ....

Yes, please include me (email sent separately).

Here's my script: function entity_init() { if (!nlapiGetFieldValue('entityid')) nlapiSetFieldValue('unsubscribe', "F"); } Hi, Can someone give me a pointer here. I used the script, and it works, in that it resets the unsubscribe field, but only whilst I am editing the record, and as soon as I save the record, it reverts…

OK. Got it now. I have added the script so that all new contacts get UNSUBSCRIBE=FALSE. Now I need to find a way to change the other 8000+ contacts who are incorrectly set to UNSUBSCRIBE=TRUE !!!!!!!!! NetSuite - Please let us correct our own contacts. Is there an enhancement request out there already?

Heres some more info, if anyone is interested: We report on all deals where the INVOICE is raised in a particular calendar month. We are more interested in GP per deal and per item, rather than revenue per deal and per item. ------------------------------- I create 2 reports (as stated earlier) and then drop the Invoice…

I use 2 custom reports and then bring them together in an external excel spreadsheet. We look at monthly total GP per deal, and GP per type (e.g. Support, Hardware, SOftware, Services) The common link here is the Sales Order (if you create all your invoices and POs from there). If you create a report of all…

Hi Darren, Actually I should be more specific. My results tend to be 1-line results per transaction. So, I use 'Main Line = TRUE' on the criteria, and then select the various fields in the results tab. Doing it this way, I can never seem to get the Created From field to appear. If I dont choose 'Main Line = True' in the…

Can anyone get the PO and SO number to appear on the same view or the same report? I cant.

Thanks. I am just starting a short trial of the ODBC module, so hopefully I will be able to see this for myself. Most important for us is knowing what our commited expenditure is, compared to outstanding customer receipts. As with many small companies, the cash flow is essential to keep us solvent !! Thanks again.

Does anyone else look forward at potential cashflow shortages, and if so, do you have a useful report you use?

I will wait for the new release. I want the flexibility to be able to allow only certain employees within a role, access to a custom record. thanks.

Good idea. Thanks. I will give it a go.

Many thanks. I have created case #571047, and have included 3 x performance examples, as required.

I think you are correct. You need to specify each of your roles and decide which level of permission. I take it by the silence from the rest of the community that there is no other quick way to do what you are asking.

They are currently 'drop ship' items. I know that if I remove the 'drop ship' check box from the items then I can only create a PO manually. I was hoping that having specified a purchase price in the estimate, that this purchase price would be carried over to the PO.

That worked a treat.

Thanks a million. I will give it a try.

I have exactly the same problem. Every time I try and update or add an item I get that annoying "There are one or more records with the name xxx" I gave trying a few months ago, and have just decided to try again. Has anyone had any success updating items with a parent:child structure. And if so, did they have any success?

Thanks for your comments. We are going to expand a Financial Year by 4 months, and we wont be changing any transactions into new posting periods, they will all stay in the same months they are currently posted in. Although the last 4 months will be moved into a previous financial year. So, from what you guys have said, and…

If its any help or reassurance, it must be a system-wide thing, as I get exactly the same result as you when I select 'other asset'.

Not sure there is a quicker way, but if there is then I would like to know as well. Anyone else got any other suggestions for us?

You could VIEW the sales order, then MAKE COPY, and that should open a new one with all the items OPEN. We occasionally do this, and then rename the old one to something else, then the new one gets renamed (re-numbered) to the original number, and then we can carry on using the same number. However, if you have already…

Its seems like you cant do it, especially as the help item says ....... If you are using the Multiple Currency feature and selected Bank as the account type: You can select a Currency for this account. Transactions made in a foreign currency bank account are shown in that currency. The Exchange Rate field will populate…

If you edit the Sales Order, then you should see that each line item has a tick box on the far-right, which will show it as CLOSED. I think that if you untick that box, then it will re-open the Sales Order.

The restricting the view to 25 lines at a time (rather than 'all') also contributed to reducing the response time from 40-15 seconds, but probably only 10 seconds of the 25 second reduction was due to that aspect.

Do you use subtotalling? I did some benchmarking on our system and found 2 things that made the biggest difference for us when we raised huge orders: 1. We removed any subtotal lines on the order. 2. For orders over 50 lines long, we restricted the current view to show just 25 lines at a time, rather than 'all'. I found…

Hi Ray, Previously the Accounts team would put in a journal entry against each order, and reverse it when the Purchase Invoice arrives. Is that the 'reversing journal' you refer to? In NetSuite it looks like you can put in a Journal entry for an account, rather than an individual order. Is that the case? I can see it is…

yes all of our items are non-inventory SteveH (UK)

So does that mean that at the end of the month I need to do the following: 1. run a report of PO Accruals to work out the total amount of what is 'pending bill' 2. Make a reversing Journal entry for the total amount not yet billed 3. Set the reversal date to the start of the new month SteveH