Skip to main content
L
lloving
December 13, 2022
Solved

QB POS Financial Exchange error 3140

  • December 13, 2022
  • 1 reply
  • 0 views

I get the following error when Running Financial Exchange > Update QuickBooks Desktop in QBPOS.

 

"Status Code: 3140. Status Message: There is an invalid reference to QuickBooks AR Account "800000D0-1340291665" in the ReceivedPayment. QuickBooks error message: The account for this transaction must be of type Accounts Receivable"

 

I have done the following:

 

  1. In QBPOS.
  1. From the File menu, select Preferences.
  2. Select Company.
  3. Under Financial, click Accounts.
  4. 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.
  5. Run financial exchange

 

The accounts linked in the Advanced tab of Company>Financial>Accounts>Advanced tab are Accounts Receivable type. That said there are several (5) GL accounts listed as type Accounts Receivable.

 

Any advice would be greatly appreciated.

Best answer by JamaicaA

I appreciate you initiating to review your Preferences, @lloving.

 

I can see how important it is to your business to be able to run Financial Exchange report. I’ll provide further troubleshooting steps to help fix the errors you encountered.

 

The Status code 3140: There is an invalid reference to QuickBooks AR Account "###### - #########" happens if accounts are not mapped properly in Point of Sale. The error you received specifies the incorrect setting. Therefore, you’ll need to make sure that you’re A/R account is mapped correctly.

 

Since you’ve already gone through your Preferences, it’s possible that you’re experiencing data integrity issue. To fix this, let’s start with verifying and rebuilding your data. This process scans your company files for errors or data damage.

 

Here’s how:

 

  1. Go to the File then Utilities. Select Verify Data.
  2. Wait for it to load.
  3. Click File again, Utilities, then Rebuild Data.
  4. Press OK when you get the message "Rebuild has completed".

 

For other damage troubleshooting steps for Windows, feel free to check out this article: Verify and Rebuild Data in QuickBooks Desktop.

 

If you get the same result after running those troubleshooting steps, I suggest proceeding to the Solution 2: Repair your company file using QuickBooks File Doctor on this article: Fix data damage on your QuickBooks Desktop company file.

 

If you still get the same result after performing these processes, you can reach out to our payments support team for further assistance regarding this issue. Check out this reference to connect with us easily: Contact Payments and learn support hours.

 

If there's anything else that I can help you with aside from financial exchange error, please hit the Reply button below. I'll be here to lend a hand. Stay safe.

1 reply

J
JamaicaAAnswer
December 13, 2022

I appreciate you initiating to review your Preferences, @lloving.

 

I can see how important it is to your business to be able to run Financial Exchange report. I’ll provide further troubleshooting steps to help fix the errors you encountered.

 

The Status code 3140: There is an invalid reference to QuickBooks AR Account "###### - #########" happens if accounts are not mapped properly in Point of Sale. The error you received specifies the incorrect setting. Therefore, you’ll need to make sure that you’re A/R account is mapped correctly.

 

Since you’ve already gone through your Preferences, it’s possible that you’re experiencing data integrity issue. To fix this, let’s start with verifying and rebuilding your data. This process scans your company files for errors or data damage.

 

Here’s how:

 

  1. Go to the File then Utilities. Select Verify Data.
  2. Wait for it to load.
  3. Click File again, Utilities, then Rebuild Data.
  4. Press OK when you get the message "Rebuild has completed".

 

For other damage troubleshooting steps for Windows, feel free to check out this article: Verify and Rebuild Data in QuickBooks Desktop.

 

If you get the same result after running those troubleshooting steps, I suggest proceeding to the Solution 2: Repair your company file using QuickBooks File Doctor on this article: Fix data damage on your QuickBooks Desktop company file.

 

If you still get the same result after performing these processes, you can reach out to our payments support team for further assistance regarding this issue. Check out this reference to connect with us easily: Contact Payments and learn support hours.

 

If there's anything else that I can help you with aside from financial exchange error, please hit the Reply button below. I'll be here to lend a hand. Stay safe.

L
llovingAuthor
December 15, 2022

I rebuilt QBDT data as you said. Verified the GL account types were correct. Also updated QBDT. 

Re-ran Connection to QBDT and all progress bars were green. 

Success, thank you for your help. 

MaryLandT
MaryLandT
December 15, 2022

I'm happy to hear that rebuilding the data fixed the issue and you're now able to run the Financial Exchange with no error, lloving.

 

We can recommend this solution to other customers who are also getting the error.

 

I'd like to add up some information about running the financial exchange. Do you know that there are two ways to perform this process? 

 

You can do the As part of End of Day procedure or Manual exchange. 

 

Don't forget to create a new post if you have other QuickBooks concerns. We're always open to helping you.

Terms & ConditionsAccessibility statement