Boa tarde,
Após todo esse procedimento feito estou tentando imprimir o orçamento ou o pedido propriamente dito, porém ao clicar no botão de visualizar impressão ele apresenta uma tela em branco. E já tentei procurar em outros lugares no sistema porém não obtive sucesso.
Gostaria de saber como faço para poder imprimir o orçamento/pedido.
Se vou na janela de erros ele apresenta o seguinte mensagem de erro: “null - ERRO: coluna c_order_header_vt.lbr_org_location_id não existe
SQL=SELECT A.City||’.’ AS AAddress,C_Order_Header_vt.lbr_Org_Location_ID,C_Order_Header_vt.BPGreeting,C_Order_Header_vt.Name,C_Order_Header_vt.Name2,C_Order_Header_vt.BPContactGreeting,C_Order_Header_vt.Title,C_Order_Header_vt.ContactName,B.City||’.’ AS BAddress,C_Order_Header_vt.C_Location_ID,C_Order_Header_vt.DatePromised,C_Order_Header_vt.BPValue,C_Order_Header_vt.ReferenceNo,C_Order_Header_vt.POReference,C_Order_Header_vt.SalesRep_Name,C_Order_Header_vt.DocumentType,C_Order_Header_vt.DocumentNo,C_Order_Header_vt.DateOrdered,C_Order_Header_vt.Description,C_Order_Header_vt.C_Order_ID,(SELECT C_Currency.ISO_Code FROM C_Currency WHERE C_Order_Header_vt.C_Currency_ID=C_Currency.C_Currency_ID) AS CC_Currency_ID,C_Order_Header_vt.C_Currency_ID,C_Order_Header_vt.GrandTotal,C_Order_Header_vt.PaymentTerm,C_Order_Header_vt.PaymentTermNote,C_Order_Header_vt.DocumentTypeNote,C_Order_Header_vt.C_Order_ID FROM C_Order_Header_vt LEFT OUTER JOIN C_Location A ON (C_Order_Header_vt.lbr_Org_Location_ID=A.C_Location_ID) LEFT OUTER JOIN C_Location B ON (C_Order_Header_vt.C_Location_ID=B.C_Location_ID) WHERE C_Order_Header_vt.C_Order_ID=2000003 AND C_Order_Header_vt.AD_Language=‘pt_BR’ AND C_Order_Header_vt.AD_Client_ID IN(0,11) AND C_Order_Header_vt.AD_Org_ID IN(0,11,12) AND A.C_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 162 AND AD_User_ID <> 100 AND IsActive = ‘Y’ ) AND B.C_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 162 AND AD_User_ID <> 100 AND IsActive = ‘Y’ ) ORDER BY C_Order_Header_vt.DocumentNo”
O que seria isso?
Obrigado desde já.