Sales Invoice

Sales Invoice Module - User Guide

โš ๏ธ

โœจ AI-POWERED INNOVATION: Natural Language Billing (Free Preview)

Generate invoices using natural language text prompts (e.g., “Make Invoice for order = 000123”). This matches pending orders, calculates rates, and generates draft invoices instantly.

1. Introduction ๐Ÿ“

The Sales Invoice module is the critical final step in the sales fulfillment process. It represents the legal demand for payment and the official record of goods dispatched. It integrates deeply with Sales Orders, Inventory Control, GST Compliance, and Logistics.

โ„น๏ธ

In the overall business flow:

  1. It consumes Pending Sales Orders and reduces Store Stock.
  2. It generates the financial liability in Accounts Receivable.
  3. It triggers E-Invoice (IRN) and E-Way Bill compliance workflows.
  4. It issues Cryptographically Signed PDF Invoices with tamper-proof X.509 digital signatures.

Typically, this module is used by Billing Clerks, Logistics Officers, and Finance Managers.


2. Getting Started with Sales Invoice ๐Ÿš€

Accessing the Module

Navigate to the Sales Invoice Index via the Sales menu.

Sales Invoice Index Page

The Index Page

  • Search & Filters: Multi-criteria filters by Invoice No, Date (with =, >, < operators), Unit, Invoice (Sub) No, Party Short Name, Amount, and Currency.
  • PO / Item Details Explorer (invoice1index/0): Click the Item Details button on the bottom bar to search and filter individual line items across all customer invoices.

Modes of Creation

There are four primary ways to generate an invoice:

  1. Manual Header + Line Selection: Create the header first, then pick specific items from pending orders.
  2. Create From Order: Copies an entire Sales Order (Header + all OK lines) into an invoice in one click (available when line count is 0 and QR mode is not active).
  3. QR & Bulk Excel Import (invoice1import): For high-volume environments, pull pending items via QR barcode lookups or upload an ImportInvoice.xlsx file.
  4. AI-Powered Generation (aiinvoicecreate): Use natural language prompts to let the AI match orders and create preview drafts autonomously.

3. Features โœจ

๐Ÿ“ฆ Inventory & Fulfillment

  • Negative Stock Inspection (invoicenegativestockindex): Prevents dispatches exceeding physical store balance. When stock shortages occur, users can inspect the dedicated Negative Stock screen showing Item ID, Short Name, Brand, Order Qty, and current Store Balance.
  • Create From Order: One-click complete duplication of an active order into an invoice.
  • Multi-Order Invoicing: Combine multiple Sales Orders for the same party into a single invoice.

๐Ÿš› Logistics & Other Operations

  • Transit Info Screen (invoicetransitinfo): View custom Ship-to and Dispatch addresses; automatically syncs from linked Sales Orders for non-e-invoiced records.
  • Dispatch Info Overrides (invoiceupdatedispatchinfo): When auto e-way bill is enabled, modify dispatch party name, address, location, pin code, and state.
  • LR (Lorry Receipt) Management (invoiceuploadlrno): Upload, download, and re-upload transporter LR copies in PDF format.
  • Forwarding Note Printing: Generate formal forwarding documentation for logistics carriers (enabled when invoice has exactly 1 line and e-way bill parameter is active).
  • Make SDN / SCN: Direct creation of a Sales Debit Note or Sales Credit Note directly from the invoice record.

๐Ÿ’ฐ Financials & Compliance

  • Dedicated E-Invoice Screen (einvoicecreate): Interactive interface to generate IRN via API, download official JSON schemas for offline portal upload, or reactivate previously processed records.
  • Cryptographic Digital Signature: Automated X.509 SHA-256 digital signing for PDF invoices, featuring a visual ‘DIGITALLY SIGNED’ box with location/timestamp and full Adobe Acrobat validation. See Invoice Digital Signature Guide.
  • Multi-Currency Engine: Full support for export transactions with mandatory FCNR amount tracking.
  • TCS & Advanced Tax Rules: Automated GST (IGST/CGST/SGST) and TCS calculations based on state codes and turnover thresholds.

4. Complete Flow ๐Ÿ”„

Initialize the Invoice

  • Select the Party and Branch.
  • Choose the Unit (Dispatch Center).
  • The system fetches default Payment Terms, Supply State, and GST Registration data.

Define Logistics & Other Info

  • In invoicemodifyotherinfo, specify:
    • Transporter Name and Transport Mode.
    • Vehicle No (for Road) or LR/GRN No & Date (for Rail/Air/Ship).
    • Net Weight, Cases/Packets, and Carrier Charges.
    • Shipping Bill No and Date for export shipments.

Add Items (Lines)

  • Add items individually from pending orders, or use Create From Order for instantaneous full-order conversion.
  • When QR parameter is active, use Import QR (invoice1import) to search pending orders or upload ImportInvoice.xlsx.
  • The system verifies that Invoiced Qty โ‰ค Pending Qty (unless a 10% excess is permitted by system parameters).

Finalize & Dispatch

  • From invoicedetails, access Other Operations (invoiceotheroperation) to:
    • Print the Invoice PDF (automatically stamped with a cryptographic Digital Signature and visual verification seal if enabled in Company Master; see Invoice Digital Signature for setup).
    • Generate and print E-Way Bill.
    • Print Forwarding Note (for single-item dispatches).
    • Upload customer LR Copy.
    • Direct one-click creation of SDN/SCN.
    • Email the invoice and dispatch advice to customer contacts.

E-Invoice Compliance

  • Click the E-Invoice button on invoicedetails to open einvoicecreate:
    • Click Generate E-Invoice for real-time IRN generation.
    • Or click Download Json to obtain the government-standard JSON file for manual portal upload.

4.1 AI-Powered Invoice Creation โœจ (Free Preview)

The AI Invoice Creator (aiinvoicecreate) allows billing teams to generate complex invoices from plain text commands.

๐Ÿ” How It Works

  1. Enter Prompt: Type your prompt into the command bar using standard order references.
    • Example 1: Make Invoice for order = 000123
    • Example 2: Make Invoice for order = 000123 and item id = 000456
    • Example 3: Make Invoice for order = 000123, 000456
    • Example 4: Make Invoice for order = 000123, item id = 000456 and order = 000456, item id = 000123
  2. Generate Preview: The AI scans pending orders, verifies party consistency, fetches pricing, and renders an interactive Draft Invoice.
  3. Address Stock Warnings: Any line with insufficient store balance is highlighted in Red. Adjust quantities or stores directly on screen.
  4. Confirm & Create: Click Confirm & Create Invoice to save the final invoice into the system.

Note

AI Invoice Creator is currently available in Free Preview. Voice/microphone input is currently disabled/experimental and input is provided via text prompts. If access is disabled (aiFeatureCnt <= 0), please contact your System Administrator.


5. Non-Obvious Validations and Business Rules โš ๏ธ

Validation TypeWhat is checked?Rule / System Action
Cancellation vs. DeletionRemoving an invoice from the system.Direct header deletion is disabled in ERP. Invoices must be Cancelled, which requires a mandatory Cancellation Reason (up to 250 characters).
Connected Docs BlockingModifying or cancelling an invoice.Strictly blocked if linked to any Payment/Receipt Voucher, Journal Entry, Debit/Credit Note, Export commercial invoice, or Sales Rejection.
Excel Import File NameImporting lines via Excel.File MUST strictly be named ImportInvoice.xlsx. Store selection is required when line count is 0.
E-Invoice LockEditing items on an e-invoiced bill.Once an IRN or E-Way Bill is generated, quantities, rates, and amounts are permanently locked from modification.
Tax UniformityTax codes across invoice lines.All items within a single invoice must share the exact same GST tax percentage code (validated against the first added line).
Forwarding Note RequirementPrinting carrier forwarding note.Enabled only when the invoice contains exactly 1 line item and eWayBillSysParameter == "Y".
Party Allow Invoice FlagInvoicing a customer.If Allow Invoice is set to ‘No’ in Party Master, all billing operations are blocked.

6. Tools / Smart Features ๐Ÿ”ง

  • ๐Ÿ” Cross-Invoice Line Item Explorer (invoice1index/0): Search across all line items by Invoice No, Date, Sub No, Item Name, Amount, Order No, and PO No.
  • ๐Ÿ“‹ Negative Stock Diagnostic Grid (invoicenegativestockindex): Deep-dive into shorted items with direct visibility into pending order requirement vs. store stock.
  • ๐Ÿ”„ Reactivate E-Invoice Workflow: If an e-invoice generation attempt gets interrupted, the “Reactivate” button resets the state safely.
  • ๐Ÿ“ฆ Direct SDN/SCN Generation: Instant creation of credit or debit notes directly referencing the active invoice.
  • ๐Ÿ›ก๏ธ Cryptographic Digital Signature: Single-point configuration in Company Master automatically certifies all generated invoice PDFs.

7. Related Reports ๐Ÿ“Š

  • ๐Ÿ“ˆ Sales Analysis Report: Comprehensive revenue, product, and collection analytics.
  • ๐Ÿงพ GST Reports (GSTR-1, GSTR-3B): Statutory outward supply and tax summaries.
  • ๐Ÿ’ฐ Outstanding (AR/AP) Report: Detailed receivables aging analysis.
  • ๐Ÿ“‹ Sales Register: Chronological export of all billed invoices.