-
NSC | Assembly Unbuild > Cost of Goods Sold (COGS)
Scenario User has an assembly unbuild transaction is being used to break down the assembly item "raw bacon" into its components: "cooked bacon" and "bacon grease." These components are subsequently used in the production of finished goods. The issue is that this assembly unbuild is posting a cost impact to the Cost of…
-
NSC | Item Creation > Error: The subsidiary restrictions on this record are incompatible...
Scenario When creating a new item in NetSuite and changing the income account, the user encounters the error: "The subsidiary restrictions on this record are incompatible with those defined for account." Solution To resolve the issue, follow these steps: Go to Lists > Accounting > Accounts. Search for and select Income…
-
NSC | Advanced Manufacturing Tablet > Not all components are available to be consumed
Scenario When attempting to issue a work order through the Advanced Manufacturing Tablet in NetSuite, users may notice that the component list is not available. This issue occurs due to a mismatch between the Routing Step in the Manufacturing Routing and the AM Routing Step in the AM Mfg Workbench Operation. For example:…
-
NSC | Location > Include in Supply Planning > Greyed out
Scenario User wants to uncheck the "INCLUDE IN SUPPLY PLANNING" checkbox for a specific location in NetSuite because you do not want the Material Requirements Planning (MRP) system to calculate supply for that location. However, the checkbox is disabled (greyed out), preventing you from unchecking it. This issue occurs…
-
NSC | Assembly Item > Inventory Status > Inaccurate Quantity
Scenario User has an assembly item that displays both positive and negative quantities under its inventory details, specifically across the "Good" and "Under Inspection" statuses. These quantities sum to zero, indicating an error in inventory tracking, likely caused by inaccurate or overlapping status assignments. The…
-
NSC | Bill of Materials Revision > CSV Import > Update Effective End Date
Scenario User needs to update the Effective End Date for multiple Bill of Materials (BOM) Revision records. Doing this manually for each record would be inefficient and time-consuming, especially if you’re managing a large number of revisions. Solution To update the Effective End Date of your BOM Revision records using…
-
NSC | Usage of the Transaction Line Field "Invoice Date" (ID: custcol_jp_inv_date)
Scenario The user seeks clarification regarding the custom transaction line field 'Invoice Date' (ID: custcol_jp_inv_date) installed via a bundle. While the description mentions 'Invoice Date for Credit Memo line item,' its precise functionality is ambiguous. They are interested in understanding how the date entered in…
-
NSC | Unable to Edit Entity on Intercompany Journal Entry
Scenario The user is experiencing an issue while editing an intercompany journal entry, specifically when trying to modify the entity name at the line level. This problem occurs in both the Sandbox and production environments. They seek assistance in identifying the cause of this and potential solutions. Solution If a…
-
NSC | Representing Subsidiary > Resolve Error: "A Representing Entity name must match.."
Scenario The user was previously able to generate representing subsidiaries without issues, but they are now encountering an error when attempting the same action. They would like to understand the reason for this error and seek guidance on how to resolve it. Solution This is usually encountered when a representing entity…
-
NSC | Is it possible to delete a Fixed Asset that is Depreciating?
Scenario: The user is attempting to delete an asset named "Laptop - Finance Dept", which has been depreciating for several periods. The Current Net Book Value is $500, and the asset has a status of Depreciating. The user is unable to delete the asset because it is active for depreciation. Solution: Before proceeding, make…
-
NSC | Filtering Sales Order Items to Display Assembly Items Only
Scenario: A user needs to limit the list of selectable items on a Sales Order to Assembly Items only. By default, the item list includes all item types, which may not be relevant for specific business workflows involving only assembly items. Solution: To achieve this, a custom item filter must be created using a Saved…
-
NSC | Import FAM Alternate Depreciation > Resolve Error: Field not Mapped / Empty
Scenario: The user is attempting to update an existing FAM Alternate Depreciation record via CSV Import. During the import process, However the system returns the following error message: Could not find matching record. Primary name field was not mapped or is empty. This error indicates that the system could not identify…
-
NSC | Vendor Payment with Withholding Tax > Error: "INVALID_KEY_OR_REF: Invalid account reference.."
Scenario User has set up Withholding Tax in their account, and it should calculate on Payment, but when they saved the Vendor Payment, they received an email with the error: Solution This error can be caused by an inactive account used in the transaction. To resolve the error: Navigate to Setup > Accounting > Chart of…
-
NSC | Account > Add/Change Subsidiary > Error: "The subsidiary restrictions on this record.."
Scenario When updating an account record to add new subsidiaries, the user encounters an error message: "The subsidiary restrictions on this record are incompatible with those defined for item: XX. Subsidiary access on this record must be a superset of those permitted by the item." They are seeking assistance in…
-
NSC | Planned Work Order Not Visible on Close Work Order Page
Scenario: A user is attempting to close a Planned Work Order but finds that it does not appear on the Close Work Order page. This leads to confusion about whether the work order is eligible for closure and why it might be missing from the expected list. Solution: Upon further investigation, it has been determined that the…
-
NSC | Resolve Error: "Account VAT on Sales on tax line is not valid.." When Creating an Invoice
Scenario The user has recently established a new subsidiary and assigned the necessary tax codes. However, they encounter an error when attempting to save an invoice for this subsidiary. The error message is: "Account VAT on Sales on tax line is not valid for transaction Subsidiary XX. Please check the validity of the…
-
NSC | Is It Possible to Temporarily Reactive an Inactive Subsidiary?
Scenario The user is inquiring about the possibility of temporarily reactivating an inactive subsidiary within the accounting system to facilitate the posting of a single manual journal entry adjustment. They want to understand the feasibility and steps required to accomplish this task. Solution Re-activating inactive…
-
NSC | Remove balances with No Customer from AR Aging Report
Scenario User would like to seek guidance on addressing an issue with their Accounts Receivable (AR) aging report. There seem to be balances listed under 'No Customer' in the report, and they want to know how to eliminate or remove these unidentified customer balances from the AR aging report. Solution User can customize…
-
NSC | Reconcile Account Statement > Resolve Incorrect Reconciled This Statement Balance
Scenario: Assume the User is reconciling the bank account "Corporate Checking" for the period ending April 30, 2025. When opening the Reconcile Account Statement page and entering April 30, 2025 as the Statement End Date, the User notices that the Reconcile This Statement field shows an inflated amount of $250,000, whereas…
-
NSC | Invoice > CSV Import > Resolve Error: Invalid item reference key xx
Scenario: The User attempts to import the following invoice record via CSV but receives an error: Error: Invalid item reference key Item001 Solution: This error typically indicates that one or more Item values included in the import file do not match the expected format or are referencing an Item that is either inactive or…
-
NSC | Create Invoice > Error on Tax Agency and Subsidiary
Scenario: The user is creating an invoice for Subsidiary ABC, and selects a Tax Code that uses Tax Agency California Tax Board. However, upon saving the invoice, the following error appears: No tax agency defined for subsidiary: subsidiary ABC is not linked to nexus California This error typically occurs when the selected…
-
NSC | Update Invoice in a Closed Period > G/L Impact Error
Scenario: The user is required to updates the following fields on an invoice with the following details and received an error message upon hitting save. Invoice Date: January 15, 2022 Posting Period: December 2021 Current Period Status: December 2021 is Closed Change Needed: Update a non-G/L impacting field such as a…
-
NSC | FAM > Resolving Error During Asset Disposal: Asset Current Cost
Scenario: The user wants to write off a fixed asset named "Obsolete Machinery" with no expected sale value. When attempting the disposal transaction at Fixed Assets > Transactions > Asset Disposal, the user receives the error message: USER_ERROR: The amounts in a journal entry must balance. Solution: This error occurs when…
-
NSC | FAM > Resolving Error During Asset Disposal: Classification
Scenario: When attempting to dispose of a fixed asset, the user encounters the error message below: USER_ERROR: Please enter value(s) for: Class / Department" This error occurs when the Class / Department field is set as a mandatory field on the Journal Entry form, but no value is entered during the disposal process. The…
-
NSC | FAM > Resolving Error During Asset Disposal: Date Format
Scenario: The user is importing a CSV file that contains dates formatted as DD-Mon-YYYY (Example 29-May-2025), but their NetSuite preferences are set to MM/DD/YYYY. The user then received the following error: DISPOSAL_USER_ERROR: DISPOSAL_DATE_ERROR: The disposal date format of XX/XX/XXXX is invalid This error occurs…
-
NSC | FAM > Resolving Error During Asset Disposal: Tax Field
Scenario: The user is disposing of a fixed asset through a sale transaction for a customer named "ABC Corporation." On the Asset Disposal page, the user has selected a Sales Tax Code of NY Sales Tax. However, when checking the customer's record under Lists > Relationships > Customers, the Tax Item field on the Tax…
-
NSC | FAM > Resolving Error During Asset Disposal: Currency field
Scenario: The Fixed Asset in USD is being disposed of, but the associated customer record is set to EUR. When attempting to dispose of the asset, the system will trigger the INVALID_FLD_VALUE error because the currency values do not match. The specific error received was: INVALID_FLD_VALUE: You have entered an Invalid…
-
NSC | FAM > Resolving Error During Asset Disposal: Project Field
Scenario: The user is disposing of a company asset such as a vehicle and selects Sale as the disposal method. During the disposal process, NetSuite attempts to automatically generate an invoice as part of the transaction. However, the invoice form in use includes the Project field as mandatory. Since the asset disposal…
-
NSC | Resolve Error When Generating Revenue Recognition Journal Entries
Scenario: During the month-end close process, the user attempted to generate Revenue Recognition Journal Entries for existing revenue arrangements. However, the process fails, and an error message is returned that prevents further progress. The specific error message encountered is: You cannot set Eliminate to True for…
-
NSC | Resolve Error When Recording Lease Interest
Scenario: The user is recording Lease Interest for a Lease record where the Lease Company is "ABC Leasing LLC" and the Currency on the Lease is "EUR (Euro)". However, when viewing the associated Vendor record for "ABC Leasing LLC", the only listed currencies are "USD" and "CAD". Since "EUR" is not listed under the…