{"id":4582,"date":"2020-09-10T06:20:00","date_gmt":"2020-09-10T10:50:00","guid":{"rendered":"https:\/\/www.apps4rent.com\/blog\/?p=4582"},"modified":"2021-01-19T11:30:37","modified_gmt":"2021-01-19T16:00:37","slug":"map-ids-between-quickbooks-online-desktop","status":"publish","type":"post","link":"https:\/\/www.apps4rent.com\/blog\/map-ids-between-quickbooks-online-desktop\/","title":{"rendered":"How to Map IDs Between QuickBooks Online and QuickBooks Desktop?"},"content":{"rendered":"<p>Intuit encourages users to migrate from the on-premises QuickBooks Desktop solution to QuickBooks Online. It even provides the option to export to QuickBooks Online in QuickBooks Desktop.<\/p>\n<p>However, the process is not as simple as clicking a button to export the data from the on-premises solution to QuickBooks Online. The built-in migration tool is designed to make the migration seamless without affecting the data stored within the on-premises system while moving contents to QuickBooks Online. However, you will have to know how to map IDs between QuickBooks Online and QuickBooks Desktop under certain circumstances.<\/p>\n<h2 style=\"font-size: 24px;\">How Does Mapping IDs Between QuickBooks Desktop and QuickBooks Online Work?<\/h2>\n<p>When you are migrating from QuickBooks Desktop to QuickBooks Online, new identities are generated on the latter solution for different entities such as invoices and transactions. These identifiers are different from the ones used in QuickBooks Desktop. If you are using the QuickBooks migration tool, the process of mapping IDs is automated. However, the process of mapping IDs has to be performed when new QuickBooks Online entity IDs are required for using third-party applications.<\/p>\n<p>ID mapping between the entities on QuickBooks Online and QuickBooks Desktop is done using the QbdtEntityIdMapping API tool. This tool is used to access a reference table provided by Intuit for mapping the unique attributes of various database attributes while migrating to QuickBooks Online. Developers can use these IDs to query information based on a specific entity or a generic entity type.<\/p>\n<h2 style=\"font-size: 24px;\">Which QuickBooks Online IDs Can Map with QuickBooks Desktop?<\/h2>\n<p>When you are migrating from QuickBooks Desktop to QuickBooks Online, most of the financial records in the QuickBooks Desktop company file are migrated automatically. However, some of the features available in QuickBooks Desktop are not available as-is on QuickBooks Online. These require custom configuration that relies on ID mapping or the use of third-party tools.<\/p>\n<ul>\n<li style=\"margin-bottom: 10px;\">Unlike QuickBooks Desktop, there is no built-in capability for job costing in QuickBooks Online unless you are using Payroll. You might have to use the IDs for Jobs, Item Lists, and other attributes for querying this function.<\/li>\n<li style=\"margin-bottom: 10px;\">If you track inventory assemblies in QuickBooks Desktop and need to do so after migrating to QuickBooks Online, you will either have to view them as line items or map their IDs in QuickBooks Desktop for a customized solution.<\/li>\n<li style=\"margin-bottom: 10px;\">If you need specific units of measures after migrating to QuickBooks Online, you will have to use the unit of measure (UOM) feature&#8217;s ID with the QuickBooks Desktop SDK (Software Developer Kit) or use a third-party inventory management application.<\/li>\n<\/ul>\n<p>While you can find substitutes and workarounds for most features available with QuickBooks Desktop using third-party integrations, you can build your own solutions by mapping IDs for entities in QuickBooks Desktop for accessing them on QuickBooks Online.<\/p>\n<h3 style=\"font-size: 23px;\">Is Mapping Map IDs Between QuickBooks Online and QuickBooks Desktop Always Useful?<\/h3>\n<p>Mapping entity IDs from QuickBooks Desktop with those on QuickBooks Online is only useful if the migration from QuickBooks Desktop to QuickBooks Online makes sense. If your company uses multicurrency or has a large database, the migration itself is not supported.<\/p>\n<p>Additionally, there are several features on QuickBooks Desktop that still don&#8217;t have workarounds. The IDs of these attributes cannot be mapped with a corresponding feature in QuickBooks Online.<\/p>\n<h3 style=\"font-size: 23px;\">Apps4Rent Can Help with QuickBooks Desktop<\/h3>\n<p>Mapping IDs between QuickBooks Desktop and QuickBooks Online is almost always the last option to build custom-made solutions that work with QuickBooks Online. While the built-in migration tool automatically populates corresponding attributes in QuickBooks Online, other features can be mimicked with third-party application integrations. However, it is recommended to avoid a QuickBooks Desktop to QuickBooks Online migration if you are unsure of the outcome.<\/p>\n<p>Instead, you can host your copy of QuickBooks Desktop with an<strong> Intuit Authorized Hosting Provider like Apps4Rent<\/strong>. With 24\/7 phone, chat, and email support, Apps4Rent engineers can help you take advantage of all the features available on QuickBooks Desktop along with the flexibility you can expect from the cloud-based QuickBooks Online. Contact us today to know more about our <span style=\"color: #3183d7;\"><a style=\"color: #007fac;\" href=\"https:\/\/apps4rent.com\/quickbooks-cloud-hosting\/\">QuickBooks hosting plans<\/a><\/span>.<\/p>\n<style>.stick_popup{margin-top: -190px !important;}@media only screen and (min-width:99px) and (max-width:767px){.popup1 {display: none;}.stick_popup{width: 100% !important;margin-left: -188px !important;}}<\/style>\n<link rel=\"stylesheet\" type=\"text\/css\" href=\"https:\/\/www.clouddesktoponline.com\/blog\/wp-content\/themes\/apps4rentoffice\/popup\/stick-to-me.css\"\/><script src=\"https:\/\/www.clouddesktoponline.com\/blog\/wp-content\/themes\/apps4rentoffice\/popup\/stick-to-me.js\"><\/script><script>$(document).ready(function(){$.stickToMe({layer:'#stickLayer'});});<\/script><\/p>\n<div class=\"jquery-script-ads\" align=\"center\"><\/div>\n<div id=\"stickLayer\" style=\"display:none;max-width:1000px;height:auto; width:800px;background:#fff;\" class=\"stick_popup\">\n<div class=\"stick_close\" onclick=\"$.stick_close()\">X<\/div>\n<div class=\"stick_content\" style=\"padding-left: 0px;padding-top: 0px;padding-bottom: 0px;\">\n<div class=\"col-md-6 popup1\" style=\"background: #f1ab4f;color: white;padding-right: 0px;padding-left: 0px;background: -webkit-linear-gradient(rgb(255 255 255), #70b545);height: 650px\"><img decoding=\"async\" src=\"https:\/\/www.apps4rent.com\/blog\/wp-content\/uploads\/2021\/01\/quickbooks-promotions.png\"\/><\/div>\n<div class=\"col-md-6\">\n<p style=\"color: #289e0c;font-weight: 700;font-size: 27px;margin-bottom: 20px;\">Request for price promotions<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f5478-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"5478\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/4582#wpcf7-f5478-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"5478\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f5478-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:5478,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false,&quot;notice_dismissed_rollback-cf7-5.9.5&quot;:true}}\" \/>\n<\/fieldset>\n<style>.inputf{font: 16px 'Roboto';font-family: sans-serif; font-weight: normal;font-style: normal;line-height: 25px;color:#666 !important; padding: 5px 20px !important;font-size: 16px;border: #9d9fa0 1px solid !important;margin-bottom:20px !important;box-sizing: border-box;border-radius: 3px !important;width: 100%;}.inputf2{font: 16px 'Roboto';font-family: sans-serif; font-weight: normal;font-style: normal;line-height: 25px;color:#666 !important; padding: 8px 20px !important;font-size: 16px;border: #9d9fa0 1px solid !important;margin-bottom:20px !important;box-sizing: border-box;border-radius: 3px !important;width: 100%;}\n.cf7-style div.wpcf7-response-output{width: fit-content !important;margin: 0px;padding: 5px !important;}\n.button1 {padding: 15px 20px;font-size: 22px !important;background: #ff9307 !important;border: 1px solid #ff9307 !important;font-family: sans-serif;color: #fff;border: #9dbfff 2px solid;box-shadow: none;font-weight: bold;margin-bottom:0px !important;width: 100% !important;}\n<\/style>\n<style>@media only screen and (min-width:99px) and (max-width:767px){#content{margin-left:0px auto;}.sec {width:100% !important;float: none !important;}.html input[type=\"button\"], input[type=\"reset\"], input[type=\"submit\"]{font-size:16px !important;}}\n<\/style>\n<div style=\"padding-left: 15px;padding-right: 15px;padding-top: 15px;padding-bottom: 0px;\">\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"Name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name*\" value=\"\" type=\"text\" name=\"Name\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"contact\"><input size=\"40\" maxlength=\"10\" minlength=\"6\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Contact Number*\" value=\"\" type=\"tel\" name=\"contact\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"email\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Email ID*\" value=\"\" type=\"email\" name=\"email\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"desktop\"><input size=\"40\" maxlength=\"5\" minlength=\"1\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Number of Users*\" value=\"\" type=\"text\" name=\"desktop\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"lookingfor\"><select class=\"wpcf7-form-control wpcf7-select inputf2\" aria-invalid=\"false\" name=\"lookingfor\"><option value=\"Licenses or Hosting\">Licenses or Hosting<\/option><option value=\"Licenses Only\">Licenses Only<\/option><option value=\"Hosting Only\">Hosting Only<\/option><option value=\"Licenses + Hosting\">Licenses + Hosting<\/option><\/select><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-bottom:20px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"msg\"><textarea cols=\"40\" rows=\"3\" maxlength=\"250\" minlength=\"2\" class=\"wpcf7-form-control wpcf7-textarea inputf\" aria-invalid=\"false\" placeholder=\"Message\" name=\"msg\"><\/textarea><\/span>\n\t\t<input class=\"wpcf7-form-control wpcf7-hidden\" value=\"\" type=\"hidden\" name=\"timezone\" \/>\n\t\t<input class=\"wpcf7-form-control wpcf7-hidden\" value=\"\" type=\"hidden\" name=\"user_time\" \/>\n\t\t<\/p>\n\t<\/div>\n\t<div>\n\t\t<p><input type=\"submit\" class=\"button1\" onclick=\"this.form.submit();this.disabled = true;\" value=\"SUBMIT REQUEST\" \/>\n\t\t<\/p>\n\t<\/div>\n<\/div><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"113\"\/><script>document.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Intuit encourages users to migrate from the on-premises QuickBooks Desktop solution to QuickBooks Online. It even provides the option to export to QuickBooks Online in QuickBooks Desktop. However, the process is not as simple as clicking a button to export the data from the on-premises solution to QuickBooks Online. The built-in migration tool is designed [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[541],"tags":[],"class_list":["post-4582","post","type-post","status-publish","format-standard","hentry","category-quickbooks"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts\/4582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/comments?post=4582"}],"version-history":[{"count":3,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts\/4582\/revisions"}],"predecessor-version":[{"id":5552,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts\/4582\/revisions\/5552"}],"wp:attachment":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/media?parent=4582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/categories?post=4582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/tags?post=4582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}