Aged Creditors Extra Ref and duplication
Posted: 09 May 2018, 11:20
Hi Bruce,
I've read a few of the posts about the Extra Ref not showing on reports etc, that's not exactly my isssue.
I have turned on the Sage setting to allow the splits to be shown.
The issue is the duplication from the Audit Splits and the subsequent totalling.
I've been trying to follow the Sage article
https://my.sage.co.uk/public/help/askar ... leid=30829
Which relates to "..If you then add the AUDIT_SPLIT_EXTRA_REF variable, when you run the report, each transaction appears twice, once for each extra reference."
It then suggests adding a group "Evaluate Section = AUDIT_SPLIT.HEADER_NUMBER Footer"
However, i can add the group into the report, and no matter where i put it i get varying results, but the duplication still appears.
My question is , should i be adding fields into this AUDIT_SPLIT.HEADER_NUMBER group, and if so, what and where in the structure should it appear.
I'm currently working on the Aged Creditors Analysis (Detailed) with disputed items report - SPLAGEDD.
I've attached the report in the hopes you can point me in the right direction. I've added a few extra fields to the Account Ref Header, as we need to see a little more info - but as they are all puling from the Purchase Ledger table, i don't think this is causing the issue, as i've tried the original report (added extra ref and nothing else) and i'm getting the same issue. The filter is also set to look at --BACS payment methods only. Hope this makes sense?
Thanks
Paul
I've read a few of the posts about the Extra Ref not showing on reports etc, that's not exactly my isssue.
I have turned on the Sage setting to allow the splits to be shown.
The issue is the duplication from the Audit Splits and the subsequent totalling.
I've been trying to follow the Sage article
https://my.sage.co.uk/public/help/askar ... leid=30829
Which relates to "..If you then add the AUDIT_SPLIT_EXTRA_REF variable, when you run the report, each transaction appears twice, once for each extra reference."
It then suggests adding a group "Evaluate Section = AUDIT_SPLIT.HEADER_NUMBER Footer"
However, i can add the group into the report, and no matter where i put it i get varying results, but the duplication still appears.
My question is , should i be adding fields into this AUDIT_SPLIT.HEADER_NUMBER group, and if so, what and where in the structure should it appear.
I'm currently working on the Aged Creditors Analysis (Detailed) with disputed items report - SPLAGEDD.
I've attached the report in the hopes you can point me in the right direction. I've added a few extra fields to the Account Ref Header, as we need to see a little more info - but as they are all puling from the Purchase Ledger table, i don't think this is causing the issue, as i've tried the original report (added extra ref and nothing else) and i'm getting the same issue. The filter is also set to look at --BACS payment methods only. Hope this makes sense?
Thanks
Paul