Mapping an Account for a Transaction
You will need to map an account for a transaction when syncing transactions with NetSuite Connector. If an invalid account is mapped to a transaction that is synced, you will receive the following error message: INVALID_KEY_OR_REF - Invalid Account Reference Key Error.
To change the account in your transaction record:
-
Open the transaction record.
-
For invoices, go to Transactions > Sales > Create Invoice > List.
-
For credit memos, go to Transactions > Customers > Issue Credit Memos > List.
-
For customer refunds, go to Transactions > Customers > Issue Customer Refund > List.
-
For refunding cash sales, go to Transactions > Customers > Refund Cash Sales > List.
-
For cash sales, go to Transactions > Sales > Enter Cash Sales > List.
-
For customer payment, go to Transactions > Customers > Accept Customer Payments > List.
-
-
Select a transaction and click Edit.
-
Change the account of the transaction record.
-
For invoices:
-
Go to the Accounting subtab.
-
Select an account in the Account dropdown.
-
-
For credit memos:
-
Go to the Accounting subtab.
-
Select an account in the Account dropdown.
-
-
For customer refunds, select an account in the A/R Account dropdown.
-
For refunding cash sales, select an account in the Account dropdown.
-
For cash sales:
-
Go to the Accounting subtab.
-
Under Account Information, select Account.
-
Select an account in the Account dropdown.
-
-
For customer payment:
-
Select Account under Primary Information.
-
Select an account in the Account dropdown.
-
-
-
Click Save.
The account that is used in the transactions that are causing this error might not be present. Changing the account in your transaction records should fix the problem. In the case the account is present but you still get an error, you need to check your mappings or that the account used in this transactions is the same as the data NetSuite Connector is syncing. If these are the same and correct you can try manually creating a transaction record with the same details. If the record is successfully saved, take note of the original transaction ID, the error generated, and the transaction ID of the manually-created transaction record and contact support.