Subversion Repositories SmartDukaan

Last modification

• Rev 35479 2025-12-22 02:15:05
• Author: amit

• Log message:

  Optimize Aging.SoldAgingModel query and fix column mapping
  
  - Changed DATEDIFF(NOW(), inv.invoiceDate) > 15 to sargable condition
  - Fixed trailing spaces in column names (SLOWMOVING_Billed, RUNNING_Billed, etc.)
  - Enables index usage on invoiceDate column
  
  🤖 Generated with [Claude Code](https://claude.com/claude-code)
  
  Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>