4 Replies Latest reply: Oct 29, 2012 5:53 AM by Eduard Cabanas Gili RSS

    Problem with this function

    Eduard Cabanas Gili

      I have Two tables:

       

      COSTES cames from an excel and has the standard product costs

      SALESLINE: is a sql table, and I want to introduce the value COSTEUDCASTD  from table "costes" , I tryed this, but it doesn'y work...

       

      Thank's in advance to eveyone!!!

       

      Eduard

       

      COSTES:

      Directory;

      LOAD [Código artículo] AS ITEMID,

           [Descripcion Articulo],

           [Precio Coste Ud] AS COSTEUDSTD,

           [Precio Coste UD CA]AS COSTEUDCASTD

      FROM

      [..\..\..\Data BI\Costes_Standard.xlsx]

      (ooxml, embedded labels, header is 10 lines, table is Cost);

       

       

      SALESLINE:

      Load SALESID, ITEMID, SALESSTATUS, NAME, QTYORDERED, SALESPRICE, INVENTTRANSID, CUSTACCOUNT,EVE_AMOUNTMSTEXCLTAX, year(CREATEDDATETIME)AS ANO, Month(CREATEDDATETIME)AS Mes;

      SQL SELECT SALESID,ITEMID,SALESSTATUS,NAME,QTYORDERED,SALESPRICE,INVENTTRANSID,CUSTACCOUNT,CREATEDDATETIME,EVE_AMOUNTMSTEXCLTAX

      from DynamicsAx.dbo.SALESLINE;

      inner JOIN (SALESLINE)

      LOAD ITEMID, COSTEUDCASTD

      From COSTES;