syspel Posted August 5, 2015 Report Share Posted August 5, 2015 Não consigo colar nada dentro desse escript, está anexado a baixo! Sobre o xml o contador da porcentagem do icms não inclementa nem com reza brava. Carlos, syspel AA.TXT Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 5, 2015 Report Share Posted August 5, 2015 Copiando para você: 35150607721579000201550050025105781574903771 olhe esta chave imprime o danfe e ve alicota nsegprod10:=PegaPosicao(aCampos,"/nfeproc/nfe/infnfe/det/imposto/icms/icms00/picms",nsegprod10+1) 1o item a picms nao tem 2o item a picms nao tem 20 item a picms 18% 40 item a nao tem 50 item a nao tem ele repete os 18% em tudo Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 5, 2015 Report Share Posted August 5, 2015 Postando XML para os demais olharem. <nfeProc versao="3.10"> <NFe> <infNFe versao="3.10" Id="NFe35150607721579000201550050025105781574903771"> <ide> <cUF>35</cUF> <cNF>57490377</cNF> <natOp>Venda Merc.Adq.Terc.</natOp> <indPag>1</indPag> <mod>55</mod> <serie>5</serie> <nNF>2510578</nNF> <dhEmi>2015-06-15T00:00:00-03:00</dhEmi> <tpNF>1</tpNF> <idDest>1</idDest> <cMunFG>3556453</cMunFG> <tpImp>1</tpImp> <tpEmis>1</tpEmis> <cDV>1</cDV> <tpAmb>1</tpAmb> <finNFe>1</finNFe> <indFinal>0</indFinal> <indPres>0</indPres> <procEmi>0</procEmi> <verProc>NDDigital NFe 4.5.4</verProc> </ide> <emit> <CNPJ>07721579000201</CNPJ> <xNome>DIPALMA COM.DIST. LOG DE PROD.ALIM. LTDA</xNome> <xFant>DIPALMA VGP</xFant> <enderEmit> <xLgr>RUA SALVADOR EDUARDO DE SOUZA</xLgr> <nro>S/N</nro> <xBairro>JARDIM MIRIAM</xBairro> <cMun>3556453</cMun> <xMun>VARGEM GRANDE PAULISTA</xMun> <UF>SP</UF> <CEP>06730000</CEP> <cPais>1058</cPais> <xPais>BRASIL</xPais> <fone>1121382600</fone> </enderEmit> <IE>720067862114</IE> <CRT>3</CRT> </emit> <dest> <CNPJ>62718788000123</CNPJ> <xNome>FRANCELINO DOS SANTOS - 280550</xNome> <enderDest> <xLgr>RUA AMARILLA</xLgr> <nro>240</nro> <xBairro>PQ AMERICA</xBairro> <cMun>3544103</cMun> <xMun>RIO GRANDE DA SERRA</xMun> <UF>SP</UF> <CEP>09450000</CEP> <cPais>1058</cPais> <xPais>BRASIL</xPais> <fone>1148204441</fone> </enderDest> <indIEDest>1</indIEDest> <IE>589005321116</IE> </dest> <det nItem="1"> <prod> <cProd>17896010002130</cProd> <cEAN>17896010002130</cEAN> <xProd>BEB.CONHAQUE DREHER 900ML - 59919</xProd> <NCM>22089000</NCM> <CFOP>5405</CFOP> <uCom>CX12</uCom> <qCom>1.0000</qCom> <vUnCom>94.9800000000</vUnCom> <vProd>94.98</vProd> <cEANTrib>17896010002130</cEANTrib> <uTrib>CX12</uTrib> <qTrib>1.0000</qTrib> <vUnTrib>94.9800000000</vUnTrib> <vOutro>0.43</vOutro> <indTot>1</indTot> </prod> <imposto> <ICMS> <ICMS60> <orig>0</orig> <CST>60</CST> </ICMS60> </ICMS> <IPI> <cEnq>999</cEnq> <IPITrib> <CST>99</CST> <qUnid>1.0000</qUnid> <vUnid>94.9800</vUnid> <vIPI>0.00</vIPI> </IPITrib> </IPI> <PIS> <PISAliq> <CST>01</CST> <vBC>95.41</vBC> <pPIS>1.6500</pPIS> <vPIS>1.57</vPIS> </PISAliq> </PIS> <COFINS> <COFINSAliq> <CST>01</CST> <vBC>95.41</vBC> <pCOFINS>7.6000</pCOFINS> <vCOFINS>7.25</vCOFINS> </COFINSAliq> </COFINS> </imposto> </det> <det nItem="2"> <prod> <cProd>27891035652008</cProd> <cEAN>27891035652008</cEAN> <xProd>ESPIRAIS REPEL.DETEFON C/10 - 66117</xProd> <NCM>38089119</NCM> <CFOP>5405</CFOP> <uCom>CX20</uCom> <qCom>1.0000</qCom> <vUnCom>40.9500000000</vUnCom> <vProd>40.95</vProd> <cEANTrib>27891035652008</cEANTrib> <uTrib>CX20</uTrib> <qTrib>1.0000</qTrib> <vUnTrib>40.9500000000</vUnTrib> <vOutro>0.19</vOutro> <indTot>1</indTot> </prod> <imposto> <ICMS> <ICMS60> <orig>0</orig> <CST>60</CST> </ICMS60> </ICMS> <IPI> <cEnq>999</cEnq> <IPITrib> <CST>99</CST> <qUnid>1.0000</qUnid> <vUnid>40.9500</vUnid> <vIPI>0.00</vIPI> </IPITrib> </IPI> <PIS> <PISAliq> <CST>01</CST> <vBC>41.14</vBC> <pPIS>1.6500</pPIS> <vPIS>0.68</vPIS> </PISAliq> </PIS> <COFINS> <COFINSAliq> <CST>01</CST> <vBC>41.14</vBC> <pCOFINS>7.6000</pCOFINS> <vCOFINS>3.13</vCOFINS> </COFINSAliq> </COFINS> </imposto> </det> <det nItem="3"> <prod> <cProd>70330631335</cProd> <cEAN>070330631335</cEAN> <xProd>ISQUEIRO BIC MAX CARTELA ATAC.C/12(E) - 384658</xProd> <NCM>96131000</NCM> <CFOP>5102</CFOP> <uCom>CT1</uCom> <qCom>1.0000</qCom> <vUnCom>30.0000000000</vUnCom> <vProd>30.00</vProd> <cEANTrib>070330631335</cEANTrib> <uTrib>CT1</uTrib> <qTrib>1.0000</qTrib> <vUnTrib>30.0000000000</vUnTrib> <vOutro>0.14</vOutro> <indTot>1</indTot> </prod> <imposto> <ICMS> <ICMS00> <orig>0</orig> <CST>00</CST> <modBC>3</modBC> <vBC>30.14</vBC> <pICMS>18.0000</pICMS> <vICMS>5.43</vICMS> </ICMS00> </ICMS> <IPI> <cEnq>999</cEnq> <IPITrib> <CST>99</CST> <qUnid>1.0000</qUnid> <vUnid>30.0000</vUnid> <vIPI>0.00</vIPI> </IPITrib> </IPI> <PIS> <PISAliq> <CST>01</CST> <vBC>30.14</vBC> <pPIS>1.6500</pPIS> <vPIS>0.50</vPIS> </PISAliq> </PIS> <COFINS> <COFINSAliq> <CST>01</CST> <vBC>30.14</vBC> <pCOFINS>7.6000</pCOFINS> <vCOFINS>2.29</vCOFINS> </COFINSAliq> </COFINS> </imposto> </det> <det nItem="4"> <prod> <cProd>17896098909710</cProd> <cEAN>17896098909710</cEAN> <xProd>LAVA ROUPAS PO (CT) TIXAN 500G PRIMAVERA - 4243</xProd> <NCM>34022000</NCM> <CFOP>5405</CFOP> <uCom>CX24</uCom> <qCom>1.0000</qCom> <vUnCom>60.0000000000</vUnCom> <vProd>60.00</vProd> <cEANTrib>17896098909710</cEANTrib> <uTrib>CX24</uTrib> <qTrib>1.0000</qTrib> <vUnTrib>60.0000000000</vUnTrib> <vOutro>0.28</vOutro> <indTot>1</indTot> </prod> <imposto> <ICMS> <ICMS60> <orig>0</orig> <CST>60</CST> </ICMS60> </ICMS> <IPI> <cEnq>999</cEnq> <IPITrib> <CST>99</CST> <qUnid>1.0000</qUnid> <vUnid>60.0000</vUnid> <vIPI>0.00</vIPI> </IPITrib> </IPI> <PIS> <PISAliq> <CST>01</CST> <vBC>60.28</vBC> <pPIS>1.6500</pPIS> <vPIS>0.99</vPIS> </PISAliq> </PIS> <COFINS> <COFINSAliq> <CST>01</CST> <vBC>60.28</vBC> <pCOFINS>7.6000</pCOFINS> <vCOFINS>4.58</vCOFINS> </COFINSAliq> </COFINS> </imposto> </det> <det nItem="5"> <prod> <cProd>37891200190943</cProd> <cEAN>37891200190943</cEAN> <xProd>SUPER BONDER ORIGINAL 3G SM - 39993</xProd> <NCM>35061010</NCM> <CFOP>5405</CFOP> <uCom>CX24</uCom> <qCom>1.0000</qCom> <vUnCom>77.3200000000</vUnCom> <vProd>77.32</vProd> <cEANTrib>37891200190943</cEANTrib> <uTrib>CX24</uTrib> <qTrib>1.0000</qTrib> <vUnTrib>77.3200000000</vUnTrib> <vOutro>0.36</vOutro> <indTot>1</indTot> </prod> <imposto> <ICMS> <ICMS60> <orig>0</orig> <CST>60</CST> </ICMS60> </ICMS> <IPI> <cEnq>999</cEnq> <IPITrib> <CST>99</CST> <qUnid>1.0000</qUnid> <vUnid>77.3200</vUnid> <vIPI>0.00</vIPI> </IPITrib> </IPI> <PIS> <PISAliq> <CST>01</CST> <vBC>77.68</vBC> <pPIS>1.6500</pPIS> <vPIS>1.28</vPIS> </PISAliq> </PIS> <COFINS> <COFINSAliq> <CST>01</CST> <vBC>77.68</vBC> <pCOFINS>7.6000</pCOFINS> <vCOFINS>5.90</vCOFINS> </COFINSAliq> </COFINS> </imposto> </det> <total> <ICMSTot> <vBC>30.14</vBC> <vICMS>5.43</vICMS> <vICMSDeson>0.00</vICMSDeson> <vBCST>0.00</vBCST> <vST>0.00</vST> <vProd>303.25</vProd> <vFrete>0.00</vFrete> <vSeg>0.00</vSeg> <vDesc>0.00</vDesc> <vII>0.00</vII> <vIPI>0.00</vIPI> <vPIS>5.02</vPIS> <vCOFINS>23.15</vCOFINS> <vOutro>1.40</vOutro> <vNF>304.65</vNF> </ICMSTot> </total> <transp> <modFrete>0</modFrete> <transporta> <xNome>ROSIMEIRE SILVEIRA GARCIA</xNome> <IE>ISENTO</IE> <xEnder>RUA HELIO DEPIERI 320</xEnder> <xMun>MAUA</xMun> <UF>SP</UF> </transporta> <veicTransp> <placa>FMX5937</placa> <UF>SP</UF> </veicTransp> <vol> <qVol>5</qVol> <pesoL>25.810</pesoL> <pesoB>33.190</pesoB> </vol> </transp> <cobr> <dup> <nDup>2510578 / 1</nDup> <dVenc>2015-07-07</dVenc> <vDup>304.65</vDup> </dup> </cobr> <infAdic> <infCpl>0 IMPOSTO RECOLHIDO POR SUBSTITUICAO TRIBUTACAO -ART. 313-C DO RICMS-SP - Cliente: MERCADINHO DO FRANCA - NroCarga: 846171 - Representante: ANTONIO DONIZETE DE QUEIROS - Telefone: (11) - 991793892 - NroPedido: 5063473 - Forma Pagto: BOLETO - Cond. Pagto: 21 DIAS - ( VOLUME: 1+2+1+1 = 5 ) ** ATACADO BATE FORTE, eleito em 2015 o MELHOR ATACADISTA E DISTRIBUIDOR DO ESTADO DE S?O PAULO, segundo a ABAD ** FAVOR CONFERIR A MERCADORIA NO ATO DA ENTREGA. NAO ACEITAMOS RECLAMACOES POSTERIORES.**</infCpl> </infAdic> </infNFe> <Signature> <SignedInfo> <CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/> <SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/> <Reference URI="#NFe35150607721579000201550050025105781574903771"> <Transforms> <Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/> <Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/> </Transforms> <DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/> <DigestValue>XRoCUT4zK//RLjziFAWYKTccD6Q=</DigestValue> </Reference> </SignedInfo> <SignatureValue>XRoCUT4zK//RLjziFAWYKTccD6Q=</SignatureValue> <KeyInfo> <X509Data> <X509Certificate>XRoCUT4zK//RLjziFAWYKTccD6Q=</X509Certificate> </X509Data> </KeyInfo> </Signature> </NFe> <protNFe versao="3.10"> <infProt> <tpAmb>1</tpAmb> <verAplic>NDDigital NFe 4.5.4</verAplic> <chNFe>35150607721579000201550050025105781574903771</chNFe> <dhRecbto>2015-06-15T19:12:12-03:00</dhRecbto> <nProt>135150366396362</nProt> <digVal>XRoCUT4zK//RLjziFAWYKTccD6Q=</digVal> <cStat>100</cStat> <xMotivo>Autorizado o uso da NF-e</xMotivo> </infProt> </protNFe> </nfeProc> Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 5, 2015 Report Share Posted August 5, 2015 /* <imposto> <ICMS> <ICMS00> <orig>0</orig> <CST>00</CST> <modBC>3</modBC> <vBC>30.14</vBC> <pICMS>18.0000</pICMS> */ nsegprod10:=PegaPosicao(aCampos,"/nfeproc/nfe/infnfe/det/imposto/icms/icms00/pICMS",nsegprod10+1) ? [nsegprod10 ], nsegprod10 // RETORNA 129 ???, Nao deveria ser 18% ? Quote Link to comment Share on other sites More sharing options...
syspel Posted August 6, 2015 Author Report Share Posted August 6, 2015 seria assim 129 e a posicao de onde esta ? acampos[nsegprod10,2) ele aparece 18.000 ele grava todos picms com 18.000 e é so no 3 item da nota isto que esta errado,parece que nao imprementa + 1 carlos syspel Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 6, 2015 Report Share Posted August 6, 2015 Entendi. ele grava todos picms com 18.000 Ele grava aonde? em: NFE2.DBF? Qual é o campo? Quote Link to comment Share on other sites More sharing options...
syspel Posted August 6, 2015 Author Report Share Posted August 6, 2015 e assim na hora de gravar ? select nfe2 replace nfe2->aicms with abacax2[10] replace nfe2->picms wth abacax2[11] ele repete 18% icms em tudo picms e aicms carlos syspel Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 6, 2015 Report Share Posted August 6, 2015 e assim na hora de gravar ? select nfe2 replace nfe2->aicms with abacax2[10] replace nfe2->picms wth abacax2[11] ele repete 18% icms em tudo picms e aicms carlos syspel Estranho, aqui não está gravando. Ele grava: 99 99 ??? não tem 18% em lugar nenhum. ????Muito louco. Compilei com FWHX15.05. Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 6, 2015 Report Share Posted August 6, 2015 Quote Link to comment Share on other sites More sharing options...
syspel Posted August 6, 2015 Author Report Share Posted August 6, 2015 QUANDO NAO ACHA A PERCENTAGEM EU COLO 99 PARA TATAR COMO ISENTA AI NESTE EXPLO QUE VC POSTOU DEVERIA SER 18 ICMS OK OBRIGADO Quote Link to comment Share on other sites More sharing options...
syspel Posted August 12, 2015 Author Report Share Posted August 12, 2015 ajuda ai gente ninguem se abalita ? carlos syspel Quote Link to comment Share on other sites More sharing options...
kleyber Posted August 12, 2015 Report Share Posted August 12, 2015 Carlos, Poste a função PegaPosição(), por favor. Quote Link to comment Share on other sites More sharing options...
kapiaba Posted August 12, 2015 Report Share Posted August 12, 2015 Carlos, Poste a função PegaPosição(), por favor. Kleyber, baixe aqui: http://www.4shared.com/zip/SYk-3EXxce/SYSPEL1.html abs. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.