Best Of

Hi , You can use internal ID of customer to make sure it's the exact entity. NetSuite is sensitive with spacing and spelling so it should be exactly the same when using Names.

Hello User_VCOB,

In addition to Dext3r's request for the mapping details, please include a screen print of the Import Options page.

To add to Dext3r's question regarding the 'invalid entity reference key', see the attached screenshot for defining the Reference Type (Names, Internal ID, External ID).

NetSuite should not, and does not, allow Invoice creation with a negative total. This is enforced via the UI, CSV, and other contexts.

Sounds like it's just not able to match the entity/customer from your CSV to one stored in your records.

It would be best if you can share the file you're trying to upload, or at least some of the data if it's sensitive.
And also your mapping stage, including weather you're trying to match entity by name, internal or external ID.

Hi @Jet Zhang

It sounds like you're trying to source the GL Impact of the Invoices being paid? Your search is filtered to the main line, so you won't get any of the data related to the invoices lines in Your search.

Change main line to false, and you might be able to see the GL Impact for the lines.

Good Luck!

@Judith Culanding-Oracle,

As I mentioned, we're already in the middle of implementing EBP and have created a custom file format so I don't know why you're telling me to purchase Electronic Bank Payments license. We can access everything we need except for what I said above. I'll go ahead and submit a case to Netsuite support.

Thank you

Hello,

You may also check the Records Catalog Overview SuiteAnswer Article to find information about the record types and fields available for specific NetSuite channels. This dynamic NetSuite model reflects the customizations and features enabled or disabled in your account.

Thank you!

NetSuite Users — I need your help!

There’s an open enhancement request that would fix a long‑standing issue with Flat Rate Promotions.

🆔 Enhancement 860915

Title: Flat Rate Promotions should not be applied to Free Items

Status: Open – Accepting Votes

Right now, if a promo is set up as a Flat Rate discount, NetSuite still applies that discount to items that are intentionally added to the order at $0.00. This creates inaccurate discounts, messy reporting, and prevents businesses from giving free items without unintended markdowns.

This enhancement would allow (or default) Flat Rate Promotions to exclude free items, which is exactly how most businesses expect promotions to behave.

If this would help your team or your clients, please take a moment to vote for Enhancement #860915 in SuiteIdeas. Every vote helps push this forward.

Let’s get NetSuite to fix this one!!!

Hi @mv_gibson . It looks like Oracle took down the article. I'm not sure it does any good to post what it said here, but you can find the link still on this page: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_0714082142.html#bridgehead_0804033316

Note that the link from that page is the same, so is also invalid (maybe will be valid again if Copilot Studio decides to support PKCE).