Microsoft Dynamics AX (Archived)

Criteria for Voucher Transactions

(0) Share

Report

Posted on by Community Member

Hello,

For the criteria for voucher transaction are you able to do an 'Or Statement'?

Also in the criteria for voucher transaction how to do pull actual vs budget information?

Thanks!

Meghan

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Syed Fasih 2,442 on at

Like (0)

Report

For you 1st part of the questions, what do you mean when you say "Or statement"?

For the 2nd part of your question, the budget transaction is not recorded at voucher level. The budget is captured at main account.

The actual vs. Budget report can be taken from budgeting module.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For the first part what I mean by an Or statement is that are two sets of criteria that I am trying to pull back in one report. For example I want it to be account XYZ within a date range or I want it to be account QRS with a different date range.

Sounds good, thanks!

Was this reply helpful? Yes No
Suggested answer

Syed Fasih 2,442 on at

Like (0)

Report

I am afraid, that is not available. The criteria works in combination with all parameters. You can use some BI cubes to get this intelligence.

Please marks the answers as verified if your queries are solved.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sounds good, thanks for all your help!

Was this reply helpful? Yes No
Verified answer

Syed Fasih 2,442 on at

Like (0)

Report

Please marks the answers as verified if your queries are solved.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Meghan Isaacs,

One possibility might be if-then-else statements that you can define in Management Reporter.

Technically this is not an 'OR' condition but I believe that you can get the outcome you are looking for.

Probably have a look at the following site (msdn.microsoft.com/.../dn464327.aspx) and do some testing in MR.

Best regards,

Ludwig

Was this reply helpful? Yes No