[marcnyc]

I see in the si_invoices table in phpMyAdmin that they are called custom_field1, custom_field2 etc but if I edit my manage.tpl file code from this:

                "columns": [
                    {"data": "action"},
                    {"data": "index_id"},
                    {"data": "biller"},

to this:

                "columns": [
                    {"data": "action"},
                    {"data": "index_id"},
                    {"data": "custom_field1"},

What I get when I reloead the web page is this error alert box:

DataTables warning: table id=si-data-table – Requested unknown parameter ‘custom_field1’ for row 0, column 2. For more information about this error, please see http://datatables.net/tn/4

I don’t see the biller being one of the si_invoices table columns so I have a feeling I’m changing the wrong part of the code, but that is the only place I see the word “biller” appear in the manage.tpl file and I don’t see it appear anywhere else in that file or in the manage.php file.

What am I missing?

[marcnyc]

Oh damn, I feel stupid now… it’s always the small stuff…

Ok so now that I see what I’m modifying, would you please tell me what the names of the Custom Fields are in the database?

Speicfically, if I have:
invoice :: Custom field 1 set to Artist

How can I access/refer to/call the name of the invoice :: Custom field 1 and the contents to put inside the json file?

[marcnyc]

Yes I had figured out the switch thing on my own by clicking around, but I don’t see those XXXX appear anywhere…
here’s screenshots of my structure and backend

Attachments:

1. 

   Screen-Shot-2025-10-20-at-5.38.24-PM.png
   

2. 

   Screen-Shot-2025-10-20-at-5.37.30-PM.png
   

3. 

   Screen-Shot-2025-10-20-at-5.35.43-PM.png
   

[marcnyc]

Sorry found it:
here

Tried to delete my post above but was unable to…

[marcnyc]

I think this is the post you were referring to in the other thread…
I followed these instructions and I copied /modules/invoices/manage.php to extensions/MYextension/modules/invoices/manage.php and then I copied /templates/default/invoices/manage.tpl to extensions/MYextension/templates/default/invoices/manage.tpl and then I enabled MYextension in SETTINGS > Customize > Extensions (it now has a lit light bulb and a green puzzle piece on the right).

You mentioned the getAllWithHavings but in the manage.php file I only see this code:

    $invoices = Invoice::getAllWithHavings($having, '', '', true, false,
                                           $invoiceDisplayDays);

and no other way to add any fields there…

Next I opened in the editor the manage.tpl file and where the table is built and this line is:
<th>{$LANG.billerUc}</th>
I’ve added (just to make sure I’m in the right place) of the code:
<th>xxxx{$LANG.billerUc}</th>
but I don’t see those “xxxx” being displayed anywhere in my table, even after re-loading, logging out and using an incognito browser window. What am I doing wrong?

Also later in that file I see:

    <script>
        {literal}
        $(document).ready(function () {
            $('#si-data-table').DataTable({
                "ajax": "./public/data.json",
                "orderClasses": false,
                "deferRender": true,
                "responsive": true,
                "columns": [
                    {"data": "action"},
                    {"data": "index_id"},
                    {"data": "biller"},
                    {"data": "customer"},
                    {"data": "preference"},
                    {"data": "date"},

but what are the other “data” fields I can add here? How do I add the custom fields here?

[marcnyc]

Sorry but I cannot find another post of mine where this is addressed… Could you please link to the relevant response or tell me in this thread how I can add fields to the Table so that I can display other fields from the database, thus have them searched by the search function?

Much appreciated.

[marcnyc]

bumping this cause I need to search in some of the other fields…

[marcnyc]

Got it. That’s part of why I want to add some fields in that table. I’ve asked this in my other post, so I won’t double-post here and I hope you can show me in the other post how to add some fields to the table. Thank you

[marcnyc]

Sorry to be dumb, but I am a bit confused.
I found the Settings > Customize > Extensions menu and I see the “Core part and the “eway payment gateway” and nothing else. I don’t see a way to add an extension here.
How would I add an extension? And what would the extension be/entail?

What I am trying to achieve are two separete things:

1. add some of the CUSTOM FIELDS that I have set in Settings>Custom Fields to the main view that I see when I load the main page in Money>Invoices.

Right now that page shows a table with: Actions / Invoice / Biller / Customer / Preference etc etc
What I want to do is add two custom fields to that table.

2. somehow I misspelled my name in the PDF invoice at the top right corner and I can’t find where the settings are for that… I’ve looked in all the PEOPLE menus and SETTINGS menus but I can’t see where the misspelled name is, where would that be saved?

[marcnyc]

Wonderful RRowley! Thank you for doing that!

[marcnyc]

just bumping this up to make sure it is seen…

[marcnyc]

Thank you RRolwey for the explanation.
Should you find a way to make the search feature system wide in the future, I think that would be a great feature to add so that one can always search the entire database.
From the little PHP I know it should be easy to disconnect the search feature from the table and just run the search across all the fields of the database.

[marcnyc]

Thank you so much. This is SUPER helpful!
The Display Days settings is what I needed!
I keep all my customers always enabled (cause, as they say, sometimes they come back! 😉 so I wouldn’t need any options to show only enabled customers, but the 1-year worth of invoices did the trick!
I can always click All if I have to find older ones…

The one change/feature request I would like to ask for/add is that the search should always work in ALL (entire database of invoices)… I’ve noticed that if I set the days to 365 it won’t search for older invoices… I think the display feature should not affect the search feature as that can create some headaches and confusion (if you forget you have set it to a year of invoices and you need to find an old one with the search function).

[marcnyc]

Moving the manage.tpl file from the old install to custom/default_template didn’t work…
Basically, what I am trying to do is change what values are shown inside the table that is shown in the main MONEY>INVOICES screen (at the URL: /index.php?module=invoices&view=manage)
What part of the template file generates this table so I can change what is show in that table? Or is there another way to change what is shown?

As for the PDF, thanks for telling me where the font settings are.

I have one last PDF question: my name is misspelled in the PDF invoice at the top right corner and I can’t find where the settings are for that… I’ve looked in all the PEOPLE menus and SETTINGS menus but I can’t see where the misspelled name is, where would that be saved?

Thanks

[marcnyc]

Thank you so much for your help!

[Author]

Posts