# Shared Custom Fields **URL:** \ **Category:** Uncategorized\ **Created:** [June 9, 2020, 8:15am UTC](https://forum.manager.io/t/shared-custom-fields/28657 "2020-06-09T08:15:06Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 9, 2020, 8:15am UTC](https://forum.manager.io/t/shared-custom-fields/28657/1 "2020-06-09T08:15:06Z")
Dear @lubos, after few days of playing with the new reporting tools I can say that probabily you are crating a perfect tool to match all the localization needs. I think that Manager, together with custom fields for the chart of accounts that I’ve already suggested, is still missing the possibility to share custom fields through different typology of data. I try to explain better what I am suggesting through an example. As already exposed, in Italy, under certain conditions, we can change (anticipate) the accrural period of the VAT of the fiscal documents (ie invoices and notes) without altering the accrual period of the invoices. To do this we have created two custom fileds, one that sets the VAT period (ie, for quarters 1Q2020, 2Q2020, 3Q2020, 4Q2020) and one that set the Anticipation (Anticipated or blank). Obviously we had to create these custom fields for all the typologies of fiscal documents (Sales Invoices, Credit Notes, Purchase Invoices, Debit Notes). The problem is that when we create the query we have eight columns: four columns of “VAT Period” and four columns of “Anticipation”. To be functional, usable, coherent and also understandable there should be only two columns that goes through all the different fiscal documents. Any solution for this problem? Thanks for the great work you are doing. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [June 9, 2020, 11:25pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/2 "2020-06-09T23:25:22Z")
This is something I had in mind for quite some time. New custom reports only reinforce the need for this. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [June 9, 2020, 11:36pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/3 "2020-06-09T23:36:02Z")
> [@Davide](#): > > share custom fields through different typology of data A report displaying a value from one of several variables (where the sub variable has the same name) requires - The variable sets to be mutually exclusive, which maybe none trivial for the program to ascertain in the general case - The report to not combine variable with the same name when that is what the user wants The alternative is a localisation combines variables when that is what is wanted. Btw I’m not saying it wont work or is not possible, just that it maybe harder than it sounds ---
**Author:** ![AJD](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@AJD](https://forum.manager.io/u/AJD)\ **Post date:** [June 10, 2020, 12:07am UTC](https://forum.manager.io/t/shared-custom-fields/28657/4 "2020-06-10T00:07:27Z")
I think this may be the same as idea suggestion made by @generalegend on March 8th. > [@Idea: Different categories of Custom Fields](https://forum.manager.io/t/idea-different-categories-of-custom-fields/27278): > > The categories would be: Line item Custom Field Transaction Custom Field List Custom Field. The advantages of this would be: a. A single common field could be created and applied to either one or as many of the entry forms in that category. This would save having to set up the same custom field for each form. b. Selection of custom fields in Custom Reports would be made easier and would only need one column for a common custom field which would report across all transaction types. … ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 10, 2020, 8:06am UTC](https://forum.manager.io/t/shared-custom-fields/28657/5 "2020-06-10T08:06:27Z")
The solutions can be different (and I don’t know how Manager’s engine works!): 1. Revert the perspective of how custom fields works. Now you choose the **tab** you want to assign them and then you create the custom field. In the new implementation one can create first the custom field and then assign it to many different tabs. 2. Add the possibility to link different custom fields like a sort of CONCAT() in the SQL language. In the reporting tab there should be a place to link these fields. The second solution is much easier and faster but the first one, from a functional point of view, is the best solution. For example, if you think of a drop down field, with the second solution you cannot have the guarantee that the list is the same in all the Tabs. The first one maybe can have problem with the legacy of the old custom fields implementation and can imply a big work on the whole Manager way of working. ---
**Author:** ![Drew\_Mike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/drew_mike/32/23586_2.png) [@Drew\_Mike](https://forum.manager.io/u/Drew_Mike)\ **Post date:** [June 10, 2020, 10:11am UTC](https://forum.manager.io/t/shared-custom-fields/28657/6 "2020-06-10T10:11:29Z")
I used Accounting system before, where the system provide you with tags that can be enabled in any transaction screen. You may rename the tag, but the system will still recognize it as tag 1, tag 2,…etc. Maybe this is one way to do it. Just thought of sharing this. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 8, 2021, 7:33am UTC](https://forum.manager.io/t/shared-custom-fields/28657/7 "2021-06-08T07:33:10Z")
Dear @lubos, any update about this idea? ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [August 12, 2022, 1:01am UTC](https://forum.manager.io/t/shared-custom-fields/28657/8 "2022-08-12T01:01:35Z")
This has been implemented in the latest version (22.8.12). It is now possible to have single custom field that can span multiple transaction types ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/6/f6ecba5c086dcb1dab155687742180fb0b70b366.png) ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [August 12, 2022, 4:09am UTC](https://forum.manager.io/t/shared-custom-fields/28657/9 "2022-08-12T04:09:42Z")
Thanks @lubos. Any idea on how to merge the duplicate ones now that they spread across different items? ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [August 12, 2022, 8:05pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/10 "2022-08-12T20:05:57Z")
The best solution to assist with transition would be generic find & recode which I didn’t implement yet. Currently it can be done with `Batch Update` but that is quite rough to use. ---
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [August 13, 2022, 7:25pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/11 "2022-08-13T19:25:34Z")
> [@lubos](#): > > Currently it can be done with `Batch Update` I’ve managed to use `Batch Update` to merge all my custom fields except for the one that is placed in lines in sales invoices and purchase invoices. This doesn’t appear as a column when in the `Sales Invoices` or `Purchase Invoices` tabs. Thankfully for me I’ve only used this a handful of times, so it won’t take long to change them individually. But is there an easy way to quickly find all sales invoices and purchase invoices that use this custom field so that I can be sure I don’t miss any? ---
**Author:** ![AJD](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@AJD](https://forum.manager.io/u/AJD)\ **Post date:** [August 14, 2022, 10:41pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/12 "2022-08-14T22:41:48Z")
@lubos will there be an option to select a shared custom field in custom reports only once to cover all transaction types and report in one column across all transaction types? (At the moment the shared custom field needs to be selected for each transaction over multiple columns.) ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [August 14, 2022, 10:42pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/13 "2022-08-14T22:42:57Z")
I’m working on new implementation of custom reports which will be simpler to use. So not really looking at how this shared custom fields concept affects current implementation. ---
**Author:** ![AJD](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@AJD](https://forum.manager.io/u/AJD)\ **Post date:** [August 14, 2022, 10:46pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/14 "2022-08-14T22:46:24Z")
Thanks. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [August 14, 2022, 10:46pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/15 "2022-08-14T22:46:50Z")
> [@GrahamvdR](#): > > is there an easy way to quickly find all sales invoices and purchase invoices that use this custom field For sales invoices, you could create a Sales Invoice Totals by Custom Field report if this was a standard custom field. There is no similar report for purchase invoices. But since you are looking for a line-item custom field, you are out of luck anyway. ---
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [August 15, 2022, 7:47am UTC](https://forum.manager.io/t/shared-custom-fields/28657/16 "2022-08-15T07:47:28Z")
OK, thanks. I’m actually not sure if I ever did use the field in a purchase invoice, and it will be no great loss if I do lose one or two entries that I did make. So I think I’ll go ahead and replace the field in purchase invoices with the one from sales invoices. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [August 15, 2022, 9:51am UTC](https://forum.manager.io/t/shared-custom-fields/28657/17 "2022-08-15T09:51:28Z")
Can you please consider in the new implementation: 1. the possibility to have logical operators (AND, OR) in the queries 2. the possibility to create groups of custom reports ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [August 15, 2022, 1:15pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/18 "2022-08-15T13:15:15Z")
@Davide, can you explain yourself further? What queries are you referring to? And what is the use case for a group of custom reports? ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [August 15, 2022, 4:12pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/19 "2022-08-15T16:12:24Z")
I also agree about logical operators for `where..` statements. But I don’t understand what’s the suggested grouping for custom reports. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [August 15, 2022, 4:43pm UTC](https://forum.manager.io/t/shared-custom-fields/28657/20 "2022-08-15T16:43:59Z")
Tipically a SQL query syntax is: SELECT _column1_ , _column2, …_ FROM _table\_name_ WHERE _condition1_ AND/OR _condition2_ AND/OR _condition3 …_ Custom Report is a sort of reduced preconfigued SQL query with a graphical interface. Right now WHERE conditions are linked only with AND and OR is not selectable. I’m asking to have this function implemented About groups… we have many custom reports in our businesses. It’s a big list which makes them hard to find. Having the possibility to group them (ie putting them inside sort of folders) will help find them and get rid of this mess. [Next page](https://forum.manager.io/t/shared-custom-fields/28657.md?page=2)