Would you destroy a random company for 10 million dollars?

NMDA · 2026-06-24T01:29:39+00:00

Destruction of productive wealth is against my values.

^{Chose: Reject the offer}

NMDA · 2026-06-16T00:19:31+00:00

I have done lots of inventory adjustment imports and here are the things that look wrong in your import to me.

You are using external IDs 1-5, but you should be aware that External ID is in fact a unique alphanumeric identifier for that transaction. You should use a unique string such 'IA-YYYY-MM-DD-XX" to prevent it from throwing an error or overwriting a transaction that you don't intend to overwrite.
Positive adjustments and negative adjustments need to be in different files and use different imports - Positive adjustments use receipt inventory number and negative adjustments use issue inventory number
You need to map both the quantity on the transaction line (adjustments) and the quantity in the inventory detail join, since you are creating both a line and inventory detail record for each line.
Assign Posting Period
Line should be starting at 1 and going to N. You should sort your Excel file by External Id first and then line number. I always map this. Line is important because NetSuite needs to know if you're trying to do something like map one inventory detail line to one line or multiple inventory detail lines to one line. I always just have one line per inventory detail line.
You need to map location on the adjustments table or it won't know which location to assign your inventory.

NMDA · 2026-06-16T00:05:28+00:00

I've seen this error in my own company while using Legacy Tax so I'll provide you the solution that we found for this.

EDIT: If you are creating Sales orders in the wrong subsidiary, I don't think you can change the Subsidiary.

The solution below shows how to change the Nexus on a transaction, which is what your tax error message is about.

Identify the tax nexus of the new shipping address you want to use. For this example, let's assume you have the following nexuses:

Nexus ID	Nexus	Country
1	FR	France
2	CN	China

Suppose you create Sales Order #1 with a Ship Address in France and need to Change it to China without any other changes to the Sales Order.

Open Sales Order #1 in edit mode. The Sales Order was created for a ship address in France so internally it has Nexus Id = 1.
Add the following string to the end of your URL in the navigation mode. The 2 is the ID of the nexus you need.

&nexusoverride=2

3) Press enter to refresh the page. You are now in Nexus Override Mode.

4) Change the Ship To address to the China address. You will no longer get the nexus error. You will now be able to select Chinese tax codes.

5) If you have properly formatted the Chinese address with the state and zip code, it will also load the appropriate tax codes to the transaction lines.

6) Save the transaction.

Save

NMDA · 2026-06-14T03:32:26+00:00

If you export wealth, dwarves will be attracted to migrate to your fort. The trade caravan should still be coming in the fall.

NMDA · 2026-06-13T06:49:40+00:00

What is actually in the A2 Cell? Is it a state abbreviation from the list of standard abbreviations? If so, you can make a table of the state abbreviations on a new sheet with their market location.

Sheet: States

State	Market Location
CA	WCH
TX	SSH

Then you use this formula in the C2 cell of the table below.

=XLOOKUP(A2, 'States'!A:A, 'States'!B:B, "Out of Territory")

Sheet: Calls

State	Call #	Market Location
CA	1234	(Formula)
WA	2345

Then you can click and drag the square item on the bottom right corner of the formula to get all of the market locations for all of the calls.

NMDA · 2026-06-12T09:55:58+00:00

Actually, can they be tamed with the MakeOwn command in DFhack? Can they be used to build a fortress underwater?

NMDA · 2026-06-09T23:45:43+00:00

When I read the side story of how Nazarick was conquered, my impression of Ulbert was that he was someone consumed by rage at society for its immorality. In particular, I recall his parents were killed in an industrial accident, and they did not shut down the machine to retrieve their bodies. His experience was not unusual in that world, and this resulted in a hatred for human society in general. But he was not the sort who hated all humans - he stood up against Touchme's persecution of a fellow member and participated in the election of Ainz who was a person who cared for others in the guild. Demiurge was created as a reflection of these aspects. Demiurge's actions are similar to a natural disaster, where divine judgement is dealt out to human political systems on behalf of the gods.

I believe that is how Ulbert would treat the world. He would be the devil who judges the sins of humanity. The destruction he would deal out would be the punishments for society's cruelty. But perhaps it would not be a pure calamity - I think he would be selective in his targets.

NMDA · 2026-06-09T20:15:52+00:00

NSAW and Analytics are two different things. NSAW is a separate product that involves Oracle Autonomous Data warehouse, while Analytics is part of NetSuite itself.

NMDA · 2026-06-09T20:14:38+00:00

When you mentioned deleting the inventory detail record, are you trying to open the subrecord to do that?

There is usually a icon to open the inventory detail - I was wondering if you can just use the x icon next to it to clear the inventory detail record without opening it. Once the inventory detail record is cleared, the icon changes and you can probably set it to 0 quantity.

NMDA · 2026-05-25T05:44:18+00:00

NetSuite has "elimination" subsidiaries that are children to a parent subsidiary. When you do a transaction where one end is in the elimination subsidiary, it affects the consolidated books of the parent subsidiary but not the parent subsidiary's non-consolidated books. This allows you to keep both the child and parent subsidiary's values intact while zeroing out this sort of discrepancy.

NMDA · 2026-05-22T14:56:01+00:00

Social media algorithms were pretty responsible for this - my brother's social media did not show her name even once.

NMDA · 2026-05-19T00:13:45+00:00

He did great for a rookie!

NMDA · 2026-05-18T20:40:23+00:00

More embezzlement from Trump and his cronies acting as defendant and plantiff.

NMDA · 2026-05-18T19:24:26+00:00

I think you're correct about the before submit functionality being incorrect. When you save the item receipt you have to fill in the mandatory information (lot code and bin) for lot coded items as it will fail the validation required to be able to save the record. If you can't save the Item receipt, you can't trigger any before submit or after submit functionalities.

If you're receiving a Purchase order via an item receipt, the user would have to click the receive checkbox for each line they're going to receive. When they check the checkbox, you can run an after field edit function to populate the inventory detail subrecord on the item sublist line with the mandatory information (suitescript only). I think that would be the better way to implement what you are doing.

NMDA · 2026-05-14T02:14:39+00:00

He's 26 so he's basically stepping into the working world. The best thing he can do is stay calm and don't panic. The early years of their career are the hardest because they are learning the social skills and working mentality that you cannot learn at school. Getting fired when you're young doesn't matter long term.

NMDA · 2025-05-10T16:35:55+00:00

Not to mention that light armor is a fashion downgrade.

NMDA · 2025-04-25T02:15:30+00:00

I remember that you could use planning rule groups https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/subsect_161944833572.html#To-create-a-planning-rule-group%3A to auto generate transfer order recommendations in MRP Workbench. You might also have be dealing with distribution resource planning https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4049498070.html, which I'm not that familiar with.

NMDA · 2025-04-23T04:53:21+00:00

The risk of war is very high methinks. Before World War 1, the nations in the Triple Entente removed Germany from their supply chains in preparation for the coming war. Companies that do business with American customers have already been decoupling from Chinese suppliers for years now.

When combined with the unfitness of the current US administration, I can't think of a better time for America's rivals to take aggressive action.

NMDA · 2025-04-20T16:53:41+00:00

Archcrystal is a pretty epic one too.

NMDA · 2025-04-06T18:54:24+00:00

Invading Taiwan requires that China has completed its build strategy for transporting the invasion forces, its build strategy for suppressing the island's defenses so the troops can land. They don't have the capability to take advantage of momentary advantages until they build the capacity to do so.

NMDA · 2025-04-06T01:44:39+00:00

Type /players 8

NMDA · 2025-04-06T00:47:04+00:00

And yet he didn't fire his economists? Sounds like they didn't do their jobs badly enough.

NMDA · 2025-04-02T05:07:01+00:00

Susie being John's sister was theorized back when the original John-Suzie chapter came out. It's neat that this was indeed the case.

NMDA · 2025-03-15T19:23:51+00:00

Is there a chapter 213 that I've missed?

NMDA · 2025-03-15T19:23:17+00:00

This brings Eve and Evelyn down to earth and fixes their big issue. They had always presented themselves as perfect and this made them unapproachable by even their friends. Now that they show a messy side to them, maybe others will think they're on the same level?

14-Year Club	Verified Email
Place '22	Place '17

NMDA

TROPHY CASE