The column costperitem from table ShopOrderRoutingStepPlans has values with 2 digits.
Could this be set towards 5 digits (like Exact Online)?
Invantive SQL does not change the number of digits. According to the data model, CostPerItem is a double.
See https://documentation.invantive.com/notes/webhelp/invantive-notes-a-somewhat-exact-api.html for more background.
Can you provide a sample where digits are shown in Exact Online web interface and none in the receiving package? Make sure to also try another tool or multiply it by 1000 to make trailing digits visible which might be not displayed.
Maybe what I look for is in another table, but I am looking for the costprice for production hours. I can find them for material, but not production hours (at leat, not for 5 digits).
See attachment:
To clarify:
the cosprice in ShopOrderRoutingStepPlans is the planned (expected) costprice. I am looking for the realized cosprice per unit or the total realized costs (see also the attachement in previous message).
Where did you find it for production hours, but with incorrect number of digits? Do you have an Invantive SQL sample?
This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.
Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.