Small and medium business | Business Central, N...

Reporting issue duplication

(0) Share

Report

Posted on by swebb111

Hi All,

I'm new to AL development, and I'm having an issue where I have a report that seems to be duplicating some entries. I'm pulling data from both my Posted Sales Invoice Table and the Posted Credit Memo Table, and trying to combine them in to one Excel file for an end user who does pivots from there. The issue we're running in to is that there are significantly more credit memos than sales invoices. I think it is causing duplications for the sales invoice data per unique value of the credit memo data. I'm wondering if it is possible to to accomplish this? I may not be choosing the best option here, so any and all feedback is appreciated it. Thanks.

All responses (2)

Answers (0)

Community member 11 on at

Like (0)

Report

Reporting issue duplication

As ZHU mentioned it is a bit difficult to pinpoint the problem. I am guessing excel buffer build-up in wrong trigger...
Suggested answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (0)

Report

Reporting issue duplication

I don't know how your report is developed. If you only need header data, you can consider using Customer Ledger Entries directly. There is a Document Type in it, which can filter out Invoice and Credit memo.

Hope this can give you some hints.

Thanks.

ZHU