topic Re: Microsoft AX ERP with QV in QlikView

Microsoft AX ERP with QV

Mon, 18 Jan 2010 12:23:01 GMT

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

Microsoft AX ERP with QV

Mon, 18 Jan 2010 13:04:44 GMT

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

Microsoft AX ERP with QV

Tue, 19 Jan 2010 06:02:55 GMT

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);

}

Microsoft AX ERP with QV

Mon, 25 Jan 2010 10:27:31 GMT

Hi Martin,

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

Microsoft AX ERP with QV

Mon, 16 Apr 2012 09:24:59 GMT

Hi Jai,

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

if so pls share with me.

Re: Microsoft AX ERP with QV

Wed, 25 Jul 2012 13:18:40 GMT

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