Pervasive DataSolutions Logo

Amount on Quote/Estimate is not synching from/to QB / CRM

Last post 01-20-2010 4:57 PM by mgreendyk. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 01-19-2010 9:17 PM

    Amount on Quote/Estimate is not synching from/to QB / CRM

    Answer

    Hello,

    I created a Quote in QB and it synched to CRM but with $0.00 as the dollar amount.  I then changed the $ amount in CRM and synched.  Nothing changed in QB.

    I'd like to attach screen prints of the items and my settings in DataSync to this post but can't seem to figure out how to do this!

    I am running the trial version and testing to see if I can recommend to a prospective client!!

    Thanks for your help!

    ~Maria

     

  • 01-20-2010 8:33 AM In reply to

    Re: Amount on Quote/Estimate is not synching from/to QB / CRM

    Answer

    When you mentioned you changed the amount, where you doing this in the amount field or by adding line items to the quote?

  • 01-20-2010 2:44 PM In reply to

    Re: Amount on Quote/Estimate is not synching from/to QB / CRM

    Answer

    I changed the dollar amount of the one line item of the quote.

  • 01-20-2010 3:39 PM In reply to

    Re: Amount on Quote/Estimate is not synching from/to QB / CRM

    Answer

    So the sync doesnt actually look at the line item amount when syncing between the two systems.  It uses what is stored within the QuickBooks inventory list as the amount.

    For instance:

    Widget 10$ ea listed as an Non-Inventory Item within QuickBooks.

    If this is applied to an invoice within QuickBooks and synced over to MSCRM all that is transmitted is "Widget x10".  The amount is stored within the price book of CRM.  So when the line item appears within an Invoice in MSCRM it shows up as Widget x10 for 100 dollars, because it looks up the amount from the price book.  CRM allows for overwritting of the price book value with a custom amount at the time of creation (or during an edit), but the software doesnt.  If you were to change the line item amount to 4$ and thus the amount of the invoce to 40$ and resync the record, QuickBooks would still show as 100$ since its using the amount from the Inventory list.

    So what I am assuming here is that the product you are testing with has a value of 0$ within QuickBooks and when you synced the product to CRM it came accross as 0$.  Then you added this product to an invoice and then chained the line item amount to somthing greater than 0$.  But when you sync back its going to still use the 0$ amount stored within the inventory list.

    Does that make sense?

  • 01-20-2010 4:57 PM In reply to

    Re: Amount on Quote/Estimate is not synching from/to QB / CRM

    Answer

    Yes.  What you describe is what is happening to me.

    So, are you saying that if I provide 'flexible' pricing with no standard price for my services, then this synchronization utility will not work for me?

    Thanks!

    ~Maria

Page 1 of 1 (5 items)

Copyright © 2009 Pervasive Software, Inc. All Rights Reserved. All Pervasive brand and product names are trademarks or registered trademarks of Pervasive Software Inc. in the United States and other countries. All other marks are the property of their respective owners. Your transaction secured by high-grade AES-256 encryption.