Invoice are not creating in Quickbooks.

  • kishore.k_84
    Participant
    8 years, 8 months ago #5378

    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?

    sid.g_87
    Participant
    7 years, 1 month ago #5652

    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)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.