Troubleshooting Your SCIS Installation

This section includes information about resolving common errors in SuiteCommerce InStore (SCIS) setup and configuration.

Note:

If you choose to uninstall the SuiteCommerce InStore SuiteApp, some records that were added to your NetSuite account on the first installation will remain in the system. If you choose to uninstall or remove the SuiteApp, and then install it again, you must select the option to replace the records during the latest installation process.

Error Message	Problem/Cause	Solution
Script Execution Usage Limit Exceeded	Searches for transaction record document numbers can exceed script execution usage limits.	Go to Setup > Company > Auto-Generated Numbers. Click Document Numbers. You can enter a prefix for Cash Sale, Estimate, Sales Order and Invoice. In SCIS a search can occur for any of these transactions. For example, enter the prefix, “CASHSALE” for cash sale transactions.
Internal error: Must identify a region associated with this site	The subsidiary associated with the logged–in employee is not marked as online.	Go to Commerce > Websites. Click the Setup subtab. At the bottom of the page, mark the appropriate subsidiary online.
There is an internal error	Items are not displayed in SCIS. GET request returns a 500 Internal Server Error.	Rebuild the Search Index. Go to Commerce > Websites. Click the Actions menu, and then select Rebuild Search Index.
Sales associate is not able to log in. After a managed SuiteApp update, the SCIS Clerk role may be removed from the employee record.	Go to Lists > Employees. Click Edit next to the employee record. Click the Access tab. Reset the role on the employee record.
An nlobjSearchColumns contains an invalid column join ID, or is not in proper syntax: custrecord_ns__pl_plip_value	The Product List SuiteApp is not updated on the account.	Go to Customization > SuiteBundler > Search & Install Bundles > List. Click the Action icon to update your version of the Product List SuiteApp.
The record type [CUSTOMRECORD_NS_POS_GATEWAY] is invalid. The Credit Card Payment couldn't be processed. Please check your credit card details provided and try again	The custom record referenced in the error has been deprecated.	Go to Customization > SuiteBundler > Search & Install Bundles > List. Click the Action icon to update your version of SCIS.
Invalid shippingtaxcode reference key -7 for shipaddress	Each time an item is added to the cart, the error is shown. This is because the –Not Taxable– tax code is inactive.	To resolve the error, review the following settings: Ensure the shipping items are assigned to the SCIS site. Go to Customization > Lists, records, & Forms > Record Types. Find SCIS Settings, and then click List in that row. Edit the SCIS Location record for that location. Select SCIS Shipping Methods. Set the –Not Taxable– tax code as active. Go to Setup > Accounting > Tax Codes. Mark the Show Inactives box. Clear the inactive box next to –Not Taxable–. Ensure that accounting periods have been set for the current fiscal year. Go to Setup > Accounting > Manage Accounting Periods. Set accounting periods for the current fiscal year.
Invalid account reference key 123 for subsidiary 1	The SCIS Store Safe Account used in the sales associate’s location does not have the subsidiary set correctly.	To resolve the error: Check the location on the employee record for the sales associate. Verify that the location on the employee record matches the location for the subsidiary named in the error (check the ID for the subsidiary, for example, id=1). Verify that the subsidiary on the account you use for the SCIS Store Safe Account is also the same. Note: SCIS Store Safe Account is set on the Location record. Go to Setup > Company > Locations. Make a note of the SCIS Store Safe account assigned to the location. Go to Setup > Accounts > Chart Of Accounts. Find the account you selected as the SCIS Store Safe Account. For example, this could be the Petty Cash account. Edit the account record and select the subsidiary.
Cannot read attributes of undefined	The roundItemId is missing from CustomConfiguration.js	If you installed SCIS prior to the 2016.1.0 release, you must also update the CustomConfiguration.js file to support currency rounding capabilities introduced in SCIS 2016.1.0. Search for ns_pos_rounditem in NetSuite, and then add `roundItemId: 0,` to the CustomConfiguration.js file, under the `voidItem` definition. Replace 0 with the ID for the item in your account. For more information, read Setting up Currency Rounding for SCIS.
Error: Please enter value(s) for: Account	This error can be displayed during an initial loan or end of day transaction entered in SCIS. The problem could be any of the following: Cash Drawer account is not set correctly in SCIS User Settings. SCIS Store Safe Account and SCIS Cash Drawer Difference Account are not set on the location record. The subsidiary setting on the SCIS Store Safe Account does not match the location.	Review the following settings: Go to Customization > Record Types > SCIS User Settings. Set the correct cash drawer account for the employee. Check the location record for the store. Verify that there is a value for SCIS Store Safe Account and SCIS Cash Drawer Difference. Check the Chart of Accounts to verify that the subsidiary on the account selected as the SCIS Store Safe Account and the SCIS Cash Drawer Difference hav the same subsidiary as the location.
Please enter a value for amount	This error occurs because the price of the item was not entered for the currency used in the order.	To resolve this error, go to Lists > Accounting > Items. Click Edit next to the item, and then enter prices for each currency on the Sales/Pricing subtab.
Invalid taxcode reference key 115 for subsidiary 6	This error occurs because the tax code for sales on the tax schedule was set incorrectly for the country where SCIS is being used.	To resolve the error: Setup > Accounting > Tax Codes. Click Edit next to the tax code associated with the region where the order is being entered in SCIS. In the Available On list, ensure that Sales Transactions or Both is selected. Click Save.
Insert transaction failure: No valid, open, tax period for date – 4/22/2016. Please visit setup > manage tax periods to set up a new tax period. Your payment couldn’t be processed. Please review the amount entered and the order details, and try again.	If this error occurs, it will be displayed instead of the receipt popup window after a payment is made on an order. The problem is that the tax reporting period does not exist.	To resolve the error, go to Setup > Accounting > Manage Tax Reporting periods. Set up tax reporting periods as needed.
An nlobjSearch Filter contains an invalid operator or is not in proper syntax: upccode	After the sales associate adds a line level discount, this error can appear in the Enter Access Code popup window.	Verify that the discount item has the location and subsidiary set properly. Both location and subsidiary must match the settings on the sales associate's employee record and the SCIS settings record.
An unexpected error occurred. Please go back and try again. invalid property id (CustomConfiguration.js#414)	This error can appear while performing any action in SCIS. It happens because of an error in the CustomConfiguration.js file.	To resolve the error, verify any changes made to the CustomConfiguration.js file following installation of the SCIS SuiteApp. Double-check any customizations.
Enter only numeric characters	This error appears in the Cash Payment popup window after adding an item to the order and clicking on a Cash Denomination. It typically happens in accounts that use multiple currencies. The problem may be related to the configuration of the currency record in NetSuite.	To resolve the error: Go to Lists > Accounting > Currencies. Click Edit next to the currency that displayed the error. Check the Override Format check box.
Invalid Number undefined	This error occurs when attempting to initiate a customer return from the customer profile page. The problem is that the saved search, SCIS Transactions Details was modified, removing the ID and some required fields.	Do not modify the SCIS Transactions Details saved search.
Invalid taxcode reference key undefined for subsidiary 13	This error typically occurs in accounts that use multiple currencies with SCIS. The CustomConfiguration.js file must contain an ID for the non taxable tax group record associated with each currency in which you transact. Note that you must create a zero percent (0.0%) tax group for each region. For more information, read Setting up Currency Rounding for SCIS.	To resolve the problem: Go to Commerce > Hosting > Website Hosting Files> Live Hosting Files > SSP Applications > NetSuite Inc. - POS > SuiteCommerce InStore. Click Edit next to CustomConfiguration.js. Add IDs for the tax groups you want to use for calculating tax on transactions where rounding was applied. (Replace 0 with the ID for the applicable tax groups in your account.) `, nonTaxableTaxCodes: { US: 0 , CA: 0 , AU: 0 , NZ: 0 , GB: 0 , SP: 0 , DE: 0 , FR: 0`
Couldn’t add items. The following items couldn’t be added. Item #: unknown error.	This error occurs because the nonTaxableTaxCode is set incorrectly in the CustomConfiguration.js file. There must be a zero percent (0.0%) tax group for the country associated with the order.
Invalid taxcode reference key undefined for subsidiary 6. Your payment couldn’t be processed. Please review the amount entered and the order details and try again.	This error may appear instead of the receipt popup window, after a payment is entered. There must be a zero percent (0.0%) tax group for the country associated with the order.
Configuration Error: Subsidiary on Employee and SCIS must match	The Subsidiary selected on the Employee must match the Subsidiary on the website record.	To resolve this error: Go to Lists > Employees. Click Edit next to the employee in question. Note which Subsidiary is selected on the Employee record. Go to Commerce > Websites Click Edit next to the SCIS website. Click the Setup subtab, and then scroll to the bottom of the page. Ensure that the same subsidiary is selected on the website and on the Employee record. If there are multiple subsidiaries, at least one must match.
Must identify a region associated with this site

Error Message

Problem/Cause

Solution

Script Execution Usage Limit Exceeded

Searches for transaction record document numbers can exceed script execution usage limits.

Go to Setup > Company > Auto-Generated Numbers. Click Document Numbers. You can enter a prefix for Cash Sale, Estimate, Sales Order and Invoice. In SCIS a search can occur for any of these transactions.

For example, enter the prefix, “CASHSALE” for cash sale transactions.

Internal error: Must identify a region associated with this site

The subsidiary associated with the logged–in employee is not marked as online.

Go to Commerce > Websites. Click the Setup subtab. At the bottom of the page, mark the appropriate subsidiary online.

There is an internal error

Items are not displayed in SCIS. GET request returns a 500 Internal Server Error.

Rebuild the Search Index. Go to Commerce > Websites. Click the Actions menu, and then select Rebuild Search Index.

Sales associate is not able to log in. After a managed SuiteApp update, the SCIS Clerk role may be removed from the employee record.

Go to Lists > Employees. Click Edit next to the employee record. Click the Access tab. Reset the role on the employee record.

An nlobjSearchColumns contains an invalid column join ID, or is not in proper syntax: custrecord_ns__pl_plip_value

The Product List SuiteApp is not updated on the account.

Go to Customization > SuiteBundler > Search & Install Bundles > List. Click the Action icon to update your version of the Product List SuiteApp.

The record type [CUSTOMRECORD_NS_POS_GATEWAY] is invalid.

The Credit Card Payment couldn't be processed. Please check your credit card details provided and try again

The custom record referenced in the error has been deprecated.

Go to Customization > SuiteBundler > Search & Install Bundles > List. Click the Action icon to update your version of SCIS.

Invalid shippingtaxcode reference key -7 for shipaddress

Each time an item is added to the cart, the error is shown. This is because the –Not Taxable– tax code is inactive.

To resolve the error, review the following settings:

Ensure the shipping items are assigned to the SCIS site.

Go to Customization > Lists, records, & Forms > Record Types. Find SCIS Settings, and then click List in that row. Edit the SCIS Location record for that location. Select SCIS Shipping Methods.
Set the –Not Taxable– tax code as active.

Go to Setup > Accounting > Tax Codes. Mark the Show Inactives box. Clear the inactive box next to –Not Taxable–.
Ensure that accounting periods have been set for the current fiscal year.

Go to Setup > Accounting > Manage Accounting Periods. Set accounting periods for the current fiscal year.

Invalid account reference key 123 for subsidiary 1

The SCIS Store Safe Account used in the sales associate’s location does not have the subsidiary set correctly.

To resolve the error:

Check the location on the employee record for the sales associate.
Verify that the location on the employee record matches the location for the subsidiary named in the error (check the ID for the subsidiary, for example, id=1).
Verify that the subsidiary on the account you use for the SCIS Store Safe Account is also the same.

Note:
SCIS Store Safe Account is set on the Location record.
1. Go to Setup > Company > Locations. Make a note of the SCIS Store Safe account assigned to the location.
2. Go to Setup > Accounts > Chart Of Accounts.
3. Find the account you selected as the SCIS Store Safe Account. For example, this could be the Petty Cash account.
4. Edit the account record and select the subsidiary.

Cannot read attributes of undefined

The roundItemId is missing from CustomConfiguration.js

If you installed SCIS prior to the 2016.1.0 release, you must also update the CustomConfiguration.js file to support currency rounding capabilities introduced in SCIS 2016.1.0. Search for ns_pos_rounditem in NetSuite, and then add

                    roundItemId: 0,

to the CustomConfiguration.js file, under the voidItem definition.

Replace 0 with the ID for the item in your account. For more information, read Setting up Currency Rounding for SCIS.

Error: Please enter value(s) for: Account

This error can be displayed during an initial loan or end of day transaction entered in SCIS. The problem could be any of the following:

Cash Drawer account is not set correctly in SCIS User Settings.
SCIS Store Safe Account and SCIS Cash Drawer Difference Account are not set on the location record.
The subsidiary setting on the SCIS Store Safe Account does not match the location.

Review the following settings:

Go to Customization > Record Types > SCIS User Settings. Set the correct cash drawer account for the employee.
Check the location record for the store. Verify that there is a value for SCIS Store Safe Account and SCIS Cash Drawer Difference.
Check the Chart of Accounts to verify that the subsidiary on the account selected as the SCIS Store Safe Account and the SCIS Cash Drawer Difference hav the same subsidiary as the location.

Please enter a value for amount

This error occurs because the price of the item was not entered for the currency used in the order.

To resolve this error, go to Lists > Accounting > Items. Click Edit next to the item, and then enter prices for each currency on the Sales/Pricing subtab.

Invalid taxcode reference key 115 for subsidiary 6

This error occurs because the tax code for sales on the tax schedule was set incorrectly for the country where SCIS is being used.

To resolve the error:

Setup > Accounting > Tax Codes.
Click Edit next to the tax code associated with the region where the order is being entered in SCIS.
In the Available On list, ensure that Sales Transactions or Both is selected.
Click Save.

Insert transaction failure: No valid, open, tax period for date – 4/22/2016. Please visit setup > manage tax periods to set up a new tax period.

Your payment couldn’t be processed. Please review the amount entered and the order details, and try again.

If this error occurs, it will be displayed instead of the receipt popup window after a payment is made on an order. The problem is that the tax reporting period does not exist.

To resolve the error, go to Setup > Accounting > Manage Tax Reporting periods. Set up tax reporting periods as needed.

An nlobjSearch Filter contains an invalid operator or is not in proper syntax: upccode

After the sales associate adds a line level discount, this error can appear in the Enter Access Code popup window.

Verify that the discount item has the location and subsidiary set properly. Both location and subsidiary must match the settings on the sales associate's employee record and the SCIS settings record.

An unexpected error occurred. Please go back and try again.

invalid property id (CustomConfiguration.js#414)

This error can appear while performing any action in SCIS. It happens because of an error in the CustomConfiguration.js file.

To resolve the error, verify any changes made to the CustomConfiguration.js file following installation of the SCIS SuiteApp. Double-check any customizations.

Enter only numeric characters

This error appears in the Cash Payment popup window after adding an item to the order and clicking on a Cash Denomination. It typically happens in accounts that use multiple currencies.

The problem may be related to the configuration of the currency record in NetSuite.

To resolve the error:

Go to Lists > Accounting > Currencies.
Click Edit next to the currency that displayed the error.
Check the Override Format check box.

Invalid Number undefined

This error occurs when attempting to initiate a customer return from the customer profile page.

The problem is that the saved search, SCIS Transactions Details was modified, removing the ID and some required fields.

Do not modify the SCIS Transactions Details saved search.

Invalid taxcode reference key undefined for subsidiary 13

This error typically occurs in accounts that use multiple currencies with SCIS.

The CustomConfiguration.js file must contain an ID for the non taxable tax group record associated with each currency in which you transact. Note that you must create a zero percent (0.0%) tax group for each region. For more information, read Setting up Currency Rounding for SCIS.

To resolve the problem:

Go to Commerce > Hosting > Website Hosting Files> Live Hosting Files > SSP Applications > NetSuite Inc. - POS > SuiteCommerce InStore.
Click Edit next to CustomConfiguration.js.

Add IDs for the tax groups you want to use for calculating tax on transactions where rounding was applied. (Replace 0 with the ID for the applicable tax groups in your account.)

                        ,   nonTaxableTaxCodes: {
    US: 0
,   CA: 0
,   AU: 0
,   NZ: 0
,   GB: 0
,   SP: 0
,   DE: 0
,   FR: 0

Couldn’t add items.

The following items couldn’t be added.

Item #: unknown error.

This error occurs because the nonTaxableTaxCode is set incorrectly in the CustomConfiguration.js file. There must be a zero percent (0.0%) tax group for the country associated with the order.

Invalid taxcode reference key undefined for subsidiary 6.

Your payment couldn’t be processed. Please review the amount entered and the order details and try again.

This error may appear instead of the receipt popup window, after a payment is entered. There must be a zero percent (0.0%) tax group for the country associated with the order.

Configuration Error: Subsidiary on Employee and SCIS must match

The Subsidiary selected on the Employee must match the Subsidiary on the website record.

To resolve this error:

Go to Lists > Employees.
Click Edit next to the employee in question.
Note which Subsidiary is selected on the Employee record.
Go to Commerce > Websites
Click Edit next to the SCIS website.
Click the Setup subtab, and then scroll to the bottom of the page. Ensure that the same subsidiary is selected on the website and on the Employee record. If there are multiple subsidiaries, at least one must match.

Must identify a region associated with this site

Related Topics