[freeside-users] Payment batches not working in freeside 4.1

[Amitay Isaacs]

Hi,

Thanks for the pointers.

freeside-daily was run without any options.  However, after enabling debug
option (-v), it became clear why the payment batches were not created.
Here's is an excerpt of output from freeside-daily -v:

----------------------------
 [FS::cust_main::Billing] due_cust_event called with options stage:
collect, check_freq: 1d, time: 1490967001, debug: 1
  6 total possible cust events found in initial search
  0 cust events left satisfying conditions
    invalid conditions not eliminated with condition_sql:
      cust_bill_has_noauto: 1
      payby: 6
----------------------------

There are 2 invalid conditions listed.

cust_bill_has_noauto:

   This relates to part_pkg table having no_auto empty.  (ut_flag()
definition treats NULL same as 'Y')
   Do I need to update the relevant part_pkg entries with no_auto='N'?

payby:

   I don't understand this invalid condition.  Probably relates to the
billing event below.

The log made it clear that none of the billing events were getting
triggered.  Adding payments to payment batches is the first event.

Here's the definition of 1st billing event:
-------------------------------------------------------------------------------------------
#   Event           Type      Check freq.
1  Batch Card    Invoice       daily

Conditions
  Don't run this event again after it has completed successfully
  Customer Balance (Balance over:0)
  Amount owed on specific invoice (Amount owed over:0)
  (Deprecated) Customer payment type (payby:CARD)
  Invoice eligible for automatic collection

Action
  Add card or check to a pending batch
-------------------------------------------------------------------------------------------

The condition "Customer payment type" is deprecated in 4.1.  This
definitely worked in 3.4.
What's the equivalent option in 4.1?

Also, are there default billing events for 4.1?

Amitay.


On Thu, Mar 30, 2017 at 4:45 AM, Erreu Gedmon <eg at keyway.net> wrote:

> What switches are you using with freeside-daily? If you are using -p you
> will need to remove it:
>     man freeside-daily
>          -p: Deprecated, will produce a fatal error (formerly was: Only
> process customers with the specified payby (CARD, DCRD, CHEK, DCHK, BILL,
> COMP, LECB))
>

> Do payment batches work when you execute them manually with Tools,
> Billing, Process payment batches?
>
> Also, after enabling Configuration, Settings, event_log_level, debug and
> executing freeside-daily are there any related errors in: Reports, Logs,
> System Log
> Reports, Logs, Billing Events
> /var/log/apache2/error.log
> /var/log/apache2/access.log
> /var/log/messages
> /usr/local/etc/freeside/*log*
> /var/log/syslog
> /var/log/postgresql/*log
> /var/spool/mail (or wherever cron emails errors to)
>
> Erreu Gedmon
>
> --
> "You see persons and things not as they are but as you are."
>         -- Anthony De Mello
>
> On 03/29/2017 02:07 AM, Amitay Isaacs wrote:
>
> Hi,
>
> Ever since the upgrade to 4.1, payment batches feature does not seem to
> be working.  I have verified that in the settings for "Payment batching"
> "batch-enable_payby" and "batch-default_format" are configured.
>
> Also, freeside-daily script has been running every day for more than a
> week now.  However, I don't see any new payment batches being created.
>
> After the upgrade to 4.1, I did notice the following warning message.
>
>   FS::part_event::Condition::payby is disabled; skipping
>
> Is this related to why payment batches are not working?  If yes, how do
> I fix it?  If not, is there any additional settings required to enable
> payment batches in 4.1?
>
> Thanks.
>
> Amitay.
>
>
> _______________________________________________
> freeside-users mailing listfreeside-users at freeside.bizhttp://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20170402/aa52a2ef/attachment.html>