Discussion:
[Citrusdb-users] payment due date gets set to start of invoiced month
n***@hush.com
2012-07-09 09:45:05 UTC
Permalink
A persistent problem I can't figure out:

I set up a new "invoice monthly" test account,
set the "next billing date" to 2012.2.2,
the "from date" to 2012.1.1,
the "to date" to 2012.2.1,
and, to give them a couple of weeks to pay,
the "payment due date" to 2012.2.16.
The generated invoice for January shows these dates.
Fine.
But the next invoice, generated on March 2 for the
month of February, shows the "payment due" as
February 1, i.e., earlier than the previous month
and a month earlier than the invoice date.
When an invoice is generated at the start of April
for the month of March, the same thing happens,
i.e. the payment due is March 1.
What I expect to happen is that the payment due
date for the second invoice is a mongth later than
the first, i.e., March 16, and the third invoice
is due on April 16.

But I can't get it to behave correctly and I can't
see what I might be doing wrong.

Has anyone seen this before?

Regards
Michael
Paul Yasi
2012-07-09 23:59:32 UTC
Permalink
The next billing dates are all based on the from date. Also if today
was january 1st and you are creating a bill now you should set the
next billing date to today's date, eg for a january invoice use
2012-01-01 as your next billing date for that first invoices. After
the monthly invoices is created it inserts new next billing dates,
from dates, and payment due dates by adding a month to the from date
of the invoice it just created.

Paul
Post by n***@hush.com
I set up a new "invoice monthly" test account,
set the "next billing date" to 2012.2.2,
the "from date" to 2012.1.1,
the "to date" to 2012.2.1,
and, to give them a couple of weeks to pay,
the "payment due date" to 2012.2.16.
The generated invoice for January shows these dates.
Fine.
But the next invoice, generated on March 2 for the
month of February, shows the "payment due" as
February 1, i.e., earlier than the previous month
and a month earlier than the invoice date.
When an invoice is generated at the start of April
for the month of March, the same thing happens,
i.e. the payment due is March 1.
What I expect to happen is that the payment due
date for the second invoice is a mongth later than
the first, i.e., March 16, and the third invoice
is due on April 16.
But I can't get it to behave correctly and I can't
see what I might be doing wrong.
Has anyone seen this before?
Regards
Michael
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Nathan Kirk
2012-07-10 01:56:21 UTC
Permalink
What would I need to do for daily billing? Is that possible in this code?

Nathan Kirk
Post by Paul Yasi
The next billing dates are all based on the from date. Also if today
was january 1st and you are creating a bill now you should set the
next billing date to today's date, eg for a january invoice use
2012-01-01 as your next billing date for that first invoices. After
the monthly invoices is created it inserts new next billing dates,
from dates, and payment due dates by adding a month to the from date
of the invoice it just created.
Paul
Post by n***@hush.com
I set up a new "invoice monthly" test account,
set the "next billing date" to 2012.2.2,
the "from date" to 2012.1.1,
the "to date" to 2012.2.1,
and, to give them a couple of weeks to pay,
the "payment due date" to 2012.2.16.
The generated invoice for January shows these dates.
Fine.
But the next invoice, generated on March 2 for the
month of February, shows the "payment due" as
February 1, i.e., earlier than the previous month
and a month earlier than the invoice date.
When an invoice is generated at the start of April
for the month of March, the same thing happens,
i.e. the payment due is March 1.
What I expect to happen is that the payment due
date for the second invoice is a mongth later than
the first, i.e., March 16, and the third invoice
is due on April 16.
But I can't get it to behave correctly and I can't
see what I might be doing wrong.
Has anyone seen this before?
Regards
Michael
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Paul Yasi
2012-07-10 06:40:49 UTC
Permalink
Billing the same customer every day would not be possible, it uses month
intervals. 1 month or multiple months.
Post by Nathan Kirk
What would I need to do for daily billing? Is that possible in this code?
Nathan Kirk
Post by Paul Yasi
The next billing dates are all based on the from date. Also if today
was january 1st and you are creating a bill now you should set the
next billing date to today's date, eg for a january invoice use
2012-01-01 as your next billing date for that first invoices. After
the monthly invoices is created it inserts new next billing dates,
from dates, and payment due dates by adding a month to the from date
of the invoice it just created.
Paul
Post by n***@hush.com
I set up a new "invoice monthly" test account,
set the "next billing date" to 2012.2.2,
the "from date" to 2012.1.1,
the "to date" to 2012.2.1,
and, to give them a couple of weeks to pay,
the "payment due date" to 2012.2.16.
The generated invoice for January shows these dates.
Fine.
But the next invoice, generated on March 2 for the
month of February, shows the "payment due" as
February 1, i.e., earlier than the previous month
and a month earlier than the invoice date.
When an invoice is generated at the start of April
for the month of March, the same thing happens,
i.e. the payment due is March 1.
What I expect to happen is that the payment due
date for the second invoice is a mongth later than
the first, i.e., March 16, and the third invoice
is due on April 16.
But I can't get it to behave correctly and I can't
see what I might be doing wrong.
Has anyone seen this before?
Regards
Michael
------------------------------------------------------------------------------
Post by Nathan Kirk
Post by Paul Yasi
Post by n***@hush.com
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
------------------------------------------------------------------------------
Post by Nathan Kirk
Post by Paul Yasi
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
Post by Nathan Kirk
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
n***@hush.com
2012-07-10 07:24:08 UTC
Permalink
Post by Paul Yasi
The next billing dates are all based on the from date.
....
Post by Paul Yasi
After
the monthly invoices is created it inserts new next billing dates,
from dates, and payment due dates by adding a month to the from
date
of the invoice it just created.
Thank you for replying, Paul.
You seem to be saying that what it is doing is correct.
But roll forward from your example: I issue an invoice on
2012-01-01. This must be for whatever the customer used
in the previous month, i.e., December. So the
n***@hush.com
2012-07-11 08:19:17 UTC
Permalink
Post by Paul Yasi
Post by Paul Yasi
The next billing dates are all based on the from date.
....
Post by Paul Yasi
After
the monthly invoices is created it inserts new next billing
dates,
Post by Paul Yasi
from dates, and payment due dates by adding a month to the from
date
of the invoice it just created.
Thank you for replying, Paul.
You seem to be saying that what it is doing is correct.
But roll forward from your example: I issue an invoice on
2012-01-01. This must be for whatever the customer used
in the previous month, i.e., December. So the
Loading...