on 07-20-2011 12:40 AM
HOLA CHICOS,
Tengo un problema con un reporte que hicimos para la version 2007 de SAP. nuestro cliente migró a la version 8.81 y dejó de funcionar. cuando se corre traba el sistema y consume 50 gigas en disco duro y no se temina de ejecutar. Este reporte es muy importante para la operación de nuestro cliente. Se que cambiaron tablas de b1 con respecto a los lotes pero no se como arregalar este query, hay alguna documentación o alguna propuesta que me pueda ayudar?
Les agradezco.
saludos cordiales.
NANCY
T2.[PrdDate], T2.[ExpDate], T2.[Located], T2.[Quantity] as 'Kilos obtenidos', T2.[U_Grasa], T2.[U_PH], T2.[U_Acidez], T2.[U_PROT], T2.[U_VOLUMEN], T2.[U_RENDIM], T2.[U_HUMEDAD] FROM OWOR T0 INNER JOIN IGN1 T1 ON T0.[DOCNUM]=T1.[BASEENTRY]
INNER JOIN OIBT T2 ON T1.[DOCENTRY]=T2.[BASENUM]
INNER JOIN WOR1 T3 ON T0.[DOCNUM]=T3.[DOCENTRY]
INNER JOIN OITM T4 ON T3.[ITEMCODE]=T4.[ITEMCODE] WHERE T0.[PostDate] >=[%0] AND T0.[PostDate] <=[%1]
Nancy
Primero prueba la query sin campos de usuario.
Estas segura que los campos estan actualmente en la tabla OIBT? ya que eso era en version 2007
Ademas el query a simple vista se ve sencillo, aparte de los campos de usuario no veo algun otro problema
Slds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Prueba con
OBTN
Cito nota de SAP
Symptom
From SAP Business One 8.8 onwards, the print layout template for
Batch/Serial printing has changed corresponding to the changes of
Batch/Serial relevant tables.
Batches
1)Batch Number Report changes from IBT1 to BTN1
in the repetitive area, all columns are bound to new tables RBTN or
instead of OIBT.
2) Batch Number Transactions Report changes from IBT2 to BTN2
In the repetitive area header, all columns are bound to new tables RBTN or OBTN instead of OIBT.
In the repetitive area, all columns are bound to new table RITL instead of IBT1.
The report Var 102 and 104 are no longer supported. They are replaced by binding to a table field:
Var 102 now binds to RITL.CardCode.
Var 104 now binds to RITL.Quantity.
3) Batch Report In Document Structure changes from IBT3 to BTN3
In the repetitive area, all columns are bound to new tables RBTN or OBTN instead of OIBT.
Series
1) Serial Number changes from SRI1 to SRN1
In the repetitive area, all columns are bound to new tables RSRN or OSRN instead of OSRI.
2) Serial Number Transactions Report Changes from SRI2 to SRN2
In the repetitive area header, all columns are bound to new tables RSRN or OSRN instead of OSRI.
In the repetitive area, all columns are bound to new table RITL instead of SRI1.
3) Serial Numbers Structures (SRI3)
In the repetitive area, all columns are bound to new tables RSRN or OSRN instead of OSRI.
Espero te sirva
Edited by: Mauricio I Quintana on Jul 28, 2011 11:38 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
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.