Hi everyone,
Sorry, but now I'm blocked!!! I have a table called SALESID_TEMP, that select fields from two sources.
I want to add to this table (after the last record) another table/source EVE_CUSTINVOICETRANS
I have the following scrip, but for example
| ITEMID | SALESID
| EVE_AMOUNTMSTEXCLTAX | COSTAMOUNTPOSTED(EVE_CUSTINVOICETRANS) |
|---|
| 1 | PV00001 | 100 |
|
| 2 | PV00001 | 200 |
|
|
|
|
|
| PICKING | PV00001 |
| 20 |
| PICKING | PV00001 |
| 25 |
The PICKING lines come from EVE_CUSTINVOICETRANS
SALESLINE_TEMP:
Load UPPER(ITEMID)AS ITEMID,SALESSTATUS,SALESID,QTYORDERED,INVENTTRANSID,CUSTACCOUNT,EVE_AMOUNTMSTEXCLTAX,CREATEDDATETIME, year(CREATEDDATETIME)AS ANO, Month(CREATEDDATETIME)AS Mes;
SQL SELECT SALESID,ITEMID,SALESSTATUS,QTYORDERED,INVENTTRANSID,CUSTACCOUNT,CREATEDDATETIME,EVE_AMOUNTMSTEXCLTAX
from DynamicsAx.dbo.SALESLINE;
inner join(SALESLINE_TEMP)
Load INVENTTRANSID, DATEFINANCIAL;
SQL SELECT INVENTTRANSID, DATEFINANCIAL
from DynamicsAx.dbo.INVENTTRANS;
Concatenate (SALESLINE_TEMP)
Load SALESID,COSTAMOUNTPOSTED;
SQL SELECT SALESID,COSTAMOUNTPOSTED
from DynamicsAx.dbo.EVE_CUSTINVOICETRANS;
Thank you!!!
Eduard
