Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
COSTES is a resident table, so try
inner JOIN (SALESLINE)
LOAD ITEMID, COSTEUDCASTD
resident COSTES;
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.
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
Hi Gysbert!!!
Thank YOU!!!!!!!!!!!!!!!!!!!!!!!