Skip to Content
Actions

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

Query Facturas reservadas por corte de fecha

This question is answered

Como puedo hacer un query en donde puede ver las facturas reservadas que mantienen notas de creditos.

saludos,

asv

Former Member
May 27, 2011 at 17:57 PM
0 Likes
Correct Answer
Former Member replied
May 27, 2011 at 17:42 PM

Estimado,

Hay 2 posibilidades

1) No han ingresado ninguna Factura de reserva en el rango que especificaste, sugerencia; amplia el rango de fecha

2) Esa query es para las facturas de proveedores reservadas, si tu querias para las de clientes debes ejecutar este query

SELECT T0.isIns, T0.DocEntry'Facura', T2.DocEntry'NCredito'
FROM OINV T0
INNER JOIN INV1 T1 ON T1.DocEntry = T0.DocEntry
LEFT JOIN ORIN T2 ON T2.DocEntry = T1.TrgetEntry
WHERE T0.DocDate BETWEEN '[%0]' AND '[%1]' AND T0.isIns = 'Y'

Saludos

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

6 replies