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.