Scenario
User noticed that some invoices do not display the Est. Extended Cost, even though the same items on other orders show this value consistently. The Est. Extended Cost represents the estimated total cost of an item on an invoice, typically calculated based on the item’s cost estimate type (e.g., Average Cost) and quantity.
The discrepancy arises because the calculation for Est. Extended Cost can occasionally get stuck in NetSuite’s backend. This prevents the value from updating or displaying properly on certain invoices, even when the item and configuration appear identical to those on invoices where it works correctly.
Solution
To resolve this issue and ensure the Est. Extended Cost is calculated and displayed on the affected invoices, you can force NetSuite to refresh the calculation by exposing and adjusting the Cost Estimate Type field. Follow these step-by-step instructions:
- Open an Affected Invoice: Navigate to one of the invoice records where the Est. Extended Cost is missing.
- Access Form Customization: Hover over the Customize hyperlink located in the upper right corner of the invoice page.
- Select Customize Form: From the dropdown menu, click Customize Form to edit the invoice form settings.
- Expose Cost Estimate Type: In the Sublists Fields tab, locate the Cost Estimate Type field and check the Show checkbox to make this column visible on the invoice form.
- Save the Form: Click Save to apply the changes. Optionally, rename the form (e.g., "Invoice with Cost Estimate") for clarity and future reference.
- Verify the Column: Return to the invoice record. Under the Items tab, confirm that the Cost Estimate Type column is now visible.
- Edit the Invoice: Click Edit to enter edit mode for the invoice.
- Retoggle Cost Estimate Type: Under the Items tab, change the Cost Estimate Type to a different option (e.g., switch from Average Cost to Custom) and click OK. Then, switch it back to the original setting (e.g., Average Cost).
- Save the Invoice: Click Save to update the invoice record.
After completing these steps, the Est. Extended Cost should now calculate and appear correctly on the invoice.
Additional Notes
- Repeat as Needed: You may need to apply this fix individually to each affected invoice.
- Check for Broader Issues: If this problem occurs frequently, it could indicate a deeper configuration or data issue in your NetSuite setup. Consider consulting with your NetSuite administrator or support team to investigate further and prevent recurrence.
This approach resolves the immediate issue by manually triggering the stuck calculation, ensuring consistency across your invoices.
-----
If you find this information useful, let us know by reacting or commenting on this post!
