Softshop > NFe: Recurso do sistema excedido quando vai clicar no botão Nfe para poder exportar notas
Software: SOFTSHOP | Grupo: NFE | Prioridade: ALTA
Solução
Causa:
Não esta com as tabelas localmente ou está com a consulta completa tanto do simples e do normal
Solução:
1 - Verificar se as tabelas Nfe se estão locais
2 - Verificar a consulta Nfe_ExplinhaW_Totaisse o cliente for regime tributario NORNAL deixe na consulta SELECT Ordem, NFe_ExpLinhaN10.VALORBASE, NFe_ExpLinhaN10.VALORICMS, NFe_ExpLinhaN10.VALORBASEST, NFe_ExpLinhaN10.VALORICMSSTFROM NFe_ExpLinhaN10;UNIONSELECT Ordem,NFe_ExpLinhaN09.VALORBASE, NFe_ExpLinhaN09.VALORICMS, NFe_ExpLinhaN09.VALORBASEST, NFe_ExpLinhaN09.VALORICMSSTFROM NFe_ExpLinhaN09;UNIONSELECT Ordem,0 AS VALORBASE, 0 AS VALORICMS, NFe_ExpLinhaN08.VALORBASEST, NFe_ExpLinhaN08.VALORICMSSTFROM NFe_ExpLinhaN08;UNIONSELECT Ordem,NFe_ExpLinhaN07.VALORBASE, NFe_ExpLinhaN07.VALORICMS, 0 AS VALORBASEST, 0 AS VALORICMSSTFROM NFe_ExpLinhaN07;UNIONSELECT Ordem,0 AS VALORBASE, 0 AS VALORICMS, 0 AS VALORBASEST, 0 AS VALORICMSSTFROM NFe_ExpLinhaN06;UNIONSELECT Ordem,0 AS VALORBASE, 0 AS VALORICMS, NFe_ExpLinhaN05.VALORBASEST, NFe_ExpLinhaN05.VALORICMSSTFROM NFe_ExpLinhaN05;UNIONSELECT Ordem,NFe_ExpLinhaN04.VALORBASE, NFe_ExpLinhaN04.VALORICMS, 0 AS VALORBASEST, 0 AS VALORICMSSTFROM NFe_ExpLinhaN04;UNIONSELECT Ordem,NFe_ExpLinhaN03.VALORBASE, NFe_ExpLinhaN03.VALORICMS, NFe_ExpLinhaN03.VALORBASEST, NFe_ExpLinhaN03.VALORICMSSTFROM NFe_ExpLinhaN03;UNION SELECT Ordem,NFe_ExpLinhaN02.VALORBASE, NFe_ExpLinhaN02.VALORICMS, 0 AS VALORBASEST, 0 AS VALORICMSSTFROM NFe_ExpLinhaN02;
Mas se for SIMPLES nacional deixar essa consulta:FROM NFe_ExpLinhaN10c;UNIONSELECT NFe_ExpLinhaN10d.Ordem, 0 AS VALORBASE, 0 AS VALORICMS, 0 AS VALORBASEST, 0 AS VALORICMSSTFROM NFe_ExpLinhaN10d;UNIONSELECT NFe_ExpLinhaN10e.Ordem, 0 AS VALORBASE, 0 AS VALORICMS, NFe_ExpLinhaN10e.VALORBASEST, NFe_ExpLinhaN10e.VALORICMSSTFROM NFe_ExpLinhaN10e;UNIONSELECT NFe_ExpLinhaN10f.Ordem, 0 AS VALORBASE, 0 AS VALORICMS, NFe_ExpLinhaN10f.VALORBASEST, NFe_ExpLinhaN10f.VALORICMSSTFROM NFe_ExpLinhaN10f;UNIONSELECT NFe_ExpLinhaN10g.Ordem, 0 AS VALORBASE, 0 AS VALORICMS, NFe_ExpLinhaN10g.VALORBASEST, NFe_ExpLinhaN10g.VALORICMSSTFROM NFe_ExpLinhaN10g;UNIONSELECT NFe_ExpLinhaN10h.Ordem, NFe_ExpLinhaN10h.VALORBASE, NFe_ExpLinhaN10h.VALORICMS, NFe_ExpLinhaN10h.VALORBASEST, NFe_ExpLinhaN10h.VALORICMSSTFROM NFe_ExpLinhaN10h;qualquer duvida comparar com o softshop padrao
Tags: recurso do sistema excedido, excedido, consulta muit