Auto Action that will fire ONLY on the following recurring payments but not on the first one

What do you think? Could it be improved?

For the invoice number I'd of just had a single query field calculate the next invoice number and used it in CBSubs > Settings > Display > Invoices as there's less chance of an existing invoice being accidentally incremented if the trigger fires in an unexpected scenario. Should be fine though as long as your tests are looking ok.

krileon wrote: For the invoice number I'd of just had a single query field calculate the next invoice number and used it in CBSubs > Settings > Display > Invoices as there's less chance of an existing invoice being accidentally incremented if the trigger fires in an unexpected scenario.

The problem is that you are not sending to PayPal the invoice number but the proforma invoice number.

You can specify the format for both. You should be able to use substitutions in both as well. Change "Numbering of invoices" to "Proforma invoice number at order time, then different final invoice number once paid" and you can specify the per proforma invoice number format in addition to invoice number format.

That option is already set as you are saying, both:

"Increment each consecutive Proforma Invoice [NUMBER] by"

AND

"Increment each consecutive Invoice [NUMBER] by"

are set to 0.

What I'm talking about is that you are sending the `proformainvoice` number to PayPal instead the `invoice` number and if I set the `proformainvoice` number to 1 every time someone creates a basket that number is changed and the wrong number is sent to PayPal.

The below should work to allow a CB field to act as the invoice number. The CB field you'd use is a query field that calculates the invoice number. It would always need to return the next invoice number.

Proforma Invoice number format: [cb:userdata field="FIELD_NAME" /]
Invoice number format: [cb:userdata field="FIELD_NAME" /]

Please provide a screenshot of your invoice numbering format.

Here you are:



For me it is not a problem now as I've kind of turned off your invoices numbering and made my own with the 3 UPDATE queries in the autoAction I've posted above.

Now I've noticed a bigger problem: the invoicing fields are mandatory but if the user doesn't change any of the pre-populated invoicing fields nothing gets saved in the CB invoicing fields. And because I'm including them fields in the emails with your substitutions, namely:

[cb_subs_inv_payer_business_name]
[cb_subs_inv_first_name]
[cb_subs_inv_last_name]
[cb_subs_inv_address_street]
[cb_subs_inv_address_city]
[cb_subs_inv_address_state]
[cb_subs_inv_address_zip]
[cb_subs_inv_address_country]
[cb_subs_inv_contact_phone]
[cb_subs_inv_vat_number]

I get empty results and that information is missing in my email invoices.

Could you advice how to workaround that issue please?