Invoice Line item

  • 14Views
  • Last Post 09 August 2020
0
votes
Shelby Wilson posted this 06 August 2020

Hi,

we want integration  QBO in to salesforce for that i ahve created package but how we can mapped lineitem on another tables?  i did't find any source lists for lineitem.

Order By: Standard | Newest | Votes
0
votes
Marc Rosenberg posted this 06 August 2020

Are you trying to push QBO Items to SFDC Products?

I'm working on a similar project, except I'm sync'ing SFDC to QBO.  I have a lot of experience doing this as I accomplished this using a different platform and I'm now testing Skyvia as an alternative because it has more connectors and is less expensive.  

Maybe we can help each other.  These integrations are tricky.  Good luck!

 

0
votes
Mariia Zaharova posted this 06 August 2020

Hello Shelby,

 

Please give us more details on your scenario, e.g. specify which source and target tables you are using, describe exact steps you are performing with comments and screenshots so that we are able to advise you on this.

 

Best regards,

Mariia

0
votes
Shelby Wilson posted this 08 August 2020

No we are not pusing QBO item to Salesforce products.

 

we are trying to synscronize QBO invoices on Salesforce customer object "Invoice" 

but  how we can also sync Invoice Line Item from QBo to SalesForce?

becuase of it's not found in Source Lists while I Mapping the Entity on Create Package screen.

   

0
votes
Mariia Zaharova posted this 08 August 2020

Hello Shelby,

 

All the QuickBooks tables that have the LineItem suffix in their name are read-only and they are not available in Import packages as a target or in Synchronization packages. These tables store the same information as the Lines field of the corresponding main tables.

To modify lines of an invoice, bill, etc. you need to provide values in JSON format for the Lines field of the corresponding main table - Invoice, Bill, etc.

Please refer to https://docs.skyvia.com/connectors/cloud-sources/quickbooks_connections.html

 

Best regards,

Mariia

0
votes
Shelby Wilson posted this 08 August 2020

Hi  but before few days ago it will their no it's not visible me  check below screen we have alrady used in one billLineItem same thing we are trying for invoice line so it's remove now? 

while i try to crate new package as per below screenshot now billLineItem also not comeing now.      

0
votes
Mariia Zaharova posted this 09 August 2020

 Hello Shelby,

 

Your QuickBooks connection "QBO_sandbox" is not working at the moment. Please refresh it by clicking "Log In with QuickBooks".

 

Please try again your scenario and let us know the results.

 

Best regards,

Mariia

Close