{"id":1020,"date":"2021-05-01T11:09:00","date_gmt":"2021-05-01T15:09:00","guid":{"rendered":"https:\/\/www.letsyncsolution.com\/?post_type=docs&#038;p=1020"},"modified":"2022-04-08T13:50:50","modified_gmt":"2022-04-08T17:50:50","slug":"billpaymentcreditcard","status":"publish","type":"docs","link":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/","title":{"rendered":"BillPaymentCreditCard"},"content":{"rendered":"\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>FIELD NAME<\/strong><\/td><td><strong>FIELD NAME<\/strong> (old)<\/td><td><strong>QUERYABLE<\/strong><\/td><td><strong>UPDATEABLE<\/strong><\/td><td><strong>REQUIRED<\/strong><br><strong>ON<\/strong> <strong>UPDATE<\/strong><\/td><td><strong>INSERTABLE<\/strong><\/td><td><strong>REQUIRED<br>ON INSERT<\/strong><\/td><\/tr><tr><td>TxnID<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>TimeCreated<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>TimeModified<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>EditSequence<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>TxnNumber<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>PayeeEntityRef_ListID<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td>true<\/td><\/tr><tr><td>PayeeEntityRef_FullName<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td>true<\/td><\/tr><tr><td>APAccountRef_ListID<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td><em>optional<\/em><\/td><\/tr><tr><td>APAccountRef_FullName<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td><em>optional<\/em><\/td><\/tr><tr><td>TxnDate<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td><em>optional<\/em><\/td><td><em>optional<\/em><\/td><\/tr><tr><td>CreditCardAccountRef_ListID<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td><em>optional<\/em><\/td><td><em>optional<\/em><\/td><\/tr><tr><td>CreditCardAccountRef_FullName<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td><em>optional<\/em><\/td><td><em>optional<\/em><\/td><\/tr><tr><td>Amount<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>CurrencyRef_ListID<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>CurrencyRef_FullName<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>ExchangeRate<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td><em>optional<\/em><\/td><\/tr><tr><td>AmountInHomeCurrency<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>false<\/td><td>false<\/td><\/tr><tr><td>RefNumber<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td><em>optional<\/em><\/td><\/tr><tr><td>Memo<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td><em>optional<\/em><\/td><\/tr><tr><td>ExternalGUID<\/td><td><\/td><td>true<\/td><td>false<\/td><td>false<\/td><td>true<\/td><td><em>optional<\/em><\/td><\/tr><tr><td>UserData<\/td><td>user field<\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><\/tr><tr><td>Operation<\/td><td>add,refresh,delete<\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul><li><strong>AppliedToTxnRet<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Paying a bill using<\/strong> <strong>BillPaymentCreditCard:<\/strong><\/p>\n\n\n\n<p>I am using the Sample Rock Castle Construction company sample file.<\/p>\n\n\n\n<p><strong>CreditCardCharge<\/strong><\/p>\n\n\n\n<p>TxnID = 123456<br>AccountRef_FullName = QuickBooks Credit Card<br>PayeeEntityRef_FullName = Thomas Kitchen &amp; Bath (vendor)<br>RefNumber = 8059 (ref no of the bill)<br>Operation = add<\/p>\n\n\n\n<p><strong>ExpenseLineRet<\/strong><\/p>\n\n\n\n<p>AccountRef_FullName = Accounts Payable<br>Amount = 585.00<br>CustomerRef_FullName = Thomas Kitchen &amp; Bath (CustomerRef must refer to a vendor (not to a customer))<br>PARENT_IDKEY = 123456<\/p>\n\n\n\n<p><strong>Go to LetSync Desktop and run Update and Refresh on CreditCardCharge<\/strong><\/p>\n\n\n\n<p><strong>BillPaymentCreditCard<\/strong><\/p>\n\n\n\n<p>TxnID = 123456<br>PayeeEntityRef_FullName = Thomas Kitchen &amp; Bath (vendor)<br>APAccountRef_FullName = Accounts Payable<br>CreditCardAccountRef_FullName = QuickBooks Credit Card<br>RefNumber = 8059 (ref no of the bill)<br>Operation = add<\/p>\n\n\n\n<p><strong>AppliedToTxnRet<\/strong><\/p>\n\n\n\n<p>TxnID = 5C90-1197713660 (bill original TxnID from QuickBooks)<br>Amount = 585.00<br>PARENT_IDKEY = 123456<\/p>\n\n\n\n<p><strong>SetCredit<\/strong><\/p>\n\n\n\n<p>CreditTxnID = 28CC0-1702698121 (creditcardcharge original TxnID from QuickBooks)<br>AppliedAmount = 585.00<br>Override = true<br>PARENT_IDKEY =5C90-1197713660 (TxnID that was put on the AppliedToTxnRet table)<\/p>\n\n\n\n<p><strong>Go to LetSync Desktop and run Update and Refresh on BillPaymentCreditCard<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>FIELD NAME FIELD NAME (old) QUERYABLE UPDATEABLE REQUIREDON UPDATE INSERTABLE REQUIREDON INSERT TxnID true false false false false TimeCreated true false false false false TimeModified true false false false false EditSequence true false false false false TxnNumber true false false false false PayeeEntityRef_ListID true false false true true PayeeEntityRef_FullName true false false true true APAccountRef_ListID &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/\"> <span class=\"screen-reader-text\">BillPaymentCreditCard<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"doc_category":[40],"doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>BillPaymentCreditCard | LetSync<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BillPaymentCreditCard | LetSync\" \/>\n<meta property=\"og:description\" content=\"FIELD NAME FIELD NAME (old) QUERYABLE UPDATEABLE REQUIREDON UPDATE INSERTABLE REQUIREDON INSERT TxnID true false false false false TimeCreated true false false false false TimeModified true false false false false EditSequence true false false false false TxnNumber true false false false false PayeeEntityRef_ListID true false false true true PayeeEntityRef_FullName true false false true true APAccountRef_ListID &hellip; BillPaymentCreditCard Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/\" \/>\n<meta property=\"og:site_name\" content=\"LetSync\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-08T17:50:50+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/\",\"url\":\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/\",\"name\":\"BillPaymentCreditCard | LetSync\",\"isPartOf\":{\"@id\":\"https:\/\/www.letsyncsolution.com\/#website\"},\"datePublished\":\"2021-05-01T15:09:00+00:00\",\"dateModified\":\"2022-04-08T17:50:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.letsyncsolution.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\/\/www.letsyncsolution.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BillPaymentCreditCard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.letsyncsolution.com\/#website\",\"url\":\"https:\/\/www.letsyncsolution.com\/\",\"name\":\"LetSync\",\"description\":\"QuickBooks Import &amp; Export data | QuickBooks API Integration\",\"publisher\":{\"@id\":\"https:\/\/www.letsyncsolution.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.letsyncsolution.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.letsyncsolution.com\/#organization\",\"name\":\"LetSync\",\"url\":\"https:\/\/www.letsyncsolution.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.letsyncsolution.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.letsyncsolution.com\/wp-content\/uploads\/2022\/03\/icon-image.png\",\"contentUrl\":\"https:\/\/www.letsyncsolution.com\/wp-content\/uploads\/2022\/03\/icon-image.png\",\"width\":32,\"height\":32,\"caption\":\"LetSync\"},\"image\":{\"@id\":\"https:\/\/www.letsyncsolution.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/yudel-rosales-echemendia-a0045a103\/recent-activity\/shares\/\",\"https:\/\/www.youtube.com\/watch?v=467ExiD7GTo\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BillPaymentCreditCard | LetSync","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/","og_locale":"en_US","og_type":"article","og_title":"BillPaymentCreditCard | LetSync","og_description":"FIELD NAME FIELD NAME (old) QUERYABLE UPDATEABLE REQUIREDON UPDATE INSERTABLE REQUIREDON INSERT TxnID true false false false false TimeCreated true false false false false TimeModified true false false false false EditSequence true false false false false TxnNumber true false false false false PayeeEntityRef_ListID true false false true true PayeeEntityRef_FullName true false false true true APAccountRef_ListID &hellip; BillPaymentCreditCard Read More &raquo;","og_url":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/","og_site_name":"LetSync","article_modified_time":"2022-04-08T17:50:50+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/","url":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/","name":"BillPaymentCreditCard | LetSync","isPartOf":{"@id":"https:\/\/www.letsyncsolution.com\/#website"},"datePublished":"2021-05-01T15:09:00+00:00","dateModified":"2022-04-08T17:50:50+00:00","breadcrumb":{"@id":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.letsyncsolution.com\/docs\/billpaymentcreditcard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.letsyncsolution.com\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/www.letsyncsolution.com\/docs\/"},{"@type":"ListItem","position":3,"name":"BillPaymentCreditCard"}]},{"@type":"WebSite","@id":"https:\/\/www.letsyncsolution.com\/#website","url":"https:\/\/www.letsyncsolution.com\/","name":"LetSync","description":"QuickBooks Import &amp; Export data | QuickBooks API Integration","publisher":{"@id":"https:\/\/www.letsyncsolution.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.letsyncsolution.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.letsyncsolution.com\/#organization","name":"LetSync","url":"https:\/\/www.letsyncsolution.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.letsyncsolution.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.letsyncsolution.com\/wp-content\/uploads\/2022\/03\/icon-image.png","contentUrl":"https:\/\/www.letsyncsolution.com\/wp-content\/uploads\/2022\/03\/icon-image.png","width":32,"height":32,"caption":"LetSync"},"image":{"@id":"https:\/\/www.letsyncsolution.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/in\/yudel-rosales-echemendia-a0045a103\/recent-activity\/shares\/","https:\/\/www.youtube.com\/watch?v=467ExiD7GTo"]}]}},"_links":{"self":[{"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/docs\/1020"}],"collection":[{"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/comments?post=1020"}],"version-history":[{"count":1,"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/docs\/1020\/revisions"}],"predecessor-version":[{"id":2230,"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/docs\/1020\/revisions\/2230"}],"wp:attachment":[{"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/media?parent=1020"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/doc_category?post=1020"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.letsyncsolution.com\/wp-json\/wp\/v2\/doc_tag?post=1020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}