Search results

  1. H

    ODBC Date prefilter for Power Query

    Hi, I am working on a power query report, based on QAD erp data tables using ODBC connection. I am using filters already on the source to optimise load time (mainly date, domain etc.). Here is an example: SELECT op_date,op_qty_comp,op__dec01,op_emp FROM PUB.op_hist WHERE op_date >...
  2. H

    Question How to include logistic cost as a cost element for purchased items.

    Hi, We buy several types of materials with EXW incoterm. As to have a clear picture on item cost and to be in line with local regulations we should make the reception of the goods (mainly base material) with all the additional costs included (transport cost, customs tax, other logistic...
Top