SUBTOTAL using SORT

[Maria Jak]

Hi!

Does anyone here have any advice for this?

Input (FB 50)

PROP1 31/07/2020 -50.00
PROP1 31/01/2020 10.01
PROP2 31/01/2020 10.00
PROP1 31/03/2020 10.02
PROP3 31/03/2019 11.11
PROP1 30/04/2020 10.03
PROP1 31/05/2020 10.04
PROP2 31/05/2020 11.01

Output (FB 50)

PROP1 31/01/2020 10.01 20200131 10.01
PROP1 31/03/2020 10.02 20200331 20.03
PROP1 30/04/2020 10.03 20200430 30.06
PROP1 31/05/2020 10.04 20200531 40.10
PROP1 31/07/2020 -50.00 20200731 -9.90
PROP2 31/01/2020 10.00 20200131 0.10
PROP2 31/05/2020 11.01 20200531 11.11
PROP3 31/03/2019 11.11 20190331 22.22

Expected Output (FB 50)

PROP1 31/01/2020 10.01 20200131 10.01
PROP1 31/03/2020 10.02 20200331 20.03
PROP1 30/04/2020 10.03 20200430 30.06
PROP1 31/05/2020 10.04 20200531 40.10
PROP1 31/07/2020 -50.00 20200731 -9.90
PROP2 31/01/2020 10.00 20200131 10.00
PROP2 31/05/2020 11.01 20200531 21.01
PROP3 31/03/2019 11.11 20190331 11.11

Results were given by:

INREC FIELDS=(01,25,13,04,10,02,07,02,17X)
SORT FIELDS=(01,05,CH,A,26,08,CH,A)
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(01,05,26,08,
TRAILER3=(01,35,
37:SUBTOTAL=(19,06,SFF,EDIT(SIIT.TT),SIGNS=(,-))))

Key: columns 01 to 05.
Also tried SECTIONS=(01,05, but the results were not the expected ones, as it is mandatory to keep all records with their respective subtotals (accumulated) by date.
I am using Syncsort 3.1.3.0N.

Any support would be appreciated.
Thank you.
Maria