User cases with calculation example

User cases:

  •       PO Item Without valuated GR

o   Purchasing of consumable material or service – without goods receipts

o   Purchasing of consumable material or service – with non-valuated goods receipts

 

  •       PO Item with valuated GR

o   Purchasing of consumable material – with valuated goods receipt postings

o   Purchasing of service – with service entry sheet postings

User case.png

Example:

* Explanation of abbreviation in T-accounts

   GR: Posting of valuated goods receipt

   AC: Posting of accruals

   SIV: Posting of invoice

   ACRV: The accruals of the former period are reversed

 

User case A  

Purchasing office material:

A PO post on 06/01/2020 with total amount of 6000 EUR without good receipts

Delivery Schedule:

12/02/2020   10 PCs

10/03/2020   15 PCs

09/04/2020   25 PCs

11/05/2020   10 PCs

Net price 100 EUR/PC

 

Invoice post on:

15/2/2020    500 EUR

25/03/2020  3500 EUR

06/06/2020  2000 EUR

Event:

A.1.png

Accrual Calculation:

A.2.png

T-accounts:

A.3.png

User case B

Purchasing office material:

A PO post on 06/01/2020 with total amount of 6000 with non-valuated goods receipts.


Good receipt(Non-valuated ):

12/02/2020   10 PCs

10/03/2020   15 PCs

09/04/2020   25 PCs

11/05/2020   10 PCs

Invoice post on:

15/2/2020    500 EUR

25/03/2020  3500 EUR

06/06/2020  2000 EUR

Event:

B.1.png

Accrual Calculation:

B.2.png

T-accounts:

B.3.png

User case C

Purchasing office material:

A PO post on 06/01/2020 with total amount of 6000 with valuated goods receipts

Delivery Schedule:

12/02/2020   10 PCs

10/03/2020   15 PCs

09/04/2020   25 PCs

11/05/2020   10 PCs

Net price 100 EUR/PC

 

GR post the cost on:

15/2/2020    500 EUR

25/03/2020  3500 EUR

06/06/2020  2000 EUR

 

Invoice post on:

05/03/2020 2000 EUR

16/06/2020 5000 EUR

Event:

C.1.png

Accrual Calculation:

c.2.png

T-accounts:

C.3.png

In this scenario will not consider invocie cost into actual cost.

User case D (1)

Standard PO total amount of 6000 EUR, item category E, post on 06/01/2020

Start date and end date respectively are 01.01.2020 to 31.06.2020

Received an invoice on 10.02.2020 with amount 1500 EUR

Received an invoice on 25.06.2020 with amount 4500 EUR

Event:

D.1.png

The frequency of accrual postings is customized to By Posting Period. As a consequence, the Accrual Engine splits the lifetime into intervals of dates which correspond to the first and last day of the fiscal periods. Afterwards it uses for each such interval the last day of each period as key date for the calculation of the accrual amounts. This will be the result:

Accrual Calculation:

D.2.png

T-accounts:

D1.3.png

User case D (2) – PO Amount is revised

On 15/04/2020 the total PO amount is changed from 6000 to 9000

Received an invoice on 10.02.2020 with amount 1500 EUR

Received an invoice on 25.06.2020 with amount 7500 EUR

Event:

D2.1.png

Accrual Calculation:

D2.2.png

T-accounts:

D2.3.png