Local: PDVServico Mensagem: Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_PctMaximaPermitidoLojaAlteraPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_PctMaximaPermitidoLojaAlteraPreco'. Invalid column name 'tpi_PctMaximaPermitidoLojaAlteraPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Instrucao SQL Truncate Table tbTabelaPrecoProdutoItemPDV ; Insert Into tbTabelaPrecoProdutoItemPDV (tpv_CodigoEmpresa, tpv_CodigoTabelaPrecoProduto, tpv_CodigoProduto, tpv_Preco, tpv_PrecoPromocao) Select tpi_CodigoEmpresa, tpi_CodigoTabelaPrecoProduto, tpi_CodigoProduto, Case When isnull(prl_PrecoLoja, 0) = 0 Or isnull(tpi_TipoAlteracaoPreco, 'M') <> 'L' Then tpi_Preco When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) > isnull(tpi_Preco, 0) And isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0) = 0 Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) > isnull(tpi_Preco, 0) And isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0) > 0 And Convert(decimal(10,2),(tpi_Preco + ((tpi_Preco * isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(prl_PrecoLoja, 0) Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) = 100 Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco , 0) = 0 And isnull(prl_PrecoLoja, 0) < isnull(tpi_Preco, 0) Then tpi_Preco When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_Preco, 0) = 0 Then isnull(prl_PrecoLoja, 0) When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) < isnull(tpi_Preco, 0) And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) > 0 And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) < 100 And Convert(decimal(10,2),(tpi_Preco - ((tpi_Preco * isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(prl_PrecoLoja, 0) Then prl_PrecoLoja Else tpi_Preco End as tpi_Preco, tpi_PrecoPromocao From tbTabelaPrecoProdutoItem (NOLOCK) Inner Join tbTabelaPrecoProduto (NOLOCK) On tpp_CodigoEmpresa = tpi_CodigoEmpresa And tpp_Codigo = tpi_CodigoTabelaPrecoProduto And tpp_Ativo = '1' Inner Join tbTabelaPrecoProdutoLoja (NOLOCK) on ppl_CodigoEmpresa = tpi_CodigoEmpresa And ppl_CodigoTabelaPrecoProduto = tpi_CodigoTabelaPrecoProduto And ppl_Principal = '1' Inner Join tbProduto (NOLOCK) ON pro_CodigoEmpresa = tpi_CodigoEmpresa And pro_Codigo = tpi_CodigoProduto And pro_Ativo = 1 And isnull(pro_DataProdutoDescontinuacao, getdate()) >= getdate() Left Join tbProdutoLoja (NOLOCK) on prl_CodigoEmpresa = tpi_CodigoEmpresa And prl_CodigoProduto = tpi_CodigoProduto And prl_CodigoLoja = 101 Where tpp_CodigoEmpresa = 1017 And ppl_CodigoLoja = 101 And Convert(DATE, tpp_InicioVigencia, 23) <= Convert(DATE, getdate(), 23) And Convert(DATE, isnull(tpp_TerminoVigencia, '2200-01-01'), 23) >= Convert(DATE, getdate(), 23) ; Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.Executar(SqlCommand comando) at ideologica.clsBD_TabelaPrecoProduto.MontaTabelaPDVLoja() at ideologica.basPDVServicoEProduto.SetaTabelaPrecoProdutoPrincipal() at ideologica.frmAbertura.frmAbertura_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Local: .Net SqlClient Data Provider Mensagem: Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_PctMaximaPermitidoLojaAlteraPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_PctMaximaPermitidoLojaAlteraPreco'. Invalid column name 'tpi_PctMaximaPermitidoLojaAlteraPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'tpi_TipoAlteracaoPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'tpi_PctMinimoPermitidoLojaAlteraPreco'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Invalid column name 'prl_PrecoLoja'. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ideologica.IdeoFramework.BancoDadosSQL.Executar(SqlCommand comando) ========================= Informações do Aplicativo ========================= Arquivo: PDVServico.exe Caminho: C:\Allegro.IOT - Migração\PDVServico.exe Versão: 7.0.0.1225 ====================== Informações da Máquina ====================== Nome da Máquina: WS0525 Memória: 7,69 GB Sistema Operacional: Microsoft Windows 11 Pro Processador: 12th Gen Intel(R) Core(TM) i5-1235U (2496Mhz) Usuário: IDEOLOGICA1\lucca.santana Resolução do Vídeo: 1536x864 Versão SQL Server: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 26200: ) (Hypervisor) Versão exe: 7.0.0, Computador: WS0525