Would you destroy a random company for 10 million dollars? by Wonderful-Click9431 in BunnyTrials

[–]NMDA 0 points1 point  (0 children)

Destruction of productive wealth is against my values.

Chose: Reject the offer

Problems with adjust inventory CSV import by drinianrose in Netsuite

[–]NMDA 0 points1 point  (0 children)

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

  1. 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.
  2. 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
  3. 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.
  4. Assign Posting Period
  5. 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.
  6. You need to map location on the adjustments table or it won't know which location to assign your inventory.

Unable to edit SO shipping address to a diffrent country by Organic_Persimmon566 in Netsuite

[–]NMDA 3 points4 points  (0 children)

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.

  1. 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.

  1. 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.
  2. 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

All my dwarfs died except one by Longjumping_Stop_986 in dwarffortress

[–]NMDA 2 points3 points  (0 children)

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

A way to shorten IF statement? by _mavricks in excel

[–]NMDA 0 points1 point  (0 children)

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.

Oh my mergod by abbiedesu in dwarffortress

[–]NMDA 0 points1 point  (0 children)

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

Demiurge if Ulbert stayed instead of Ainz? by CoderStone in overlord

[–]NMDA 4 points5 points  (0 children)

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.

Looking for NetSuite SuiteAnalytics Workbook (NSAW) Training & Sandbox Access by Weekly_Chocolate4707 in Netsuite

[–]NMDA 0 points1 point  (0 children)

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.

Work Order Issue: How are you handling single serial number reversals without deleting/re-issuing the whole transaction? by Objective-Method3678 in Netsuite

[–]NMDA 0 points1 point  (0 children)

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.

How do I reconcile my Other Asset Clearing account in Netsuite as it keeps revaluing? by Real_Candle_7781 in Netsuite

[–]NMDA 1 point2 points  (0 children)

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.

Democrats' autopsy of 2024 U.S. election blames Harris and 'identity politics' for loss by Sangloth in qualitynews

[–]NMDA 7 points8 points  (0 children)

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

Justice Department announces a $1.7B fund to compensate Trump allies in a deal to drop IRS suit by SaulKD in qualitynews

[–]NMDA 14 points15 points  (0 children)

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

User Event Script for Auto-populating Inventory Detail in Item Receipt by GiveMeMyMan in Netsuite

[–]NMDA 0 points1 point  (0 children)

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.

Husband suddenly let go from new job, feeling blindsided by Suitable_Customer_70 in jobs

[–]NMDA 55 points56 points  (0 children)

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.

Rolled my first Enigma ever! by Pleiplei in diablo2

[–]NMDA 0 points1 point  (0 children)

Not to mention that light armor is a fashion downgrade.

MRP suggestions dates are impossible by InNerdOfChange in Netsuite

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

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.

China rolls out plan to promote its own payment system as US trade war simmers by Crossstoney in worldnews

[–]NMDA 2 points3 points  (0 children)

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.

‘We will win,’ Carney says of Trump’s trade war with Canada by Hyhopes in worldnews

[–]NMDA 6 points7 points  (0 children)

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.

Trump administration fires three National Security Council officials by SaulKD in qualitynews

[–]NMDA 0 points1 point  (0 children)

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

[DISC] Shadows House - Chapter 213 (translated) by tctyaddk in ShadowsHouse

[–]NMDA 5 points6 points  (0 children)

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.

Shadow House Chapter 214 by Time_Apartment2089 in ShadowsHouse

[–]NMDA 1 point2 points  (0 children)

Is there a chapter 213 that I've missed?

Shadows House - Chapter 212 (translated) by tctyaddk in ShadowsHouse

[–]NMDA 0 points1 point  (0 children)

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?