hi! i'm working on a query to show all pending invoices (of the sales module) and i wanted to know what is the criteria under which SAP decides if an invoice is pending or not
this is a problem because (for me) this goes beyond the field that says if the invoice is open or not, because a partial payment closes the invoice, also is beyond the analisis of the PaidToDate vs the DocTotal field because of what i just said
¿it requires also an analisis of the reconciliation over the invoice? ¿ is that analisis even posible when you grab a bunch of invoices and reconciliate them against something else?
¿also do i need to analyze the credit memo linked to the invoice?
i need help with this, thank you all 😊