on 05-05-2008 4:17 PM
Boa tarde,
Alguém saberia informar como verificamos se uma NF de Saída ou Entrada foi cancelada ou não, através de uma query?
Existe um campo na OINV chamado "Canceled" mas mesmo com a NF cancelada através da Devolução de NF de Saída, ele não muda o status.
Agradeço desde já.
Abs,
Antonio Melo
Boa tarde Antonio,
Segue o comando SQL de todas as NF canceladas
SELECT distinct T4.DocEntry,T4.DocNum FROM OINV T4 INNER JOIN INV1 T5 ON T4.DocEntry = T5.DocEntry INNER JOIN RIN1 T6 ON T6.BaseEntry = T5.DocEntry
Att
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Todas as notas fiscais menos as canceladas...
SELECT
T0.[Serial] as 'NotaFiscal',
FROM OINV T0
WHERE T0.DocEntry NOT in( SELECT T4.DocEntry
FROM OINV T4 INNER JOIN INV1 T5 ON T4.DocEntry = T5.DocEntry
INNER JOIN RIN1 T6 ON T6.BaseEntry = T5.DocEntry
INNER JOIN ORIN T7 ON T7 .DocEntry = T6.DocEntry)
Att
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Olhe no targettype em inv1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.