Hi everyone,
I could not explain the issue clearly in the title so I will try my best to do so here. I have also attached an image where you can observe what I'm talking about.
This concerns the connection between QlikSense and SAGE 200 UK, in particular, the Profit and Loss statement. This issue does not affect other countries incorporated into Qlik and connections to other systems.
As you can observe in the photo called incorrect, the first account, 129000 contains the results for each closed financial year. However, below 129000, all accounts starting with 6 and 7 appear (general company accounts, representing Profit and Loss respectively, appear). Nevertheless, they should not appear there, nor should they contain any values. In the attachment named correct you can see how it should look like. Said accounts for closed year should at least zero in.
I'm afraid I cannot provide the loading scripts as development is done by our Qlik partner and we do not have access to the backend.
Thank you in advance,
George
