Compensation Accrual Record (COAR)

Since version 9.0

Accrual Record is intended to solve the problem of calculating and storing the compensation accruals or payouts on an even more granular level.

For example, if you need to pre-calculate the compensation money not only for the whole group of sellers, but also per each seller, you can use the Accrual Record to store such detailed information.

Accrual Records allow you to store even more fine-grained compensation results than the Compensation Record. If, for example, the Compensation Record contains a group of sellers and you need to store separately a compensation amount per specific seller, you can store such numbers into the Accrual Records.

Sample hierarchy of the objects:

Line item #1 – Negotiated for a group of sellers with quarterly payout dates. So we will calculate and approve the compensation separately in four compensation records.
1. Compensation Record – for Q1, for the whole seller group
  - Accrual Record – for Q1, for seller A
  - Accrual Record – for Q1, for seller B
  - Accrual Record – for Q1, for seller C
2. Compensation Record – for Q2, for the whole seller group
  - …
Line item #2 – Negotiated for two sellers with annual payouts.
1. …

The Payout Records can be reviewed in Sales Compensations › Accrual Records, but since their usage is optional and depends on your project needs, you might find the list empty.

Fields

Unique constraints: The combination of three fields – compensationRecordUN, accrualType and name – must be unique.

name

Name of the Accrual Record, unique within the scope of the Compensation Record that creates it. Sample values from a project: Q1-1, Q1-2, …

label

Description of the meaning of this Accrual Record.

startDate

First date of validity of the values stored in this record.

endDate

Last date of validity of the values stored in this record.

payoutDate

Date when the money should be paid to the seller.

compensationTypeUN

uniqueName of the Compensation Condition Type, coming from the Compensation Condition Type of the Compensation Record in whose content this Accrual Record was generated.

compensationRecordUN

uniqueName of the Compensation Record to which it belongs. It is set automatically while the Accrual Record is created.

attribute1..100

Keeps the compensation calculation results – any values needed for the business.

status

Status of the Accrual Record (string). Values defined by project needs. Sample values from projects: "Pending", "Approved", "Denied", "Paid", etc.

accrualType / type

Type of the payout (string). Values are decided by needs of the project, e.g. to distinguish between more types of payouts. Sample values from projects: "Accrual", "Summary", …

intgStatus

String representing a status of integration of this record data to the external system. The set values will be driven by the integration tool (e.g. IntegrationManager) and the needs of the project. Sample values from projects: Processed, Sent, Error occured, Allocated, …

intgStatusDetail

String representing a detail (explanation) of the intgStatus, possibly shown to the end user.

intgStatusErpReference

String representing an ID of a document in ERP which relates to this record (or to which this record was written to). The exact usage depends on the project needs.