https://wikidoc.kase.se/index.php?action=history&feed=atom&title=News%3ACalculated_amounts_and_default_columns_in_project_invoicing%2Fen 2026-04-13T18:07:01Z Revision history for this page on the wiki MediaWiki 1.27.1 https://wikidoc.kase.se/index.php?title=News:Calculated_amounts_and_default_columns_in_project_invoicing/en&diff=35516&oldid=prev 2017-08-16T08:47:54Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='en'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 08:47, 16 August 2017</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 14:</td> <td colspan="2" class="diff-lineno">Line 14:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{{ExpandImage|Calcndefault.png}}</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{{ExpandImage|Calcndefault.png}}</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color:black; 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>Click on Save default if you want to save number of columns, column widths and formula. When you create a new invoice, it will be set up according to the state of the invoice text at the time of saving default.</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color:black; 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>Klicka på knappen Spara default för att spara antal kolumner, kolumnbredder och formel. När man skapar en ny faktura så kommer den nya fakturan att vara förinställd enligt hur fakturatexten var anpassad när default sparades.</div></td> <td colspan="2" class="diff-empty">&#160;</td> </tr> <!-- diff cache key wikidoc:diff:version:1.11a:oldid:35514:newid:35516 --> </table>

TR https://wikidoc.kase.se/index.php?title=News:Calculated_amounts_and_default_columns_in_project_invoicing/en&diff=35514&oldid=prev 2017-08-16T08:40:34Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='en'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 08:40, 16 August 2017</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 10:</td> <td colspan="2" class="diff-lineno">Line 10:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>}}</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>}}</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color:black; 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>If you use formatted invoice text in PRO, you can now write a formula that automatically calculates amount in the amount column based on the values in the other columns. In the formula, column 2 corresponds with B, column 3 with C etc. see example below. The formula supports the following operators: ()*/+- When the amount has been calculated, it will not change if you change the formula. But if you make changes in some fields, the amount will be recalculated.</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color:black; 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>Använder man formaterad fakturatext i PRO finns nu möjlighet att skriva en formel som automatiskt räknar ut belopp i beloppskolumnen baserat på värden i övriga kolumner. I formeln svarar kolumn 2 mot B, kolumn 3 mot C osv. Se angiven formel och exempeluträkning i bild nedan. Formeln stödjer följande operatorer: ()*/+- När beloppet är uträknat så ändras det inte om man gör en ändring i formeln, men om man gör en ändring i någon av fälten så sker en ny uträkning av belopp.</div></td> <td colspan="2" class="diff-empty">&#160;</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{{ExpandImage|Calcndefault.png}}</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{{ExpandImage|Calcndefault.png}}</div></td> </tr> <!-- diff cache key wikidoc:diff:version:1.11a:oldid:35504:newid:35514 --> </table>

TR https://wikidoc.kase.se/index.php?title=News:Calculated_amounts_and_default_columns_in_project_invoicing/en&diff=35504&oldid=prev 2017-08-15T12:14:22Z

<p>Updating to match new version of source page</p> <p><b>New page</b></p><div><br /> {{News<br /> |Calculated amounts and default columns in project invoicing<br /> |module=Project accounting<br /> |group=Project<br /> |version=546<br /> |revision=40517<br /> |case=968825<br /> |published=2017-08-15<br /> }}<br /> <br /> Använder man formaterad fakturatext i PRO finns nu möjlighet att skriva en formel som automatiskt räknar ut belopp i beloppskolumnen baserat på värden i övriga kolumner. I formeln svarar kolumn 2 mot B, kolumn 3 mot C osv. Se angiven formel och exempeluträkning i bild nedan. Formeln stödjer följande operatorer: ()*/+- När beloppet är uträknat så ändras det inte om man gör en ändring i formeln, men om man gör en ändring i någon av fälten så sker en ny uträkning av belopp.<br /> <br /> {{ExpandImage|Calcndefault.png}}<br /> <br /> Klicka på knappen Spara default för att spara antal kolumner, kolumnbredder och formel. När man skapar en ny faktura så kommer den nya fakturan att vara förinställd enligt hur fakturatexten var anpassad när default sparades.</div>

FuzzyBot