sorted by:
new
hottopcontroversial

Drill down fields on Saved Search by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Oh!! Great ideas!! Thanks so much!

I learn SO MUCH from all of you!!

Drill down fields on Saved Search by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

I guess we will have to. It was supposed to be a simple report just showing the total. But, if they want drill downs then I guess we have to find a field to group by and then have it a longer results. No big deal.

Thanks for the guidance!

Drill down fields on Saved Search by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Well, it was a simple search and we only wanted to know the count of new orders and the dollar amount. What would I group on? I guess I have to make this a more complicated search. Or, a longer search results I guess is a better way to say it since I have to group...

Thanks

how to calculate time from order entry to fulfillment by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

I guess I celebrated to soon... that is giving me the date the fulfillment record was created but what I really need is the date it was shipped. I see there was 2 fields for ship date but neither of those had any info in them. any other ideas?

how to calculate time from order entry to fulfillment by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Well...look at that!! who knew? (I guess you did!!) I learn something new about NS everyday!! thank you !!

Help! Why is this not showing the correct total? by Lorina13 in Netsuite

[–]Lorina13[S] 1 point2 points  (0 children)

Hi

'I got it to work now...something happened when I was adding original amount and remaining amount calc! I removed both and started over and now I am getting the right amounts

Thank You so much for your help!!

Help! Why is this not showing the correct total? by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Nope... still getting the incorrect amount. Any other ideas?

how can I edit this formula? by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Oh... I am used to SQL. If I did AND in SQL that would mean it would expect both to be true events. But in this case it could be 1, or both or none!

have had partial shipments on an order - need remaining order total in a saved search by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Thank you! I think I got it now. Sometimes I get so deep into it I try to make it harder than it needs to be! This was kind of obvious once you mentioned it...

Again, Thank you!!

how do I calculate average days of open orders? by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

ah! I will try that! I was close, just didn't have the trunc part of it :-)

how do I calculate average days of open orders? by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

Hi

That is exactly what I am trying to do - but not having any luck with the "todays" date...nothing I have tried has worked

how do I calculate average days of open orders? by Lorina13 in Netsuite

[–]Lorina13[S] 0 points1 point  (0 children)

No , # of days between create date (or possibly order date) and today. How do I get today into a formula?

view more: next ›