24 lines
631 B
SQL
24 lines
631 B
SQL
-- Saldo de Cartera por sucursal con corte al ultimo dia del mes dado
|
|
|
|
-- Instrucciones de uso:
|
|
-- mysql --defaults-file=$HOME/.my_comercial_consultas.cnf -e "set @meses=1; source $HOME/sql/MONTHLY-Analysis_of_Accounts_Receivable.sql" > $HOME/Agofer_Accounts_Receivable_$(date --date="last month" +%Y-%m).csv
|
|
|
|
SELECT
|
|
ch.fecha_historico AS Fecha_Corte,
|
|
s.nombre_sucursal AS Sucursal,
|
|
SUM(ch.valor) AS Amount_due
|
|
|
|
FROM
|
|
cartera_historico ch
|
|
JOIN sucursal s
|
|
USING (id_sucursal)
|
|
|
|
WHERE
|
|
ch.fecha_historico = LAST_DAY(ch.fecha_historico)
|
|
AND
|
|
YEAR(ch.fecha_historico) >= 2010
|
|
|
|
GROUP BY
|
|
ch.id_sucursal, ch.fecha_historico
|
|
|