Net sales amount from AR Tran table via the ERP Service API?

[Tapiiros]

Is there a way to fetch the net sales amount from AR Tran table via the ERP Service API? In our case there are additional discounts on invoices/groups that we need to allocate to invoice lines/products. In the net sales amount field this is already calculated and we can't calculate it using the information available on the Service API. We have an urgent need for the net sales amount information, so that we may calculate product level revenue and margins. The combined discount on invoice level or the DS-type invoice line don't provide enough information because group discounts have different percentages for different lines/products.

[Marten Voort]

Hi Tapiiros, unfortunately system tables are not directly accessible by API. All available information is registered here: https://integration.visma.net/API-index/

Alternatively you can seek assistance from your local partner with Visma.net ERP knowledge to help you in this process.