https://docs.plurivaerp.com/index.php?action=history&feed=atom&title=Reguli_E-Factura_-_AdaugareReguli E-Factura - Adaugare - Revision history2026-11-15T23:35:00ZRevision history for this page on the wikiMediaWiki 1.46.2https://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46879&oldid=prevGheorghe Minca at 09:21, 17 March 20252025-03-17T09:21:39Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:21, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l28">Line 28:</td>
<td colspan="2" class="diff-lineno">Line 28:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare antet (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din antetul E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. Campurile ce pot fi actualizate sunt cele aferente tabelei de antet e-factura (e necesar sa se cunoasca aceste campuri pentru a putea fi utilizata aceasta formula).</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare antet (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din antetul E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. Campurile ce pot fi actualizate sunt cele aferente tabelei de antet e-factura (e necesar sa se cunoasca aceste campuri pentru a putea fi utilizata aceasta formula).</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Exemplu de expresie:Observatii = '<del style="font-weight: bold; text-decoration: none;">a</del>'</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Exemplu de expresie:Observatii = '<ins style="font-weight: bold; text-decoration: none;">test</ins>'</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46878&oldid=prevGheorghe Minca at 09:21, 17 March 20252025-03-17T09:21:20Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:21, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l27">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Validare la transfer: se poate selecta una din optiunile: Da, Nu. Daca se bifeaza acest camp, facturile care indeplinesc conditiile din expresie, la transferul in meniul Facturi furnizori se vor importa validate. In modul standard e-facturile se transfera in Facturi furnizori in starea nevalidat. Suplimentar fata de reguli, se poate configura transferul ca facturi validate in Facturi furnizori si prin filtrul ascuns ValidareFacturiPreluate.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Validare la transfer: se poate selecta una din optiunile: Da, Nu. Daca se bifeaza acest camp, facturile care indeplinesc conditiile din expresie, la transferul in meniul Facturi furnizori se vor importa validate. In modul standard e-facturile se transfera in Facturi furnizori in starea nevalidat. Suplimentar fata de reguli, se poate configura transferul ca facturi validate in Facturi furnizori si prin filtrul ascuns ValidareFacturiPreluate.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare antet (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din antetul E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare antet (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din antetul E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara<ins style="font-weight: bold; text-decoration: none;">. Campurile ce pot fi actualizate sunt cele aferente tabelei de antet e-factura (e necesar sa se cunoasca aceste campuri pentru a putea fi utilizata aceasta formula)</ins>.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Exemplu de expresie:</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Exemplu de expresie:<ins style="font-weight: bold; text-decoration: none;">Observatii = 'a'</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46877&oldid=prevGheorghe Minca at 09:16, 17 March 20252025-03-17T09:16:16Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:16, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <del style="font-weight: bold; text-decoration: none;">'' </del>),Product)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <ins style="font-weight: bold; text-decoration: none;">&#39;&#39; </ins>),Product)</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46876&oldid=prevGheorghe Minca at 09:12, 17 March 20252025-03-17T09:12:20Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:12, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <del style="font-weight: bold; text-decoration: none;">[</del>''<del style="font-weight: bold; text-decoration: none;">] </del>),Product)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), '' ),Product)</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46875&oldid=prevGheorghe Minca at 09:12, 17 March 20252025-03-17T09:12:08Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:12, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), ''<del style="font-weight: bold; text-decoration: none;">' </del>),Product)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <ins style="font-weight: bold; text-decoration: none;">[</ins>''<ins style="font-weight: bold; text-decoration: none;">] </ins>),Product)</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46874&oldid=prevGheorghe Minca at 09:11, 17 March 20252025-03-17T09:11:45Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:11, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <del style="font-weight: bold; text-decoration: none;">/</del>'<del style="font-weight: bold; text-decoration: none;">/</del>' ),Product)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), '<ins style="font-weight: bold; text-decoration: none;">'</ins>' ),Product)</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46873&oldid=prevGheorghe Minca at 09:11, 17 March 20252025-03-17T09:11:31Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:11, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"><i></del>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), '' ),Product)<del style="font-weight: bold; text-decoration: none;"></i></del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <ins style="font-weight: bold; text-decoration: none;">/</ins>'<ins style="font-weight: bold; text-decoration: none;">/</ins>' ),Product)</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46872&oldid=prevGheorghe Minca at 09:10, 17 March 20252025-03-17T09:10:36Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:10, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><i>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <del style="font-weight: bold; text-decoration: none;">'</del>'' ),Product)</i></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><i>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), '' ),Product)</i></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46871&oldid=prevGheorghe Minca at 09:10, 17 March 20252025-03-17T09:10:26Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:10, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><i>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), '' ),Product)</i></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><i>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <ins style="font-weight: bold; text-decoration: none;">'</ins>'' ),Product)</i></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Mincahttps://docs.plurivaerp.com/index.php?title=Reguli_E-Factura_-_Adaugare&diff=46870&oldid=prevGheorghe Minca at 09:10, 17 March 20252025-03-17T09:10:14Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:10, 17 March 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l32">Line 32:</td>
<td colspan="2" class="diff-lineno">Line 32:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In campul Expresie actualizare pozitie (SET) se poate completa o formula de tip SQL prin care se poate actualiza un camp din pozitia E-facturii la preluarea din SPV si/sau la prelucrarea ulterioara. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>De exemplu urmatoarea formula seteaza in explicatiile pozitiei explicatia transmisa deja in xml de furnizor la nivel de linie factura iar in cazul in care aceasta nu este trimisa in xml de furnizor, se preia denumirea produsului din xml:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><i>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), <del style="font-weight: bold; text-decoration: none;">\</del>'<del style="font-weight: bold; text-decoration: none;">\</del>' ),Product)</i></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><i>Observatii = ISNULL(NULLIF(LTRIM(RTRIM(LineObservations)), '' ),Product)</i></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Campul Expresie conditie (WHERE) este un camp obligatoriu. In el se completeaza o formula de tip SQL prin care se specifica conditiile de identificare a documentelor asupra carora sa se aplice setarile configurate prin acea regula.</div></td></tr>
</table>Gheorghe Minca