topic Microsoft Dynamics Ax Ledger Reports In Qlikview in Español https://community.qlik.com/t5/Espa%C3%B1ol/Microsoft-Dynamics-Ax-Ledger-Reports-In-Qlikview/m-p/1478596#M13960 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>sum({$ &lt;[Tipo de acumulación] = {0}, [Tipo de informe] = {11}, [Año] = {$(=Año)}&gt;} (([Importe a credito de la transacción] + [Importe a debito de la transacción]) * [Invertir el signo]))</P><P></P><P>The combination of LedgerTrans, LegerTableGroups and the expresion allows to get the report in Qlikview. </P></BODY></HTML> Fri, 07 Mar 2014 09:25:47 GMT 2014-03-07T09:25:47Z Microsoft Dynamics Ax Ledger Reports In Qlikview https://community.qlik.com/t5/Espa%C3%B1ol/Microsoft-Dynamics-Ax-Ledger-Reports-In-Qlikview/m-p/1478596#M13960 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>sum({$ &lt;[Tipo de acumulación] = {0}, [Tipo de informe] = {11}, [Año] = {$(=Año)}&gt;} (([Importe a credito de la transacción] + [Importe a debito de la transacción]) * [Invertir el signo]))</P><P></P><P>The combination of LedgerTrans, LegerTableGroups and the expresion allows to get the report in Qlikview. </P></BODY></HTML> Fri, 07 Mar 2014 09:25:47 GMT https://community.qlik.com/t5/Espa%C3%B1ol/Microsoft-Dynamics-Ax-Ledger-Reports-In-Qlikview/m-p/1478596#M13960 2014-03-07T09:25:47Z