Thanks, i only need the one day added, i tried as suggested and it worked, thanks ever so much, going to be invaluable, much appreciated.

Hello there, thanks, thought that might be the case but wasn't sure exactly sure where to put the +1, would it be placed towards the end of the formula or does it need to go at the end of the date fields ?

Hello there, thanks for getting back to me, the date fields are 'Start Date' and 'Projected End Date'. I had spotted a couple of examples of formulas in Suiteanswers where users had had a similar issue, it seems the End Date in these types of counts is excluded by default, when i checked 5 or 6 of the examples manually in…

Apologies, just double checked and it appears to be missing one of the two dates from the calculation, in other words, the totals are one short, is there anything i can do to adjust the formula and ensure both those dates are included in the total? Thanks.

Hello there, thanks very much, have tried that and initial results looks to be working! Cheers.

Hello there, apologies, in addition to the above query i'm looking to divide the quantity of project management resource days on the report by the amount of days between start and end date, and express this across the period by month, i.e in the example highlighted i have a project lasting between 2023-07 and 2023-12 with…

Hello there, i've solved it! A bit of a semantics issue, but should've spotted sooner, when adding in the date parameters i was using within 60 days from now, and i just noticed that this automatically sets the from and to parameters to 30th September. When i tried again using before 60 days form now, hae adjusted and now…

Hello there, thanks for getting back to me, i cleared my browser cache and went with the month parameters for both: It's working as you'd expect but not pulling in the data correctly, ideally i want to be able to go off the 30/60 day from today as those are the parameters set by the company in terms of forecasting, this is…

Hi there, thanks for getting back to me, i don't want to use them as criteria as i want to include other Forecast Types in the search results also. The criteria for the highlights is any Omitted Opps within an expected close date of 60 days from today would be highlighted, and any Low Potential Opps within 30 days close…

Hello there, thanks for getting back to me, i did mean the Summary Type under Criteria, i did think it was used less frequently but thanks for the example, should be able to adapt it in principle for some of our reporting.

To clarify, i don't normally use the Summary type box circled in red, mainly out of inexperience but also because it doesn't have a group function.

Hello there, thanks for getting back to me, in many cases yes, especially on smaller or overseas projects, but we also consolidate at our warehouse for medium to large projects and arrange freight ourselves, hope this clarifies.

Ok, will start to utilise, i noticed there's no Group function in it, so not sure how to apply, will read up on it and start utilising, hopefully can improve some of my existing reports, thanks.

Hello there, understood, to be honest again the Summary Type tab at the top is not something i normally use, except for a couple of solutions i took from Suite Answers, assume it does have uses in some circumstances but so far have just used criteria and columns, this may on the other hand explain why i''ve had some…

Thanks for getting back to me, i'll be completely honest and say that when i meant drill down i meant simply that some of the invoice details wouldn't be grouped, i noticed the drill down tab on your snip, see below, can honestly say i've never seen that before throughout the last seven months of working with Netsuite, is…

Hello there, i've just realised that all invoices appear on the one line as related to the Sales Order, see below, is there a way of modifying the formula so that the invoices all appear on separate lines with the relevant SO number, having repeated So numbers isn't a problem, although would be even better if i could drill…

Hello there, i've just realised that all invoices appear on the one line as related to the Sales Order, see below, is there a way of modifying the formula so that the invoices all appear on separate lines with the relevant SO number, having repeated So numbers isn't a problem, although would be even better if i could drill…

Apologies, i've been on leave, and can confirm that this solution worked, thanks for your help.

Thanks, will do, hopefully no more net of tax queries!

As regards the 'Invoice Total billed' that is down to my incorrect labelling, it should really say 'Total of that Invoice billed', and for our purposes on that query we could manage with the amount remaining column. With Sales Orders we do often invoices in stages, hence the need for an unbilled amount, but given this is…

Hi there, ah yes, apologies, assume you mean this query, this is driven by invoice record as you're aware, so the unbilled amount will show 0 if say a previous part invoice was raised off the Sales order, in the case you mention there are two invoices, one further down the report as it's ordered by creation date. Hope this…

Hello there, i filtered out the 0 value invoices and as you suspected that was definitely the issue, so the formula below is working fine, final challenge is the Unbilled Amount, but thanks very much for getting me over another hurdle. (1-{taxtotal}/{totalamount})*{amountpaid}

Hello there, thanks for getting back to me, i've added the columns and pulled into Excel as suggested, and yes, out of 292 invoices there is one with a zero value for amount/total amount, would it be a case of adjusting the formula or filtering this particular invoice out? Thanks.

Hi there, just tried that formula and same error message, and no sign of any Invoices with 0 value, could it be something to do with the way the amount remaining formula is functioning, see below, it works fine in pulling the correct remaining amount net of tax but may be confusing matters, just a thought, thanks. CASE…

Hello there, cleared my browser cache and have tried all three multiple times, still 'Unexpected Error' every time, very frustrating and expect it's the same on your part. Maybe a glitch limited to this saved search or something to do with our Netsuite configuration. Either way i'm sure I'm taking up a lot of your time, so…

Hi there, ah that's brilliant, fixed it, very grateful for you're help.

Hi there, thanks for persevering with this, tried as directed but unfortunately got the Unexpected Error message again.

Hello there, thanks for getting back to me, have tried the above and it has reduced the line to 1 but not showing the invoice number, and showing as 'Not invoiced', is there something my formula that's making it behave this way?

Hello there, as regards the formula and unbilled amount columns, these seem to be working correctly, albeit with the tax included of course, see below. As regards the calculation mentioned, had the below back from Finance: Hi mate, that is because the Oracle example is calculating the tax incorrectly for our purposes. it…

Hello there, thanks for getting back to me, it definitely applied to all invoices, the report i set only to capture GBP transactions so Subsidiary shouldn't be an issue.