Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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-NONEdisplay AmountMST balanceMST(FromDate _fromDate = dateNull(),
ToDate _toDate = dateMax()
)
{
return this.CustVendTable::balanceMST(_fromDate, _toDate);
}
Hi Martin,
I hope you got my reply.Just let me know how to proceed further.
Hi Jai,
i am facing the same problem. Have u got the solution?..
if so pls share with me.
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