In the table ExactOnlineXML..SalesOrderLines the field CostPrice is not available, although it’s available when a SalesOrder is exported via XML in Exact Online. Can this field be added? [Sales order XML]

An approximation would be to use the historical purchase orders: -- -- Historische inkoopprijzen per artikel. -- create or replace table purchaselines@inmemorystorage as select por.orderdate , por.orderdate - to_number(to_char(por.orderdate, 'D')) sun_in_week_date , to_char(por.or…

The content of the field is skipped because the eExact-XML.xsd does not contain this field (at least on September 16, 2021): <xsd:element name="SalesOrderLine" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element ref="Description" minOccurs="0"/> <xsd:element ref="Item"/> …

A bug report has been created at Exact Online with number #03449297 to report that at least both CostPriceFC and Margin are missing in SalesOrderLine.

Currently Exact Online considers the missing fields in the XSD a feature for which an idea can be postponed on the Exact Online Community Forums. We will try to motivate that the XSD is used for automatic validation of XML and the current XML is invalid, and therefor a bug.

Wat is de divisiecode en land van deze administratie?

This question was automatically closed after 2 weeks of inactivity. 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.

Missing data field "CostPrice" in ExactOnlineXML.. SalesOrderLines

Vragen (en)

Topic		Antwoorden	Weergaven
ExactOnlineXML XML Costunits/Costcenters table empty Vragen (en) exact-online , invantive-cloud , power-bi	4	500	10 november 2022
CostpriceFC van de Verkooporderregels in Exact Online Vragen (alle) exact-online , invantive-bridge-online , invantive-cloud , power-bi	2	245	20 mei 2023
Cost per Item from ShopOrderRoutingStepPlans on Exact Online Vragen (en) exact-online	4	465	8 mei 2024
Error itgenoda483 on purchase order lines query Vragen (en) exact-online , invantive-query-tool	9	889	11 oktober 2022
Upload costcentre to Exact Online Vragen (en) exact-online , invantive-control-for-excel	2	1086	10 november 2022

Missing data field "CostPrice" in ExactOnlineXML.. SalesOrderLines

Gerelateerde topics