I am looking through our IEntry and some of the entries are holding a posting/journal entry (bilag) in VoucherNumber. When in the E-conomics application I can find the posting/journal entry but I can't seem to find it through the API.
Is this possible and how?

Best Regards
Frederik Kiær

Hi Frederik,

I'm unsure as to exactly what you mean.

Do you mean that there are entries you can see in the web application, but not in the API?


Best regards,

Christian,

I have entries which holds a VoucherNumber that is not an Invoice. When I look up the entry in E-conomics (webapplication) I can see the entry references a "bilag". This "bilag" holds information on the Debtor/Creditor, which I need to collect...

How do I find a "bilag" through the API?

Regards
Frederik

Hi,

I'm sorry, but I'm still at a loss as to exactly what you mean.

Could you post a screenshot from the e-conomic application, marking exactly what in it you're looking for in the API?


Regards

Christian,

Thanks for your patience!

Attached is the search I created for some Entries with non-valid Invoice Number in their VoucherNumber-property.

When I click on the magnifying glass-icon in the right most column in the result, I get a pop-up window with two transactions, where one holds an Debtor/Creditor reference. This is the reference I need for the entries...

How do get this through the API?

Best Regards
Frederik

Hi,

Ah - ok.

It sounds like what you really need is something like DebtorEntry.FindByVoucherNumber(), or CreditorEntry.FindByVoucherNumber(), respectively.

Neither of those are available at the moment, unfortunately - however, it would certainly make a lot of sense, so I'll add it to our list of tidbits to be added in the not-too distant future.

If anyone else could use something similar, don't hesitate to shout - the more who could benefit from this, the sooner we'll of course have to make it


Best regards,

Christian,

Thank you very much for the quick response!

Well a FindByVoucherNumber might not solve my problem...

I am searching through all my Entries since I need all entries to all accounts - not just the one extracted by DebtorEntryUtil. After I have collected all Entries of type DebtorInvoice or DebtorPayment I want to find the matching Invoices. This is needed to find the Debtor-reference, since Debtor/Creditor isn't part of the IEntry-interface.
I find that some of my collected Entries has a VoucherNumber which doesn't match an Invoice. I quickly popup a browser and finds the entry in the E-conomics webapplication (screen shots).
I can find the entries and when I click the little magnifying glass I can se two additional items (I do not know if items or entries are the correct term for the these lines...). These entries do not hold a visible serial number and I do not know how to find these specific items through the API and thus match my entry to a debtor (or creditor when that time comes).
Is there any way to know what the VoucherNumber references in the IEntry-interface?

Some other VERY nice features would be:

- (DebtorEntry/CreditorEntry).FindByDate(to, from)
- (DebtorEntry/CreditorEntry).FindBySerialNumber(int[])
- InvoiceLine.FindByInvoiceNumber(int[])

I am looking forward to the next tidbit-release ;o)

/ Frederik

Hi Frederik,

Generally speaking, IEntry is a financial entry, whereas IDebtorEntry/ICreditorEntry are debtor/creditor entries, respectively.

Internally in e-conomic, it's really the same register. Thus, at least for now, every IDebtorEntry and ICreditorEntry will always have exactly one corresponding IEntry - but not necessarily the other way around.

For example, when booking an invoice of DKK 10.000 + 25% VAT, the following kinds of entries will be created:

1. IEntry on the sales account, -10.000
2. IEntry on the VAT account, -2.500
3. IEntry on the customer group control account, +12.500
4. IDebtorEntry on the customer, +12.500

(3) and (4) are internally the same, but exposed separately in the API, as described above.

However, we split it in the API since it seems to be the more logical data model people are used to from many other accounting systems.

If an IEntry's type is DebtorInvoice, then VoucherNumber will ALWAYS be an invoice number - i.e., one you can find via the IInvoice interface. For all other entry types, no matching invoice will exist (or possibly make sense ).

I'm kind of lost as to what it is you're trying to accomplish - detached from e-conomic-specific terminology.

What event triggers you to want to find exactly what information?


Best regards,

Christian,

I have been assigned to develop a range of reports.

And I still have to find the reference to non-invoice VoucherNumbers.

I have attached an image with some postings; one has an invoice "bilag" and the others reference a "bilag" which seems to be a collection of other postings. One of these positings hold a reference to the debtor/creditor. This is the connection I need! A reference from an entry to the item referenced by a non-invoice VoucherNumber.

Is it possible to collect the non-Invoice vouchers through the API?

Regards
Frederik