kronk

[stray jolt]

Hi, can you share the invoice id where the status is null so I can further review this?

[torpid jungle]

give me a second to find an example

in_1M9egfIvcqWR3dFDIaXoXO4W

[stray jolt]

Can you confirm where you're exactly looking to attain the status?

I want to confirm that we are looking at the same thing

[torpid jungle]

i think it's just the object-level status field? the non-nested one

context for my question is i'm trying to write a SQL query to count all paid, non-refunded invoices in our stripe account. originally i thought the ones with status = null were the refunded ones, but i've noticed more recently some refunded invoices that still have status = paid

so maybe a different way of asking my original question is, is there a field on the Invoice object I can use to determine active, paid invoices? And differentiate from previously paid, then later refunded invoices?

[stray jolt]

I see, this context is helpful. That invoice is in paid status.... Let me look at a few things on my end

[torpid jungle]

thanks! if it helps, here's an example of an invoice in paid status:
in_1MeRIqIvcqWR3dFDIiLpkjqT

[stray jolt]

I had to double check with a teammate as the only option I'm seeing is that you list the refunds: https://stripe.com/docs/api/refunds/list as when a charge is refunded on a invoice, it does not change anything on the invoice. You can listen to charge.refunded going forward to keep track of this in your end.

Also, it might be easier to use our Reporting for this instead, https://stripe.com/docs/reports/payout-reconciliation#schema-payout-reconciliation-itemized-5.

[torpid jungle]

thanks! this is helpful to know