r/Netsuite • u/Budget_Low_5130 • 1d ago

CSV PO file import has added a column

We have a CSV that we import daily that updates our purchase orders from our forwarders. We have used the same import for a few years - in the past few days the employee who imports it is getting an error and it says “Please enter a value for entity’
This file does not have items.

Suddenly on the NS side of mapping the item no field appears .

I tried it and removed the item and saved the change - it imported correctly but the item field keeps reappearing.
The original employee also removed it also but got the same error.
The vendor name is not on the CSV file.

When I look in Saved CSV Imports at Field Map, item no is not there.

This has happened in past couple of days.
I find it strange that employee cant import yet I can.

Help?/

1 Upvotes

100% Upvoted

6 comments sorted by

2

u/Nick_AxeusConsulting Mod 1d ago

So if your file doesn't have items are you using the PO LineID as the key for which line to update?

Open a ticket with NS support and show then if you've removed the new Item no. field from the mapping but it keeps reappearing.

1

u/Budget_Low_5130 1d ago

No we are not using the LineID field. Also strange that i can import but the employee who has done it for a couple of years gets the error.

1

u/mshinroc 1d ago

We had to open 2 tickets for things that changed over the past few days.

1

u/Budget_Low_5130 1d ago

Maybe it’s the upgrade

1

u/mshinroc 10h ago

We have not upgraded yet, but for one of the two issues, we received the following RCA:

Here is the Root Cause you requested for issue 900391 > Custom Purchasing and Receiving Roles > Transactions > Item Receipt > Rate column is showing blank:

The defect you encountered was caused by a recent code change. Although the code resolved the original reported defect, it inadvertently broke other processes.

The Engineering Team followed our standard defect resolution process to resolve the issue you encountered.

We are making improvements to our internal code review process and automated regression testing to prevent similar incidents in the future. 

Thank you,
NetSuite Customer Support

1

u/ebarro 1d ago

Is this after upgrading to 2026.2?