Accruals

Prerequisites

Before setting up and testing an invoice integration other integrations need to be in place:

• Invoice Integration

• Actuals Integration

Integration Set-Up

When accruals have been verified and posted in Dataloy VMS, the document status is set to Ready-for-Posting.

More information, go to Accruals and Period-End-Closing.

Data Transactions

Get accruals and accrual reversals that are ready for posting to accounting

To get accruals that are ready for posting in Webhooks the following subscription can be created:

{
    "eventType":"U",
    "user": the user code to be used in the subscription,
    "objectType":"Document",
    "expression": "{"type":"group","id":"root","combine":"AND","items":[{"type":"condition","condition":{"id":"1782903975402-box7vo7","operator":"=","leftKind":"field","leftField":{"path":["invoicingStatus","statusTypeCode"],"type":"object","arrayFilters":[]},"leftSource":"current","rightKind":"literal","rightValue":"RFP"}},{"type":"group","id":"1782903976004-c70ukle","combine":"OR","items":[{"type":"condition","condition":{"id":"1782903976004-ncwqszm","operator":"=","leftKind":"field","leftField":{"path":["documentType","documentType"],"type":"object","arrayFilters":[]},"leftSource":"current","rightKind":"literal","rightValue":"ACP"}},{"type":"condition","condition":{"id":"1782903996392-x0fuak4","operator":"=","leftKind":"field","leftField":{"path":["documentType","documentType"],"type":"object","arrayFilters":[]},"leftSource":"current","rightKind":"literal","rightValue":"ACR"}}]}],"version":2}",
    "url":"your webhook url"
}

If you use the expression builder, create an expression like this: invoicingStatus.statusTypeCode = "RFP" AND (documentType.documentType = "ACP" OR documentType.documentType = "ACR")

Alternatively, a scheduled job can be setup to use the following request:

GET /Document?filter=invoicingStatus.statusTypeCode(EQ)RFP&filter=documentType.documentType(IN)ACP,ACR,CAP,CAR

Test Data

Test data for accruals integration can be generated in the Accruals module in Dataloy VMS. Generate and batch post the accruals.

Post Transaction

When an accrual is successfully transferred to an accounting system, the accrual status must to be updated to Posted in Dataloy VMS. This is done in a PUT request:

Update status to posted for a specific invoice

PUT /Document/{key}
  
{
    "invoicingStatus": "POS"
}