GSTR 9 HSN Summary — entity reference

One line of the GSTR-9 HSN-wise summary: Table 17 (outward) or Table 18 (inward). Compute GSTR9 deletes and rebuilds the return's rows each time, building Table 17 from the books-side HSN summary (GSTR-1 Table 12) rows of the GSTIN's Filed GSTR-1 returns in the financial year, added up per HSN code and rate across months and the B2B/B2C halves. Table 18 is never built. Rows are read-only: there is no form, list button or override. Save GSTR-9 to GSTN sends the rows that have a code; Export GSTR9 JSON does not include them.

Fields

Field	Label	Type	Required	What it does
`CessAmount`	Cess Amount	Currency		Cess for the code and rate added up over the year, credit notes subtracted.
`CGSTAmount`	CGST Amount	Currency		Central tax for the code and rate added up over the year, credit notes subtracted.
`CreatedById`	Created By	Lookup → UserAccount	Yes
`CreatedDateTime`	Created Date	DateAndTime	Yes
`Direction`	Direction	Text		Outward for Table 17 or Inward for Table 18. Compute GSTR9 writes Outward only; nothing creates Inward rows.
`GSTR9ReturnId`	GSTR 9 Return	Lookup → GSTR9Return		The GSTR-9 annual return this row belongs to. Set by Compute GSTR9.
`HSNCode`	HSN Code	Text		The HSN/SAC code the row adds up, taken from the GSTR-1 HSN summary rows. Blank when the sales lines had no code; a blank-code row is kept but not sent to GSTN.
`Id`	Id	Guid	Yes
`IGSTAmount`	IGST Amount	Currency		Integrated tax for the code and rate added up over the year, credit notes subtracted.
`Label`	Label	Text		Overwritten with the same generated record number as Name when the row is saved.
`ModifiedById`	Modified By	Lookup → UserAccount	Yes
`Name`	Name	Text	Yes	Record number from the GSTR9 HSN Summary Name Setting (series GST9HSN). Every compute creates fresh rows, so the name changes each time; read the code from HSN Code.
`OwnerId`	Owner	Lookup → UserAccount	Yes
`Quantity`	Quantity	Currency		Sum of the GSTR-1 HSN rows' quantities, which are 1 for goods and 0 for services per month and half. It is not the number of units sold.
`Rate`	Rate	Currency		The tax rate the GSTR-1 rows were grouped on: the rate of each tax line, so intra-state supplies appear at the central/state rate (half the GST rate) and inter-state supplies at the integrated rate, as separate rows.
`RecordTypeId`	Record Type	Guid, hidden
`SGSTAmount`	SGST Amount	Currency		State/UT tax for the code and rate added up over the year, credit notes subtracted.
`SubscriptionKey`	Subscription Key	Guid, hidden	Yes
`TaxableValue`	Taxable Value	Currency		Taxable value for the code and rate added up over the year, with credit notes subtracted. Can be negative.
`UpdatedDateTime`	Modified Date	DateAndTime	Yes
`UQC`	UQC	Text		Unit quantity code taken from the first GSTR-1 HSN row of the group that has one: NOS for goods or NA for services, as GSTR-1 reports them. Sent as NA when blank.

UserAccount — looks up via OwnerId
GSTR9Return — looks up via GSTR9ReturnId
UserAccount — looks up via ModifiedById
UserAccount — looks up via CreatedById

GSTR 9 HSN Summary — entity reference

Fields

Related entities

Related topics