Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Microsoft Dynamics Ax Ledger Reports In Qlikview

I developed a feature that allows show financial reporting of Microsoft Dynamics Ax in Qlikview. This has two parts, a Microsoft Dynamics Ax project that generates ledger accounts group of financial report definition and connector that obtains this information in Qlikview who is use with this expresion.

sum({$ <[Tipo de acumulación] = {0}, [Tipo de informe] = {11}, [Año] = {$(=Año)}>} (([Importe a credito de la transacción] + [Importe a debito de la transacción]) * [Invertir el signo]))

The combination of LedgerTrans, LegerTableGroups and the expresion allows to get the report in Qlikview.

0 Replies