Microsoft Dynamics AX (Archived)

Select Date Wise Net Balance

(0) Share

Report

Posted on by Community Member Microsoft Employee

Dear Expert

Below query date criteria is not working i am getting todate amount from database

please advice on query...Thanks

Afridi

display Amount VendorTotalCreditOnGrid(VendTrans _VendTrans)
{

real VendTotalCredit;
VendTrans vendTransLocal;

select sum(AmountCur) from vendTransLocal
where vendTransLocal.AccountNum==_VendTrans.AccountNum && vendTransLocal.AmountCur<0
&& vendTrans.TransDate <= TxtDate.dateValue();

VendTotalCredit = vendTransLocal.AmountCur;

return VendTotalCredit;

}

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Select Date Wise Net Balance

Thanks Dick I got my result
Community Member Microsoft Employee on at

Like (0)

Report

RE: Select Date Wise Net Balance

I Just Put the Local in query thanks for identifying
Community Member Microsoft Employee on at

Like (0)

Report

RE: Select Date Wise Net Balance

Thanks Dick

Yes it is control on form and EDT is TransDate and I droped Display Method on grid

to calculate amount
Verified answer

Dick Wenning 8,705 on at

Like (0)

Report

RE: AOT Date Wise Net Balance

I assume that txtDate is a control on a form?

is this one of EDT type TransDate?

also

select sum(AmountCur) from vendTransLocal

where vendTransLocal.AccountNum==_VendTrans.AccountNum && vendTransLocal.AmountCur<0

&& vendTransLocal.TransDate <= TxtDate.dateValue();

VendTotalCredit = vendTransLocal.AmountCur;

return VendTotalCredit;