Home Forums Support Number formatting invoice

This topic contains 11 replies, has 2 voices, and was last updated by  Hillel Coren 2 months, 3 weeks ago.

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • #20270

    blarblar
    Participant

    Hey there,

    first of all, InvoiceNinja is great. I setup self-hosting and so far everything is working fine.

    I have one small issue with the invoice design. It is not feasible for the tax region I live in, to change invoices after they are created, so this balance and balancedue thing is not applicable. I created a custom design with this code:

    
    {
        "columns": [
          "$notesAndTerms",
          {
            "alignment": "right",
            "table": {
              "widths": [
                "*",
                "32%"
              ],
              "body": [
                [
                  "Zwischensumme",
                  "€$invoice.subtotal_amount"
                ],
                [
                  "Mwst. 19%",
                  "€$invoice.tax_amount1"
                ],
                [
                  "Gesamt",
                  "$invoice.amount"
                ]
              ]
            },
            "layout": {
              "hLineWidth": "$none",
              "vLineWidth": "$none",
              "paddingLeft": "$amount:0",
              "paddingRight": "$amount:8",
              "paddingTop": "$amount:4",
              "paddingBottom": "$amount:4"
            }
          }
        ]
      },
    

    This is working but $invoice.subtotal_amount and $invoice.tax_amount1 are not formatted correct. If the subtotal is an integer it is show as 175 instead of 175.00 and both of them are formatted with a period as the sperator instead of a comma. The subtotal should be shown as 175,00 instead of 175 or 175.00

    Any hints?

    #20274

    Hillel Coren
    Keymaster

    Applying formatting to those fields isn’t supported, you’d need to modify the source code.

    #20275

    blarblar
    Participant

    Is there any other way to just show Total Amount and not the redundant due/paid stuff?

    #20277

    Hillel Coren
    Keymaster

    $invoiceTotal

    #20279

    blarblar
    Participant

    Sry for the confusion. I need subtotal, tax and total. Nothing more. $invoiceTotal gives me nothing?!

    • This reply was modified 2 months, 3 weeks ago by  blarblar.
    #20281

    Hillel Coren
    Keymaster

    Are you using $invoiceTotal or %invoiceTotal, it should be $invoiceTotal.

    The app doesn’t support breaking down the other fields, you’d need to use the field stack used in the default designs.

    #20282

    blarblar
    Participant

    Hey Hillel,

    thank you for this prompt support.

    Unfortunately, $invoiceTotal doesn’t help either. I do have the correct total in the right format. I need Subtotal and Tax in the right format.

    Okay, I wanted a quick solution and thought, just set the Localization/Language to English. I don’t mind if everything has a period. Möp. Doesn’t work either. Everything still is the same?!? A mix of commas and periods. Grmppf.

    FYI: I have never ever seen this “Outstanding, Paid to Date and Balance Due” on Germnan invoices. We have something called “Abschlagsrechnung”, but this is working completely different and has a set of rules which are regulated, like so many things in Germany.

    #20283

    Hillel Coren
    Keymaster

    If you use a standard design (rather than the custom design) the formatting should be correct.

    You can use this feature to lock the invoices.

    https://invoice-ninja.readthedocs.io/en/latest/configure.html#lock-invoices

    #20284

    blarblar
    Participant

    Yes, but then there is also the redundant Paid to Date / Balance stuff. This is a problem with using this app in Germany.

    Locking the invoice doesn’t prevent InvoiceNinja from showing Paid to Date when a payment is entered after the invoice is sent, so I am not sure why you are suggesting this?!

    #20289

    Hillel Coren
    Keymaster

    Just trying to help… I may have misunderstood your “It is not feasible … to change invoices after they are created” comment.

    #20293

    blarblar
    Participant

    Ooops, my bad. I didn’t mean to sound rude. It ma have been my wording. You support is awesome!

    Any chance you fix the formatting of $invoice.subtotal_amount and $invoice.tax_amount1 in the future? It prevents me from using your great piece of software.

    • This reply was modified 2 months, 3 weeks ago by  blarblar.
    #20305

    Hillel Coren
    Keymaster

    We’ll definitely keep this use case in mind for v2 but it’s unlikely we’ll support it in the current version.

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.

Posted in: