Cannot Find Correct Format for QuickBooks Deposit Line

  • 19Views
  • Last Post 02 February 2018
0
votes
Allison Harden posted this 01 February 2018

I'm trying to sync MS CRM deposits with quickbook deposits. The quickbooks deposits pulls up a field called "Line" with a DT-NTEXT type. I've looked at both the quickbooks online instance & the quickbooks api and the line "field" is actually a subfield that looks like this: 

"Line": [

      {

        "Id": "1",

        "LineNum": 1,

        "Amount": 20.00,

        "DetailType": "DepositLineDetail",

        "DepositLineDetail": {

          "AccountRef": {

            "value": "87",

            "name": "Unapplied Cash Payment Income"

          }

        }

      }

    ]

How do I correctly map this to fields in MS CRM? What format should I use so that quickbooks accepts the mapping? 

 

I've uploaded my run history (with errors) for clarification.

Attached Files

0
votes
Mariia Zaharova posted this 02 February 2018

Some QuickBooks tables store complex structured data. These are the following tables: Invoice, Estimate, Bill, BillPayment, CreditMemo, Deposit, JournalEntry, Payment, Purchase, PurchaseOrder, RefundReceipt, SalesReceipt, VendorCredit. Skyvia represent this information in such tables as a JSON field Lines. For more information please refer to:

https://skyvia.com/resources/docs/index.html?quickbooks_connections.htm (QuickBooks-Specific Features and Limitations)

For example, here is an example of the Lines field value in JSON format:

[
  {
    "Id": "1",
    "LineNum": 1.0,
    "Description": "Weekly Gardening Service",
    "Amount": 140.0,
    "DetailType": "SalesItemLineDetail",
    "SalesItemLineDetail_ItemRefId": "6",
    "SalesItemLineDetail_ItemRefName": "Gardening",
    "SalesItemLineDetail_UnitPrice": 35.0,
    "SalesItemLineDetail_Qty": 4.0,
    "SalesItemLineDetail_TaxCodeRefId": "NON"
  },
  {
    "Id": "2",
    "LineNum": 2.0,
    "Description": "Pest Control Services",
    "Amount": 35.0,
    "DetailType": "SalesItemLineDetail",
    "SalesItemLineDetail_ItemRefId": "10",
    "SalesItemLineDetail_ItemRefName": "Pest Control",
    "SalesItemLineDetail_UnitPrice": 35.0,
    "SalesItemLineDetail_Qty": 1.0,
    "SalesItemLineDetail_TaxCodeRefId": "NON"
  }
] 

 

Thus, you can use some custom field in Dynamics CRM that contains data in this JSON format and then use Column mapping for these fields, or use Constant mapping.

Please tell us if this infomation helps.

Close