Billing Rerun issue

Asked by gary on 2010-03-02

Hello Paul,
                We have been using this software for so many years and very grateful. I realised when CC transaction fails and we do rerun customer, system do the double billing instead of one. What i believe is because of 2 billing tables.
can you please tel what me where to fix this.

Question information

English Edit question
citrusdb Edit question
No assignee Edit question
Last query:
Last reply:

This question was reopened

  • 2010-03-05 by gary
Paul Yasi (paul-citrusdb) said : #1

What version are you using? I've never seen this in production, and I have rerun's all the time. A rerun is independent of the normal next billing date and it will only run old billing items. The one time when a customer will be charged for both old and new charges is if they reach their next_billing_date. Newer versions of citrus should give an error when the next billing date matches the rerun date so rerun's won't get duplicate marks since they have reached their next billing date anyway and will be charged for their past and current charges.

Paul Yasi (paul-citrusdb) said : #2

One thing it does do is create a new invoice for the rerun amount, so it moves information off the old invoice onto a new one, leaving you with an old blank invoice. Is that what you are seeing? This is done since sometimes a rerun will include multiple items from different past invoices. This is something that can be confusing and I would like to get rid of at some point, however I have not yet figured out a way to get around it and still have accurate bill amounts.

gary (gaurav10feb) said : #3

OK i might too some research on this and get back to you. mean while when i do the credit card process even if CC declined it send an tax invoice saying that transaction has processed...anything on this?

gary (gaurav10feb) said : #4

Hello Paul,

COming back to rerun is what i found....In billing tab when Amount due is coming from billing details table , by subracting the total of billed amount with total of paid_amount which is correct.
But rerun picks the amount due from billing history total_due.....which is not always same as amount due as customer might have paid after the last invoice issued....i think i made it clear...

Paul Yasi (paul-citrusdb) said : #5

I'm not sure what you are referring to. Since version 1.3.1 clicking Rerun shows a list of items billed in the past that have not been fully paid and allows you to choose if you want to run all the items or only certain ones.

Can you help with this problem?

Provide an answer of your own, or ask gary for more information if necessary.

To post a message you must log in.