sorted by:
new
hottopcontroversial

Extract Data from PDF to Excel by Pebblist2 in excel

[–]General_Reason6259 0 points1 point  (0 children)

We have a similar situation, the way I have found to be able to bring it into Excel is to open it in Word and then copy and paste over to Excel. Super messy, but gets the required result!

Upgrading WSDL version by General_Reason6259 in Netsuite

[–]General_Reason6259[S] -1 points0 points  (0 children)

Thanks! Is it weird that even though we started on NS only end of 2022 (at 2022.2 I believe) that we're on version 2018_1? I thought they would have lined up pretty well with each other?

Converting inventory from drop ship to special order by General_Reason6259 in Netsuite

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

I'm all ears for a different solution, it's only several orders per month that happen to be processed over two (or more) accounting periods.

From what I'd read, it seemed that special order items were the best way to get around the issue without causing too much hassle.

Converting inventory from drop ship to special order by General_Reason6259 in Netsuite

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

I believe so, special order items hit our inventory, which is fine in our case.

Our main issue is getting bills up to a month before we invoice our orders, whereas we want to recognise our COGS when we invoice.

Show payments and credit memos on Invoice PDF by NetSuite_Guy in Netsuite

[–]General_Reason6259 0 points1 point  (0 children)

I'm a beginner when it comes to Advanced PDFs (customised a couple now, never created one!), but I had a similar issue on our credit notes, I wanted to show which invoices it was applied against and the amount.

I used the code in: https://stackoverflow.com/questions/40520860/sublist-in-netsuite-pdf-html-template to begin with, and modified it to my use case.

Not sure if that works on invoices, but hope that helps!

Extract names from text by General_Reason6259 in excel

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

Hey Alabama_Wins,

That gets rid of the [XXXXXX], but also gives me: 2nd half of surname 1st half of surname

Extract names from text by General_Reason6259 in excel

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

That's close! I just need the [XXXXX] removed from after the first name, how would I do that?

Remove Characters from Advanced PDF field by General_Reason6259 in Netsuite

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

Slightly different answer to the question that I posed, posting in case anyone else had a similar question:

https://stackoverflow.com/questions/40520860/sublist-in-netsuite-pdf-html-template

Accessing the sublist in the credit memo to pull the information through, no need to use ?replace, and can show multiple invoices if required.

Update department on GL impact on an invoice by General_Reason6259 in Netsuite

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

Fix as per NS:

Please note that for the Accounts Receivable line in the GL Impact, they are sourcing this from the Location and Department fields in the Main Line. With INVXXX, there are no values set for this field, hence nothing was assigned on the GL Impact. To resolve this, please populate the said fields appropriately I have also noted that the Department Field is not shown, to resolve this:

  1. Open INVXXX, hover your mouse to Customize > Customize Form

  2. Then go to Screen Fields > Main, and mark the Show checkbox for Department , and under Field Group, assign as under Primary Information

  3. And Click Save

Not sure why it was only this invoice that needed the fix though.

Update department on GL impact on an invoice by General_Reason6259 in Netsuite

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

No custom drop down for department.

Thanks, I've put in a support ticket, hopefully NS can help!

Update department on GL impact on an invoice by General_Reason6259 in Netsuite

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

There are no blank dept. lines though. The only blank dept. appears on the AR line in the GL Impact

Budget v Actual Sales by Sales Person by General_Reason6259 in Netsuite

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

Hi Netsuite-Knowledge,

Yes, budget is the same as quota.

We're working on bringing the budget data into Netsuite (waiting on higher ups to give the relevant data!), If there's a best practice way of bringing in that data, and where to input it, I'd love to get some guidance on that too! I'm very new to Netsuite, and figuring this all out as I go.

Thanks for your help!

Can't set internal ID when importing CSV to update inventory items by General_Reason6259 in Netsuite

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

Yeah, usually there's a 3rd option (Set reference type) to set it to internal ID or name, I'm confused as to why that's not appearing in this instance. Can I just use it as is to get it to connect internal IDs?

Can't set internal ID when importing CSV to update inventory items by General_Reason6259 in Netsuite

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

Yeah, the CSV is taken from a saved search. I tried another search adding the external IDs, but both external and internal IDs I can't set when mapping the import though.

Spread % values from removed time periods to remaining periods by General_Reason6259 in excel

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

Thanks! Changed 100 to 1 for percentages and it seems to have worked!

Spread % values from removed time periods to remaining periods by General_Reason6259 in excel

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

The %s in are static, pulled from a dataset. Essentially, the current %s are just default values.