---
id: change/bcapps/10100
type: change
title: "#10100 [Bug 644091] Separate B2B and B2C HSN summaries in GSTR-1 report"
summary: 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.
tier: official
language: en
tags:
  - fix
  - main
  - bc30
  - query gstr1hsngstamt
  - query gstr1hsnqty
  - query gstr1hsnquery
  - report gstr-1 file format
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:09:24.094Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: 8483d6c8baf8cdb215688514645851f0bcc4a447
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/10100
    title: "microsoft/BCApps#10100: [Bug 644091] Separate B2B and B2C HSN summaries in GSTR-1 report"
    date: "2026-08-11"
    commit: 8483d6c8baf8cdb215688514645851f0bcc4a447
    t: null
    quote: Separate B2B and B2C HSN summary handling in the GSTR-1 report.
links:
  learn: []
  objects:
    - object/query/18028-in
    - object/query/18029-in
    - object/query/18030-in
    - object/report/18049-in
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 10100
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/10100
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-11T22:03:36Z"
author: v-ajaztabrez
author_type: User
community_contribution: false
labels:
  - "Team: Finance"
change_class: code
change_kind: fix
behavior_change: true
breaking: false
files:
  count: 4
  additions: 124
  deletions: 67
  al: 4
apps:
  - INReports
objects_touched:
  - key: query/18028
    page: query/18028-in
    type: query
    id: 18028
    name: GSTR1HSNGSTAmt
    app: INReports
    status: modified
  - key: query/18029
    page: query/18029-in
    type: query
    id: 18029
    name: GSTR1HSNQty
    app: INReports
    status: modified
  - key: query/18030
    page: query/18030-in
    type: query
    id: 18030
    name: GSTR1HSNQuery
    app: INReports
    status: modified
  - key: report/18049
    page: report/18049-in
    type: report
    id: 18049
    name: GSTR-1 File Format
    app: INReports
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 644091
systems:
  - finance
quote: Separate B2B and B2C HSN summary handling in the GSTR-1 report.
joined_against:
  major: "30"
  commit: a4406cfa9e57437fedc49c53c327a199a854491e
---

# #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.

[Pull request](https://github.com/microsoft/BCApps/pull/10100) · 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"](../../objects/query/18028-in.md), INReports (IN layer): modified
- [Query 18029 "GSTR1HSNQty"](../../objects/query/18029-in.md), INReports (IN layer): modified
- [Query 18030 "GSTR1HSNQuery"](../../objects/query/18030-in.md), INReports (IN layer): modified
- [Report 18049 "GSTR-1 File Format"](../../objects/report/18049-in.md), 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).