I’m currently trying to build a revenue recognition/deferred revenue model from the JSON data export and noticed that for each recurring invoice which has been sent to the client (row 2 of screenshot) a “recurring_invoice_id” is stated on the row (e.g. 3362189)
Unfortunately the “recurring_invoice_id” is not present on the recurring invoice row (first row) itself (just 0)
As the recurring invoice row does not have the id stated (3362189) there is no possibility to reference the frequency to the sent invoice and build a revenue recognition/deferral model → in this example the frequency is 9 = annually whereas the amount of 120 needs to be split (1/12)
Is there a logic for the field “recurring_invoice_id” which can be replicated? Why does the “recurring_invoice_id” not show up in the recurring invoice itself? Can this be fixed or is there a workaround to build a reference? (e.g. in PowerQuery)
Thank you very much in advance!