{"id":106573,"date":"2025-08-08T12:41:07","date_gmt":"2025-08-08T19:41:07","guid":{"rendered":"https:\/\/www.apcdynamics.com\/articles\/?p=106573"},"modified":"2025-11-04T05:42:10","modified_gmt":"2025-11-04T13:42:10","slug":"sales-commission-by-cash-receipt-for-dynamics-365-business-central","status":"publish","type":"post","link":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/","title":{"rendered":"Sales Commission by Cash Receipt for Dynamics 365 Business Central"},"content":{"rendered":"<h2>Overview<\/h2>\n<p>For some companies, commissions are a big part of their salespeople&#8217;s compensation. However, the standard commission report from <strong><a href=\"https:\/\/www.apcdynamics.com\/dynamics-365-business-central\/\">Dynamics 365 Business Central<\/a><\/strong> is based on sales, not cash receipt? This can lead to some problems, especially if your customers have a long payment terms.<\/p>\n<p>For example, let&#8217;s say your salesperson sells a product for $10,000 with a 10% commission. The standard commission report will show that your salesperson earned $1,000 in commission, even if the customer doesn&#8217;t pay for the product for 30 days. But if the customer doesn&#8217;t pay, your salesperson won&#8217;t actually get the commission.<\/p>\n<p>Traditionally, to resolve this accounting will need to do the following:<br \/>\n1. Run a cash received report for all of the invoices for the period<br \/>\n2. Bring up the invoices and figure out which lines are commissionable and which lines are not. Typically companies only pay commission on item sales<br \/>\n3. Prepare a report detailing what is owed to the salespeople<\/p>\n<p>The problem compounds when there are partial payments to an invoice. Now it&#8217;s really fun to figure out how much commission is to be paid.<\/p>\n<p>These problems can lead to inaccurate commission reports. At best, you could end up overpaying your salespeople. At worst, you&#8217;ll waste hours and hours reconciling and arguing the commissions with your sales department.<\/p>\n<h2>Solution<\/h2>\n<p>We have a <a href=\"https:\/\/www.apcdynamics.com\/business-central-add-ons\/sales-commission\/\">Sales Commission app<\/a> that will calculate the amounts that are commissionable and not commissionable based on the cash receipt that is applied against the invoice.<\/p>\n<p>Take a look at the details here:<br \/>\n<iframe loading=\"lazy\" title=\"Commission Calculation based on Cash Receipt for Dynamics 365 Business Central\" width=\"1020\" height=\"574\" src=\"https:\/\/www.youtube.com\/embed\/LOE8fdyPC5s?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>The app can be downloaded from the Microsoft Appsource by clicking here:<\/p>\n<p><strong><a href=\"https:\/\/appsource.microsoft.com\/en-US\/product\/dynamics-365-business-central\/PUBID.apcommerce%7CAID.salescomm_cashreceipt_apc%7CPAPPID.bb100bc1-8a56-4bb3-8cd6-23038b192a7e?tab=Overview\" target=\"_blank\" rel=\"noopener\">Sales Commission by Cash Receipt<\/a><\/strong><\/p>\n<h2>Conclusion<\/h2>\n<p>Every company will have different ways to calculate and pay their commission. However, one common theme we come across is that they always start the calculation with the cash they received from the customer.<\/p>\n<p>This app will get you the information you need. From there, you can use the numbers to calculate the proper commission for your sales staff.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview For some companies, commissions are a big part of their salespeople&#8217;s compensation. However, the standard commission report from Dynamics 365 Business Central is based on sales, not cash receipt? This can lead to some problems, especially if your customers have a long payment terms. For example, let&#8217;s say your salesperson sells a product forRead more<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[64],"tags":[],"class_list":["post-106573","post","type-post","status-publish","format-standard","hentry","category-reporting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Commission Tracking by Cash Receipt in Business Central<\/title>\n<meta name=\"description\" content=\"Streamline commission tracking in Dynamics 365 Business Central. Automatically calculate and pay commissions from cash receipts.\" \/>\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.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Chow\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/\"},\"author\":{\"name\":\"Alex Chow\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\"},\"headline\":\"Sales Commission by Cash Receipt for Dynamics 365 Business Central\",\"datePublished\":\"2025-08-08T19:41:07+00:00\",\"dateModified\":\"2025-11-04T13:42:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/\"},\"wordCount\":347,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"articleSection\":[\"reporting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/\",\"name\":\"Commission Tracking by Cash Receipt in Business Central\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\"},\"datePublished\":\"2025-08-08T19:41:07+00:00\",\"dateModified\":\"2025-11-04T13:42:10+00:00\",\"description\":\"Streamline commission tracking in Dynamics 365 Business Central. Automatically calculate and pay commissions from cash receipts.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"reporting\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/category\\\/reporting\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Sales Commission by Cash Receipt for Dynamics 365 Business Central\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"name\":\"APC Dynamics | Dynamics 365 Business Central Consultant\",\"description\":\"Dynamics 365 Business Central experts. Less Talk. More Results.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\",\"name\":\"APC Dynamics\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"contentUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"width\":216,\"height\":216,\"caption\":\"APC Dynamics\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/APCommerceInc\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ap-commerce-inc-\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCkM_LLmB4333D4Arjk0knyw\\\/about\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\",\"name\":\"Alex Chow\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"caption\":\"Alex Chow\"},\"sameAs\":[\"https:\\\/\\\/www.apcommerce.com\\\/\"],\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Commission Tracking by Cash Receipt in Business Central","description":"Streamline commission tracking in Dynamics 365 Business Central. Automatically calculate and pay commissions from cash receipts.","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.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/","twitter_misc":{"Written by":"Alex Chow","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/#article","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/"},"author":{"name":"Alex Chow","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0"},"headline":"Sales Commission by Cash Receipt for Dynamics 365 Business Central","datePublished":"2025-08-08T19:41:07+00:00","dateModified":"2025-11-04T13:42:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/"},"wordCount":347,"commentCount":0,"publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"articleSection":["reporting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/","url":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/","name":"Commission Tracking by Cash Receipt in Business Central","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#website"},"datePublished":"2025-08-08T19:41:07+00:00","dateModified":"2025-11-04T13:42:10+00:00","description":"Streamline commission tracking in Dynamics 365 Business Central. Automatically calculate and pay commissions from cash receipts.","breadcrumb":{"@id":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.apcdynamics.com\/articles\/sales-commission-by-cash-receipt-for-dynamics-365-business-central\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.apcdynamics.com\/articles\/"},{"@type":"ListItem","position":2,"name":"reporting","item":"https:\/\/www.apcdynamics.com\/articles\/category\/reporting\/"},{"@type":"ListItem","position":3,"name":"Sales Commission by Cash Receipt for Dynamics 365 Business Central"}]},{"@type":"WebSite","@id":"https:\/\/www.apcdynamics.com\/articles\/#website","url":"https:\/\/www.apcdynamics.com\/articles\/","name":"APC Dynamics | Dynamics 365 Business Central Consultant","description":"Dynamics 365 Business Central experts. Less Talk. More Results.","publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apcdynamics.com\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.apcdynamics.com\/articles\/#organization","name":"APC Dynamics","url":"https:\/\/www.apcdynamics.com\/articles\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/","url":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","contentUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","width":216,"height":216,"caption":"APC Dynamics"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/APCommerceInc\/","https:\/\/www.linkedin.com\/company\/ap-commerce-inc-\/","https:\/\/www.youtube.com\/channel\/UCkM_LLmB4333D4Arjk0knyw\/about"]},{"@type":"Person","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0","name":"Alex Chow","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","caption":"Alex Chow"},"sameAs":["https:\/\/www.apcommerce.com\/"],"url":"https:\/\/www.apcdynamics.com\/articles\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/106573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/comments?post=106573"}],"version-history":[{"count":6,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/106573\/revisions"}],"predecessor-version":[{"id":106753,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/106573\/revisions\/106753"}],"wp:attachment":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/media?parent=106573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/categories?post=106573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/tags?post=106573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}