Manage Accruals

This document describes how accruals are managed and calculated.

Introduction

Generating, paying, and reservation amounts are calculated through 'Trade Agreement Calculation. Open' (OIS450) based on the common rules and conditions set in the trade agreement 'Trade Agreement. Open' (OIS430) for calculating accruals. This triggers the batch jobs used to process invoiced customer orders.

Criteria is used to select by either the trade agreement number, transaction date, date range for the invoice dates and accounting dates, customer, business chain, facility, and/or item numbers.

Update from invoice

This function handles calculation or recalculation of already invoiced lines that are qualified based on the criteria set in the trade agreement and selection matrix which triggers the batch program (OIS450S4) by selecting the parameter 'Upd fr invoice' in (OIS450). This then launches the calculation for the generating amount, paying amount, and reserved amount based on the calculation rules set in the trade agreement (OIS430).

It is mandatory to run this function if the accruals management is set to 2-'Batch' in 'Trade Agreement Model Lines. Open' (OIS439) to calculate accruals for the connected trade agreements.

Retroactivity

This function handles the recalculation of past invoice lines qualified for the trade agreement which triggers the batch program (OIS450S4) by selecting the parameter 'Upd fr invoice' and 'Retroactivity' in (OIS450).

For example, if an agreement is entered after the defined 'from date' of the agreement, selecting this function makes it possible to recalculate and reprocess from the start date of the agreement until the current date to regenerate the accruals of the qualified invoiced lines.

Update dependent

This function updates the agreements that are dependent on another agreement due to a new net amount, which triggers the batch program (OIS450S5) by selecting the parameter 'Upd dependent' in (OIS450). This then triggers the recalculation of the reserved amount based on the net, following the sequence defined in the trade agreement model used (OIS439).

Reverse transactions

This function handles the reversal of transactions which triggers the batch program (OIS450S1) by selecting the parameter 'Rev transaction' in (OIS450). Trade agreement number is a mandatory input when reversing transactions. Reversed transactions are deleted from the trade agreement transaction file.

Note: When reversed transactions have already been included in the periodic accrual proposal or have been transferred to the general ledger, a new line is created to negate the original line instead of deleting the record.

Update rate

Rates can be modified while the agreement is active. This function handles the scenario when updating the reservation rate of the recipient, which triggers the batch program (OIS450S2) by selecting the parameter 'Update rate' in (OIS450). The reserved amount for existing transactions is then modified for the new rate entered for the recipient. New transactions are created in the trade agreement transactions file with the difference amount.

Note: 

This option is not supported for trade agreements with scale code set to 2-'Graduated rate - split trans' on (OIS430/F). For these agreements, an error message is displayed when a trade agreement number is provided during the run in (OIS450). If it is included in the batch run, it is skipped.

When a rate is updated for these agreements, 'Rev transaction' in (OIS450) must be run first before recalculating the agreement again to retrieve the new rate.

Reverse invalid transactions

This function validates all existing transactions against the selection matrix, and reverses transactions that are no longer valid. This triggers the batch program (OIS450S3) by selecting the parameter 'Rev inv trans' in (OIS450) in which all existing transactions are read, based on the criteria entered.

For each trade agreement record, the trade agreement model and trade agreement model lines are retrieved, in order to validate it against the selection matrix. If there are changes in the trade agreement or the trade agreement recipient, a record is added in the trade agreement transaction file in (OIS435) to reverse the current value. For example:
  • when an agreement or recipient combination is unlinked in the selection matrix
  • the date range of the matrix is no longer valid
  • a trade agreement model line in (OIS439) is deleted.