Receivables invoice open balance as of historical date (excluding tax lines)

Summary:

looking for PLSQL API to calculate invoice open line amount (excluding tax lines) as of any historical date.

For example: If an AR invoice had original open balance of 1000 and tax of 200 on Sep 10th, and payments were applied in the amount of 120 (100 line amount + 20 tax amount) each subsequent moth on the 10th; someone querying the invoice open balance on as of date as Sep 10th would still get as 1000. Oct 10th as 900, Nov10th as 800 and so on.

Content (please ensure you mask any confidential information):

looking for PLSQL API to calculate invoice open line amount (excluding tax lines) as of any historical date.