Management reports - How to Exclude a Journal entries

(0) Share

Report

Posted on by GIRMAS

Good Morning,

I need to exclude in management reports a specific Journal entry.

In the columns setting is possible under the selection "Attribute filter" indicate values for specific Journal entry numbers. But the Selection is from to.

Is it possible to exclude a specific value?

The only way I found is to create Hided columns calculating the balance (Columns A) and the value with the specific entries of the JE (Columns B) and then to have a calculated column (C) as A - B.

Having a large number of columns I am looking for a simpler solution.

Thanks

Massimo

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Massimo,

The workaround that you mentioned seems reasonable based on what you describe.

Why is it that you want to exclude this voucher?

Note that if you exclude the voucher from your balance sheet or income statement then those reports might not tie up anymore.

For a separate 'analysis' report things might work out but not for the financial statement reports.

If those reports are affected, then adjust and correct the voucher in AX rather than trying to fix it from the reporting end.

Best regards,

Ludwig

Was this reply helpful? Yes No