on 03-27-2015 5:15 PM
Hola, he realizado un query para verificar si existen facturas no timbradas y me encontré con el caso del error:301 de edicom el cual dice: ERROR:301 (El RFC receptor <xxx123456zzz> no es válido, sin embargo mi query no muestra estos casos.
He probado con:
SELECT T0.[DocDate], T0.[DocNum], T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[EDocNum] FROM OINV T0 WHERE T0.[DocDate] >='06/01/2014' and T0.[EDocNum] IS NULL ORDER BY T0.[CardName], T0.[DocTotal]
y con:
SELECT T0.[DocDate], T0.[DocNum], T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[EDocNum] FROM OINV T0 WHERE T0.[DocDate] >='06/01/2014' and T0.[EDocNum] ='ERROR: 301' ORDER BY T0.[CardName], T0.[DocTotal]
¿Alguna sugerencia?
Saludos
Hola
modifica la consulta y busca en el campo EDocErrMsg para localizar los registros por el texto del error.
Un saludo
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola
Podrías usar la siguiente consulta y meterla en una alarma para que te avise cuando exista un error en la facturación.
Saludos
Declare @mes INT= datepart(month,getdate())
Set @mes = datepart(month,getdate())
SELECT T0.[DocNum], T0.[EDocErrMsg] FROM OINV T0
WHERE DATEPART(mm, T0.DocDate) = @mes and T0.[EDocStatus]='E' and T0.[DocStatus] <> 'C'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Buen dia espero te sirva esto. y sino seria cosa de adaptarla.
Select EDocStatus,EDocNum, DocNum, cardcode, CardName,Docentry, docdate
From OINV
Where EDocStatus ='E' and EDocNum is not NULL
ó Con este otro.
Select EDocStatus,EDocNum, DocNum, cardcode, CardName,Docentry, docdate
From OINV
Where t0.[EDocErrcod] like '%301%'
Saludos
Ing. Nelson Mayo Santamaria
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
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.