Payment before - Invoice Due Date

Hey there,

If the product expires on 2013-01-01, the invoice would probably have been generated 14 days in advance, so the invoice would be in Unpaid status since it was generated, right?

I believe you can setup your invoice notifications to fire up 14 days after due date, so this way your customer is only notified about the Unpaid invoice 14 days after the product due date.

Sorry if I'm understanding your needs incorrectly.

I think the original poster meant, If I create a new product invoice for you today, but want a due date in 15 days, as it is currently setup: You will immediately be past due on the invoice created today, even if you wanted a due date 15 days from now.

Ive had this issue when I am creating invoices for customers that were not being tracked in WHMCS until now. They end up getting invoice nastygrams way earlier than thier intended due dates.

1. <?php
2. function setDueDate($vars) {
3. $invoiceid = $vars['invoiceid'];
4. $numdays = 14;
5. $newdate = time() + ($numdays * 86400);
6. $newdate = date("Y-m-d", $newdate);

   $sql = "UPDATE tblinvoices SET duedate = '".$newdate."' WHERE id = ".$invoiceid;

7. mysql_query($sql);
8. }

   add_hook("InvoiceCreated",1,"setDueDate");

9. ?>

This I believe can be simulated with some settings in WHMCS, but one important thing is missing: The due date will always be wrong one way or the other. We need the possibility to have a different duedate on invoice and product. This is important for us and most enterprises in EU that does not want to change their customer billing just because they started using WHMCS.

This would solve my problem as well. When I add a new order for a client, an invoice is generated with a due date of the same date! That is often unrealistic. If I could enter a due date on the order, of a week or so out, that would work fine. The client wouldn't get an overdue noticed the day after placing an order, and I wouldn't have to manually edit the invoices generated for new orders.

Actually we would like a field to set the invoice due date X-many days before the expiry/renewal date of a service to eliminate similar issues. This functionality exists already in WHMCS for Domain names. But not the same for services, such as hosting.

automatically set the new due date on invoice date when client make payment.

I made solution for me like this - works well for me.

If you wanna have different payment days for customers, create a custom field(i.e. Rechnungstage)

Create a file /includes/hooks/InvoiceCreationPreEmail.php

Content:

<?php

/*

change due date after invoicing

*/

$CUSTOM_FIELD_NAME = 'Rechnungstage';

$DEFAULT_DAYS = 30;

function setDueDate($vars)

{

global $CUSTOM_FIELD_NAME, $DEFAULT_DAYS;

$invoiceId = $vars['invoiceid'];

$sql = "SELECT userid FROM tblinvoices WHERE id = ".$invoiceId;

$result = mysql_query($sql);

$numrows = mysql_num_rows($result);

if ($numrows > 0)

{

$numdays = $DEFAULT_DAYS;

// Get clients id

$row = mysql_fetch_array($result);

$clientId = $row[0];

// Find number of days before due date for client

$sql = "SELECT DISTINCT cv.value FROM tblcustomfieldsvalues AS cv JOIN tblcustomfields AS cf ON cv.fieldid = cf.id WHERE cf.fieldname LIKE '".$CUSTOM_FIELD_NAME."' AND cv.relid = ".$clientId;

$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))

{

if (!empty($row['value'])) $numdays = $row['value'];

}

// Update due date

$sql = "UPDATE tblinvoices SET duedate = date_add(date, interval ".$numdays." day) WHERE id = ".$invoiceId;

mysql_query($sql);

}

}

add_hook("InvoiceCreationPreEmail",1,"setDueDate");

?>

Hello,

The script is automatic or it must be triggered manually?

I can see from the code that he's using a hook - so it will be automatic. It's quite clever and I'll be using this as I want payment terms of 14 days for all Bank Transfers. I'll be able to change his code to look up the Payment Method and set the due date if the Payment Method = Bank Transfer.

https://developers.whmcs.com/hooks-reference/invoices-and-quotes/#invoicecreationpreemail

That's the hook that's being used. It's a shame there's not a comprehensive API so the read and update database operations can be changed into API calls.

Either way, thanks a bunch U2 Pas!