Good day.

By select no corporate resources in use.

My major concern in itself, is that there may be a very great limitation in Standard version with respect to Enterprise for the...

Thanks for the feedback.

We do not use online reconstruction and also do not use table partitioning .

We are concerned with the performance, as the DAX 2012 is more robust.

Friends, I got the result we needed.

I created this script and it was extremely functional.

Many thanks to all who helped.

Hugs

SELECT

DISTINCT P.ITEMID,

RECENTES.OC,

RECENTES.DIMENSION3_

,(SELECT SUM(P2.QTYORDERED)

FROM...

friends,

I am very grateful for the help and attention you have given me.

Indeed, with these data, the result was exactly what I need.

But I think there is...

The result should be:

ITEMNF OC FINALIDADEVALOR_RATEADO

00216627360OC_000119211BAURU ...

Friends, I hope it is this:

CREATE TABLE PURCHLINE

(PURCHID nvarchar(20), ITEMID nvarchar(20),QTYORDERED numeric(28,12), DIMENSION3_ nvarchar(10), DATAAREAID nvarchar(4));

CREATE TABLE INVENTTRANS

(TRANSREFID nvarchar(20), ITEMID nvarchar(20), QTY numeric(28,12), INVOICEID nvarchar(20), COSTAMOUNTPOSTED numeric(28,12), DATAAREAID nvarchar(4));

INSERT INTO...

Steve, I just do not really understand what would those scripts that you highlight.

I need help because exhausted all attempts, but as I told you, I can not express...

Steve, these are examples of data that I have in both tables. (InventTrans and PurchLine).

See, I'm more of a purchase order with the same item, but I need only the...

Friends, see if you could detail:

-- Selects the item in the inventory transactions table

SELECT I.ITEMID ITEM,

-- Selects the number of Invoice associated purchase order

I.INVOICEID NF,

-- Selects the...

friends,

I'm grateful for all the help.

However, all the scripts that I have tried here are returning me the same result.

I still do not understand why the Group...

David,

thanks for the help too.

However, it is returning me the same result.

No returns me all the last purchase orders.

The purchase order image above is an example...

Thank you Steve.

I know this is somewhat complex's what I need.

This calculation I am doing is to apportion the value of freight.

In our system (Dynamics AX 2009),...

For me, the last transaction is not defined by date but by purchase order number.

The order with the highest number is the last created.

The numeric sequence of purchase...

I need to show the last transaction of purchase of all items (Itemid).

This, separated by company (Dimension3_).

Each purchase order (PL.Purchid) generates a transaction in stock (I.TransrefId).

What I...

Friend, thanks for the help ...

Tested with LEFT OUTER JOIN and the result was the same.

See this script below the result that I have two tables ...

Below...