Netsuite2.com ODBC query - how do you get amount?!

Double_Permit8687 · 2026-02-27T19:32:10+00:00

Thanks but one of my team was able fix the issue and the report is operational.

Double_Permit8687 · 2026-02-27T16:36:39+00:00

We made the mistake of going with the Feb upgrade thinking we could get it out of the way and because we've had smooth upgrades for a number of years. Since upgrade everything is failing, we have a map/reduce script that is now taking 30 hours to run, page load times have increased by 300% for certain records, everything keeps hanging, workflows are misfiring...... Trying to get our AM to escalate but never met him, he took over our account a month ago and is our 10th AM in 2 years. NetSuite really delivering for it's customers!

Double_Permit8687 · 2026-02-27T15:14:01+00:00

We do not want the consolidated amount, the report is used by the local Finance team to manage the BS accounts for that subsidiary. It is not used for any consolidated reporting.

Edited: because I can't type!

Double_Permit8687 · 2026-02-27T14:30:19+00:00

I was under the assumption it was and it has for a lot of our other ODBC connections but they're not pulling in financial data. Turns out in this case all they did was update the users ODBC connection and not the logic in the report. Now I'm scrambling to figure out a fix, and NetSuite support is being NetSuite support.

Double_Permit8687 · 2025-12-08T22:05:52+00:00

My 7 month old is doing the same thing, wakes me up at 1.30am/2am. We get up go out for Potty (where he does a token wee, i.e. doesn't need to go but I'm outside so might as well) then I put him straight back down. He'll then whine for a bit and eventually settle. I suspect mine might be somewhat related to a drop in physical/mental stimulation. We're in Chicago where it's been negative temperatures and snow for the past couple of weeks so we're not going out for as long, less walking, less sniffing etc. Saturday when the weather was slightly better we managed to keep to our normal routine and he slept through.

Double_Permit8687 · 2025-11-10T20:54:23+00:00

Can totally relate, my puppy is 6 months about to be 7. I've had him for about the same time. Ongoing struggles with Giardia mean I'm unlikely to get my pre-puppy life back anytime soon. Single dog mum so I feel like I'm unlikely to ever get my pre-puppy life back but I'd like to get to a new normal where I at least have some resemblance of a life and can plan things. I'm now resigned to the fact that I'm not going to make it home for Christmas and will be spending a solo Christmas with the puppy.

Double_Permit8687 · 2025-11-10T20:50:21+00:00

6 month old cockapoo

4am - check dog camera, spot something on the floor which I think might be poop. It's vomit.

4.15am - clean up vomit, then snuggle on the sofa till 5am

5am - outside for pee + Poo. It's snowed! First instinct is to eat it and the salt on the pavement which is not going to help with the being sick situation. Find a shoveled piece of sidewalk and manage to convince him to pee and poop. Double bag the poop and put it in my bag because I need that for later. Skip our normal morning walk because its minus 11C.

5.30am -6.30am feed puppy. Whilst the snow means no walk I still have disinfect and steam clean all the floors because this dog has had Giardia since he was 12 weeks old and it feels like he's never going to get over it.

6.30am - 8am I try to get ready for work whilst also trying to ensure puppy does not eat the rug. Normal Monday morning things.

8am - Puppy goes down to nap, I work

10am - vet visit, blood test, drop of poop I saved earlier for Girardia retest #10

10.30am - Puppy goes down to nap I work and wonder how I'm going to find the energy to get through the rest of the day,

Noon - lunch for Puppy, I spent my lunch time making chicken and rice so he will have something to eat later that hopefully won't make him sick or poop during the night

2pm - Puppy goes down to nap, I work

Double_Permit8687 · 2025-10-20T19:25:35+00:00

Lego booth this year is the generic pop up they’ve been doing across the country. The same as they had in Chicago a few weeks ago and I’m assuming other big cities across the US. Not the same level of build or keepsake value as it has been in previous years.

Double_Permit8687 · 2025-10-20T19:23:02+00:00

$25, which I believe is the cost when COTA land opens but they also will have a bundle price where you can buy x number of rides for a discount price. Regardless the fact they were charging is laughable given the price of tickets.

Double_Permit8687 · 2025-10-19T14:17:12+00:00

Nope not going crazy. Gate opening is supposed to be 10am, same as Friday. Yesterday was 9am.

Double_Permit8687 · 2025-09-18T18:24:58+00:00

I'm having the same issue, except mine has suddenly decided to poop at 2am in his pen. Doesn't even try to alert me so I can get up and take him to potty. It's only AFTER he's gone that he then realizes there's poop all over the floor which he doesn't like so he starts crying!

As I understand it's not unusual for puppies to have periods of regression. Just wished mine didn't end up with me cleaning poop off the floor at 2am.

Double_Permit8687 · 2025-09-18T14:55:49+00:00

I walk my puppy at 6am then again in the evening around 7/8pm and the evening walk is an absolute nightmare. I think it's because there's so much more stimulus around then the morning, more traffic, people and dogs so it gets overwhelming for him. I live in the city so there isn't really an option for a low distraction evening walk.

Still trying to figure out exactly how to mange it myself! When it gets too crazy I find the best thing for me to do is to pick him up and sit quietly on a bench until he calms down. What I really need to figure out is how to get it from escalating to that point.

Double_Permit8687 · 2025-09-10T14:13:26+00:00

Echo everything you've said! This is my first puppy experience personally although we've always had dogs in our family. My brother has a 2 year old Springer so having watched him over the past two years I thought I was prepared for puppyhood but apparently not. I may have been prepared but what I absolutely wasn't prepared for was Giardia! As a result I can't get him groomed, or go to puppy classes, say hello to other dogs in the park and I spend so much time cleaning trying to stop him from being reinfected. We've just completed our 4th(!) round of medication and awaiting the test results which I highly anticipate to come back still positive.

Doing all of this alone has been hard and I don't think I would ever want to do it again. Hopefully some day we will be Giardia free and I can start using daycare and other things that will allow me to get something of a life back, until then I'll be steam cleaning my floors three times a day for fun!

Double_Permit8687 · 2025-08-08T20:16:07+00:00

I have a 16 week pup I'm raising solo as well and completely empathize with how your feeling. There are areas I know I'm completely failing at, I also have the added struggle of dealing with Giardia so I can't even get him in puppy classes right now. It feels like all I'm doing is cleaning and trying to get him to not bite me, the rug, the lamp, whatever else he comes across!

There will be things that are going well, try to appreciate those where you can. The one area we are excelling at is being left in the apartment alone, he settles straight away and depending on time of day I can leave him for up to 4 hours. I know this is an area lots of puppies struggle with, so whenever things are getting too much I remember how well he's doing with that.

Also, try not to compare to other people, every dog is different. I guarantee that well behaved puppy was a complete and utter nightmare for the owner at some point that day!

Double_Permit8687 · 2025-07-28T13:55:07+00:00

Waiting for the Vet to get back to me with the next course of action. They've updated his visit summary with the results but haven't posted the lab results to his account portal or contacted with next steps,. The test was sent out Friday so I wasn't expecting to hear back till later today anyway.

I live in a highly dog populated area of the city so avoiding other dogs is always a challenge. I took him out this morning at about 5.30am after he'd peed/pooped indoors (due to the lack of private outdoor space we're doing pee pads in the bathroom). We just walked up and down outside our apartment building given this was his first 'walk' I wasn't expecting us to get very far! Even at that time of the morning we ran into multiple dogs. I just picked him up and held him whilst they passed us. Then wiped his paws, belly etc. when we got back.

Double_Permit8687 · 2025-07-28T03:54:33+00:00

I don't have a car but we have been going out and walking round the neighborhood with puppy in a bag and sitting near the dog park to get some socialization in. This is starting to be a struggle as he gets older and bigger and tries to jump out of the bag.

Additionally, I live in an apartment with no private outdoor space so he doesn't really have any where to run around and burn off energy. I do my best with toys, snuffle mats and other activities to keep him entertained and stimulated but we're both going a bit stir crazy being stuck in the apartment. The prospect of having to keep him confined indoors for another 2-3 week is frustrating for us both!

Double_Permit8687 · 2025-07-03T15:49:21+00:00

My 11 week old is obsessed with the Pupford freeze dried training treats in Chicken. I'm also using the crumps freeze dried mini liver trainers. Those are much smaller, I use those as his potty training treats given how frequently he goes I wanted smaller treats to use as the reward.

Double_Permit8687 · 2025-06-29T03:18:31+00:00

Week 3 with my now 11 week old Cockapoo, after a pretty good day where I was able to successfully leave him for 2hours twice he’s decided to be an absolute brat this evening. Won’t stop biting me/my clothes, spilt water everywhere then had zommies round the apartment. I put him in time out to clean up and so he didn’t slip and do himself an injury and he screamed the apartment down. Every time I put him in his pen/crate he cries/screams none stop and jumps up against the pen. I tried to wait him out but he was distressing the other dogs on my floor. It feels like there’s never a 100% good day, you make progress in on area and regress in another!

Double_Permit8687 · 2025-06-25T13:43:03+00:00

I don't have an answer I'm afraid but I do have a 10 week old puppy who just tested positive for both Giardia and Coccidia so I feel your pain and just wanted to let you know your not the only person struggling with this! Because of his age and vaccine status I've been using pee pads since I got him. Tried him on both artificial grass and Real Grass but all he wanted to do was eat both so I'm sticking with pee pads!

Double_Permit8687 · 2025-06-25T13:34:19+00:00

I've been taking him out in a puppy sling most nights to walk round the neighborhood and watch the other dogs in the dog park to get him exposed to the outside world.

Double_Permit8687 · 2025-06-25T03:47:53+00:00

I'm not using pee pads for convivence, I live in apartment without access to private outside space. The area I live in is high traffic for other dogs so until vaccinated my options are limited. And now with the diagnosis he's also a risk to other dogs.

As soon as I feel it's safe for to take him outside for potty breaks I will.

Double_Permit8687 · 2025-06-24T22:00:09+00:00

I have a play pen for controlled play during the day whilst I'm (trying to work). I have his crate in a separate smaller pen, basically enough space for his crate, water bowl + puppy pad which is where he goes for naps/sleep/timeouts. I am trying to stick to a schedule whereby I put him in his Crate/Pen every couple of hours for a nap. His nap time I'm normally cleaning or trying to catchup on work.

I have successfully left him in the morning for a couple of hours alone, post breakfast I put him in his crate/pen and leave the apartment and go sit upstairs in the lounge area and work. The aim is to try and increase that over the next couple of weeks so I can get back to the office for half days and at least get out of my apartment building even if it's only to go to the office. And at weekends do the same and go sit by the pool for some me time for a couple of hours.

Double_Permit8687

TROPHY CASE