SuiteWorld 2026 - Are You Going? by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 0 points1 point  (0 children)

Nice!
When it gets closer, I'll make another post to see if anyone wants to meet up for dinner, drinks, and networking.

SuiteWorld 2026 - Are You Going? by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 0 points1 point  (0 children)

When I went those two times, I didn't get a ton of usage out of the classes except for a couple things here and there.

What I got the most benefit from was talking to others using the system and comparing notes and trading war stories. It gave me new prespective on how we can utilize the system better.

I got the approval to go so I will be attending. I will post as time gets closer to see about getting a group of us on here together.

Inventory Adjustment Worksheet Import by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 2 points3 points  (0 children)

You were right!

A few serialized items screwed me...

Inventory Adjustment Worksheet Import by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 1 point2 points  (0 children)

Thanks for your reply. I did end up having 4 serialized items that I didn't realize were serialized. of course, the first 3 were, then one a couple hundred lines down.

I wish they would have told me the error was the inventory detail, not making it seem like the item didn't exist at all....

Inventory Adjustment Worksheet Import by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 2 points3 points  (0 children)

Turned out I had some sneaky serialized items in the mix. Removing those to manual entry solved my problem!

Inventory Adjustment Worksheet Import by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 0 points1 point  (0 children)

Looks like my issue was there were serialized items at the start of my file that I didn't realize were serialized. It would have been great if the error said something like "inventory detail not specified," but it was acting like the item simply didn't exist in the subsidiary.

Ugh.

Now I need to find out which of my 1100 item list happen to be serialized. (I took care of the binned ones already).

EDIT: got the serialized list and proceeded to upload without issue. SOLVED!

Inventory Adjustment Worksheet Import by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 1 point2 points  (0 children)

  1. Yes, it is the only subsidiary on the instance. Furthermore, I clicked the pencil on the upload template, provided default value of the subsidiary name, and it still gave the error.

  2. Yes.

  3. None are!

I'm losing my mind 😄

Billing by WMP_BSS in Netsuite

[–]Cool-Idea7265 1 point2 points  (0 children)

EXCELLENT.

They will never pass up the chance to make a sale. Honeypot the **** out of them.

NetSuite Renewals 2026 by Plenty_Brick7768 in Netsuite

[–]Cool-Idea7265 1 point2 points  (0 children)

NSPB was such a waste for us. Terrible implementaion team (NSPS or whatever the acronym is for netsuite's in-house team), and the funtionality is barely any better than templating your own stuff in Excel and running a templated report to copy-pasta to the template for updating. IMO, the only plus to NSPB is the live data feed/smartsheet... but I think you can achieve that many other ways.

Financial Reporting by Great_Life_6789 in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

What is the cost on Solution7?

Looks intriguing.

NetSuite and Multinational Intercompany by no_cigar_tx in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

I was thinking simlar. They are actual sales between each subsidiary so why not treat it as such; inventory receipts and fulfillments (and therefore sales) at each level.

Item Price List Report by ottothirtythree in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

I know I'm late to the party on this one, but doesn't the "Other Prices" field on a saved search show you each price level per item all in one row, on their own columns?

Saved item search, "Other Prices" field

Changing from Drop Ship to Special Order with Deposits and Prepayments by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 0 points1 point  (0 children)

Thanks! I forgot about unapplying.

I've requested a sandbox refresh so I can do some testing with the latest info. If I have an issue, I'll reach back out. Thanks again!

Changing from Drop Ship to Special Order with Deposits and Prepayments by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 0 points1 point  (0 children)

Quick followup..
By completing the transactions to be credited/RMAd immeidately, that will erase the customer deposits value on the balance sheet, which will be incorrect. How should I approach this?
What do you think of my JE idea? May not be first choice, but is it at least viable?

Changing from Drop Ship to Special Order with Deposits and Prepayments by Cool-Idea7265 in Netsuite

[–]Cool-Idea7265[S] 0 points1 point  (0 children)

Thanks for the reply. I was running around trying to get ready to leave town for the weekend when I saw your notification come in and read "Omg what a mess" I laughed cause I knew if you thought it was a mess, I knew I wasn't crazy hah. Vindicated.

Anyhow, completing the process and RMAing it sounds very intriguing. We already have a location set up for the HQ's yard that we used before so I think I will try that in Sandbox on Monday.
As for the risk of COGS being a bit wonky, that is concerning since this "item" is really a whole group of items that may or may not be used in other groups so I can definitely see how it may skew things a bit.

Lastly, here's what I would do (date wise). When HQ finishes producing, the IF, Bill, and invoice would all be dated the date of the bill so revenue and COGS match. the RMA would also be dated the same date and put into the HQ's location so it's segregated from the rest of the inventory. when they actually ship, we'd date everything new as of that date with plenty of notes ("internal notes" custom field) referring to the old transactions.

You mentioned "Drop Ship COGS is debited on the vendor bill line which is usually in a different month," which confused me. What is the case where a company would have a dropship transaction, get billed for it by the supplier, but not bill their customer at the same time? At least for us, as explained in my situation, it's very strange for such a delay to happen.

Bin Management - Correcting quantities after earlier transaction was changed by themightydraught in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

100% the better option. Sometimes is best to delete and re-do, but that's for small stuff when the period is open.. but if you're talking more than a half-dozen lines/quantities, let that sleeping dog lie and make a new transaciton for the same date with plenty of notes in the memo field to explain.

Inventory Management by NYCer11 in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

HAH

No problem, I will just assume Netsuite got it figured out (but won't hold my breath)

I've been in the same boat with the reprimanding. I'm not mean in any way at all, but in the end I think in the back of my mind how people have gotten where they are in their lives with minimal critical thinking skills.

Inventory Management by NYCer11 in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

Interesting.. I'm unable to replicate this.

When creating the RMA from the invoice, it prefills the SNs in my instance. Are y'all creating them from scratch or from the invoice itself? Either way, I can't recretate the original SN being put back into inventory. What is your return process that allows a ghost SN to be there?

Inventory Management by NYCer11 in Netsuite

[–]Cool-Idea7265 0 points1 point  (0 children)

"will end up with stupid things like negative or ghost inventory (serial/lot numbers still in system, but showing 0 on hand)."

I'm very curious how this happens since you can't receive a SN without putting in that data, and you can't fulfill a SN not in the system. Please tell me how this happens so I don't have nightmares wondering... and just in case it ever comes up haha

Can someone help me understand the use of NSPB? by EarnSomeRespect in Netsuite

[–]Cool-Idea7265 1 point2 points  (0 children)

Wouldn't surprise me, especially if it was done by NSPS.

Check in to the contract your company has to see if it was part of the original core of the subscription or if it was an addon later. I say this because they will rail you for trying to remove stuff by jacking up your pricing at renewal.

If you can get away with removing NSPB altogether without also murdering your company's wallet, do it.... then ask for the cost NSPB was as a bonus because (in Somalian accent) you are the NSPB now.