#arcware -invoices

1 messages · Page 1 of 1 (latest)

limber vessel
unkempt badge
#

for background, I'm doing some analysis on some of our older invoices and from Nov 2016 to May 2018 all of our invoices just had the old subscription billing reason, so I'm trying to determine which of those would be new and which would be renewals

limber vessel
#

Gotcha! I think the only way you'd be able to tell is by comparing the invoice creation timestamp lines up with the timestamp on the subscription

unkempt badge
#

ah ok, gotcha... so if the invoice created date and its subscription created date are on the same day, then it's a new subscription

#

and if the invoice create date is greater than its subscription create date, then it's a renewal

limber vessel
#

Yeah, I believe so - it's possible there may be some edge cases I'm not thinking of, but that's what I'd recommend starting with