#10100 [Bug 644091] Separate B2B and B2C HSN summaries in GSTR-1 report
The GSTR-1 report now handles B2B and B2C HSN summaries separately through conditional filtering based on the selected Nature of Supply, with fallback to combined output when no specific category is chosen.
- 4files
- 4AL files
- 4objects
Pull request · merged into main (BC30) on 2026-08-11 by v-ajaztabrez · 4 files (+124 -67), 4 AL · fix · tier official · reviewed (checked by Opus)
What changed
- HSN queries modified to support conditional filtering by Nature of Supply for B2B/B2C separation
- Report Excel generation logic updated to independently summarize B2B and B2C HSN data
- Blank Nature of Supply selection maintains backward compatibility by showing combined HSN output
- Fixes duplicate rows and incorrect totals that occurred when both B2B and B2C data existed for the same HSN
- Addresses GST portal requirements for separate B2B and B2C HSN reporting in GSTR-1
- Behaviour changes for users or extensions.
AL objects touched
- Query 18028 “GSTR1HSNGSTAmt”, INReports (IN layer): modified
- Query 18029 “GSTR1HSNQty”, INReports (IN layer): modified
- Query 18030 “GSTR1HSNQuery”, INReports (IN layer): modified
- Report 18049 “GSTR-1 File Format”, INReports (IN layer): modified
Context
- Work items: AB#644091
- Labels: Team: Finance
- Systems: finance
- From the description: “Separate B2B and B2C HSN summary handling in the GSTR-1 report.”
Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).