Microsoft AX ERP with QV

[#1]

Hi all,

Any of you developed QV reports on top of Microsoft AXEPTA ERP.If it is please let me knw asap

Thanks & Regards

Jai

[#2]

Hi Jai

We use Axapta as ERP, and have created a lot of reports/Applications on top of that as our mainly (and only BI).

I have gained a pretty good insight of the structure in Axapta since i started building apps with QlikView for this company.

Anything specifik you want to know?

/Martin

[#3]

Hi Martin,

First of all I am very glad to see your kind reply.Thing is our client using AX.In sales cube in AX there are several reports.In some of the reports fields coming directly from the base table.No issues with that.In some of reports they are using methods() to process the calucation.There,fields were calling from temp table and it is invoked to another clause again from there values passed to another clause.Every thing happening here is on the fly.So just let me knwo in qv how it should be proceed.For your calrification here I ahve attached AX script.Have a look and let me know how it should be proceed further

Normal 0 false false false EN-US X-NONE X-NONE

Script in AX:

display AmountMST balance()

{;

return custTable.balanceMST();

Normal 0 false false false EN-US X-NONE X-NONE

display AmountMST balanceMST(FromDate _fromDate = dateNull(),

ToDate _toDate = dateMax()

)

{

return this.CustVendTable::balanceMST(_fromDate, _toDate);

}

[#4]

Hi Martin,

I hope you got my reply.Just let me know how to proceed further.

[#5]

Hi Jai,

i am facing the same problem. Have u got the solution?..

if so pls share with me.

[#6]

Load CustTrans and VendTrans Table concatenated in custVendTrans Table and sum(AmountMST) field in expresión.

The statement of balanceMST display method is

select sum(AmountMST) from custVendTrans
        where custVendTrans.AccountNum  == this.AccountNum  &&
              custVendTrans.TransDate   >= _fromDate        &&
              custVendTrans.TransDate   <= _toDate;

return custVendTrans.AmountMST;

i hope to help you