static void VendorAmount(Args _args)
{
vendTrans vendTrans;
vendTransOpen vendTransOpen;
select vendtrans
where vendTrans.AccountNum == 'V0191'
join sum(AmountCur)
from vendTransOpen
where vendTransOpen.RefRecId == vendTrans.RecId;
info(strFmt('%1',vendTransOpen.AmountCur));
/*
select CurrencyCode
from vendTrans
group by CurrencyCode
where vendTrans.AccountNum == _accountNum
join sum(AmountCur), sum(AmountMST)
from vendTransOpen
where vendTransOpen.RefRecId == vendTrans.RecId
*/
}
No comments:
Post a Comment