manaTec Payment Workflow Extension

Custom Payment Workflow for Sales Orders (Payment on Sales Order)

Documentation

This module includes an additional PDF documentation in german here

Dieses Modul enthält eine zusätzliche PDF-Dokumentation auf Deutsch hier

Configuration

Payment on Sales Order Workflow

• This feature has to be enabled in the settings of the journal, you want to use it.
• Enable the checkbox and select a possible payment acquirer or use the button 'Enable & Generate' to do both in one step
• Every journal needs a separate payment acquirer of typ 'wire transfer', because you have to select the specific journal in the payment acquirer

Auto Invoicing

• This feature can be enabled under Sales/Configuration/Settings
• It has to be enabled separately for every company

Functionality

Payment on Sale Order Workflow

• When posting a bank statement, this extension try to map the lines to open sale orders (payments and credit notes)
• For the matched sale orders a new payment transaction is created with the corresponding amount
• The matching can be changed manually by a wizard (opens when clicking on the matching state)
• When confirm the matched payments, the payment transactions will be set to done and Odoo will create a payment by default (Odoo standard)
• Confirmed payment transactions can usually not be changed anymore, but there is a new button display only in debug mode on the payment transactions to change or remove linked payment transaction
• The payment transaction are linked in the sale orders and a new payment state display the current payment state of the orders
• When creating an invoice the payments transactions are automatically linked to the invoice and the invoice will be directly marked as paid

Auto Invoicing

• This feature creates invoices automatically for sale lines ready to invoice
• The feature is triggered by a cron every x minutes
• It has to be enabled separately for every company
• An additional option can be enabled to automatically post the generated invoices (only invoices, not for credit notes)

Extension for already existing payments (imports from Magento or done directly by Odoo)

• During mapping of statement lines, Odoo will check if already payment transactions with the same transaction ID (field 'Online Transaction Identifier') exists and link them if possible
• In journal of the statement the option for sale order mapping has to be enabled and the payment acquirer must linked

Changelog

14.0.1.0.1

• FIX: field 'Online Transaction Identifier' should be editable

14.0.1.0.2

• Display field 'Partner Name' in bank statement line
• Add field 'Partner Name' to mapping wizard

14.0.1.1.0

• Display error with matching found a payment transaction with a different amount
• Improve handling with linked existing confirmed transaction in bank statement (distinction between whether a transaction is created and confirmed or linked an already confirmed transaction)

14.0.1.2.0

• Add new "Duplicate and cancel" feature for sales orders (duplicate the sales order and cancel it)
• Client Order Ref and Payment transactions are moved to the new sale order
• A confirm dialog is displayed before the action, which shows additional warnings if already a delivery is done or an invoice exists.

14.0.1.3.0

• Add new feature to create payment transactions manually from sales order
• The feature can be enabled in the settings of sale module: checkbox 'Create Payment Transaction Manually'
• After confirmation of the sales order a new button appear which opens a wizard to create a payment transaction
• In the wizard the payment acquirer and the amount can be selected for the payment transaction

14.0.1.3.1

• FIX wizard create payment transaction manually: payment acquirer not selected correctly

14.0.1.3.2

• FIX wizard create payment transaction manually: payment acquirer not selected correctly

14.0.1.3.3

• Use float_compare when comparing amounts to avoid float rounding issues
• Create warning activity for sale order when unassigned amount becomes negative

14.0.1.3.4

• Use float_compare when comparing amounts to avoid float rounding issues (II)
• Improve handling of matching errors: if matching wizard is confirmed and a sale order is selected --> call create with flag ignore_errors

14.0.1.3.5

• Fix problem when transaction has a payment transaction ID and field online_transaction_identifier is used differently (online synchronization)
• Add new field for optional payment transaction reference in bank statement line

14.0.1.4.0

• Add new wizard to also can change assignment of transaction to other sale order when transaction is not linked to any bank statement line
• Add field narration (notes) from bank statement line to sale order mapping wizard

14.0.1.4.1

• Add new server action to bank statement to remove transaction mappings (in state 'open') for all lines with one click

14.0.1.4.2

• Do not create warning activity if only the payment amount is reduced and unassigned amount is still positive

14.0.1.4.3

• Bugfix in _create_invoices

14.0.1.5.0

• Add new option to define a tolerance range for payments and is considered for the delivery payment restriction

14.0.1.6.0

• Change restriction for feature "Create Payment Transaction Manually":
• Settings Checkbox is now company dependent
• Additional to this checkbox the user have to be in the corresponding group ("Create Payment Transaction Manually") to see the button in the sales order

14.0.1.7.0

• Add new feature to book payment differences on customer invoices automatically
• Feature is company dependent and can be activated in sale configuration
• Automatic booking is controlled by 2 reconcile models for underpayment and overpayment
• Payments entered manually via wizard in invoices are ignored because there is a dedicated option in the wizard for this

14.0.1.8.0

• Improve creating invoice extension (link transactions and auto post) for multi invoice creation (group and not grouped)
• Down payment invoices: also link transactions to invoice and add support for the auto post invoice feature
• If payment transaction is created after the invoice, also link transactions with open invoices (e.g. Cash on Delivery)
• Improve auto invoicing feature:
• Only create invoices in safe situations (no refunds exists on the line to avoid wrong oder double invoicing)
• Create warning activity at sale order when order can be invoiced but cron does not can create an invoice
• Restrict auto posting of invoices to the auto invoicing feature

14.0.1.9.0

• Add new option to disable automatic confirmation of paid sales orders
• Only send order confirmation mail when order is confirmed (sometimes recording payment can trigger this)

14.0.1.9.1

• Display button "Create Payment" in sales order already in states draft and sent
• Disable change order state to 'sent' when a payment is added in state draft
• Disable automatic sending of sale confirmation mail when a payment is added (otherwise confirmation mail is sent twice, because it will send again when payment processed by post payment cron)

14.0.1.9.2

• Show paid amount and difference to total amount in a sale order

14.0.1.9.3

• Fix development of residual amount in sales order

14.0.1.10.0

• Payment matching with bank statements now is considerably more extensive in which entries it attmepts to match
• To prevent over-matching, exclusion rules can be defined that cause a bank statement line to be ignored by the match algorithm

14.0.1.11.0

• Add new option (Match via linked Payment Transaction) to reconcile models to use the linked payment transaction for matching the payment move line
• FIX problem: payment was not created for credit transactions (Odoo has fixed the origin problem which was the reason for this customization)
• Reconcile payment transactions of a sale order with each other to correctly handle bookbacks (payments with negative amount)

14.0.1.11.1

• Fix bug in reconcile payment transaction with each other (filter that payments have to be in state posted)

15.0.1.12.0

• Migration to v15
• Add new separate group to enable/disable for copy-and-cancel feature on sales orders
• Remove dependency to sale_stock module

15.0.1.12.1

• Consider invoices in matching logic, if no sales order is directly found and match with the linked order of the found invoice
• Restructure code of matching logic, so that it is easier to adjust this code later if necessary

15.0.1.12.2

• Sale Order: "Register payment" Button can now be used on canceled orders.
• Improve matching sales order feature: consider current company and escape search wildcards

15.0.1.12.3

• Bank statement: remove not necessary field payment_transaction_ref on statement line
• Invoices: Remove link to payment transactions when cancel an invoice to avoid error when reconciling transactions
• Payment Transaction Mapping: When cancel reconciled payment transaction check if bank statement has not been validated and undo the current reconciling

15.0.1.12.4

• Payment acquirer: show fields for done and canceled message also for type manual transfer
• Automatic Invoicing: move filtering of invoices to post to a separate method
• Sales Order Matching: Set matching state to none if line is skipped by the exclusion criterion
• Sales Order Matching: Add action to skip all open mappings with one click
• Sales Order Matching: Improve action 'Remove Transaction Mapping'
• Payment Transaction: Remove Debug-Mode from the additional buttons in transactions as in v16

15.0.1.12.5

• Sales Order Matching: Fix bug with displayed columns of matched sales orders

15.0.1.12.6

• Sales Order Matching: Fix bug with displayed columns of matched sales orders

15.0.1.13.0

• Allow that currency of order can be deviate from the statement line
• Add new settings for currency tolerance to configure the allowed deviation when matching bank statement lines and sales orders with different currencies
• Automatically created payment transactions from matching have the residual amount of the order and not the converted amount if the difference of them is within the currency tolerance