{"id":11145,"date":"2025-01-21T06:35:29","date_gmt":"2025-01-21T06:35:29","guid":{"rendered":"https:\/\/www.trustedhosting.in\/blog\/?p=11145"},"modified":"2025-01-21T06:35:29","modified_gmt":"2025-01-21T06:35:29","slug":"how-troubleshoot-service-generation","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/how-troubleshoot-service-generation\/","title":{"rendered":"How to Troubleshoot Service Invoice Generation"},"content":{"rendered":"

\"How<\/a><\/h1>\n

How to Troubleshoot Service Invoice Generation<\/h1>\n
\n
\n

You may encounter a problem in which the system does not generate an \u00a0invoice for a service renewal. This is generally due to one of several \u00a0common causes.<\/p>\n

For more information on how WHMCS generates invoices, see\u00a0Billing Logic.<\/p>\n<\/div>\n<\/div>\n

\n

Status Not Active or Pending<\/h2>\n
\n
\n

The system only generates renewal invoices if\u00a0Status<\/strong>\u00a0is\u00a0Active\u00a0<\/em>or\u00a0Pending.<\/em>\u00a0<\/em><\/strong>Service records with other statuses will\u00a0not<\/strong>\u00a0generate renewal invoices.<\/p>\n<\/div>\n<\/div>\n

\n
\n

If you have enabled\u00a0Continuous Invoice Generation<\/strong>, the system will only generate renewal invoices if\u00a0Status<\/strong>\u00a0is\u00a0Active<\/em>.<\/p>\n<\/div>\n<\/div>\n

\n
\n

To set this value:<\/p>\n

1. Go to\u00a0Clients > Products\/Services<\/strong>.<\/p>\n

2. Search for and click on the service.<\/p>\n

3. Set\u00a0Status<\/strong>\u00a0to\u00a0Active.<\/em><\/p>\n

\"\"<\/p>\n

\n
\n
\n

4. Click\u00a0Save Changes<\/strong>.<\/p>\n

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

\n

Cancellation Requested<\/h2>\n
\n
\n

The system will not generate new renewal invoices if there is a\u00a0cancellation request. If it had already generated a renewal invoice at the time of the cancellation request, the system may have cancelled it due to your\u00a0automation settings.<\/p>\n

To check for this:<\/p>\n

1. Go to\u00a0Clients > Products\/Services.<\/strong><\/p>\n

2. Search for and click on the service.<\/p>\n

3. Look for a\u00a0Cancellation Request Notice<\/strong>\u00a0message:<\/p>\n

\"\"<\/p>\n

\n
\n
\n

If you do not want to cancel the service, see\u00a0Voiding Cancellation Requests.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n

Next Due Date Beyond Invoice Generation Days<\/h2>\n
\n
\n

A service record will not automatically generate a renewal invoice if\u00a0Next Due Date<\/strong>\u00a0is further in the future than the number of days that you specified for\u00a0Invoice Generation<\/strong>.<\/p>\n

To check for this:<\/p>\n

1. Go to\u00a0Configuration > System Settings > Automation Settings.<\/strong><\/p>\n

2. Find\u00a0Invoice Generation\u00a0<\/strong>and note the current value:<\/p>\n

\"\"<\/p>\n

3. Go to\u00a0Clients > Products\/Services.<\/strong><\/p>\n

4. Search for and click on the service.<\/p>\n

5. Find\u00a0Next Due Date<\/strong>\u00a0and check whether it is further in the future than\u00a0Invoice Generation<\/strong>\u00a0specifies.<\/p>\n

\"\"<\/p>\n

\n
\n
\n

For example, if today’s date is January 1st, 2023:<\/p>\n

\n
Next Due Date: 14th Jan 2023\r\nInvoice Generation: 14\r\n= Invoice will<\/strong> generate today.<\/code><\/pre>\n
<\/div>\n<\/div>\n
\n
Next Due Date: 15th Jan 2023\r\nInvoice Generation: 14\r\n= Invoice not<\/strong> generated today.<\/code><\/pre>\n
<\/div>\n<\/div>\n
If the invoice is not yet due for automatic renewal, you can renew the service early via\u00a0the client’s profile’s\u00a0Summary<\/strong>\u00a0tab.<\/p>\n<\/div>\n<\/div>\n<\/div>\n
\n
Previously Invoiced<\/h2>\n
\n
\n
A service will not automatically generate a renewal invoice if the system has already generated a renewal invoice for the current\u00a0Next Due Date<\/strong>\u00a0value and an admin deleted it.<\/p>\n
To check for this issue:<\/p>\n<\/div>\n<\/div>\n
\n
\n
1. Access the WHMCS MySQL\u00ae database using your preferred method (for example, phpMyAdmin).<\/p>\n
2. Run the following query:<\/p>\n
\n
SELECT * FROM tblinvoiceitems WHERE type='Hosting' AND relid='x' AND invoiceid NOT IN(SELECT id FROM tblinvoices)<\/code><\/pre>\n
<\/div>\n<\/div>\n
Replace\u00a0x<\/code>\u00a0with the service ID, which you can find next to the service in the client’s\u00a0Summary<\/strong>\u00a0tab.<\/p>\n
The query should return an empty result:<\/p>\n
\"\"<\/p>\n
\n
\n
\n
If there are any results, this indicates a deleted renewal invoice.<\/p>\n
Review the client’s profile’s\u00a0Log<\/strong>\u00a0tab’s\u00a0Invoice Deleted<\/strong>\u00a0or\u00a0Order Deleted<\/strong>\u00a0entries. This will identify who deleted it and the time of deletion.<\/p>\n
To resolve this issue and generate a new invoice:<\/p>\n
1. Go to\u00a0Domains > Products\/Services.<\/strong><\/p>\n
2. Search for and click on the service.<\/p>\n
3. Set the\u00a0Next Due Date<\/strong>\u00a0value to one day earlier.<\/p>\n
4. Click\u00a0Save Changes<\/strong>.<\/p>\n
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
\n
Daily Automation Cron Issue<\/h2>\n
\n
\n
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":"
How to Troubleshoot Service Invoice Generation You may encounter a problem in which the system does not generate an \u00a0invoice…<\/p>\n","protected":false},"author":1,"featured_media":11005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-11145","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\/11145","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=11145"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11145\/revisions"}],"predecessor-version":[{"id":11152,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11145\/revisions\/11152"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/11005"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=11145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=11145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=11145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}