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 , invantive-cloud , power-bi	5	495	11 april 2024
CostpriceFC van de Verkooporderregels in Exact Online Vragen exact-online , invantive-bridge-online , invantive-cloud , power-bi	3	244	11 april 2024
Cost per Item from ShopOrderRoutingStepPlans on Exact Online Questions exact-online	5	465	8 mei 2024
Error itgenoda483 on purchase order lines query Questions exact-online , invantive-query-tool	11	887	11 april 2024
Upload costcentre to Exact Online Questions exact-online , invantive-control-for-excel	3	1084	10 november 2022

Missing data field "CostPrice" in ExactOnlineXML.. SalesOrderLines

Gerelateerde topics