NetSuite allows users and integrations to override the Amount field on many transaction lines. Because of that, ExtendInsights can successfully upload changes while still leaving a line with an unintended (and potentially incorrect) Amount.
This commonly shows up as a yellow warning in the Reserved Status column (Column A) after upload, indicating the line total does not match the expected calculation.
Why This Happens
NetSuite behavior (platform constraint):
On many transaction line types, NetSuite allows Amount to be overridden.
If a SOAP request includes Amount, NetSuite may keep that value even when Quantity or Rate/Price changes.
ExtendInsights context:
ExtendInsights uploads exactly what your Excel template provides.
If your template includes Amount and you update other pricing fields without updating Amount, the upload can succeed but leave the line mathematically inconsistent.
How to Resolve the Issue
Use one of the options below based on your workflow.
Option A (recommended): Remove Amount from your template
Open the template in ExtendInsights.
Edit the template and remove the Amount field.
Reload/download the records again (so the table matches the updated template).
Make updates using Quantity and Rate/Price only.
Upload back to NetSuite.
Result: NetSuite calculates Amount automatically, reducing risk of mismatched totals.
Option B: Keep Amount, but always recalculate it
If you must keep Amount visible:
When changing Quantity or Rate/Price, also update Amount for the same rows.
Use an Excel calculation (example logic):
Amount = Quantity × Rate/Price
Upload back to NetSuite.
If you only fixed specific rows, upload using Selected rows only (if enabled) to avoid unintended changes elsewhere.
Implementation guidance:
Put the formula in the Amount column cells (row-level), not in Row 1.
Ensure the formula results are values you intend to upload (for some workflows, you may prefer copying and pasting values after calculating).
What to watch for after upload
Green internal ID indicates the row uploaded successfully.
A yellow message in Column A typically means NetSuite accepted the update but returned a warning (often due to Amount mismatch).
If you see a yellow warning about totals:
Re-check Quantity, Rate, and Amount on the affected rows
Correct Amount, then re-upload the affected rows (using “selected rows only” if enabled)
Need Help?
If you need assistance during go-live or rollout:
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat (bottom-right of the support site)
✉️ Email cloudextend-support@celigo.com
Include:
Record type (e.g., Vendor Bill, Invoice)
A screenshot of the affected Excel rows (including Quantity/Rate/Amount)
The warning text from Column A (Reserved Status), if shown