VEND6200 – Lista NF com Data Prevista não Cumprida
Revisão v03.80.02 – Dez./2005
Este programa tem a finalidade de relacionar todas as NF's em um período desejado, selecionando as NF's que tiveram diferença entre a data prevista para entrega e data a real da venda.
O atributo "Listar" indica o tipo de listagem a exibir e a forma de seleção das NF's:
Orçamento | NF's com diferença entre a Previsão de Entrega do Orçamento ("ORCA2000") e a Data da Transação da NF ("NOTA2400"). |
Ordem de Serviço | NF's com diferença entre a Data da Entrega da Ordem de Serviço ("OFIC1000") e a Data de Fechamento da Ordem de Serviço ("OFIC1200"). |
Veículos | NF's com diferença entre a Previsão de Entrega do Pedido de Venda ("VEIC0400") e a Data de Entrega do Veículo ("VEIC0200"). |
Recapagem | NF's com diferença entre a Data de Entrega dos Pneus ("BAND1000") e a Data da Transação da NF ("NOTA2400"). |
Também tem a opção de filtrar a divisão e o departamento das NF's. Caso queira todas as divisões ou departamentos, basta informa 0 (zero) em um destes campos.
A ordem do relatório é: departamento, número da NF e data da NF.
v04.10 – Maio/2008
Nova coluna "QT PENUS", quantidade de pneus para a opção Listar = "R – Recapagem".
Modelos das listagens:
Orçamento:
NOME DA FILIAL Lista N.Fiscal c/ Dt.Entr. Fora do Prazo DATA: 99/99/9999 99:99:99
SISDIA-VEND6200-vAL.FA.01 DATA INICIAL: 99/99/9999 DATA FINAL: 99/99/9999 PAGINA: 999
SOMENTE ORCAMENTOS DE BALCAO
----------------------------------------------------------------------------------------------------------------------------------------------------------
NR.NFISCAL DATA NOTA DT.TRANSACAO VLR N.FISCAL CLIENTE AGENTE NR.ORCAMENTO DT.ORCAMENTO DT.PREVIS. DEPARTAMENTO
----------------------------------------------------------------------------------------------------------------------------------------------------------
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
9999999-999 99/99/9999 99/99/9999 99999,99 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx 99999 99/99/9999 99/99/9999 xxxxxxxxxxxxxxxxxxx
Ordem de Serviço:
NOME DA FILIAL Lista N.Fiscal c/ Dt.Entr. Fora do Prazo DATA: 99/99/9999 99:99:99
SISDIA-VEND6200-vAL.FA.01 DATA INICIAL: 99/99/9999 DATA FINAL: 99/99/9999 PAGINA: 999
SOMENTE ORDENS DE SERVICOS
----------------------------------------------------------------------------------------------------------------------------------------------------------
NR.NFISCAL DATA NOTA DT.RESULTADO VLR N.FISCAL CLIENTE AGENTE NR.ORD.SERV. DT.ORD.SERV. DT.PREVIS. DEPARTAMENTO
----------------------------------------------------------------------------------------------------------------------------------------------------------
9999999-999 99/99/9999 99/99/9999 99999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXX 99999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 99999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXX 99999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 99999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXX 99999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 99999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXX 99999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 99999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXX 99999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 99999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXX 99999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXX
Veículos:
NOME DA FILIAL Lista N.Fiscal c/ Dt.Entr. Fora do Prazo DATA: 99/99/9999 99:99:99
SISDIA-VEND6200-vAL.FA.01 DATA INICIAL: 99/99/9999 DATA FINAL: 99/99/9999 PAGINA: 999
SOMENTE VEICULOS
----------------------------------------------------------------------------------------------------------------------------------------------------------
NR.NFISCAL DATA NOTA DT.ENTREGA VLR N.FISCAL CLIENTE AGENTE NR.PEDIDO DT.PEDIDO DT.PREVIS. DEPARTAMENTO
----------------------------------------------------------------------------------------------------------------------------------------------------------
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
Recapagem:
NOME DA FILIAL Lista N.Fiscal c/ Dt.Entr. Fora do Prazo DATA: 99/99/9999 99:99:99
SISDIA-VEND6200-vAL.FA.01 DATA INICIAL: 99/99/9999 DATA FINAL: 99/99/9999 PAGINA: 999
SOMENTE RECAPAGEM
----------------------------------------------------------------------------------------------------------------------------------------------------------
NR.NFISCAL DATA NOTA DT.TRANSACAO VLR N.FISCAL CLIENTE AGENTE NR.COLETA QT PNEUS DT.COLETA DT.ENTREGA DEPARTAMENTO
----------------------------------------------------------------------------------------------------------------------------------------------------------
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX
9999999-999 99/99/9999 99/99/9999 999999,99 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX 999999 9999 99/99/9999 99/99/9999 XXXXXXXXXXXXXXXXXXX