How can i track the currency filter in the initVendTransQuery() ?

(1) Share

Report

Posted on by Rabih Khoury

110

Dear

I am trying to customize the vendor statement of account (class VendAccountStatementIntDP) and i need to track the currency filter value indicated below. I realized that this value isn't passed by a parameter but by a query criteria found in the (method Query initVendTransQuery()) in the VendAccountStatementIntDP class.

appreciate your help

thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Hi,

what exactly you want to do with currency filter ?? can you please provide more details ?

Was this reply helpful? Yes No
Rabih Khoury 110 on at

Like (0)

Report
Copy link

Link copied!

I want to show also the Unposted transactions in the vendor statement of account, I've succeeded so far but

I need to use/get this value ("USD" in this example) to filter transactions by currency.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Hamza Bin Mushtaq 160 on at

Like (1)

Report
Copy link

Link copied!

Hi White,

The below query is used by this report.

And, the query already filters the data based on the selected Currency filter.

Can you provide a little bit more details that how are you customizing this report?

Regards,

Hamza

Was this reply helpful? Yes No
Rabih Khoury 110 on at

Like (0)

Report
Copy link

Link copied!

Hi Hamza,

I need to put the "USD" currency filter value shown in red in the first screenshot instead of the yellow highlighted value in the screenshot below:

http://imgur.com/a/6AmfM

Thanks.

Was this reply helpful? Yes No
Verified answer

Hamza Bin Mushtaq 160 on at

Like (3)

Report
Copy link

Link copied!

Hi White,

You can use the default query to get the value of the Currency Range by this code.

{

Query q;
CurrencyCode currency;

q = this.parmQuery();

currency = q.dataSourceTable(tableNum(VendTable)).findRange(fieldNum(VendTable,Currency)).value();

}

Regards,
Hamza

Was this reply helpful? Yes No
Rabih Khoury 110 on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot! That's what I needed.

Was this reply helpful? Yes No