Chris NetSuite support aren't being overly helpful with this (because they want me to use their built in Est GP field - which has other issues). I have created a custom column field for transactions that is sourced from the Item, Item Defined Cost field. Currently my item is sold in Packs of 10, but I set the base unit to…

Chris What is your experience of Item Defined Cost (Field ID: costestimate) On the Item Screen it shows the UoM for that field as the same as the Sales Unit But when I use this field on a Line Level Custom field it appears to be showing the value per base unit (despite the sales line showing in the sales units) Is this…

Thanks for the suggestion - I have tried some of this: * I believe the parenthesises should only be around the last two criteria (set to OR), not the entire list? * I assume selecting all 'Types' is the same as not have a Type filter at all? * Because of the above I am seeing a lot of irrelevant, non-posting transactions…

I have looked into this some more today, and found some of the issues, but have no idea how to resolve them. I exported a list of all transactions on the affected accounts into Excel, and the looked at the transaction types that impacted those accounts. I then looked at these 1 by 1 to find out how any changes to these…

Thanks - I was using 'Main Line = True' in my search, and that appears to have been the problem. I have recreated as per the above and it is working now.

OK I will have to create an additional role for this purpose.

The user is using the Sales Representative Role, and the report is called strukta Comparative Profit and Loss with Budget

The Report was set to 'All Roles', but I have now changed that to just one of the specific roles that the user has, and it still doesn't work.

OK, so I started again with this, and after a few hours I now have it working. The relevant part of the formula (in case anyone else needs it in future) is: (CASE WHEN TO_DATE(sysdate, 'dd/mm/yyyy')- TO_DATE({activity.date},'DD/MM/YYYY') < 10 THEN '00'||TO_CHAR(TO_DATE(sysdate, 'dd/mm/yyyy')-…

Thanks CDuf I discussed this with some of the Oracle team in London earlier this week and they said similar things. The Suite Answers article only has very high level information - what SuiteApps are being affected and then the 'Core' updates. Last time I looked I have over 50 enhancements listed in the system, so I don't…

Thanks Michelle - really easy solution! To be honest, I don't think I've ever even looked in that 'Function' drop down before - loads of useful things in there.. Thanks again

Thanks

Wow - that's really impressive, and potentially very useful. Turns out I already have the bundle installed - I just hadn't found it yet I will investigate this in more detail - thanks for pointing me in the right direction.

Thanks very much for this - that has worked exactly as you described (and I have bookmarked the linked page for these additional functions as they appear to be very useful)

All good ideas above (some that I need to research to learn from!) I would approach this differently: * Workflow on Field Edit on your Class Field * Criteria on the Workflow:* Dept = Service * Class None of Residential, Commercial * Then the action on this workflow could be a pop up message to tell the user ('Class…

We had a similar problem. We have created a column called 'Applied Transactions' after the charge and payment columns and populated it like this: <tr> <td>${line.datecol}</td> <td>${line.description}</td> <td align="right">${line.charge}</td> <td align="right">${line.payment}</td> <td align="right"> <#assign…

Thanks, that helped, but there still isn't a direct link between the bin on hand and bin number sublists so I had to also include {binnumber.binnumber} = {binonhand.binnumber} as well. That has got me close, but I'm now struggling with the LISTAGG function which I have seen mentioned on here but isn't documented in…

CDuf Please can you tell me where I can find these performance dashboards in NetSuite, they look really useful. Also, when you are asking users to 'optimise their clients', what actions are you recommending?

Thanks - that is somewhat useful. Does NetSuite publish details of what is included in the eFix? In particular can I review previous eFixes to find out what changes may have been made to my environment? I have a (relatively) significant functionality change, and I don't know the underlying cause of it.

OK thanks - I've requested that Enhancement to be added to our account. If anyone else comes across this problem, another workaround is for an Admin to change the Owner of the Search to the 'super-user' and then they should be able to edit it. Not ideal, but preferable to giving out more Admin roles than necessary.

Yep - I had exactly the same problem. It's just the name (no number), and if it's a parent / child situation it's: parent : child As Chis mentioned, using Internal IDs overcomes this issue. The frustration is the Finance Team start from a report / export from NetSuite for all their accounts to build their budgets - and…

Thanks CDuf - that makes sense and I will attempt to do that with some of mine. Where you have had success - how did you know? Were you notified that the Enhancement had been resolved? Did you find it in the Release Notes? or did you just find that the problem had been resolved? On a related note, I understand that…

Sorry, you are misunderstanding my requirement/issue. The Saved Search needs to be available to a number of different Roles to run the Search, but those users should not be able to Edit the Search. I then want 1 or 2 specific users (with a specific role if necessary) to be able to edit the Search. I don't think the…

Yes, but that would mean that everyone with access to view the report could edit it. I am training up users to be 'super users' to do things like editing reports, but I don't necessarily want to give them Admin access.

Thanks for the explanations and suggestions - I will discuss this with the head of finance in the morning.

If you click on the amount on any Trial Balance line you get 'Account Detail' report - this is the one I want to customise. You can customise it manually to add in the memo field, but next time you click an amount you get the default report again.

Thanks Janet If I customise the General Ledger report, I have the same issue as I do with the Trial Balance report - there is no option to set the detail report: How do I get this option available:

Thank you! I was looking under Sublists for these type of lists, I did not realise some were listed under Screen Fields Very helpful

Thanks very much - works perfectly!

Thanks