Skills
.Work. You
Rest

icg-erp

Community

Guardrails for ICG ERP data queries.

Data & Analytics#database#erp#consumption#query-best-practices#kiosco#sql-server-2017
Authorjota-batuta
Version1.0.0
Installs0

System Documentation

What problem does it solve?

ICG ERP databases (KIOSCO) often suffer from confusing schema, mismatched field meanings, and inconsistent terminology across tables. This Skill helps you understand the schema, common gotchas, and best practices to write accurate queries and interpret ERP data reliably.

Core Features & Use Cases

  • Comprehensive mapping of core ERP tables (STOCKS, MOVIMENTS, TRASPASOSCAB, ALMACEN, ARTICULOS, PROVEEDORES) with notes on key columns and pitfalls.
  • Guidance on how to compute true consumption by combining ALBVENTALIN and ALBVENTACONSUMO, and how to avoid relying on VENTASACUMULADAS for totals.
  • NOLOCK guidance and safety checks for production queries; validation rules to ensure correct joins with N column (multi-empresa).
  • Use cases: writing inventory queries, stock verification, identifying cross-referenced albaranes, verifying transfers, and diagnosing stock anomalies.

Quick Start

Identify a product and store, then compute total daily consumption by summing direct sales and recipe usage from ALBVENTALIN and ALBVENTACONSUMO.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: icg-erp
Download link: https://github.com/jota-batuta/batuta-dots/archive/main.zip#icg-erp

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.