on 04-18-2011 11:32 PM
Hola. Tengo un detalle con un informe que nos generaron los consultores que están haciendo la implementación de SAP Business One (Ver. 2007).
El informe presenta la relación de cheques recibidos (Pagos recibidos) y aplicados. Este informe no nos muestra el nombre del banco al que corresponde el cheque, siento que debe haber alguna relación guardada en una o varias tablas.
La consulta que nos dejaron es la siguiente:
SELECT T0.[usersign],T0.[DocNum], T1.[DueDate], T0.[CardCode], T0.[CardName], T1.[CheckSum], T1.[Currency], T0.[DocTotal], T2.[QryGroup1] as 'Ejecutivo1', T2.[QryGroup2] as 'Ejecutivo1', T2.[QryGroup3] as 'Ejecutivo1', T2.[QryGroup4] as Ejecutivo1', T2.[QryGroup5] as 'Ejecutivo1', T2.[QryGroup6] as 'Ejecutivo1' FROM ORCT T0 INNER JOIN RCT1 T1 ON T0.DocEntry = T1.DocNum INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode WHERE T0.[Canceled] = 'n' and T1.[DueDate] >=[%0] AND T1.[DueDate] <=[%1]
En resumidas cuentas, necesitamos agregar a esta consulta algún campo o parámetro que nos devuelva el banco del cheque.
Gracias de antemano por su ayuda.
Hola Álvaro,
Aquí te dejo una consulta:
SELECT T0.usersign,T0.DocNum, T1.DueDate, T0.CardCode, T0.CardName, T1.CheckSum, T1.Currency, T0.DocTotal, T2.QryGroup1 as 'Ejecutivo1', T2.QryGroup2 as 'Ejecutivo1', T2.QryGroup3 as 'Ejecutivo1', T2.QryGroup4 as Ejecutivo1', T2.QryGroup5 as 'Ejecutivo1', T2.QryGroup6 as 'Ejecutivo1', T4.[BankName] FROM ORCT T0 INNER JOIN RCT1 T1 ON T0.DocEntry = T1.DocNum INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode LEFT JOIN DSC1 T3 ON T1.AcctNum = T3.Account INNER JOIN ODSC T4 ON T1.BankCode = T4.Bankcode WHERE T0.Canceled = 'n' and T1.DueDate >='[%0]' AND T1.DueDate <= '[%1]'
Saludos,
Tere
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Intenta uniendo con la tabla de bancos ODSC y dsc1
[dbo].[RCT1] T0 INNER JOIN [dbo].[ORCT] T1 ON T0.DocNum = T1.DocEntry INNER JOIN DSC1 T2 ON T0.BnkActKey = T2.AbsEntry INNER JOIN ODSC T3 ON T2.BankKey = T3.AbsEntry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
11 | |
6 | |
6 | |
5 | |
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.