Problem with this function

[ecabanas]

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;

[swuehl]

COSTES is a resident table, so try

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

resident COSTES;

[Gysbert_Wassenaar · Accepted solution]

This is probably causing the error:

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From resident COSTES;

But when you load SALESLINE it will be joined on COSTES as both contain the field ITEMID. So you can leave it out all together.

[ecabanas]

Hi swuehl, thank's fro your answer, but doing your answer I had this message:

not possible to open the file'C:\Users\eduard\Documents\COSTES' The system could not find the file

  inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From COSTES

any idea?

thank's

[ecabanas]

Hi Gysbert!!!

Thank YOU!!!!!!!!!!!!!!!!!!!!!!!