Different values returned from getberegnregnskab

[smulle48]

Hi

It looks like my data returned looks a bit different from what you are using in your code, so I have attached my data, if you want to use it.

For example, my line 18 is the aconto amount (for each aconto) and I got a line 7 and 22 also.

{"faktlini":[{"ekstra":"kr.","enhedPris":"392,00","linieType":"3","antalEnheder":"5,290","enhed":"MWh","tekst":"6464705","prisEnhed":"kr./MWh","opl4":"MWh","opl3":"152,753","opl2":"MWh","opl1":"147,463","ialt":"2.073,68"},{"ekstra":"kr.","enhedPris":"392,00","linieType":"3","antalEnheder":"7,464","enhed":"MWh","tekst":"Prognose: 08-04-2023 til 31-12-2023","prisEnhed":"kr./MWh","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"2.925,89"},{"ekstra":"","enhedPris":"","linieType":"22","antalEnheder":"","enhed":"","tekst":"","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":""},{"ekstra":"","enhedPris":"","linieType":"22","antalEnheder":"","enhed":"","tekst":"Gennemsnitlig fremløbstemp. i perioden","prisEnhed":"","opl4":"°C","opl3":"61,64","opl2":"","opl1":"","ialt":""},{"ekstra":"","enhedPris":"","linieType":"22","antalEnheder":"","enhed":"","tekst":"Gennemsnitlig returtemp. i perioden","prisEnhed":"","opl4":"°C","opl3":"25,06","opl2":"","opl1":"","ialt":""},{"ekstra":"","enhedPris":"","linieType":"22","antalEnheder":"","enhed":"","tekst":"Forventet returtemperatur","prisEnhed":"","opl4":"°C","opl3":"40,00","opl2":"","opl1":"","ialt":""},{"ekstra":"kr.","enhedPris":"","linieType":"22","antalEnheder":"","enhed":"","tekst":"Ingen tillæg","prisEnhed":"","opl4":"%","opl3":"0,00","opl2":"","opl1":"","ialt":"0,00"},{"ekstra":"","enhedPris":"","linieType":"22","antalEnheder":"","enhed":"","tekst":"","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":""},{"ekstra":"","enhedPris":"","linieType":"0","antalEnheder":"","enhed":"","tekst":" ","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":""},{"ekstra":"kr.","enhedPris":"10,00","linieType":"1","antalEnheder":"106","enhed":"m²","tekst":"Beboelse iflg. BBR","prisEnhed":"kr./m²","opl4":"","opl3":"","opl2":"dage","opl1":"365","ialt":"1.060,00"},{"ekstra":"kr.","enhedPris":"600,00","linieType":"7","antalEnheder":"","enhed":"","tekst":"Abonnement","prisEnhed":"kr./år","opl4":"","opl3":"","opl2":"dage","opl1":"365","ialt":"600,00"},{"ekstra":"","enhedPris":"","linieType":"0","antalEnheder":"","enhed":"","tekst":" ","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":""},{"ekstra":"kr.","enhedPris":"","linieType":"12","antalEnheder":"","enhed":"","tekst":"Total før moms","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"6.659,57"},{"ekstra":"kr.","enhedPris":"","linieType":"10","antalEnheder":"25","enhed":"%","tekst":"Moms","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"1.664,89"},{"ekstra":"kr.","enhedPris":"","linieType":"12","antalEnheder":"","enhed":"","tekst":"Total med moms","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"8.324,46"},{"ekstra":"kr.","enhedPris":"","linieType":"18","antalEnheder":"","enhed":"","tekst":"Opkrævet acontorate (med moms)","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"-1.700,00"},{"ekstra":"kr.","enhedPris":"","linieType":"20","antalEnheder":"","enhed":"","tekst":"Forventet indbetalt: 08-04-2023 til 31-12-2023","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"-6.800,00"},{"ekstra":"kr.","enhedPris":"","linieType":"12","antalEnheder":"","enhed":"","tekst":"Årets forventede resultat","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":"-175,54"},{"ekstra":"","enhedPris":"","linieType":"0","antalEnheder":"","enhed":"","tekst":" ","prisEnhed":"","opl4":"","opl3":"","opl2":"","opl1":"","ialt":""}]}

[kpoppel]

Thanks. Does your PR take care of all relevant differences?

[smulle48]

Thanks. Does your PR take care of all relevant differences?

No, but im looking into it 😃

[smulle48]

Hi again.

This year, it's divided into 5 payments, the first 01-03-23 then 01-05-23 and so forth, but when I look how they summed it up, they added the 01-05-23 rate as unpaid. That way the rest of April, it looks like, that I by the end of the year are 1400,- dkr short of payment when in fact they owe my 230,- dkr.

Maybe there's a way to get around this

[kpoppel]

This report is really difficult because it seems this is not standardised across all eForsyning companies. Some use more text, some less, some uses some words, other not for the same thing.

From this report I pick out the price of M3 and MWh, VAT and the total incl. VAT line (8269,09 in your case). The amount paid (Opkrævet acontorate (med moms), and lastly the Amount remaining (Forventet indbetalt) which is both an attribute and the actual sensor value.
Those were the only amounts I could get to line up consistently :-) The 'good' thing is that the amount remaining is adjusted every day and gives an indication of where it is headed (hopefully towards 0).