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:
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.
Solved! Go to Solution.
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:
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.
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.
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:
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.
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.
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.
Running the Exchange as part of the End Of Day function essentially makes the Financial Connection automatic. Love it.
Thanks for getting back to us, @lloving.
I’m glad to know that the information provided above helped you. It’s our priority to assist you with any concerns you may have.
If you have follow up questions about any other QuickBooks tasks, add them below. It’s our pleasure to answer them for you.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here