Issue: TRANS_UNBALNCD","message":"Transaction was not in balance
Causes:
This occurs when Lightspeed applies taxes but NetSuite is not set up correctly to allow the Tax Total to be overwritten.
Taxes not set up correctly for one of the following:
Nexuses not created
Tax Schedules not updated
Tax Group/code not generated
Nexuses not listed under the Subsidiary
Customer is set to non-taxable
Items in NetSuite non-taxable, or their Tax schedule is not marking nexus as Taxable
Incorrect Lightspeed Location Mappings:
City, State, Zip not entered correctly - NetSuite cannot find right code
Resolutions:
Make sure that Customer is marked as taxable and customer does NOT have a tax item Customer Mapping for taxable = T (unless Customer is specifically set up otherwise)
Check Location Mappings Address used to find a Taxable Code/Group for correct City, State, Zip. May need to Update Payload to correct.
Make sure Items are taxable with Tax Schedule (Some clients may be mapping to Set Items non-Taxable per Schedules to Shopify item.) If Items in NetSuite are required to stay non-taxable, you can create a 'orderitems' parameter, with the line level checkbox istaxable = T
CHECK TAX SETUP TO CONFIRM THE FOLLOWING:
Nexus for Country and State is created
Nexus listed under Subsidiary Nexuses
Taxable Tax schedule Marked T or taxable tax code for the Country or State
Tax Codes/Groups Create or generated
US wise from Admin. Setup > Accounting > Use State Tax Tables
2
Issue: Code: INVALID_FLD_VALUE Details: You have entered an Invalid Field Value TRIPPMICHAEL 1913@GMAIL.COM for the following field: email
Resolution:
Update email of the Customer record in Lightspeed to a valid email.
Update the emails in the Order or Customer Payload in NetSuite Request.
Reprocess the Request that is in Error. This should clear the Error.
3
Issue: Error: Item not found with Vend internal id: 0266a95f-e55d-11ed-eb65-4526e5c3c2af
Resolution:
Check the item you referenced on the Order if it was inactivated from Vend.
Make sure the Item in Lightspeed was synced from NetSuite and NOT directly created in Lightspeed. This option is unsupported.
4
Issue: I made a saved search to show which Item prices have changed today and scheduled it to sync every 4 hours. However, it doesn't appear to be running per my schedule settings.
Resolution:
Check to see if the Price Sync script is set to Scheduled.
Is the NetSuite Item listed with the correct Subsidiary for the integration?
Does the Transaction Custom Form have a Search listed in the Sublist Items tab that prevents the item from being listed on the Transaction?
6
Issue: You can not initialize itemreceipt: invalid reference 3956105
Resolution:
Check if Items trying to be received from the Purchase Order have the correct Product ID from the Payload.
7
Issue: The transaction date you specified is not within the date range of your accounting period.
Causes:
The Accounting Period for the Transaction Date trying to be set is not open. Either someone already closed the Accounting Period in NetSuite for the record being created; or
The New Year Accounting Period is not open yet but NEW records are already trying to be created in that period.
Resolution:
Open the Accounting Period
Go to Setup > Accounting > Manage Accounting Periods
8
Issue: "code":"USER_ERROR","details":"Please specify a tax code and tax rate for this customer
Cause:
No Tax Account has been created for the State in Shipping; or
NetSuite cannot Set the Tax Item on the Order
Resolution:
Go to Setup > Accounting > Tax Control Accounts
Make sure there is a Tax account for the State Nexuses
This may need to be regenerated with override for Tax groups/codes
'Use State Tax Tables'
Check on Tax Setup per orders to make sure NetSuite can set the Tax Item as needed
The Tax Agency Vendor Record is not in the correct Subsidiary for the Site Subsidiary
No Address Validation on the Shopify Shipping Address
The ZIP code is not correct for the Order address
Resolutions:
Update the Primary and Sublist to only list the subsidiary needed. You may not use multiple subsidiaries in this case
Correct the Zip code and re-process
10
Issue: No mappings found for record type: xx
Cause:
The Lightspeed X-Series Parameters are inactive or not created.
Resolution:
Go to Setup > Lightspeed X-Series > Mappings & Parameters.
Create or activate your Lightspeed X-Series Parameters for the associated record type.
11
Issue: No Location Mapping. Please make sure that the NetSuite to Vend Outlet Locations are Mapped. From Setup > Vend > Location Mappings.
Cause:
For Purchase Orders, the Outlet ID from the payload was unable to find a Location mapped on the Location Mappings.
Resolution:
Go to Setup > Lightspeed X-Series > Locations Mappings.
Create or activate your Lightspeed X-Series Location Mappings.
12
Issue: Multiple settings defined for Store: <store>. Only one setting should be defined for each store.
Cause:
There are multiple Lightspeed X-Series Settings using the same store.
Resolution:
Go to Setup > Lightspeed X-Series > Settings.
Retain just one Setting that uses the specified store.
13
Issue: No setting defined for Store: <store>. Please add a domain_prefix in setting for this store.
Cause:
There are no Lightspeed X-Series Settings set up to use the store.
Resolution:
Go to Setup > Lightspeed X-Series > Settings.
Create an active setting for store specified.
14
Issue: Sync is not enabled for this account id. See Settings.
Cause:
The Setting(s) being used are not set up with the Account ID of your NetSuite Instance.
Resolution:
Go to Setup > Lightspeed X-Series > Settings.
Select the Settings you are working with.
Update the NetSuite Account IDs field and add the account ID you are using.
Click ‘Save.’
15
Issue: Line item level discount is being used, set discount item on settings.
Cause:
The Discount Item in the Lightspeed X-Series Settings is not set.
Resolution:
Go to Setup > Lightspeed X-Series > Settings.
Select the Settings you are working with.
Add a Discount Item to the Lightspeed X-Series Settings.
Click ‘Save.’
16
Issue: No settings found for the Location mapping match for location: <locationName>
Cause:
Location mapping does not have a Setting for the specified Location.
Resolution:
Go to Setup > Lightspeed X-Series > Locations Mappings.
Select the Location Mapping you are working with.
Input a setting in the Setting field.
Click ‘Save.’
17
Issue: Please assign value in Vend Setting field in In8 Vend Mappings Type record. Internal Id: id
Cause:
Location mapping does not have a Setting for the specified Location.
Resolution:
Go to Setup > Lightspeed X-Series > Mappings & Parameters.
Select the Mapping you are working with.
Input a setting in the Setting field.
Click ‘Save.’
18
Issue: Tax schedule not found on the item. You are using "USE TAX RATE FROM TAX SCHEDULE" feature and with this, tax schedule is mandatory on the item.
Cause:
‘TaxSchedule’ is not set on the Item.
Resolution:
Go to Lists > Accounting > Items.
Select the item you are working with.
Click the ‘Accounting’ tab.
Enter Tax Schedule for the Item.
19
Issue: Code: USER_ERROR - Details: Illegal ID. Please enter a name.
Causes:
The “Illegal ID” Error occurs when ‘Auto-Generated Numbers’ is not enabled and the Customer being updated has the same name or same Company name as another Customer.
In some cases, the Customer on the order may not have any name or company value to during Customer creation. This could result in duplicate Customer IDs when ‘Auto Generated Numbering’ is not enabled.
Resolution:
Our recommendation is to keep Auto-Generated Numbering enabled for all Customers. If this is disabled, an ‘UPDATE ALL’ command can be given when enabling. This updates Customer IDs to unique numbers, if necessary, so customers with the same individual or Company names are created/synced properly in NetSuite.
Confirm that all Customers created in Lightspeed have listed names, either First and Last Name or Company.
20
Issue: Code: INVALID_KEY_OR_REF Details: Invalid location reference key <location internal id> for subsidiary <subsidiary internal id of transaction>.
Cause:
The location trying to be set is not in the same subsidiary as the Transaction, per the Parameters setup in Subsidiary Mapping.
Resolution:
Make sure that the Location Mappings being used are in the Same Subsidiary that the Site is set up for on all Transaction Type Mappings in Configurations.
Issue: Error: Could not find item with the Vend internal id : <Lightspeed internal id>
Cause:
Item was created in Lightspeed Direct, outside of integration support
Item in NetSuite with the Lightspeed ID under the In8sync > Lightspeed Ids field was deleted in NetSuite, but not in Lightspeed
Old Lightspeed Item was deleted and new NetSuite item has new Lightspeed ID
Resolution:
Retrieve the Lightspeed ID from the URL “UUID” and make sure that ID is displayed on the correct NetSuite item
24
Issue: Error: Item <item> : using Inventory Status, has insufficient QTY available to be used on the order
Cause:
Inventory Status is enabled and Quantity Available per the Location on the Order is not sufficiently available to create the Order
Resolution:
Adjust the Inventory in NetSuite to make sure the correct QTY Available is listed per the Location for the Orders to be created
25
Issue: Code: USER_ERROR Details: Total contribution for partners is 0.0%. It must be 100%. Please modify contributions.
Cause:
This Error occurs if the Original Cash Sale Setting (under Relationships > Partner listing) is set to contribute less than 100%
Resolution:
Update the Original Cash Sale to 100% for Partner
26
Issue: Code: EXCEEDED_MAX_FIELD_LENGTH Details: The field giftcertnumber contained more than the maximum number ( 9 ) of characters allowed.
Cause:
When Gift Card Code Setting is ‘Enter on Order,’ only nine (9) characters are allowed. Max is 22 characters in NetSuite.
Resolution:
Go to Setup > Accounting Preferences > Item/Transactions Change the Setting to ‘System Generated.’
27
Issue: Error: Code: USER_ERROR Details: Please specify a tax code and tax rate for this customer.
Causes:
Default Non-Taxable is not active
Tax Codes are not set up
Location Mappings do not have the Address adequately filled out for integration to find Tax Code
Resolution:
Map No Tax to ‘non-taxable’ that is active for the account
Make sure the Tax Codes are properly generated per the Source Location Address
Make sure that the Location Mappings are fully configured with address of POS location
28
Issue: Code: USER_ERROR Details: Could not calculate cost for the selected Realtime rate. Missing/Illegal ShipTo/Address/StateProvinceCode
Cause:
Customer Record may be listing a ‘Real Time’ Rate Shipping Method in error
Resolution:
Remove the Default Shipping Method on Customer under Preferences
29
Issue: Code: USER_ERROR Details: Items on this line have been fulfilled. To delete this line, you must first delete the corresponding line(s) in the associated transaction(s).
Cause:
The Accounting Period has not yet been opened for the New Year
Resolution:
Open the Accounting period for current Year
30
Issue: Code: VALID_PRD_REQD Details: Insert Transaction Failure: No valid, open, tax period for date - 17/01/2023. Please visit Setup > Manage Tax Periods to set up a new tax period.
Cause:
The Tax Period has not yet been opened for the New Year
Resolution:
Open the Tax period for current Year
31
Issue: Lightspeed (X) Transaction Payments UE | Error: Site Prefix: [site domain| Lightspeed X returned an error for this request: Can not create sale for SKU: null
Cause:
NetSuite to LSX On account Payment Sync back to On Account Order, with Customer currently set to NO for Account Limit
Total On Account Sales Amounts are greater than the Account Limit Amount
Resolution:
Make sure the Customer on the On Account order allows for On account limit, cannot be no
Make sure the total on Account Sales amount is Less than the Account Limit
JavaScript errors detected
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.
