User Profile
Jeroen Bijl
14
Posts
0
Kudos
1
Solution
19-11-2024
13:29
I seem to recall talks of a vat/moms api on the partner kickoff, is there anything happening here?
... View more
16-10-2023
13:58
Hi, I'm having an issue where I get more journal transactions from the API endpoint than from a manual export. The extra journal transaction is the only one with "status": Balanced, the rest are Posted. Is there a reason the ui export excludes Balanced? Is there any documentation to what this status means?
... View more
23-05-2023
13:19
Bumping this, it's a blocker for our integration
... View more
27-04-2023
13:01
Hi, Ive read this old post: https://community.visma.com/t5/Forum-in-Developers-Visma-net/Endpoint-for-General-ledger-transactions-with-VAT-TX40500S/m-p/421962?_gl=1*1jnjgbn*_up*MQ..*_ga*NzI5NjAzNTgzLjE2ODI1OTI1OTA.*_ga_EM2X009C54*MTY4MjU5MjU4OS4xLjEuMTY4MjU5MjYyOC4wLjAuMA..#M1914 and what other posts I found regarding VAT. However Im struggling to figure out a "good"(any way really) way to get VAT data for all journal transactions. Our integration is going to be used for a wide variety of customers, so making the accountants check the "make a VAT transaction" manually is not an option. Is there a proper way to fetch this data these days? Doing a manual export I get VAT data, but the api call to f.ex API/controller/api/v2/journaltransaction/{voucherNumber} does not include the VAT data on the same line. In the api call I can see: "createVatTransaction": false, "skipVatAmountValidation": false, But there is VAT data there on the manual export. How do I get it? And how can it be done with as little overhead as possible?
... View more
17-04-2023
08:25
Does this fetch "reskontro"? I find no supplier/customer data on the response from that endpoint. Im not looking for just the 1500 account etc, I want to see all unpaid customer/supplier transactions/invoices at 31.12
... View more
12-04-2023
10:57
Not a solution, but further issues. When an invoice i in a currency other than nok, I get Agio lines to deal with as well. So in order to calculate the remaining balance I have to foreach the payments -> fetch journalTransactionLines on a batchnumber from the payment, then find the agio line and use it in the calculation. At this point I'm at (Documents/1000) -> filter to find whatever was open at 31.12 (this case ~100 documents) -> so 100 api calls to get payment data -> worst case I get 10+ payments to find agio lines for, foreach of those payments. So it's more than 1000 api calls to create a simple accounts payable report. This can't be the only way?
... View more
03-04-2023
10:21
Hi, I am attempting to fetch AR/AP, "Reskontro", for suppliers and customers. I have arrived at a possible solution, but I believe there must be a simpler way, so if someone has done it I would appreciate some feedback/comments. I need to find the remaining balance on all customer/supplier accounts on 31.12. Current solution: - Fetch from "v1/supplierDocument"(or customer) *supplier endpoint has no date filtering of sorts, so I fetch all supplier documents. - This means paging is a must, and I end up fetching thousands of records. - Then I filter them based on a logic with "closedFinancialPeriod" and "financialPeriod" - Since the response is "date-independent" and not point in time etc, the balance I get returned is wrong for invoices which are paid in intervals/some in 2022 and some in 2023. Example; an invoice from 04.2022, paid monthly for 12 months, is done in 03.2023. Which means at 31.12 there should be a remainder balance, but the endpoint returns balance as 0 (because it is paid of at the time of the api request). In order to figure out the remaining balance at 31.12 I have to fetch from "v1/supplierPayment". - This means an api call for each invoice in order to figure out if there was a remaining balance/calculate it. In conclusion I end up with a lot of api-calls. Non working attempts/endpoints: - "customerinvoices?status=Open" (or supplierinvoices) -> with or without financialPeriod filter. The problem is it checks the current status of invoices, not what they were at year end or sepcified financialPeriod. The customerInvoices endpoint also only contains invoices, so creditNotes are not returned even though there is a documentType filter. Anyone have a good way to fetch this data for a given date/period?
... View more
31-03-2023
15:21
I have encountered the error again a few times the last 30 min or so
... View more
28-02-2023
12:36
Hi, Is there any way to get the tenants/list of customers who have installed our application through api calls? Or is the only way to log in to the ui? Is there a way to subscribe to events for "new integrations"? I am looking for the data in this view: https://oauth.developers.visma.com/service-registry/applications/{appId}/integrations/tenants
... View more
21-02-2023
09:18
Attachments aren't linked to the journal transaction, in my test data they are only connected to an invoice. So the above results make sense. But I do have a follow-up issue. I am attempting to replicate the "View Source Document" functionality form the ui. Fetch the attachment linked to a journal transaction. Anyone have a good idea how to achieve that? Journal Transaction has a referenceNumber, but this is not a param on CustomerInvoice/SupplierInvoice. I could fetch all for the given financial period and select the one with a matching ref number. Select Customer/Supplier based on the journal transaction module, but I hope there is a better way. I could also check NumberSequence to attempt to figure out if a referenceNumber is a Bill or an Invoice, but seeing as the sequences can overlap this doesn't seem ideal either. Any tips are most welcome
... View more
20-02-2023
16:40
Hi, I am attempting to fetch attachements based on Journal Transactions. Using the CustomerInvoice endpoint I can verify the attachements are there, and the endpoint returns expected values. However, when using: https://integration.visma.net/API/controller/api/v2/journaltransaction For the same period, the attachement data is not present. I have tried with expandAttachements=true and false, but there is no attachement data. Looking at the swagger documentation there should be attachement data on both the Journal Transaction level and Journal Transaction Line. Anyone using attachement info from journal transactions? or have an idea why I can't get the data?
... View more
Activity Feed for Jeroen Bijl
- Posted Re: VAT data is not included on General Ledger transactions on Forum in Developers Visma.net. 19-11-2024 13:29
- Kudoed API for driftsmidler for Glenn Markussen. 30-10-2024 10:05
- Posted Journaltransactions v2, fetches more data than ui export on Forum in Developers Visma.net. 16-10-2023 13:58
- Posted Re: VAT data is not included on General Ledger transactions on Forum in Developers Visma.net. 23-05-2023 13:19
- Posted VAT data is not included on General Ledger transactions on Forum in Developers Visma.net. 27-04-2023 13:01
- Posted Re: Accounts Payable and Receivable at year end on Forum in Developers Visma.net. 17-04-2023 08:25
- Posted Re: Accounts Payable and Receivable at year end on Forum in Developers Visma.net. 12-04-2023 10:57
- Posted Accounts Payable and Receivable at year end on Forum in Developers Visma.net. 03-04-2023 10:21
- Posted Re: Urgent - Connection to cache service failed on Forum in Developers Visma.net. 31-03-2023 15:21
- Kudoed Re: Getting Tenants/Customers for an application in the Developer Portal for Magnus Johnsen. 01-03-2023 11:43
- Kudoed Re: Getting Tenants/Customers for an application in the Developer Portal for Yıldırım. 01-03-2023 11:43
- Kudoed Re: Getting Tenants/Customers for an application in the Developer Portal for Magnus Johnsen. 28-02-2023 14:23
- Posted Getting Tenants/Customers for an application in the Developer Portal on Forum in Developers Visma.net. 28-02-2023 12:36
- Posted Re: Fetch attachementId from Journal Transactions on Forum in Developers Visma.net. 21-02-2023 09:18
- Posted Fetch attachementId from Journal Transactions on Forum in Developers Visma.net. 20-02-2023 16:40