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

Find matching entries (udlignede posteringer)

0
Hi

I am trying to figure out how to get the matching entries (udlignede posteringer) for a given entry - i.e. the following lookup

https:// secure.e-conomic.com/secure/generelt/dataedit.asp?form=2123popup=yestype=debvaluta=DKKnr=CNpostnr=SN

where CN is the CreditorNumber and SN is the SerialNumber.

I know I can get open entries by the GetOpenEntries method, but can I get the matching information about the closed entries (how they were closed -- whether it was a kreditnota or a payment that matched the entry).

I hope I make sense, and that the desired lookup can be performed.

Best regards
Søren
created Jul 24, 2012 by shaagerup
0% Accept Rate
Q 1 A 2 C 0

5 Answers

0
Hi,

This is not currently exposed.

In practice, an entry may have been matched against any number of other entries - and in full or part at that.

So, in order to get the complete information, you'd really need a list of (entry reference + matched amount in currency + matched amount in base currency)


Best regards,
answered Jul 26, 2012 by Christian Estrup
0
That is exactly the information I'm interested in! I know that the info sometimes is not available (= when the accountant has not specified it), but sometimes - in the case of invoices etc. - the information is actually known by e-conomic.

Will this information be available in the future? If the info is technically stored in the databases of economic, it will not be that hard to expose it to the api, would it?
answered Jul 27, 2012 by shaagerup
0
Hi,

What do you mean by That is the information I'm interested in...sometimes is not available...when the accountant has not specified it?

It seems you're mixing two - albeit related - concepts a bit:

The invoice number that may be set on manual customer invoices, customer payments, supplier invoices and supplier payments (it's always set on actual customer invoices) is 'voluntary' - but setting it on both an invoice and payment will result in the two entries automatically being matched.

The information on the actual matching - as mentioned, that'd involve a 'pair' of entry references + the matched amount in currency and base currency, respectively - does not necessarily have any relation to whether invoice numbers have been set on the underlying invoice/credit note/payment/refund entries in the first place: Matching may well have been done later - either 'manually', using the 'Automatic matching' function, or via the API.

To make matters even 'funnier', you can't actually count on e.g. an invoice and a payment with the same invoice number having been matched against each other - since, while it likely took place originally, the matching may later have been undone by a user

So, in conclusion: To know which entries have actually been matched against each other, you need the 'match' entity - consisting of entry references + amounts.

Now, while there is currently no scheduled time for exposing this, we'd of course love to hear from other developers needing it -  thus giving us a better idea on how many would benefit from it!


Best regards,
answered Jul 30, 2012 by Christian Estrup
0
Ok - yes, I think you got the idea of what I want.

Most easily it could be realized by a MatchingID column when querying Entries (maybe an array of matchingIDs, to support if an entry can be part of multiple matchings?) Would that make sense? This would also support the cases where more than two entries are part of a matching, and even partial matchings.

I need it to do some custom reporting, which closely tracks what the money on a bank account has been used for. Therefore it would be best to have a way of getting a lot of entries and corresponding matchings at once. I have done similar reports with other accounting systems.

It could be great to have the feature around the end of August, but I understand that your developers must have many tasks in the pipeline. Right now I can take care of most matchings by looking at InvoiceIds, but the other way is more stable.
answered Aug 7, 2012 by shaagerup
0

Hi all,

The possibility to get information about which entries were matched (and unmatched!) is exactly what we need.

Have you done anything more to cover these needs?

For our integration needs, we need to read a stream of payments on customer invoices (the payment could actually be either a real payment or any other credit entry). Currently we only support the simple scenario: a payment is registered with the invoice number. The problem is if the invoice is not known at the time of payment, or the payment is actually for several invoices etc., we simply leave it out.

I consider the best / most general purpose solution would be to have a method "GetMatchesBySerialNumber" which returns an object with:

- Date
- Currency
- An array of all the involved entries (with balance before, assigned amount, balance after)

 

A less abstract way of describing (and possibly solving) our needs would be to say that we need to have a stream of the balance on each single customer invoice. Currently we could go and ask for the balance on all invoices, but that would take quite some time if there are many invoices. Since we need to know the delta of the balance (i.e. what is "paid"), we would have to store the previously known balance and calculate the difference. It would of course be much more convenient to get a "serialized stream" of events, including the deltas, from Economic (as described above). 

I would love to hear your thoughts about this, and when such a function could be added to the API.

answered Feb 20, 2014 by tkristiansen
Get information about matched entries

Network

Find all the documentation and resources you need to build great apps.
Go to Developer site

Newsletter

Get the latest news and important info from the e-conomic developer world.
Sign up now

Visma e-conomic A/S
...