Skip to main content
Brant
August 2, 2022
Solved

QB Point of Sale Financial exchange error

  • August 2, 2022
  • 1 reply
  • 0 views

Each time I run a financial exchange between POS v19 and QB Desktop Pro 2021 I keeping getting the following error message:

Status code: 3140; Status message: There is an invalid reference to QuickBooks deposit account "8000034E-
1305430999" in the ItemPayment. QuickBooks error message: To change the posting account, you must switch to single-user mode.;

 

I have no idea what deposit account "8000034E1305430999" is.  Does anyone know what the message means and how to correct it?


We are a new user of Quickbooks payments.

 

Thanks.

See file attached.

Best answer by MadelynC

I’ve got a solution for you to get rid of this error, @Brant.


The status code 3140 that says “There is an invalid reference to QuickBooks Account "###### - #########" in the item…” happens if the mapped item account in Point of Sale is incorrect, or the item account is inactive or deleted in QuickBooks financial.


Before you perform the instructions below, make sure to create a backup of your QuickBooks Point of Sale (POS)  file and QuickBooks Desktop Pro file. After, follow these steps to review your Preferences:

 

  1. Open your POS.
  2. From the File menu, select Preferences.
  3. Select Company.
  4. Under Financial, click Accounts.
  5. Check the Basic and Advanced tabs. Ensure the accounts are mapped correctly, then select Save. Please know that an account name in brackets ([ ]) indicates that the account isn’t mapped.
  6. Run financial exchange.


Then, check your item account. Here are the steps to do it:

 

  1. In QuickBooks Financial, select the Lists menu.
  2. Go to Chart of Accounts.
  3. Press Account at the bottom, then click Show Inactive Accounts.
  4. If it's inactive, it has an X mark beside its name. Select on the X mark or right-click the account, then select Make Account Active.
  5. Run another financial exchange.


On the other hand, if the account is deleted, you’ll want to create a new one in the program.


Also, you can reach out to our payments support team in case you want to verify this issue further. Check out this reference to connect with us easily: Contact Payments and learn support hours.


I’ll be here to help if you have any other questions or concerns besides the financial exchange error. Simply hit the Reply button below to add your comments. Always take care!

1 reply

MadelynCAnswer
August 2, 2022

I’ve got a solution for you to get rid of this error, @Brant.


The status code 3140 that says “There is an invalid reference to QuickBooks Account "###### - #########" in the item…” happens if the mapped item account in Point of Sale is incorrect, or the item account is inactive or deleted in QuickBooks financial.


Before you perform the instructions below, make sure to create a backup of your QuickBooks Point of Sale (POS)  file and QuickBooks Desktop Pro file. After, follow these steps to review your Preferences:

 

  1. Open your POS.
  2. From the File menu, select Preferences.
  3. Select Company.
  4. Under Financial, click Accounts.
  5. Check the Basic and Advanced tabs. Ensure the accounts are mapped correctly, then select Save. Please know that an account name in brackets ([ ]) indicates that the account isn’t mapped.
  6. Run financial exchange.


Then, check your item account. Here are the steps to do it:

 

  1. In QuickBooks Financial, select the Lists menu.
  2. Go to Chart of Accounts.
  3. Press Account at the bottom, then click Show Inactive Accounts.
  4. If it's inactive, it has an X mark beside its name. Select on the X mark or right-click the account, then select Make Account Active.
  5. Run another financial exchange.


On the other hand, if the account is deleted, you’ll want to create a new one in the program.


Also, you can reach out to our payments support team in case you want to verify this issue further. Check out this reference to connect with us easily: Contact Payments and learn support hours.


I’ll be here to help if you have any other questions or concerns besides the financial exchange error. Simply hit the Reply button below to add your comments. Always take care!

Brant
BrantAuthor
August 4, 2022

Before posting, I had already taken the steps you recommended.  So I spent over four hours on the phone with POS support and resolved the issue.  We run a "reboot" file in the directories of QB Desktop Pro and POS v19.  I have no idea what this did, but it seems to have resolved the issue.  Thanks.