nlxs

I like it, this is exactly what i need.

I like it!! This is exactly what i need.

i have send you a PM

This can only happen, when the invoice send on 1-february has a "payment period of 14 days" It is not acceptable to Request to upload amount in advance. Just like any other invoice i need a payment term of 14 days after sending the invoice. As far as i can see, this is not possible, or do you have a solution for that?

Thank you for the suggestion, unfortunatly I cannot work with pro-forma invoices (required to send real invoice after the month) The other solution is onepayment (he also offers) but then you get multiple invoices with 1 payment, also not acceptable. The software of Kian doesn't support invoicing before due/term date, only afterwards. I tried it but without luck and with bad support. as you can see it's very bad rated on whmcs marketplace My goal is to send only 1 invoice a month before the start of the service(s)/domains (no proforma invoice) So in short version: I am just looking for a sql script/hook that search for the (next) due date (of the services in the next month) --> change it (every night) to 15-xx-xx,. So I can send a invoice on the 1st of every month with a due payment of 14 days. When we only do the thing above, we do not change the original registration date (other field) (so i can always search for the start of the contract term). Can someone write this sql php script for me? I can create a cronjob to start above script every night for example.

Can someone help me with the following. At this moment I am using software to invoice my hosting clients on a monthly base, domains/hosting/spamfilters are all invoiced on the 1st of the month. For example the content of a invoice send on the 1st this month. Domain xxx.XXX - term: 20/07/2019 - 20/07/2020 Hosting xxx.XXX - term: 20/07/2019 - 20/07/2020 Hosting yyy.YYY - term: 31/07/2019 - 31/07/2020 Domain aaa.AAA - term: 02/07/2019 - 02/07/2020 At this moment their is no solution to invoice the same way from WHMCS, I can set pro-forma invoicing, but thats only applicable for services and not domains. Another solution is to modify all the dates to 14th of the month and set invoicing 2 weeks before due date. To modify all dates by myself is way too much work everytime, and I don't want to edit the "contract-term" Does someone has a SQL solution for this, so I can invoice everthing from 1 month on 1 invoice, without editting contract-terms...? I think updating all due dates with a daily sql hook/script will do the trick... But i don't know if the due dates are regenerated based on the "registration/start/contract-term" date(s)