Cloud Applications Studio - Connect Payment Date for Partial Payment with Invoice

[former_member624201]

Hello experts,

We are looking for a Standard Object (or combination) to connect partial payments (amount and payment date) to the appropriate Invoice.

We first read from Standard Object AccountsReceivablePayableLedgerAccount.DueItem" using the Invoice number. Then we read the ClearingInformation of the retrieved item.

var item = AccountsReceivablePayableLedgerAccount.DueItem.Retrieve(key);
var clearingInfo = item.DueItemHistory.SetOfBooksClearingInformation;

Clearing Info contains:

• OpenLocalCurrencyAmount
• OriginLocalCurrencyAmount
• OriginPostingDate
• ClearingPostingDate

We can recognize the Open amount, however we do not have the payment date.
ClearingPostingDate is only filled when the whole invoice is cleared.

WHAT WE TRIED:

1. We used "Payment" and QueryByElements
The partial payment is found with the amount paid and the transaction date, however except the BusinessPartnerID, we cannot link this with the Invoice.
There is NO Invoice number. The value of BaseBusinessTransactionDocumentReference/ID/content cannot be matched with the entry in standard object "AccountsReceivablePayableLedgerAccount".

2. TradeReceivablesPayablesRegister ItemOverview:
It shows the cleared amount, the open amount, but not the date of the paid amount.

Is there some Standard Object which we can use to find the partial payment information (amount, currency, invoice, date)?

Thank you very much for your help and time.

Best Regards,
Savvas Karasavvas