Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query para obtener factura cliente que no fue timbrada por error:301

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

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question