Include buyer Tax ID in India sales report

[ershad]

[Osman536556]

The specific steps to include the Buyer Tax ID (which, in the context of India's Goods and Services Tax, is generally the GSTIN - Goods and Services Tax Identification Number) in a sales report depend entirely on the accounting or ERP software you are using (e.g., TallyPrime, Zoho Books, SAP, etc.) and the report's customisation options. 📝 General Steps to Address the Request Here is the general approach you'll need to follow to fulfill the request for "India sales report #2183":

1. Identify the Tax ID Type The term "Tax ID" in India for a business or dealer is typically the GSTIN (15-digit alphanumeric code). GSTIN Format: The first two digits are the state code, the next ten digits are the entity's PAN, the 13th is the entity number within the state, the 14th is 'Z' by default, and the 15th is a checksum digit. Action: Ensure the Buyer's GSTIN has been collected and recorded in their master record (customer/ledger profile) in your accounting system.
2. Update the Buyer/Customer Master Data Before a Tax ID can appear on a report, it must be stored in the system. Navigate to the Customer/Ledger Master file for the buyers included in Sales Report #2183. Locate the Tax ID field (often labeled GSTIN, VAT ID, or Tax Registration No.). Input or verify the correct GSTIN for each buyer. This is a critical prerequisite.
3. Customize the Sales Report This is where you modify the specific report to display the data you just verified. Open Sales Report #2183 (or the template it's based on) in your software. Look for an option to Configure, Modify, or Customize the report (this is often an on-screen button like F12 or a 'Settings' icon). In the customization menu, find a list of Available Fields or Columns. Select/Enable the field named "Buyer GSTIN," "Customer GSTIN," or "Tax Registration No." to add it to the report's visible columns. Save the report configuration and Re-run the report. If your report is a custom export (e.g., to Excel or CSV), the field must be included in the mapping template before the export is generated

[yashranaway]

#2189 is ready for review.

[sambhavnoobcoder]

@ershad raised a PR for this issue here in #2244 . however wanted to confirm a couple of things regarding the change , would appreciate your response on the same :

1. Report Scope

• Question: Include both B2B + B2C, or keep B2C-only, or separate reports?
• My Assumption: Single report with ALL transactions (B2B + B2C combined)

2. File Naming/Versioning

• Question: Change filename to indicate new schema version?
• My Assumption: Keep existing filename pattern (india-sales-report-YYYY-MM-*.csv)

3. Column Label

• Question: "Buyer GSTIN" vs "Customer GST Number" vs "Business GST Number"?
• Assumption: Used "Buyer GSTIN" (India-specific terminology)

4. Backward Compatibility

• Question: Are there automated parsers that need updates?
• Assumption: Breaking change acceptable, parsers will need manual update

[steveo-es]

@ershad , what is the status of this report?