How to deduct/offset credit note on future invoices?

Make sure to familiarize yourself with this topic first: https://xtrf.userecho.com/knowledge-bases/6/articles/163-how-to-create-credit-notes


Unfortunately, there is no fully automated process to deduct Credit Notes from future Invoices, however the below solution can be proposed:  

  1. Create 2 categories for invoicing for Client Invoices: Credit Note – resolved and Credit Note – unresolved.
  2. Create a view in the Invoices module that shows only documents marked with the Credit Note – unresolved category.
  3. In the project where you want to issue a credit note you create a New Task (language independent one with Empty Workflow, set to be Invoiceable). Force Status to Ready in Jobs tab.
  4. In this task, create a Receivable where quantity will be "1", and Rate will be "-100". Job type may be "translation" or whatever really but you may want to enter "Credit Note" in the receivable's Description field. Alternatively, you can create new Job Type named "Credit Note" and use it. (The following article explains it in detail: https://xtrf.userecho.com/knowledge-bases/6/articles/163-how-to-create-credit-notes)
  5. In Finance tab, create an Invoice. Create Items using Add an Item for Each Task Receivable button. The invoice will have negative total.
  6. Categorize the invoice as Credit Note – unresolved.
  7. Select the template – you will need a custom document template first, if you wish to send credit notes as a PDF with positive total.
    After sending such an invoice to Client, its Payment Status will be shown as Fully Paid. Therefore:
  8. When invoicing Client next time, open the view you created in step 2. Check this view to see if the Client has any credit that needs to be offset when you create an invoice.
  9. To include the negative item on a normal invoice, manually add an item like this:




    This adjusts the Net and Gross Total of the invoice accordingly:



  10. To mark a credit note as offset, change its category to Credit Note – resolved.

This article was helpful for 1 person. Is this article helpful for you?