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…

Missing data field "CostPrice" in ExactOnlineXML.. SalesOrderLines

Questions

forums Split this topic November 4, 2021, 6:55pm 4

9 berichten zijn gesplitst naar een nieuw topic: Kostprijs in verkoopmarge

Topic		Replies	Views
ExactOnlineXML XML Costunits/Costcenters table empty Questions exact-online , power-bi , invantive-cloud	5	493	April 11, 2024
CostpriceFC van de Verkooporderregels in Exact Online Vragen power-bi , invantive-bridge-online , invantive-cloud , exact-online	3	241	April 11, 2024
Cost per Item from ShopOrderRoutingStepPlans on Exact Online Questions exact-online	5	464	May 8, 2024
Error itgenoda483 on purchase order lines query Questions invantive-query-tool , exact-online	11	874	April 11, 2024
Upload costcentre to Exact Online Questions exact-online , invantive-control-for-excel	3	1071	November 10, 2022

Missing data field "CostPrice" in ExactOnlineXML.. SalesOrderLines

Related Topics