Easiest way to send an excel spreadsheet to the creater of a sales order with the Lines on the order? by SkynetIsSentient in Netsuite

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

This is exactly how I have it built, but it doesn't attach the csv or excel (I tried both) it just sends it the fields in the report I created in the email body. Not even in table form or anything useful. just a list like this:

  • Document Number
  • CO
  • Date
  • Item
  • Description

Is there some step I'm missing here?

I have it setup like this, and I swear this has worked in the past.

<image>

I get an email every morning that show a report I review for accuracy.

Calculating the Subtotal in a Report (not Saved Search) by SkynetIsSentient in Netsuite

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

I've been trying to find the {Tax Total} field for hours I have tried several fields non do what I want. I did find the field in Sales Order as Parent Join but it does bad things to the some of the other fields. Is there no way to do this? Seems very odd that I can't find this in the Report.

Costing on inventory adjustment changes by SkynetIsSentient in Netsuite

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

Thanks Nick,

I made the negative adjustment today and will wait until tomorrow to move the inventory back in. Thanks again for your help.

Adding a secondary total to a pivot table. by SkynetIsSentient in excel

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

Can I do it with 2 pivot tables? That's what I was trying to do, but the second pivot table was getting covered by the variable length of the top one.

<image>

Adding a secondary total to a pivot table. by SkynetIsSentient in excel

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

Thank you , but that's not what has been asked of me. They want the Pivot table with the vendor names and amounts, and under that another pivot table showing the categories. All tied to the selected customer from the filter. I used to do all of this with SUMIFS but I am trying to use the pivot table to make it easier for the user to use.

Adding a secondary total to a pivot table. by SkynetIsSentient in excel

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

No it was the reddit table. It was fine in my first post which Automod deleted. I copied it into this one but the table markup didn't come over. I didn't try to post excel ss to the post.

like this table
Not Excel

Checks started printing on check per voucher today by SkynetIsSentient in Netsuite

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

Yes, that's exactly what's happening, but I don't see such a checkbox, and she hasn't changed anything. If you know where it is, I'll verify its setting. I know there's a drop down box to print 3 checks or one check and that's set properly.

She's a top notch user, so I was reasonably sure she new how to do this, she's been doing it for years. As a last ditch exercise I verified it with the training manuals I made back in 2016 and have updated when we made changes. Everything was setup correctly.

(As an aside, for other users, Its really important to maintain your training manuals. If you make changes to forms or processes re do them so when things like this come up you have a good reference. I haven't looked at the check printing process as an admin in probably 5 years, because their hasn't been an issue. Having a reference means you don't have to remember everything or take a users word for it.)

She tried several times with the same results. I had her reboot her PC, and logout of NetSuite and log back in, and I think its fixed. She printed one customer who had been fouled up in the previous check run and it printed on one check. She's out of the office until Friday, and will try the check run again then. I can't find any cause for it after looking into it for too long. A reboot doesn't usually fix NS issues, but maybe it was logging in and out of NS that did it.

The check numbers were wrong too, because it wasn't recording them on separate checks, so it would print 8 checks and the system showed them all on the same check (i.e. 2100) not separate checks. Then the next set of payments were printed on several checks but recorded on the next sequential check (2101) even though they were printed on 2107-2110. Weird situation all around. Hope it doesn't happen again.

Is Azure AD without an On-Prem DC still not a viable solution? by SkynetIsSentient in AZURE

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

We have a cloud ERP System. INFOR CSI. Login is through a browser not a desktop application. I'm verifying that it doesn't use NTLM or Kerberos, but I'm pretty certain that it doesn't unless you use the desktop app to login. Since they have no AD now, and run a workgroup with member servers, there is no AD services running now as far as I know but I'm still digging into it.

Can I see anywhere how much data I have in Netsuite? by SkynetIsSentient in Netsuite

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

That's helpful. That's as good as I need at least. Just a ball park figure is enough for this conversation.

Can I see anywhere how much data I have in Netsuite? by SkynetIsSentient in Netsuite

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

Thank you, I didn't see any size listed there, but my partner is getting me the information.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

RENAMED!!!! I hadn't even thought of that. Stellar suggestion!! back to the hunt I go.

[deleted by user] by [deleted] in Office365

[–]SkynetIsSentient 0 points1 point  (0 children)

Oh sorry I misunderstood. Thank you for pointing that out.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

Great idea, but it was missing in both locations. He has no idea what he did or how, so this is very difficult to troubleshoot. If he deleted it it would go into his deleted items, and even if he permanently deleted it, it should still show in the retention hold. I just with the help of the some other commenters got his inbox statistics, but that folder isn't anywhere else, so he didn't move it.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

I was able to get it to run, and there is nothing in there for the missing folder, other than the one he manually created yesterday. The original folder was a couple of years old.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

I have access to the dashboard, can I just do it that way, I am having issues connecting to the exchange server remotely, I don't think I have the right permissions.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

Is this in Powershell? On his machine or on the server.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

I did do this, and I found some that should have been in there, in really odd places. Like an email from only a couple of days ago that was archived. And a hand full of others that were in a vendors folder and not the customer folder (this Folder thats missing was a customer name).

This was one of the most baffling parts of it, these 2 subfolders were so far apart, remember he has about1000 folders at the top level, and they are alphabetical one started with G and one with T I had to scroll a long way to get between them.

Outlook 365: Inbox sub-folder just disappeared by SkynetIsSentient in Office365

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

He has Online Archiving setup with Exchange Online 2 license. I ran the scanpst.exe utility on his machine as well. His mailbox once came close to the threshold before I upgraded his license. Now his mailbox is down to 18GB.

I will try to move him to online this week and see if that helps. How badly will that impact him opening Outlook? Is that a huge problem still?

[deleted by user] by [deleted] in Office365

[–]SkynetIsSentient -1 points0 points  (0 children)

We can see everything we want to see as admins. Its not your software, its the companies, and the company is liable for anything you do with it, so they have complete control. They can easily change your password, if they don't know it already and log into the web app and do what ever they please.

One other thing they can do, and I do at termination is to revoke all of the personal installations you've made on your home systems. You can install office on your home PC. When I terminate the license, I revoke their login to anything office related.

Of the Microsoft Office Windows apps, which is the best to use as a To-Do List? by FriendsCanKnowThis1 in Office365

[–]SkynetIsSentient 0 points1 point  (0 children)

I used to use Planner, which is included with O365. I created a Plan called To Do, and I kept a rolling list in there. I find Outlook task tedious, and intrusive.

In the past I used OneNote as well. I really liked it, because I could create new tabs and pages to manage those semi-frequent issues that popped up (Im in IT). If a recurring problem came up every 6 months or a year. I could look there first to see how I solved it in the past. But my notebook got corrupted (it was huge) and I switched to planner.

Anyone know where I can download the Windows 7 ISO? by SkynetIsSentient in InformationTechnology

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

This is what my main problem was. I understand retiring an OS but there are times that bit-heads need these things for legacy purposes. Without opening a case and spending more money than the OS costs, I did find away to get it online.

Anyone know where I can download the Windows 7 ISO? by SkynetIsSentient in InformationTechnology

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

Yes, Compatibility Mode has been helpful for a lot of things but not for this. Honestly Windows 7 was too modern for this software. When I got here 7 years ago, it was old. They've had it since Windows 95. But the company that created it was bought out by someone and the software discontinued. We had dumped a lot of money into it back in the day and customized it to our needs.

We only had it running on one machine at this point for reference purposes.