OdooVarse

Account Statement Configurations.

Customer Filter Statement Flow

Go to the customer => customer statement.

You can filter statements, So select the filter option 'This Month'.

Select the type of the customer statements like 'Not paid, paid, In payment, Partially paid, Reversed, or Invoicing app legacy'.

Press 'Get Customer Statement'.
You can send filter statements by mail, so press 'Send Filter Customer Statement' and press 'Print Filter Customer Statement' to print filter customer statement.
You can also send filter statements by whatsapp.

Customer filter statement sent by mail.
Email statement form view.

You can see the statement attachment from an email.

The statement looks like this.

Customer Statement Flow

Go to the customer => customer statement, press 'Send Customer Statement' to send the statement by mail and press 'Print Customer Statement' to print the statement. You can also send filter statements by whatsapp.

Customer filter statement sent by mail.
Email statement form view.

You can see the statement attachment from an email.

The statement looks like this.

Customer Overdue Statement Flow

Go to the customer => customer statement, press 'Send Overdue Customer Statement' to send the statement by mail and press 'Print Overdue Customer Statement' to print the statement.

Customer filter statement sent by mail.
Email statement form view.

You can see the statement attachment from an email.

The statement looks like this.

Customer Account Statement/Overdue Statement Mail Log History Flow

The statement log history configuration, you can see mail log history from the 'See all mail log history'.

Customer Statement Quick Send & Print Flow

The statement log history tree view.

Statement log history form view.

You can filter and group by statements by the provided list.

You can print statements from the 'Action'.

You can send a statement/overdue statement from the 'Action' button.

Customer Auto Send Statement/Overdue Statement Flow

Customer auto-send statements/overdue statements configuration.

You can weekly auto-send customer statements.

You can monthly auto-send customer statements, you can select monthly days.

You can auto-send customer statements by end of the month.

You can yearly auto-send customer statements.

You can send statements by scheduled action(cron job).

Customer Portal Statement Flow

Now tick 'Show Customer Statement Menu In Portal'.

After go to the portal => customer statement.

You can get customer statement from the port.

You can download customer statements from the portal.

You can download customer overdue statements from the portal.

You can send customer statements from the portal.
It shows a popup after successfully send customer statements.

The statement sent by mail.
Email statement form view.

You can see the statement attachment from an email.

Customer Statement XLS Report

You can print an XLS report of the customer filter statement.

Customer filter statement XLS report looks like this.

You can print an XLS report of the customer statement.

Customer statement XLS report looks like this.

You can print an XLS report of the customer overdue statement.

Customer Overdue statement XLS report looks like this.

You can 'Download Filtered Statement XLS' from the portal.

You can download the customer overdue statement XLS report from the portal.

Opening balance in customer statements.

Go to invoice setting >> Enable the 'Account Statement Auto Send Configuration' according to your preferences.
Select the "Filter Only Unpaid, Send nothing if all invoices are paid."

Here, you can see the customer form view.
In the customer statement tab, you have the option to filter customer statements based on specific time periods, such as monthly, quarterly, yearly, or custom.