If you are negative on a branch that brings inventory from another branch

[Ribeiro]

If Cod with today's date

for = <0

Bring the balance Stock Cod of Branch 3 and 5

See Cod 1 its coding is with stock: So it will not bring anything.

Only Code 21 and 3

[Ribeiro]

When I do not fix the dates it works. Any suggestion..LET vHoje = Date(Today(), 'YYYY-MM-DD');
LET vDateMin=num(makedate(2018,01,01));
LET vDateMax=floor(monthend(today()));
LET vDateMin2=num(makedate(2007,01,01));
LET vDateMax2=floor(monthend(today()));

Calenderio:
LOAD
Distinct
Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS CalendarDate,
ceil(Month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY'))/3) & 'Trim' as Trimestre,
month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Mes,
WeekDay(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Semana,
Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Dia,
year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Ano,
monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS MesAno

AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);

LOAD
Qtde_Estoque_Atual,
CodigoProduto,
if([Qtde_Estoque_Atual] <= 0,0,1) as Estoque_Sim,
NomeProdutoE,
Date(Floor(Data_Alteracao),'DD/MM/YYYY') as CalendarDate,
Data_Alteracao,
CodigoFilialE

FROM
[C:\Users\Gateway\Desktop\Estoque.qvd]
(qvd);