Click Data Source database or cloud app and select one QuickBooks connection as source from the drop-down list.Select the Use new runtime checkbox to activate the Nested Objects option.Please note that if you omit this step, the package name will remain Untitled in the list of created packages In the open package editor, rename your package by clicking and editing the package name.Follow these simple steps to adjust general package settings: To successfully create and run a new package, you need to adjust general package settings and configure task editor settings. Creating Package for Importing into QuickBooks Read the QuickBooks topic to find out how to configure settings of the necessary cloud app and check the Connections topic to know how to create a connection following several simple steps. One connection will serve as source, another one - as target. Creating Connectionsįirst, you need to create connections in Skyvia, which you will use as source and target in your import package.Īs we are going to import Invoices and Customers between two different QuickBooks accounts, we create two connections to two QuickBooks accounts. Make sure you have selected the Use new runtime checkbox in your import package before adding a task. Please note that the Nested Objects functionality is available when the new data integration runtime is selected. To find out how to create an import package to import customers and invoices into QuickBooks Online and configure mapping settings of nested objects correctly, read our step-by-step instruction below. However, when you select the Nested Objects checkbox in your import package, the nested Line object is divided into separate fields, and it becomes possible to use Expression or Constant, then map necessary columns easily and import data with changes made. The main problem of importing the Invoce object is that its Line column is not represented as separate fields, it has an array data structure, and if during transfer of invoices from one QuickBooks company to another, you need to make changes to the quantity of goods for each invoice for example, you should specify it somehow inside json strings, which is quite inconvenient and problematic. If the Customer object is simple for import, the Invoice object is not so easy in mapping. In this tutorial, we will show how to import Customers and Invoices from one QuickBooks account to another one. Easy Importing Invoices and Customers Between QuickBooks Online Accounts
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |