Cashflow

Cashflow Manual · Chapter 4

How to create Payment – Cashflow for Vtiger CRM

In the following sections you can find short description of the payment and how to create your first payment for vtiger CRM using Cashflow. As was already mentioned, the Cashflow allows you to track incoming payments that you will receive from customers or outgoing payments you will have to make in the future. The payment consists of more or less twenty fields, but to create the new payment only following 4 are required:

Name Description
Payment Name Payment Name; used to distinguish payments.
Payment Type Type of the payment. Can be only incoming or outgoing.
Amount The amount of the payment
Due Date The data until the payment has to be paid or is expected

Table 1: Required fields for payment creation

The payment
The payment

The fields mentioned in the Table 1 are enough to be filled in order to create simple payment but they are not sufficient to utilize the real potential of the Cashflow. Using additional fields you can simply refer the payments to entities of other modules (INV, SO, PO, CN, PI, OP), check the status of payment (invoice) or define payment category to have better view of your business.

Name Description
Reference Reference to invoice, sales order or purchase order. (Not required)
Payment Date Real date of payment.
(most important field for Cashflow based on this field is set Payment status)
Payment Status Status automatically defined based of Due Date and Payment Date.
  • Received (incoming payment and Payment Date <= actual date)
  • Waiting (incoming payment and Payment Date > actual date)
  • Paid (outgoing payment and Payment Date <= actual date)
  • Waiting(outgoing payment and Payment Date > actual date)
Payment Category,
Payment Subcategory
(Sub)Category of the payment. User editable field.

Table 2: Fields for payment creation

Within the module Cashflow you are able to create payments without any reference (also called “Other” payments) or payments with references. The following picture describes the references between Cashflow and other vtiger CRM modules and type of references for modules:

  • Invoice – there are three possibilities how to create payment for invoices:
    • 1:1 – one payment for one invoice
    • M:1 – more payments for one invoice – used for advanced payments
    • 1:N – one payment from one organization to pay more invoices at once
  • Sales Order, Purchase Order, PreInvoice, CreditNotes, Opportunities – there are just two
    possibilities to create payment:
    • 1:1 – one payment for one sales order, purchase order, preinvoice, creditnote,
      opportunity
    • M:1 – more payments for one sales order, purchase order, preinvoice, creditnote,
      opportunity – used for advanced payments

The Cashflow4You takes care also in case of payment(s) for sales order and additional payment(s) for related invoices. This scenario is described in details in the chapter (4.5 SO – payment – INV – payment scenario).
In addition to above mentioned references, the payments can refer to Organization or Vendor as well. Two approaches exist to assign the payment towards Organization (or Vendor):

  • automatic creation of the reference – information about Organization is taken directly from Invoice, Sales Order, PreInvoice, Credit Note, Opportunity; for Vendor the information is taken from Purchase Order
  • manual creation of the reference – you can assign each payment to Organization or to Vendor according to your needs, i.e. you can assign payments to Organization or Vendor although the payment is without any reference to INV, SO,PO, PI, CN or OP.

Creating payment
In order to create the Cashflow4You payment you can use following three approaches:

  • Cashflow Payments button – from the DetailView of the modules INV, SO, PO, PI, CN; very quick approach which pre-defines the fields based on related INV, SO, PO, PI or CN
    records (The creation of the payment or partial-payment from payments block)
  • The creation of the multi-payment for more invoices – this is used to create one payment for more invoices in one step (The creation of the multi-payment for more invoices)
  • The basic creation of the template from Cashflow4You ListView – the payment is created from scratch, i.e. you have to define all necessary fields according to your needs from the beginning (The basic creation of the template from Cashflow4You ListView)

4.1 The creation of the payment or partial-payment from DetailView of record

The Cashflow Payments button is available inside the DetailView of the modules Invoice, Sales Order, Purchase Order, PreInvoice and Credit Notes. As already mentioned, the payment or partial-payment can refer to records from these modules. This makes creation of the payment and partial-payment much easier. In order to create the payment using Payments block please provide following steps:

  1. Go to the DetailView of the module Invoice or Sales Order or Purchase Order or PreInvoice or Credit Notes according to your needs and click on More button – The creation of the payment or partial-payment from DetailView of record button and select Add Payment or Payments.

    Add payment from DetailView
    Add payment from DetailView

  2. If you click on Add Payment skip to step 3. If you choose Payments you can see Cashflow block with info about previous Payments. Click on Create payment button – The creation of the payment or partial-payment from DetailView of record

    Payment block
    Payment block

  3. The EditView will appear on the screen. As you can see below the fields Payment Type, Amount, Due Date, Payment date (actual date) and references to invoice (SO, PO, PI, OP, or CN) and organization or Vendor are already available and based on fields from related record. Fill in at least all missing required fields. You can also define Payment Category and Payment Subcategory. Save the payment.

     Creating Payment from DetailView of Invoice (SO, PO, PI, CN, OP)
    Creating Payment from DetailView of Invoice (SO, PO, PI, CN, OP)

Please refer also to chapter Payment block for more details regarding block Payments.

4.2 The creation of the one payment for more invoices

Especially for module invoices the Cashflow brings the possibility to assign one payment towards more invoices. This functionality is available only for Invoice module. This possibility is useful in case that one organization sent payment at ones for more invoices. Such payment can be created only from ListView of the module Invoice:

  • Go to the ListView of the module Invoice and select two or more invoices. Click on More button and choose Create Payment.

    ListView of Invoice
    ListView of Invoice

  • The Create Payment window will appear on the screen. As you can see below the fields Payment Type and Amount are already available and based on fields from related Invoices. Save the payment using button
    How to add one payment to more Invoices
    How to add one payment to more Invoices
    • New functionality you can use when Amount is less than Summary of Invoice’s Total. Standard behavior of Cashflow is that Cashflow try to use Amount to balance Invoice in Order.
      Split amount in order
      Split amount in order

      But now, you can prioritize Invoice by using check-box Pay Off.

      How to change distribution of amount
      How to change distribution of amount

  • In the More Information part of Payment you can find references to these Invoices.

    References to Invoices in DetailView of multi-payment
    References to Invoices in DetailView of multi-payment

The Amount and all particular payments are editable in case you want to define them according to your needs. Currently there is restriction that Amount <= Sum of all payments i.e. final Balance has to be zero. Please note that Due Date is not prefilled because can be different for more Invoices. You have to define your own date in this case.

4.3 The basic creation of the payment from Cashflow ListView

This approach will be used by users mostly for payments which are not related to any invoice, sales order or purchase order, i.e. to “other” payments. In order to start creation of the template provide following steps:

  • Go to the Cashflow ListView and click on button Add payment button – The basic creation of the payment from Cashflow ListView.

    Cashflow ListView
    Cashflow ListView

  • The EditView will appear on the screen. Fill in at least all required fields. You can also define Payment Category and Payment Subcategory. Please note that you can define your own values for these fields. Save the payment.

    Basic creation of the payment
    Basic creation of the payment

Need help with Cashflow?

Our support team answers questions about installation, templates and settings.