{"id":11137,"date":"2025-01-21T06:19:32","date_gmt":"2025-01-21T06:19:32","guid":{"rendered":"https:\/\/www.trustedhosting.in\/blog\/?p=11137"},"modified":"2025-01-21T06:19:32","modified_gmt":"2025-01-21T06:19:32","slug":"how-trouble-domain-invoice-generation","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/how-trouble-domain-invoice-generation\/","title":{"rendered":"How to Troubleshoot Domain Invoice Generation"},"content":{"rendered":"<p><a href=\"https:\/\/www.trustedhosting.in\/master-reseller-hosting.html\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11009 size-full\" title=\"How to Troubleshoot Domain Invoice Generation\" src=\"https:\/\/www.trustedhosting.in\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-scaled.jpg\" alt=\"How to Troubleshoot Domain Invoice Generation\" width=\"2560\" height=\"1862\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-scaled.jpg 2560w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-300x218.jpg 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-1024x745.jpg 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-768x558.jpg 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-1536x1117.jpg 1536w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/3585381_66226-2048x1489.jpg 2048w\" sizes=\"auto, (max-width: 2560px) 100vw, 2560px\" \/><\/a><\/p>\n<h1>How to Troubleshoot Domain Invoice Generation<\/h1>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_411E245D-1F97-42DB-8368-A905432B4F9E\" class=\"text-block-content\">\n<p>You may encounter a problem in which the system does not generate an invoice for a domain renewal. This is generally due to one of several common causes.<\/p>\n<\/div>\n<\/div>\n<div class=\"step step-depth-1\" data-step-uuid=\"DB1B9258-8E4F-4079-BF6B-3771B50111A0\">\n<h2 id=\"auto-renew-disabled\" tabindex=\"0\">Auto Renew Disabled<\/h2>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_E3143BED-A8BF-46DA-AA2B-562CEB0ADD87\" class=\"text-block-content\">\n<p>A domain record will not automatically generate a renewal invoice if\u00a0<strong>Auto Renew<\/strong>\u00a0is disabled.<\/p>\n<p>To disable this option:<\/p>\n<p>1. Go to\u00a0<strong>Clients &gt; Domain Registrations.<\/strong><\/p>\n<p>2. Search for and click on the domain in question.<\/p>\n<p>3. Under\u00a0<strong>Management Tools<\/strong>, find the\u00a0<strong>Disable Auto Renew<\/strong>\u00a0toggle. If it is set to\u00a0<em>YES<\/em>, automatic renewal is disabled and the system will not automatically generate an invoice.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11138\" src=\"https:\/\/www.trustedhosting.in\/blog\/wp-content\/uploads\/2025\/01\/b9bc9033-386f-4e76-8808-681ee3051b8d.png\" alt=\"\" width=\"891\" height=\"49\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/b9bc9033-386f-4e76-8808-681ee3051b8d.png 891w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/b9bc9033-386f-4e76-8808-681ee3051b8d-300x16.png 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/b9bc9033-386f-4e76-8808-681ee3051b8d-768x42.png 768w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/p>\n<div class=\"step step-depth-1\" data-step-uuid=\"DB1B9258-8E4F-4079-BF6B-3771B50111A0\">\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_55A726B0-FC81-46A1-82AB-27354FDF15C2\" class=\"text-block-content\">\n<p>4. Set\u00a0<strong>Disable Auto Renew<\/strong>\u00a0to\u00a0<em>NO<\/em>.<\/p>\n<p>5. Click\u00a0<strong>Save Changes<\/strong>.<\/p>\n<p>The system will generate the renewal invoice the next time that the daily automation cron tasks run.<\/p>\n<p>For more information, see\u00a0Domain Renewals.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"step step-depth-1\" data-step-uuid=\"C9481B26-DF80-4C68-AF93-9DA3B2A2C204\">\n<h2 id=\"domain-status-not-active\" tabindex=\"0\">Status Not Active or Pending<\/h2>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_7412C60F-FC63-458B-BBC3-CD0B83C16F6D\" class=\"text-block-content\">\n<p>A domain record will not generate a renewal invoice if\u00a0<strong>Status<\/strong>\u00a0is anything other than\u00a0<em>Active<\/em>\u00a0or\u00a0<em>Pending<\/em>.<\/p>\n<p>To set this value:<\/p>\n<p>1. Go to\u00a0<strong>Domains &gt; Domain Registrations<\/strong>.<\/p>\n<p>2. Search for and click on the domain.<\/p>\n<p>3. If\u00a0<strong>Status<\/strong>\u00a0is not set to\u00a0<em>Active<\/em>\u00a0or\u00a0<em>Pending<\/em>, update it:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11139\" src=\"https:\/\/www.trustedhosting.in\/blog\/wp-content\/uploads\/2025\/01\/938226b8-ebd6-4f74-b08c-e768ff2917d1.png\" alt=\"\" width=\"380\" height=\"95\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/938226b8-ebd6-4f74-b08c-e768ff2917d1.png 380w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/938226b8-ebd6-4f74-b08c-e768ff2917d1-300x75.png 300w\" sizes=\"auto, (max-width: 380px) 100vw, 380px\" \/><\/p>\n<div class=\"step step-depth-1\" data-step-uuid=\"C9481B26-DF80-4C68-AF93-9DA3B2A2C204\">\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_BE792BB9-BD1F-46F0-B56F-6992B5E1340C\" class=\"text-block-content\">\n<p>4. Click\u00a0<strong>Save Changes<\/strong>.<\/p>\n<p>The system will generate the renewal invoice the next time that the daily automation cron tasks run.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"step step-depth-1\" data-step-uuid=\"58B69262-AEE4-43FB-96A8-1FF4EE63FFF0\">\n<h2 id=\"next-due-date-beyond-invoice-generation-days\" tabindex=\"0\">Next Due Date Beyond Invoice Generation Days<\/h2>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_EF6C8BC4-2036-433C-90FE-2EA46FBF39BD\" class=\"text-block-content\">\n<p>A domain record will not automatically generate a renewal invoice if\u00a0<strong>Next Due Date<\/strong>\u00a0is further in the future than the number of days you specified in\u00a0the\u00a0<strong>Invoice Generation<\/strong>\u00a0setting:<\/p>\n<p>1. Go to\u00a0<strong>Configuration &gt; System Settings &gt;\u00a0<\/strong><strong>Automation Settings<\/strong><strong>.<\/strong><\/p>\n<p>2. Find the\u00a0<strong>Invoice Generation<\/strong>\u00a0value:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11141\" src=\"https:\/\/www.trustedhosting.in\/blog\/wp-content\/uploads\/2025\/01\/a5cacd15-c8c0-4777-b508-68c60be8727a-1.png\" alt=\"\" width=\"641\" height=\"163\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/a5cacd15-c8c0-4777-b508-68c60be8727a-1.png 641w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/a5cacd15-c8c0-4777-b508-68c60be8727a-1-300x76.png 300w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/p>\n<p>3. Go to\u00a0<strong>Clients &gt; Domain Registrations.<\/strong><\/p>\n<p>4. Search for and click on the domain.<\/p>\n<p>5. Find the\u00a0<strong>Next Due Date<\/strong>\u00a0value and check whether it is further in the future than the\u00a0<strong>Invoice Generation<\/strong>\u00a0value specifies.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11142\" src=\"https:\/\/www.trustedhosting.in\/blog\/wp-content\/uploads\/2025\/01\/f9c8dd5a-6eec-48ea-8648-afd86ea9463b.png\" alt=\"\" width=\"319\" height=\"138\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/f9c8dd5a-6eec-48ea-8648-afd86ea9463b.png 319w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/f9c8dd5a-6eec-48ea-8648-afd86ea9463b-300x130.png 300w\" sizes=\"auto, (max-width: 319px) 100vw, 319px\" \/><\/p>\n<div class=\"step step-depth-1\" data-step-uuid=\"58B69262-AEE4-43FB-96A8-1FF4EE63FFF0\">\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_BBADA040-1F6C-40F0-AB7C-0778A9401E3A\" class=\"text-block-content\">\n<p>For example, if today&#8217;s date is 1st Jan 2022:<\/p>\n<div class=\"code-block copy-clipboard--parent\">\n<pre id=\"code-content_bcd7fecc-6174-4e55-9158-12e15cc55f66\"><code>Next Due Date: 14th Jan 2022\r\nInvoice Generation: 14\r\n= Invoice <strong>will<\/strong> generate today.<\/code><\/pre>\n<div class=\"copy-clipboard copy-clipboard--tt-right\"><\/div>\n<\/div>\n<div class=\"code-block copy-clipboard--parent\">\n<pre id=\"code-content_269206c2-88dd-424b-ba68-e39c016bf90a\"><code>Next Due Date: 15th Jan 2022\r\nInvoice Generation: 14\r\n= Invoice <strong>not<\/strong> generated today.<\/code><\/pre>\n<div class=\"copy-clipboard copy-clipboard--tt-right\"><\/div>\n<\/div>\n<p>If the invoice is not yet due for automatic renewal, you can renew the domain early via the Client Area shopping cart or\u00a0in the client&#8217;s\u00a0<strong>Summary<\/strong>\u00a0tab.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"step step-depth-1\" data-step-uuid=\"2571BB74-8B71-4A8C-996B-9A3E30B8FCE5\">\n<h2 id=\"previously-invoiced\" tabindex=\"0\">Previously Invoiced<\/h2>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_396B0071-75B6-48F0-81AD-C930596FC349\" class=\"text-block-content\">\n<p>A domain record will not automatically generate a renewal invoice if the system has already generated a renewal invoice for the current\u00a0<strong>Next Due Date<\/strong>\u00a0value and an admin deleted it.<\/p>\n<p>To check for this issue:<\/p>\n<\/div>\n<\/div>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_C59DC1AC-3B21-4404-9D8C-1E7EF1CC9FE8\" class=\"text-block-content\">\n<p>1. Access the WHMCS MySQL\u00ae database using your preferred method (for example, phpMyAdmin).<\/p>\n<p>2. Run the following query:<\/p>\n<div class=\"code-block copy-clipboard--parent\">\n<pre id=\"code-content_16b3364f-d9ea-45f9-8e83-90221064567d\"><code>SELECT * FROM tblinvoiceitems WHERE relid='x' AND (type='Domain' OR type='DomainRegister' OR type='DomainTransfer') AND invoiceid NOT IN(SELECT id FROM tblinvoices)<\/code><\/pre>\n<div class=\"copy-clipboard copy-clipboard--tt-right\"><\/div>\n<\/div>\n<p>Replace\u00a0<code>x<\/code>\u00a0with the domain ID, which you can find next to the domain in the client&#8217;s\u00a0<strong>Summary<\/strong>\u00a0tab.<\/p>\n<p>The query should return an empty result:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11143\" src=\"https:\/\/www.trustedhosting.in\/blog\/wp-content\/uploads\/2025\/01\/5dc22ef6-b088-4502-a699-0c7b0da741b7.png\" alt=\"\" width=\"855\" height=\"57\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/5dc22ef6-b088-4502-a699-0c7b0da741b7.png 855w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/5dc22ef6-b088-4502-a699-0c7b0da741b7-300x20.png 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2025\/01\/5dc22ef6-b088-4502-a699-0c7b0da741b7-768x51.png 768w\" sizes=\"auto, (max-width: 855px) 100vw, 855px\" \/><\/p>\n<div class=\"step step-depth-1\" data-step-uuid=\"2571BB74-8B71-4A8C-996B-9A3E30B8FCE5\">\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_6AF8D51F-9425-4B09-A396-014996D54000\" class=\"text-block-content\">\n<p>If there are any results, this indicates a deleted renewal invoice.<\/p>\n<p>Review the client&#8217;s\u00a0<strong>Log<\/strong>\u00a0tab&#8217;s\u00a0<strong>Invoice Deleted<\/strong>\u00a0or\u00a0<strong>Order Deleted<\/strong>\u00a0entries. This will identify who deleted it and the time of deletion.<\/p>\n<p>To resolve this issue and generate a new invoice:<\/p>\n<p>1. Go to\u00a0<strong>Clients &gt; Domain Registrations.<\/strong><\/p>\n<p>2. Search for and click on the domain.<\/p>\n<p>3. Set the\u00a0<strong>Next Due Date<\/strong>\u00a0value to one day earlier.<\/p>\n<p>4. Click\u00a0<strong>Save Changes<\/strong>.<\/p>\n<p>The system will generate the renewal invoice the next time that the daily automation cron tasks run.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"step step-depth-1\" data-step-uuid=\"18B7B5E7-2FC3-44E8-8211-8637D38F1A2B\">\n<h2 id=\"daily-automation-cron-issue\" tabindex=\"0\">Daily Automation Cron Issue<\/h2>\n<div class=\"instructions screensteps-textblock\" tabindex=\"0\">\n<div id=\"text-content_C6D6DA4D-89AF-4782-8419-73CF6FC67F53\" class=\"text-block-content\">\n<p>The daily\u00a0cron job\u00a0handles invoice generation, payment reminders, and account suspensions and terminations according to your\u00a0automation settings. If some of these do not occur, the cron job may not be running successfully.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>How to Troubleshoot Domain Invoice Generation You may encounter a problem in which the system does not generate an invoice&hellip;<\/p>\n","protected":false},"author":1,"featured_media":11009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-11137","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whmcs"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=11137"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11137\/revisions"}],"predecessor-version":[{"id":11144,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11137\/revisions\/11144"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/11009"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=11137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=11137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=11137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}