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

Creditor invoice amount?

0
Hello,

I can't seem to find any functions where i can get the invoice amount of a Creditor Invoice?

I have the following variables to make a search with:
- CreditorNumber
- Invoicenumber

This should be enough?
created May 25, 2011 by QubixDK
0% Accept Rate
Q 4 A 14 C 0

11 Answers

0
Hi,

Assuming the invoices are booked, they're represented by the ICreditorEntry interface.

You can find all entries on a creditor using the creditor object's .GetEntries() method.

The returned CreditorEntry objects have the properties Amount (in currency) and AmountDefaultCurrency, representing the amount of each entry.


Best regards,
answered May 26, 2011 by Christian Estrup
0
Hi Christian,

Cant seem to find ICreditorEntry in https://www.e-conomic.com/secure/api1/E ... rvice.asmx?


Another question, is it not possible to set the exchange rate on a CashBookEntry?
This is veryy much needed, because we have a bank account only in currency of EUR, and the exchange rate that E-conomic calculates between Amount and AmountDefaultCurrency.

Can I somehow set the exchange rate on a entry manually?
answered May 26, 2011 by QubixDK
0
Hi Christian,

Solved the one about ICreditor - it's called Creditor_GetEntries
answered May 26, 2011 by QubixDK
0
Creditor_GetOpenEntries() only returns invoice handles that I can put into CreditorEntry_GetAmount()...
answered May 30, 2011 by QubixDK
0
Hi,

No, Creditor_GetOpenEntries() returns _CreditorEntry_ handles.

If you wish to find the invoice amount, given a creditor number and invoice number:

1. Lookup the creditor with the given creditor number.
2. Retrieve all entries on that creditor (if you don't know if the entry is still open, use Creditor_GetEntries().
3. Loop through the CreditorEntries returned until you find the one with the CreditorInvoiceNumber you're looking for.


Best regards,
answered May 30, 2011 by Christian Estrup
0


Is this possible??
answered Jun 6, 2011 by QubixDK
0
Hi,

The exchange rate is not explicitly available.

However, you can set the Amount and AmountDefaultCurrency - the relationship between which is obviously the exchange rate.

We've chosen to go down that route instead, to allow you to set the exact default currency amount - rather than having to rely on assumptions on rounding etc..


Best regards,
answered Jun 6, 2011 by Christian Estrup
0
Hi Christian,

Our CreditorInvoices is booked in exchange rate 750, if the exchange rate is not exactly that, a currency difference will occour.

How can we solve this?
answered Jun 6, 2011 by QubixDK
0
Hi,

I simply don't understand your question

When you create your creditor invoice entries via the API, you must specify both Amount and AmountDefaultCurrency. Whether the latter is 7.50 times the former, or some other factor, is entirely up to you to set.

- thus allowing you to set the exchange rate on an entry manually.


Best regards,
answered Jun 7, 2011 by Christian Estrup
0
Hi Christian,


I found an error in your system...

When I create a CreditorPayment, i use the amounts found matching an invoicenumber to Creditor_GetOpenEntries.

When I use the Amount and the AmountDefaultCurrency the exchange rate is not calculated correctly!

The amounts are:

74,97 EUR (This I typed in when I created the CreditorInvoice)
562,28 DKK (Amount calculated by E-conomic)
This gives a calculated exchange rate of: 7,500066693344004 ~ 750,006669 (In E-conomic)
answered Jun 29, 2011 by QubixDK
Visma e-conomic A/S
...