2 posts / 0 new
Last post
Invoice are not creating in Quickbooks.
I’m trying to create an Invoice in QuickBooks using a Salesforce Opportunity by attaching ‘n’ number of line items to that Opportunity. When I run the sync, I’m getting the following error message in the “QB Error” field on Opportunity page layout in Salesforce. Error : ERROR:(3185) - There is an invalid reference to QuickBooks Item "l" in the Invoice line. QuickBooks error message: Invalid argument. The specified record does not exist in the list. What I notice is that each error line corresponding to the above one shows that first letter of the each line item that is attached. Why is it just considering the first letter and not the complete line item name?
You voted 1. Total votes: 2017

When you are using LEFT function in the mappings, then compulsory need to specify the number of characters to be consider from left. That would resolve your issue.
For example, find the mapping below.
Mapping:
InvoiceAddRq/InvoiceAdd/InvoiceLineAdd/ItemRef/FullName =LEFT(VALUE("PricebookEntry/Product2/Name"),31)

You voted 2. Total votes: 1907