Compensations with the use of the buttons [Combine]/[Compensate]

Compensation allows for registering mutual deduction of receivables/due payments, that is for creating associations between receivables and payables of a given entity or their group.

Compensations can be made by registering a compensation document with the use of the button [Combine] or [Compensate].

To be able to make compensations in all available places of the system, it is necessary to, from the level of Configuration → Operator Groups → edition of specific operator group → Other Permissions, check parameter Making of compensations. The possibility of reading, modifying or deleting compensation depends on checking parameters available from the level of Configuration → Operator Groups → edition of specific operator group → Other Permissions → Compensation. To be able to compensate all objects (transactions/payments), the user must be entitled to read payments and cash/bank transactions.

Compensation with the use of the button [Combine]

It is possible to compensate a payment with the use of button [Combine] from the level of:

  • cash/bank transaction details
  • payment details

The mechanism of making compensation is the same both from the level of transaction details as from the level of payment details. In order to make a compensation from the level of transaction details, it is necessary to:

  • edit the form of a given transaction
  • check Compensation parameters which is available over the list of documents to complete. After checking the parameter, transactions of the opposite type will be displayed on tle list Documents to Be Paid. It means that in case of completing a transaction of revenue type, additionally, all uncompleted transactions of expense type will be displayed on the list and in case of completing a transaction of expense type, all uncompleted transactions of revenue type will be displayed on the list.
  • on the list of documents to be paid, check toe transaction with which the edited document has to be compensated
  • click on the button [Combine] placed in the Payments group of buttons. The same effect can be obtained by double-clicking on a given transaction/payment.

After making a compensation, a document completing a given transaction appears on the list Documents to Be Paid. Additionally, if such document has been paid in full, it will not be displayed on the list Documents to Be Paid anymore.

Note
Payments and cash/bank transactions which values equal to zero are not displayed in this panel.

Note
On the list Documents to be paid, there are only payments/transactions relating to the entity whose payment is currently being compensated.

Parameter Compensations and button [Combine] on transaction

Compensation with the use of the button [Compensate]

It is possible to compensate a payment with the use of button [Compensate] from the level of:

  • payment estimate
  • cash/bank transaction details
  • payment details
  • list of customer and vendor payments
  • list of receivables/payables

The mechanism of making compensation is the same for all the levels.

In order to compensate a payment from the level of the payment estimate, it is necessary to mark it on the payment list and select the button [Compensate]. It opens the list of all open payments of opposite type associated with the same customer/vendor from which it is necessary to select documents to be compensated.  After selecting a payment, it is necessary to click on the [Combine] button.

The list of open payments is displayed after clicking on the [Compensate] button.
Example
In the system there are invoices issued for the customer ABC: SI/2019/001 amounting to 200 USD and PI/2019/KR/002 amounted to 320 USD.  Under an agreement with the customer, it was set that payments from those invoices will be compensated. Therefore, the following actions must be performed:

  • Highlight the invoice SI/2019/001 on the list
  • Click on the button [Compensate] placed in the Payments group of buttons
  • On the created list of open transactions of the entity, find and highlight the invoice PI/2019/KR/002
  • Select the button [Combine] from the Transactions group of buttons

As a result of these actions:

  • Payment for the invoice SI/2019/001 is completed entirely
  • Payment for the invoice PI/2019/KR/002 is completed entirely
  • The completed amount is 200 USD
  • The amount to be applied is 120 USD

 




List of compensation documents

Compensation documents allow for registering mutual deduction of receivables/due payments, that is for creating associations between receivables and payables of a given entity or their group.

The functionality of registering compensation documents is available only if on the definition of the company the parameter Register compensations is checked. The parameter is:

  • unchecked on databases in Polish language version, with a possibility to check it at any moment
  • unchecked on databases in English and German language version, with a possibility to check it at any moment
  • unchecked on databases in French and Spanish language version, without a possibility to check it

Parameter Register compensations on a company form

The list of compensation documents is available from the level of Finances, under the button [Compensations].

A compensation document is visible on the list, if:

  • was issued by the center to which the user is currently logged−in
  • it was issued by a center which is subordinate to the current center
  • it was added by a center which makes it available (by specifying its visibility for document types) for the current center or a center which is subordinated to the current center

The list contains standard buttons which have been described in article <<Standard buttons>>.

List of compensation documents

The list is composed of the following columns:

  • Document Number
  • Date of Issue
  • Date of Compensation
  • Entity Code
  • Entity Name
  • Address − address of the entity indicated on the compensation
  • Value – compensation amount
  • Currency
  • Status − compensation document status (Initiated, Unconfirmed, Confirmed, Posted, Canceled)

And columns hidden by default:

  • Reference Number − number entered by a user for providing an additional identification of a document
  • Compensate Documents − allows for filtering compensation documents by the value of the parameter Compensate documents
  • Owner − center of the company structure which is the issuer of a document

 

Detailed description of functioning of the filters can be found in category <<Searching and filtering data>>>




Compensations in different currencies

In the system, it is possible to compensate transactions denominated in different currencies, that is to compensate transaction denominated in system currency with a transaction denominated in a foreign currency.  When compensating documents denominated in different currencies, an exchange rate difference is not calculated.

Compensation of transaction in different currencies is available from the level of:

  • cash/bank transaction form (button [Compensate] in the tab Payments)
  • list of customer and vendor payments
  • payment estimate

Example
A CD transaction amounting to 1 000.00 USD at the exchange rate of 1USD = 4.30 PLN was registered and and a CW transaction amounting to 700,00 PLN. The transactions have been compensated, as a result of which:

  • The CW transaction is entirely completed
  • The CD transaction is partially completed
  • Compensation amount in the system currency 700, 00 PLN (the amount of the transaction amounting to a lowe value)
  • Compensation amount in the foreign currency (USD): 700 PLN/4.30 PLN = 162.79 USD
  • Amount to be paid in the system currency: 4,300 PLN – 700 PLN = 3,600 PLN
  • Amount to be paid in the foreign currency (USD) 700 3,600.00/4.30 PLN = 837.21 USD



Generation of a compensation document in the payment estimate

The user may generate a compensation document directly in the payment estimate. In order to do so, it is necessary to select from the list all payments/transactions which are to be compensated and select the option [Compensate] available in the Generation section. The system will open a window in which the user may select a date of compensation (by default, the system prompts the current date) and one of the following options:

  • Collective compensation document − generates and opens a collective compensation document with Initiated Such document can be created only if selected payments are expressed in the same currency and were issued in the company to which the user is logged-in. In case payments regarding only one entity are selected for compensation, on the side panel of generated document, this entity will be indicated and in the tab Payer, its data will be displayed. If payments for many different entities are, compensation document will be created without entity on it.
  • Individual compensation documents for entity − individual and unconfirmed compensation documents will be generated for each entity and currency. Such documents will be created only for payments issued in the company to which the user is logged-in.

Window for generating compensation

After indicating the date and selecting the option [Confirm], a compensation document is generated and opened. The following fields can be edited:

  • Reference Number
  • Content
  • Owner
  • Description
  • Date of Issue
  • Confirmation Date
  • Compensate Documents parameter

 




Registration of deduction from the level of cash/bank transaction

During application of a cash/bank transaction, it is possible to include a deduction for uncompleted payments of the opposite type and for correcting invoices. A deduction can be registered by associating documents directly or through a compensation document. A cash/bank transaction can be associated with already existing compensation or with a document that is generated directly from the level of the transaction during its application.

Deductions can be applied only by operators who are assigned to an operator group that is entitled to this operation (menu <<Configuration → Company Structure → Operator Group → edited operator group → tab Other Permissions, selected permission Taking account of deductions during payments>>).

During creation and conversion, that parameter is:

  • activated and editable by default at any time for the operator group that is entitled to making compensations (menu Configuration → Company Structure → Operator Group → edited operator group → tab Other Permissions, selected permission Making of compensations)
  • deactivated and not editable by default for the operator group that is not entitled to making compensations

A deduction can be registered after selecting the button [Complete] or [Compensate] during registration or edition of a cash/bank transaction. In order to register a deduction via the button [Complete], it is necessary to:

  • select the button [Complete] from the Payments button group on the form of cash/bank transaction to invoke the list of open payments
  • select the parameter Show payments of the opposite type – then the open payables will additionally be displayed on the list of receivables, whereas open receivables will be displayed on the list of payables
  • indicate on the list the payments whose deduction must be registered
  • select one of the options: [Compensate Selected] or [Generate Compensation] from the button group Deductions

Selecting the option Compensate Selected completes a payment of the opposite type directly. This function is analogical to the function <<Making payment with the use of [Combine Selected] button>>.

Option Generate Compensation is used to complete a payment through an automatically generated compensation document. Before a compensation is generated, a window is opened, in which it is possible to specify a compensation date and whether to apply a current transaction to the compensation.  The process of compensation generation is the same as the one described in chapter <<Generation of a compensation document in the payment estimate>>.

A deduction registration mechanism using the option [Compensate] is the same.

Note
Payments of the opposite type are on the list opened with the button [Complete] or [Compensate] presented with an opposite sign in columns: Amount, Amount Remaining, Completed with an opposite sign. Value presented in the column To Be Paid is always an absolute value.

Example

The following transactions were registered for the customer/vendor ABS:

  • SI/1/2019 for the amount of 11 070 (amount remaining is 9 000)
  • SI/2/2019 for the amount of 123 000
  • PI/1/2019 for the amount of 36 900
  • SIVC/1/2019 for the amount of -123
  • SIVC/2/2019 for the amount of -492
  • PIVC/1/2019 for the amount of -246

A user, entitled to taking account of deductions during payments, registered a deposit transaction for the customer ABC and then selected the option [Complete]. The following open receivables were displayed on the list:

NumberAmountAmount PaidTo Be PaidAmount Remaining
1SI/1/201911 070.002 070.009 000.009 000.00
2SI/2/2019123 000.000.00123 000.00123 000.00
3PIVC/1/2019246.000.00246.00246.00

Next, the user selected the parameter Show payments of the opposite type after which currently open payables were additionally displayed on the list. The user selected, additionally, the amount of 28 000.00 as amount to be paid for SI/2/2019.

NumberAmountAmount PaidTo Be PaidAmount Remaining
1SI/1/2019123 000.0028 000.0095 000.0095 000.00
2SIVC/1/2019-123.000.00123.00-123.00
3SIVC/2/2019-492.00-100.00392.00-392.00
4PIVC/1/2019246.000.00246.00246.00

The user highlighted the records: 1, 2, 3, 5 and selected the button [Compensate Selected].

The following documents were associated in the effect:

  • SI/1/2019 and PI/1/2019 for the amount of 9 000
  • PI/1/2019 and SI/2/2019 for the amount of 27 900
  • SIVC/2/2019 and SI/2/2019 for the amount of 100

After the document associations, the list of open receivables/payables was updated as follows:

NumberAmountAmount PaidTo Be PaidAmount Remaining
1SI/1/2019123 000.0028 000.0095 000.0095 000.00
2SIVC/1/2019-123.000.00123.00-123.00
3SIVC/2/2019-492.00-100.00392.00-392.00
4PIVC/1/2019246.000.00246.00246.00

The user highlighted the records: 2, 4, and selected the button [Generate Compensation]. In the window with parameters, the user accepted the date and deselected the parameter: Include current transaction. A compensation was generated with the following data:

  • Value: 123.00
  • Receivables: 246.00
  • Payables: 123.000
  • Amount Remaining: 123.00

After the compensation is saved, the list of open receivables/payables was updated as follows:

NumberAmountAmount PaidTo Be Paid Amount Remaining
1SI/2/2019123 000.0028 000.0095 000.0095 000.00
2SIVC/2/2019-492.00-100.00392.00-392.00
3PIVC/1/2019-246.00123.00123.00-123.00

Example

A deposit transaction CD/3/2019 was registered for the customer/vendor ABS and a date 01.12.2019, the system date is: 01.05.2019. After selecting the button [Compensate], open withdrawal transactions were displayed.

NumberAmountAmount PaidTo Be PaidAmount Remaining
1CW/1/201920 000.000.0020 000.0020 000.00

After selecting next the parameter Show payments of the opposite type, the following open deposit transactions were additionally displayed on the list.

NumberAmountAmount PaidTo Be PaidAmount Remaining
1CW/1/201920 000.000.0020 000.0020 000.00
2CD/1/2019-2 000.000.002 000.00-2 000.00
3CD/2/2019-3 000.000.003 000.00-3 000.00

The user highlighted the records: 1 and 3 and selected the button [Generate Compensation]. In the window with parameters, the date of compensation was changed from 01.06.2019 to 01.02.2019 and the parameter Include current transaction was selected. A compensation was generated with the following data:

  • Date of Issue: 01.05.2019
  • Date of Compensation: 01.02.2019
  • Compensation Value: 20 000
  • Receivables: 20 000
  • Payables: 21 000
  • Amount Remaining: -1 000

DocumentReceivablePayableCompensationAmount Remaining
1CW/1/201920 000.000.0020 000.000.00
2CD/2/20190.003 000.003 000.000.00
3CD/3/20190.0018 000.0017 000.00-1 000.00

 




Compensation document form

To add a compensation document, it is necessary to, from the level of Finances -> Compensations, select the button [Add]. It opens compensation document form.

Note
It is possible to add a compensation document if Compensation payment form exists in the system.

Compensation document form

The compensation form contains standard buttons which have been described in article <<standard buttons>> and, additionally:

  • [Compensate Documents] – selecting this button creates payments for a compensation document and associates them with the payments of the documents indicated on the list of compensation items. Additionally, in the side panel of the compensation form, the parameter Compensate Documents is checked by default.
  • <<[Payment Estimate]>> – button available only if in the side panel of the document a customer/vendor has been selected as entity. Clicking on the button opens the list of payment estimate filtered by a given customer/vendor.
  • [Preview] – button available only if in the side panel of the document, a customer/vendor has been selected as entity. Clicking on the button opens the form of a given customer/vendor.
  • [History] – button available only if in the side panel of the document, a customer/vendor has been selected as entity. Clicking on the button opens all transactions executed with participation of a given customer/vendor.

The form of compensation document is composed of the following elements:

Side panel

  • Document status – status of a currently opened document
  • Number – entered automatically by the system according to numerator definition
  • Value – compensation amount
  • Receivables – total of document receivables
  • Payables – total of document payables
  • Amount Remaining – total of Remaining amounts from document items
  • Reference Number – number entered by a user for providing an additional identification of a document
  • Entity – selected from the list of: customers/vendors, employees, banks or institutions. It is not obligatory to fill in this field on the compensation form but it facilitates the registration of compensations with a single entity.
  • Date of Issue – the current date is set by default, can be changed by the user
  • Date of Compensation – the system date is set by default, can be changed by the user This field is updated automatically in case of changing the date of issue, on condition that a document does not contain items
  • Confirmation Date – set as the system date, by default; it can be changed until compensation document is posted
  • Compensate Documents – selecting this button creates payments for a compensation document and associates them with the payments of the documents indicated on the list of compensation items. More information regarding functioning of the parameter can be found in description of the tab
  • Content – predefined value defined in document definition with a possibility to change it. A user can add new message content level of Configuration -> Generic Dictionaries -> General -> E-mail Content.
  • Currencies – a document currency is retrieved by default on the basis of a currency assigned to an entity selected by the user, with a possibility to change it. If a currency assigned to that entity is inactive, currency in the compensation document is set as the system one. It is only possible to change currencies if a given compensation document does not contain items.

An exchange rate is retrieved on the basis of settings specified in the definition of a given document type (Configuration → Company Structure → Rights Structure → Relevant company form → Documents tab).

In the case where the user selects the option none as the exchange rate type, created payments will use an exchange rate from the compensation document items.

  • Owner – center of the company structure which is the issuer of a document. Owner can be changed in a compensation document only if the document is unconfirmed. Documents issued in the same company but different centers can be edited. Documents issued in different companies can be previewed only.
  • Reference Number – number entered by a user for providing an additional identification of a document

Tab Items

The tab contains lists of receivables and payables added to a compensation document. The lists are composed of the following columns:

  • No. – item ordinal number
  • Document – system document number
  • Reference Number
  • Due Date – due date for payment or document date for transaction
  • Receivable/Payable – payment/transaction amount remaining to be completed without the current compensation. Amounts of receivables and expense transactions are indicated in the column Receivable, whereas amounts of payables and revenue transactions are indicated in column
  • Compensation – amount subject to compensation
  • Amount Remaining – payment/transaction amount remaining to be completed, including the compensation. Amounts of receivables are presented with positive sign, whereas amounts of payables are presented with negative sign.

And columns hidden by default:

  • Entity Code – entity’s code indicated on payment or cash-bank transaction
  • Entity Name – entity’s name indicated on payment or cash-bank transaction

Selecting the button [Add] on the list of items opens the list of payment estimate with a possibility of checking selected items. The list contains only uncompleted payments for the entity and currency indicated on the compensation document. If no entity is indicated, the payment estimate is displayed with the parameter All customers and vendors checked automatically in the filter section regarding the entity, which allows for adding payment compensation of different entities to the document.

Note
It is not possible to add items from the level of the Calendar tab.

List of uncompleted payments and transactions.

The payment estimate opened while adding compensation document items contains a parameter Partial compensation. If this parameter is selected, the list will display an additional column To Compensate, presenting an amount to be compensated in the case of a given payment/transaction.  By default, an amount to be compensated equals an amount to be paid. However, the user may change this amount in a range [0; Remaining]. In the column To Compensate, amounts are presented in absolute terms. However, when summing up the column, the data is presented with a plus or minus sing, depending on the payment/transaction type (receivables and expense transactions with plus sign and payables and revenue transactions with minus sign).

Compensate column on the payment estimate list with the Partial compensations parameter active

The system controls whether a given payment has already been selected in this particular document and displays a summary of marked records in a given section.

Note
Compensation items can only be documents subject to completion, that is: transactions, payments from confirmed documents and payments of the following documents: VAT invoice, accounting memo and opening balance.

Upon selecting elements from the payment estimate, a window with information about items added and not added to compensation is displayed:

Compensate column on the payment estimate list with the Partial compensations parameter active

Example
The following items have been added to a compensation document:

Receivables:

  • SI 1/2017 amounting to 4 000, amount remaining: 1 000, due date: 10.12.2017
  • SI 2/2017 amounting to 12 000, amount remaining: 2 000, due date: 04.04.2017
  • SI 3/2017 amounting to 6 000, amount remaining: 4 000, due date: 03.09.2017

Payables:

  • SIC 1/2017 amounting to 40 000, amount remaining: 20 000, due date: 10.12.2017
  • PI 2/2017 amounting to 12 000, amount remaining: 2 000, due date: 04.04.2017

Deposits:

  • CD 1/2017 amounting to 4 000, amount remaining: 4 000, document date: 12.03.2017

Withdrawals:

  • CD 1/2017 amounting to 5 000, amount remaining: 1 000, document date: 12.03.2017

Total of amounts to be paid:

Receivables: 1,000 + 2,000 + 4,000 +1,000 = 8,000

Payables: 20,000 + 2,000 + 4,000 +1,000 = 26,000

Compensation value (amount): 8 000.00

The values of the document are presented in the table below:

No.Document Due DateReceivablePayableCompensationAmount Remaining
Receivables
1.CD 1/201712.3.20171 000.00 0.001 000.000.00
2.SI 2/20174.4.20172 000.000.002 000.000.00
3.SI 3/20173.9.20174 000.000.004 000.000.00
4.SI 1/201710.12.20171 000.000.001 000.000.00
Payables
5.CD 1/201712.3.20180.004 000.004 000.000.00
6.PI 1/20174.4.20170.002 000.002 000.000.00
7.SIC 1/201710.12.20170.0020 000.002 000.00-18 000.00
Total8 000.0026 000.008 000.00-18 000.00
Compensation amount: 8 000.00

  • Receivable amounting to 8 000 should be associated with items: 5,6, and 7.
  • Payable amounting to 8 000 should be associated with items: 1,2, 3, and 4.

Example
The following items have been selected in a compensation document with the Compensate Documents parameter active:

Receivables:

  • SI 1/2018 amounting to 2 000, amount 1 000 has been indicated in the payment estimate, in the column To Compensate
  • SI 2/2018 amounting to 400, amount 100 has been indicated in the payment estimate, in the column To Compensate

Payables:

  • PI 1/2018 amounting to 3 000, amount 2 000 has been indicated in the payment estimate, in the column To Compensate

Compensation amount: 1 100.00

The values of the document are presented in the table below:

ReceivablePayableCompesnation/ValueAmount Remaining
SI 1/20181 000.000.001 000.001 000.00
SI 2/2018100.000.00100.00300.00
PI 1/20180.002 000.001 100.00-1 900.00
CMP document header1 100.002 000.001 100.00-600

  • A payment of the Receivable type amounting to 1 100 has been created

The payment has been compensated with the payable for PI/2018

  • A payment of the Payable type amounting to 1 100 has been created

The payment has been compensated with receivables for SI 1/2018 and SI 2/2018

 

Note
When deleting compensation items, it is necessary to pay attention, whether documents on appropriate list have been checked, because after clicking on the [Delete] button all checked items will be deleted – both from the list of receivables and payables. To avoid errors, before checking items to deleted, it is recommended to click on the [Deselect All] button.

Tab Payer

This tab presents the data of an entity selected as a payer in the document side panel. The system imports the main, default address of an entity which is next copied into a printout of the compensation document. If the document side panel does not contain any payer, the address section of the printout will present the data of all payers selected in payments.

Tab Payments

This tab displays the payments of a compensation document associated with payments indicated as items. The creation of payments and their association with the payments of documents selected as document items depends on the value of the Compensate Documents parameter:

  • If the parameter is checked, the compensation amount is calculated and then compensation payments are generated and calculated with the payments indicated as compensation items. On the lists of receivables and payables and in payments indicated as compensation items, the amount remaining to be applied is updated, as the compensation amount is taken into consideration.
  • If the parameter is unchecked, the compensation payments are not created and the amount remaining to be completed is updated only on the list of payables and receivables of the compensation document.

The parameter Compensate Documents is checked by default. The user can uncheck it until the compensation document is confirmed. If the parameter is unchecked in a document containing items, the system will display a notification informing the user about the deletion of compensation document payments: Document status will be changed and existing payments will be deleted. Would you like to continue? Yes/No. The status of the Compensate Documents parameter (active/inactive) is remembered for a given session.

Creating and completing compensation payments is performed on the basis of the following rules:

  • A payment of the Payable type is created on the basis of the sum of receivables and release transactions subject to compensation and related to a given entity. Afterwards, it is automatically associated with these receivables and transactions
  • A payment of the Receivable type is created on the basis of the sum of payables and receipt transactions subject to compensation and related to a given entity. Afterwards, it is automatically associated with these payables and transactions

The user may not create a new association or delete an existing one manually. Additionally, it is not possible to merge or divide compensation payments.

Example

The following items have been selected in a compensation document with the Compensate Documents parameter active:

Receivables:

  • SI 1/2018 with customer A and amount 1000
  • SI 2/2018 with customer A and amount 2000
  • SI 3/2018 with customer B and amount 1200

Payables:

  • PI 1/2018 with customer C and amount 4000
  • PI 2/2018 with customer C and amount 300

The sums of amounts to be paid:

  • Receivables: 1000 + 2000 + 1200 = 4200
  • Payables: 4000 + 300 = 4300

The compensation has been completed for the amount of 4200.

  • The system has created a payment of the Payable type with customer A and amount 3000. The payment has been compensated with the receivables for SI 1/2018 and SI 2/2018
  • The system has created a payment of the Payable type with customer B and amount 1200. The payment has been compensated with the receivable for SI 3/2018
  • The system has created a payment of the Receivable type with customer C and amount 4200. The payment has been compensated with the payable for PI 1/2018 and partly compensated with the payable for PI 2/2018 with the amount of 200

Note
It is not possible to confirm a compensation document in which the Compensate Documents parameter is inactive.

If a payment/transaction has been selected as an item in a compensation document with the Compensate Document parameter inactive, the system blocks the possibility to:

  • select this payment as a document item in SRO, SPO, and ST documents
  • complete or compensate this payment/transaction
  • delete the payment association or compensation of this payment/transaction
  • select this payment/transaction as a document item of another compensation document

The user will be informed about the blockade with a notification: Unable to perform the action. The document has been selected in (compensation document number).

Note
Canceling of a compensation deletes the document payment.

Tab Associated Documents

Information about the association is displayed both from the level of the compensation document and source document of the payment.

Tabs Attributes, Attachments, Change History

Detailed description of the tabs can be found in <<Article>>.