For the complete documentation index, see llms.txt. This page is also available as Markdown.

Do Not Update Doc Details in GSTR1 Excel Sheet\JSON\API

YouTube: How to Disable Export of Document Details in GSTR -1 Excel , JSON and GST APIs?

How to Disable Export of Document Details in GSTR -1 Excel, JSON and GST APIs?

In this tutorial, we will learn how the "Do Not Update Doc Details in GSTR1 Excel Sheet, JSON & API" feature works during GST Return generation in Logic ERP. This option allows users to prevent document details from being exported to GSTR1 Excel files, JSON files, and API-based GST submissions.


Objective of This Feature

  • Exclude document details from GSTR1 exports.

  • Control the information included in GST filing data.

  • Simplify exported GST return files when document details are not required.

  • Manage Excel, JSON, and API output according to business requirements.


Access to GST Returns Configuration

  • Navigate to Reports/Queries and then Sale Registers.

  • Select GST Reports/Returns.

  • Open GST Returns Module.

  • Click on Configuration and open Configuration Settings 2.

  • Locate the option labeled as:

"Do Not Update Doc Details in GSTR1 Excel Sheet, JSON & API"

  • When enabled, document details are not exported during GSTR1 generation.


Observe the Default Behavior

  • The feature is currently disabled.

Action

  • Select the Return Type as GSTR1.

  • Select the required return period.

  • Click Generate.

Review the GSTR1 Data

  • Navigate to the Doc Details tab.

  • All document details are visible in the report.

  • Document information is available for export.

Export the Return Data

Available Export Options

  • Generate JSON File for GST Portal upload.

  • Export report data to Excel using the Upload button.

  • Submit data through API integration where applicable.

  • Example: Export the GSTR1 report to Excel.

Result

  • In the generated Excel file:

    • The Doc Details tab contains all document details.

    • Voucher and document information is exported because the feature is disabled.


Enable the Feature

  • Return to GST Returns Configuration.

  • Enable the option: "Do Not Update Doc Details in GSTR1 Excel Sheet, JSON & API"

  • Save the configuration.

Generate and Export the Return Again

  • Generate the GSTR1 return for the same period.

  • Export the report data to Excel using the Upload button.

Result

  • After enabling the feature:

    • The Doc Details tab is no longer updated.

    • Document details are not exported to the Excel file.

    • The same behavior applies to JSON exports and API-based data transmission.


Key Benefits

  • Provides better control over GSTR1 export data.

  • Prevents document details from being included in exported files.

  • Simplifies Excel and JSON output.

  • Supports customized GST filing workflows.

  • Reduces unnecessary document-level data in exports.


Best Practice Tips

  • Keep the feature disabled when detailed document information is required for reconciliation or audit purposes.

  • Enable the feature when document-level details are not needed in exported GST files.

  • Review exported Excel and JSON files before filing returns.

  • Ensure compliance with your organization's GST reporting requirements before excluding document details.


Final Outcome

When the "Do Not Update Doc Details in GSTR1 Excel Sheet, JSON & API" feature is enabled, Logic ERP excludes document details from GSTR1 exports generated through Excel files, JSON files, and API integrations. This allows businesses to control the level of detail included in GST return exports and tailor the output according to their reporting requirements.

Last updated