API Forum

This forum is in read-only mode.
Please refer to our API support in case you have any questions.
We can be reached at api@e-conomic.com
e-conomic API developer forum

Debtor amount due

0
How do I get the amount due for a debtor or, alternatively, a list of debtors and amounts due...?
created May 1, 2012 by woodyard
0% Accept Rate
Q 1 A 2 C 0

4 Answers

0
Hi,

For each debtor, call .GetOpenEntries() - this will return a number of DebtorEntry objects, representing not-fully-matched entries on the debtor.

Each of these have a Remainder and a RemainderDefaultCurrency, as well as a DueDate - which you can use to calculate the total due amount as of some specific date.

For optimization, you may wish to do this only for debtors whose Balance  0


Best regards,
answered May 1, 2012 by Christian Estrup
0
Christian,

Could this be implemented as a SOAP request, eg Debtor_GetAmountDue with customernumber and a date as parameters?

/Henrik
answered May 1, 2012 by woodyard
0
Hi,

For performance reasons, I'd probably lean towards simply exposing a default currency due amount on the Debtor entity - being calculated as of today's date, similar to what's exposed in the GUI customer register.

(Calculating back-in-time due amounts is rather heavy-loading since it isn't just a date-filtered entry total, but needs to take e.g. effective matching dates into consideration).

Would that work for you?


Best regards,
answered May 1, 2012 by Christian Estrup
Hello Christian,

Is the information about the amount due as today, already available?

Can't find it in API documentation.

Best regards
No, not that simple.

You can, however, retrieve it by retrieving all DebtorEntry's on a Debtor, and then calculating the total Remainder for those entries whose DueDate <= today.

However, that obviously doesn't scale very well :-)


BR,
0
Hi Christian,

Amount due as of todays date is fine - I just suggested the function with a date to make it flexible. I only need todays date

/Henrik
answered May 1, 2012 by woodyard
Visma e-conomic A/S
...