Product code in sales order line table Snelstart

Questions (nl)
, ,
1

I am looking for a key or item code in sales order lines in Exact. I have built an inventory report in PowerBI using data from Snelstart, where I display the quantities in stock and their value.

With the table SalesOrderLines@SNR, I do get the lines per sales order with the description of the items. However, there are multiple items with the same name in my Snelstart. Unfortunately, this cannot be adjusted.

So I am looking for a table that shows a unique key, such as the product code, for items in sales order lines.

Does anyone know if this exists?

3

In a new version of the data model provided by SnelStart, these fields appear to be available. An analyst will assess whether the changes can be incorporated into the current SnelStart driver. This topic will be updated thereafter. This process may take several weeks.

5

From release 26.0.84, the article_id field will be available. This new release is being/will be implemented in production on Invantive Cloud.

For more information see:

6

This question has been automatically closed after 1 week of inactivity. The last given answer has been marked as the solution.

Please start a new topic if the issue reoccurs. In the new question, please include a link to this topic by pasting its URL into the text.