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 Heeft dit topic gesplitst 4 november 2021 om 18:55 4

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

Topic		Antwoorden	Weergaven
ExactOnlineXML XML Costunits/Costcenters table empty Questions exact-online , power-bi , invantive-cloud	5	493	11 april 2024
CostpriceFC van de Verkooporderregels in Exact Online Vragen power-bi , invantive-bridge-online , invantive-cloud , exact-online	3	241	11 april 2024
Cost per Item from ShopOrderRoutingStepPlans on Exact Online Questions exact-online	5	464	8 mei 2024
Upload costcentre to Exact Online Questions exact-online , invantive-control-for-excel	3	1071	10 november 2022
ExactOnlineRest SalesOrderLines ontbrekende kolommen modified, modier, modifierfullname Vragen exact-online	3	337	11 april 2024

Missing data field "CostPrice" in ExactOnlineXML.. SalesOrderLines

Gerelateerde topics