Custom Field on Sales Invoice

Hi, i started to use the custom field on our Sales Invoice. However, it seems something is not ok here. I made the custom field but due to some reason i cannot see it on the document?

any idea, help on that?

From your images it looks like you have created your own template for sales invoices. That’s fine but then you will have to add custom fields yourself to the template.

Custom fields can be referenced by name like this: {{ custom_field_name }}

Good luck.

Hi @Hans, no i use the current template, not a own one due to i have no idea on html, so just use the current template

Dietmar

I have never seen the text “THANK YOU FOR YOUR BUSINESS !” on the default template.
You can check what template you are using when you create new sales invoice (at the bottom).
If the dropdown list for template is empty, you are using the default.

It is the default template. I never do something others here.!

to make this “Thank you…” you can use the notes then write it notes as pic attached" if you use f.e. USD - Bank Konto Information: this text will show BOLD text in printing documents.

Got it; the boxed border around the text is what confused me. I don’t use the notes field.
Leaves you with the problem that starts to look like a bug. I will do some test after work.

Hi @Dietmar

I created a new custom dropdown list for Sales invoice with the Show custom field as column and on printed documents checked. Then I created new invoice and could use my custom dropdown. Made sure the View template field was empty, saved it and viewed the Sales invoice, and as expected the dropdown was there.

Since custom fields are placed at the bottom of the invoice I still think it has something to do with your notes field. Maybe you can try removing it.

Also can you explain a bit more about: **write it notes as pic attached" if you use f.e. USD - Bank Konto Information: this text will show BOLD text in printing documents.**

Hi @Hans, thanks for feedback. I tried several times, also removed the notes field. All not ok, I have the custom field in Sales Invoice, can choose what i need but don t see it then on printing document. Also, I removed my notes and tried again but also still not on printing documents. Now i tried the same on Purchase Invoice but also here cannot see on printing documents

for other issue you want more info. For example, if you write in notes BANK INFO… the this will show on printing document as normal font. If you write in notes BANK INFO, then the font will be bold. Just use the ** in front and end of text, hope now more clear

Hi @Dietmar,

So even though you don’t use HTML, you do seem to use Markdown (lightweight markup language).
Like this for italic or bold. Also there is a lot of space between the total amount on the invoice and the “THANK YOU” text box. The default template puts the notes field directly under invoice line items (see picture with dropdown)

Since it works for me I can only suggest you create a new business and call it something like Test or Demo and create your dropdown list. Then create invoice, leave template box empty, and check invoice.

Hi, ok I made the test company and checked. Then i found out all is fine and working as i would need it. (see pic 1)

then i go back to our company and checked again. After careful check and compare with test company i found out that in the field VIEW TEMPLATE there was marked My Template. I don’t know why and how this happened. Anyhow i took this out and now all is fine (see pic 2)

thanks for support, finally seems this is solved

Dietmar

HI, regarding adding custom field to sales invoice, what should the html code look like to point to that label / data?
example, customs field in “Sales Invoice” call “Weight”

Hi @Dietmar, I am glad all is fine.

For @comspal see quote for syntax.

Also have a look here: Manager Guides

hi, tried different way but still can get the custom field showing up on the template, where am I going wrong?

div>Number of Cartons: {{ sales.invoice.custom_fields_Gross_Weight }}

Gross Weight (Kg): {{ sales invoice.custom_fields[‘Number.of.Cartons’] }}

First, when you edit custom field, make sure the option Show custom field on printed documents is checked.

Then in your HTML template, you can inject the content of custom field using this syntax:

{{ custom_fields['Number of Cartons'] }}

Or just don’t use custom HTML template and the custom field will show by default.

Got it, THANKS :smile:

Hi

Please help, i want t generate custom field (Drop Down List) in Sales Invoice. i have ticked “show custom field as a column” and “on printed documents”

However, the column does not appear. instead it appear besides accounts under document.

And we must do input by ourselves as the drop down list function not working.

Thank you

Elvie

There are two issues involved. Both are related to the fact that you have defined a line-item custom field rather than an ordinary transaction-level custom field. You did not mention which was your goal.

  • The checkbox to show as a column applies only for ordinary custom fields. When you check it, the content shows in the Sales Invoices tab listing, not on the completed invoice.

  • The dropdown list option does not function for line-item custom fields yet. But the custom field definition screen is used for both types of custom fields.

I suspect you actually wanted an ordinary custom field, since the sales invoice would apply only to one clinic location, not to individual goods or services on separate lines. If so, you should delete this custom field and create an ordinary one. To learn more about the differences, read the two Guides:
https://www.manager.io/guides/8941
https://www.manager.io/guides/10411

A post was split to a new topic: Expense claim custom report