Best Of

Hello,

Upon checking related concern they mentioned that it appears that the behavior of how values are accepted in the findSublistLineWithValue(options) function has changed starting in the 2026.1 release, and this change was not previously documented.

As referenced in SuiteAnswer 45391, the options.value parameter supports multiple data types (number, Date, string, array, boolean). However, the specification only defines the accepted types and does not guarantee that implicit type conversion will occur based on the target field.

Here’s a comparison of the behavior across releases:

• 2025.2: Implicit conversion (e.g., number to string) was observed, although this was not officially documented.
• 2026.1: The behavior now enforces strict type matching based on the field definition. For example, a field defined as NUMBER (such as refnumber) requires a numeric value or TEXT field requires string value

This updated behavior in 2026.1 aligns more closely with type-safe expectations, while the automatic conversion seen in 2025.2 appears to have been an undocumented implementation detail.

Hope this helps clarify the behavior you’re encountering.

Hi @Wishal44 ,

If you're using a custom billing schedule for this, then your only option will be to create an invoice for 0 manually. NetSuite won't calculate the first one due to the limitations on custom schedules.

I hope this helps!

Hi @Mariela S.

As of March 2026, the new NetSuite Connector for Outlook is finally officially available and can now be downloaded directly from the Microsoft Marketplace / AppSource

Availability & Rollout Details:

• Where to find it: You can search for "NetSuite Connector for Outlook" in the Microsoft AppSource/Marketplace.
• Regions: The initial rollout was slated for customers in the US, Canada, UK, Ireland, Australia, and New Zealand.
• Admin Approval: Because it requires accessing mailbox data, Enterprise users will likely need their Microsoft 365 IT administrator to approve and deploy the add-in for the organization before individual users can connect it to their NetSuite accounts.

Thanks a lot Angela! I will check this, and keep you updated!!

Hi @User_CN4QU

If you are using NetSuite OneWorld and your COP subsidiary rolls up to a parent subsidiary that uses USD as its base currency, you can easily view the standalone COP financials translated into USD:

1. Open your standard Profit and Loss report.
2. At the bottom of the screen, change the Subsidiary Context to the USD Parent Subsidiary. (This tells NetSuite to apply your period's Consolidated Average Exchange Rate to translate the amounts into USD).
3. Click Customize to open the Financial Report Builder.
4. Go to the Filters tab, select Subsidiary, and set it strictly to your COP Subsidiary.
5. Result: This will yield a P&L that contains only the data for your Colombian subsidiary, but fully translated into USD. (Note: To view COP and USD side-by-side, you would need to run the COP context in one tab and the USD context in another).

Hi User_CN4QU

Since the subsidiary’s base currency is COP, the Profit and Loss report for the subsidiary is generated in COP by default. Displaying amounts in USD depends on the specific scenario, as outlined below:

Scenario 1: Transaction currency is USD
If the transaction currency is USD, the Amount (Foreign Currency) column can be used in the Profit and Loss report. This will display the transaction amount in USD along with the USD currency symbol.

Scenario 2: Parent base currency is USD, subsidiary base currency is COP
When the head parent’s base currency is USD, select the subsidiary context as “Head Parent – Consolidated” and apply Subsidiary as a column filter. This will display the subsidiary-wise Profit and Loss in USD.

Scenario 3: Neither the transaction currency nor the base currency (subsidiary or head parent) is USD
In such cases, Multi-Book Accounting is typically implemented to support reporting in USD.

Hope this helps.

Hi @davidd039,

Apologies for the late revert on this one.

Kindly try and run this search if this will provide you with Sales Order with no waves.

1. Navigate to Lists > Search > Saved Searches > New > Transaction
2. Enter title as necessary
3. Under Criteria tab > Standard subtab, enter the following:

4. Under Criteria tab > Summary subtab, enter the following:

5. Under Results tab > Columns subtab, enter the following:

6. Under Available Filters tab, enter the following

7. Hit Save & Run

Hope this helps! Let us know if there's any concerns.

Regards,
Sho

Hi @Audrey G.

NetSuite has a system-generated, native Retained Earnings account (Account Type = Retained Earnings). In NetSuite's architecture, this specific system account is the hardcoded final destination for rolling over Net Income at year-end. You cannot substitute a custom Equity account to replace the native Retained Earnings account for the final close.

When you configured the Period End Journal Entry (PEJE) feature in the Subsidiary Settings Manager, the Equity accounts you selected were likely mapped to the Income Summary Profit Account and Income Summary Loss Account.

When the PEJE process runs with the "Create Income Summary Journals" preference enabled, NetSuite performs a two-step process:

1. Journal 1: Reduces all income and expense accounts to zero and posts the net income/loss to the custom Equity (Income Summary) account you selected.
2. Journal 2: Immediately moves that exact balance out of your selected Equity account and dumps it into the native NetSuite Retained Earnings account.

Your selected Equity account is only acting as an intermediate "clearing" account to satisfy statutory requirements in certain countries (like France or Germany) that require a two-step close.

How to Fix It

Because NetSuite forces the final balance into the native Retained Earnings account, the standard NetSuite best practice is to stop using a custom Equity account for this purpose.

Instead, you should repurpose the native Retained Earnings account so that it matches what your accounting team wants to see:

1. Navigate to Lists > Accounting > Accounts.
2. Find the system-generated Retained Earnings account and click Edit.
3. Change the Account Number and Name to perfectly match the custom Equity account your team originally wanted to use.
4. Move any historical balances (if applicable) out of your custom account and into the native account via a manual journal entry, and then mark your custom Equity account as Inactive.