Apply credit balance to overdue invoices

Knowledge Center > Workflow > Workflow Use Cases > Apply credit balance to overdue invoices

Apply credit balance to overdue invoices

If the policy of your organization is to apply available credit balances to overdue invoices, you can create a workflow to search for qualified accounts and perform the operations for all qualified accounts together.

In this article, we'll use a standard workflow to apply credit balances to overdue invoices. 

Available templates

Invoicing > Positive Account Credit Balances to Invoices Limit 1

Workflow overview

workflow_template_apply_credit.png

The workflow consists of three tasks. 

  1. Export: Exports data about accounts that have positive credit balances and overdue invoices at the same time. Related invoices are also exported. 
  2. Iterate: Iterates unique accounts.
  3. Create: For each unique account, creates a credit balance adjustment to apply the credit balance to the related invoice. If the credit balance is greater than the invoice balance, the amount that is equal to the invoice balance will be applied. If the credit balance is less than the invoice balance, the full amount of the credit balance will be applied. 

Configurations 

  • After a successful test run, you can remove "Limit 1" in the query in the Conditions tab of the export task. 
  • If you want the workflow to be run regularly, configure a schedule for the workflow.
Last modified

Tags

Classifications

(not set)