# \#drops **URL:** https://community.silverfin.com/tag/drops/224.md [Latest](https://community.silverfin.com/latest.md) · [Categories](https://community.silverfin.com/categories.md) · [Tags](https://community.silverfin.com/tags.md) --- ## [Count all starred accounts](https://community.silverfin.com/t/count-all-starred-accounts/2558)
**Author:** [@Mike.davis](https://community.silverfin.com/u/Mike.davis)\ **Replies:** 2\ **Last updated:** [April 28, 2025, 11:14am UTC](https://community.silverfin.com/t/count-all-starred-accounts/2558 "2025-04-28T11:14:26Z")
Hi, I’m looking to count the number of starred accounts active on a client file, to use this as an insight for reporting purposes. From some research on the forums I’ve compiled the following code, but it is currently … --- ## [Detail "Huur gebouwen"](https://community.silverfin.com/t/detail-huur-gebouwen/2492)
**Author:** [@svalais](https://community.silverfin.com/u/svalais)\ **Replies:** 5\ **Last updated:** [February 15, 2024, 10:19am UTC](https://community.silverfin.com/t/detail-huur-gebouwen/2492 "2024-02-15T10:19:40Z")
Hello, I made a change to one of our existing account template but I have a problem because when I type an amount in the new field, the program also copy this amount to the next field in the table. This is what happens… --- ## [Issues with values not matching even though identical when doing data cleansing](https://community.silverfin.com/t/issues-with-values-not-matching-even-though-identical-when-doing-data-cleansing/2418)
**Author:** [@ngrayfc](https://community.silverfin.com/u/ngrayfc)\ **Replies:** 7\ **Last updated:** [April 14, 2023, 9:07am UTC](https://community.silverfin.com/t/issues-with-values-not-matching-even-though-identical-when-doing-data-cleansing/2418 "2023-04-14T09:07:00Z")
Hi all, Been working lately on a use case which requires data cleansing for an export: All external adjustments as a summary in a CSV export - where if there’s multiple adjustments of the same account code it compiles … --- ## [Changed needed after recent Silverfin changes (drops-\>reconsiliations)](https://community.silverfin.com/t/changed-needed-after-recent-silverfin-changes-drops-reconsiliations/2395)
**Author:** [@Panagiotis\_Issaris](https://community.silverfin.com/u/Panagiotis_Issaris)\ **Replies:** 5\ **Last updated:** [March 23, 2023, 3:24pm UTC](https://community.silverfin.com/t/changed-needed-after-recent-silverfin-changes-drops-reconsiliations/2395 "2023-03-23T15:24:38Z")
Hi, We were informed that due to changes in Silverfin, we would need to change our templates according to various tables posted on this forum, such as: According to this specific table, it seems as if period.custom.m… --- ## [Disclosure Liquidation reserve](https://community.silverfin.com/t/disclosure-liquidation-reserve/2391)
**Author:** [@svalais](https://community.silverfin.com/u/svalais)\ **Replies:** 4\ **Last updated:** [January 23, 2023, 8:49am UTC](https://community.silverfin.com/t/disclosure-liquidation-reserve/2391 "2023-01-23T08:49:47Z")
In a new disclosure, I need to recover the data from the first table of the disclosure Liquidation reserve. The data of the columns “Datum einde boekjaar”, “Bedrag” and “Verlaagde taxatie vanaf” is not a problem. I … --- ## [Call value stored in handle based on string](https://community.silverfin.com/t/call-value-stored-in-handle-based-on-string/2392)
**Author:** [@James](https://community.silverfin.com/u/James)\ **Replies:** 1\ **Last updated:** [January 23, 2023, 7:52am UTC](https://community.silverfin.com/t/call-value-stored-in-handle-based-on-string/2392 "2023-01-23T07:52:33Z")
I am trying to pull through data into a reconciliation from an account template. It works when I use the following code; {{ period.reconciliations.maz\_fx\_rates.results.datapoint\_1612051200\_USD }} however when I try to … --- ## [Result tags corporate tax in report](https://community.silverfin.com/t/result-tags-corporate-tax-in-report/2388)
**Author:** [@Julie\_Vandekerckhove](https://community.silverfin.com/u/Julie_Vandekerckhove)\ **Replies:** 1\ **Last updated:** [January 13, 2023, 8:03am UTC](https://community.silverfin.com/t/result-tags-corporate-tax-in-report/2388 "2023-01-13T08:03:50Z")
Hi, Is there a way to add reconciliation values in a report comming from the corporate tax. I’ve tried the following: But no values seem to be added into the report. Thank you! --- ## [CASE: persistent\_id](https://community.silverfin.com/t/case-persistent-id/2328)
**Author:** [@t0gden](https://community.silverfin.com/u/t0gden)\ **Replies:** 0\ **Last updated:** [August 8, 2022, 3:32pm UTC](https://community.silverfin.com/t/case-persistent-id/2328 "2022-08-08T15:32:39Z")
Hi there! Today we will take a look at the difference between person.persistent\_id and person.id. Both of these methods are useful when we want to access information about a person but there is an important difference. … --- ## [CASE: access the number of a bookyear](https://community.silverfin.com/t/case-access-the-number-of-a-bookyear/1359)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [January 22, 2019, 12:42pm UTC](https://community.silverfin.com/t/case-access-the-number-of-a-bookyear/1359 "2019-01-22T12:42:12Z")
From now on you can access the number of a bookyear by this code: {{ period.bookyear\_index }} For Belgium tax calculations, this can be used as we sometimes need to know if the bookyear is part of the first 3 years o… --- ## [CASE: check if an attachment (or attachments) are added](https://community.silverfin.com/t/case-check-if-an-attachment-or-attachments-are-added/1225)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [October 1, 2018, 12:34pm UTC](https://community.silverfin.com/t/case-check-if-an-attachment-or-attachments-are-added/1225 "2018-10-01T12:34:12Z")
If you want to check whether or not documents (attachments) have been added to a database variable, you can by using the document method: {% if custom.attachements.things.document == blank %} {% ic %} {::infotext … --- ## [CASE: display reconciliation of previous period](https://community.silverfin.com/t/case-display-reconciliation-of-previous-period/1197)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [September 17, 2018, 11:40am UTC](https://community.silverfin.com/t/case-display-reconciliation-of-previous-period/1197 "2018-09-17T11:40:12Z")
Let’s take this case: and say we want an option to display the same reconciliation from the previous year as well. If you create your details into a custom collection, you can call upon these details by this code: … --- ## [CASE: order a drop or custom collection on certain object](https://community.silverfin.com/t/case-order-a-drop-or-custom-collection-on-certain-object/1108)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [August 9, 2018, 7:09am UTC](https://community.silverfin.com/t/case-order-a-drop-or-custom-collection-on-certain-object/1108 "2018-08-09T07:09:05Z")
Take this overview of done investments, where I’ve put in all investments but not in the order of the data they were done: This is the code behind it: {% stripnewlines %} {% fori acc in custom.investments\_office\_mat… --- ## [CASE: display the name of account](https://community.silverfin.com/t/case-display-the-name-of-account/1008)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [June 19, 2018, 8:56am UTC](https://community.silverfin.com/t/case-display-the-name-of-account/1008 "2018-06-19T08:56:24Z")
In case you’d rather display quickly the name of an account (instead of creating a collection with only the account in, and looping over it to create it, for instance: {% assign accounts = period.accounts.400000 %} {% … --- ## [CASE: use date General Meeting or the postponed General Meeting](https://community.silverfin.com/t/case-use-date-general-meeting-or-the-postponed-general-meeting/955)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [June 4, 2018, 7:44am UTC](https://community.silverfin.com/t/case-use-date-general-meeting-or-the-postponed-general-meeting/955 "2018-06-04T07:44:56Z")
If you want to display the date of the General Meeting, you can do so by using following object: {{ period.custom.av.datum }} However, if you checked for postponing the General Meeting (boolean in text template of the … --- ## [CASE: give amount of an account of a previous period](https://community.silverfin.com/t/case-give-amount-of-an-account-of-a-previous-period/888)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [May 16, 2018, 2:23pm UTC](https://community.silverfin.com/t/case-give-amount-of-an-account-of-a-previous-period/888 "2018-05-16T14:23:31Z")
Let’s say we want to display the amount of an account of the previous year in an account template. In an account template we have the so called current\_account drop, where you can get certain data from it (think of the … --- ## [CASE: when to use .size and .count to display the amount in a drop or variable?](https://community.silverfin.com/t/case-when-to-use-size-and-count-to-display-the-amount-in-a-drop-or-variable/793)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [April 3, 2018, 8:07am UTC](https://community.silverfin.com/t/case-when-to-use-size-and-count-to-display-the-amount-in-a-drop-or-variable/793 "2018-04-03T08:07:46Z")
If you want to count how many elements a certain drop has, you can add .countto your drop-name or the name of a collection : {{ period.directors.count }} Above code will result in the amount of directors have been c… --- ## [CASE: how to count the shareholders that were marked as present?](https://community.silverfin.com/t/case-how-to-count-the-shareholders-that-were-marked-as-present/280)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [May 28, 2017, 1:45pm UTC](https://community.silverfin.com/t/case-how-to-count-the-shareholders-that-were-marked-as-present/280 "2017-05-28T13:45:38Z")
This is only the case if you want to use your own count of present shareholders or directors for instance. In our own standard templates this is done automatically. F.i. any given director, will be saved in a special d… --- ## [Shareholer automatic completion](https://community.silverfin.com/t/shareholer-automatic-completion/2254)
**Author:** [@lieels01](https://community.silverfin.com/u/lieels01)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 11:30am UTC](https://community.silverfin.com/t/shareholer-automatic-completion/2254 "2022-03-14T11:30:23Z")
Hi! I’d like to have an automatic system where the possible shareholders appear (some kind of boolean maybe) and depending on the name that is selected, the name and number of shares of the selected person should be com… --- ## [Issue with dropdown input](https://community.silverfin.com/t/issue-with-dropdown-input/2251)
**Author:** [@lieels01](https://community.silverfin.com/u/lieels01)\ **Replies:** 2\ **Last updated:** [March 4, 2022, 3:07pm UTC](https://community.silverfin.com/t/issue-with-dropdown-input/2251 "2022-03-04T15:07:07Z")
Good morning, I have the below code that comes out a bit strange… Can you perhaps tell me what’s wrong with the input field that should actually be a dropdown menu? {% if custom.approval.postponement == true %} {% ca… --- ## [Custom template](https://community.silverfin.com/t/custom-template/2213)
**Author:** [@Stefan.Temelie](https://community.silverfin.com/u/Stefan.Temelie)\ **Replies:** 10\ **Last updated:** [February 28, 2022, 11:12am UTC](https://community.silverfin.com/t/custom-template/2213 "2022-02-28T11:12:06Z")
Hi, Can you please let me know if any of the two are possible and advise how I can achieve this? 1 To see unreconciled indicators at the top of the table instead of showing after each questions 2 To add a new dropdown… --- ## [Automatic completion of accounting details](https://community.silverfin.com/t/automatic-completion-of-accounting-details/2207)
**Author:** [@lieels01](https://community.silverfin.com/u/lieels01)\ **Replies:** 5\ **Last updated:** [February 16, 2022, 5:16pm UTC](https://community.silverfin.com/t/automatic-completion-of-accounting-details/2207 "2022-02-16T17:16:45Z")
Hi, In Silverfin you have the option to automatically complete data from the system by for example using: {{ company.name | strip }} {{ full\_company\_form | strip }} or {{ period.accounts.assets.value | currency }} {{ co… --- ## [Listing all method for custom drop](https://community.silverfin.com/t/listing-all-method-for-custom-drop/2203)
**Author:** [@cdriess](https://community.silverfin.com/u/cdriess)\ **Replies:** 1\ **Last updated:** [February 10, 2022, 12:51pm UTC](https://community.silverfin.com/t/listing-all-method-for-custom-drop/2203 "2022-02-10T12:51:49Z")
Hi all, I am trying to create custom reports and for that, I need custom fields, comany related, but I don’t know the exact name of the method to retreive it. Is there a way (fori?) to list them all? Indeed, as Luxembo… --- ## [Transaction drop date](https://community.silverfin.com/t/transaction-drop-date/2190)
**Author:** [@Fintrax](https://community.silverfin.com/u/Fintrax)\ **Replies:** 17\ **Last updated:** [January 31, 2022, 10:55am UTC](https://community.silverfin.com/t/transaction-drop-date/2190 "2022-01-31T10:55:36Z")
The transaction drop has a date method which returns the booking date of the transaction. Is there however a way to access the date of when the transaction actually happened? If not, is it possible to add this? I assume … --- ## [Reduce the amount of code lines](https://community.silverfin.com/t/reduce-the-amount-of-code-lines/2191)
**Author:** [@Stefan.Temelie](https://community.silverfin.com/u/Stefan.Temelie)\ **Replies:** 1\ **Last updated:** [January 3, 2022, 8:29am UTC](https://community.silverfin.com/t/reduce-the-amount-of-code-lines/2191 "2022-01-03T08:29:07Z")
Hi, I am building a template where I will have many questions and I am going to use the below code for each of the questions. Can you please advise if I can reduce the amount of lines that i will have in my code ? {% … --- ## [Updating an in-use reconciliation](https://community.silverfin.com/t/updating-an-in-use-reconciliation/2176)
**Author:** [@jhanley](https://community.silverfin.com/u/jhanley)\ **Replies:** 2\ **Last updated:** [November 12, 2021, 10:56am UTC](https://community.silverfin.com/t/updating-an-in-use-reconciliation/2176 "2021-11-12T10:56:36Z")
Hi, We have a reconciliation that has been used for some time, and we’d like to add a new required field that will be needed to ensure the document flags as reconciled. How can we release this update, without this beco… --- ## [Access "Marked as reviewed" from other reconciliations](https://community.silverfin.com/t/access-marked-as-reviewed-from-other-reconciliations/2173)
**Author:** [@Bjorn\_Lindroth](https://community.silverfin.com/u/Bjorn_Lindroth)\ **Replies:** 1\ **Last updated:** [November 3, 2021, 2:44pm UTC](https://community.silverfin.com/t/access-marked-as-reviewed-from-other-reconciliations/2173 "2021-11-03T14:44:56Z")
Hi! Is it possible to set the status “Reviewed by” without using the workflow review? We are considering creating a custom reconciliation showing key figures from other reconciliations to make the review work easier. So… --- ## [Beginner \[Exercise 3: Filters & Drops\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-3-filters-drops-training-slides-exercise/1735)
**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\ **Replies:** 1\ **Last updated:** [April 7, 2020, 9:51am UTC](https://community.silverfin.com/t/beginner-exercise-3-filters-drops-training-slides-exercise/1735 "2020-04-07T09:51:08Z")
Print the following content on a document applying the respective filters: The name of the company in Capital Letters The address of the company, replacing any blank spaces by an underscore (\_) The date of the end of t… --- ## [Creating a new comment](https://community.silverfin.com/t/creating-a-new-comment/1434)
**Author:** [@Tine1](https://community.silverfin.com/u/Tine1)\ **Replies:** 1\ **Last updated:** [March 21, 2019, 2:04pm UTC](https://community.silverfin.com/t/creating-a-new-comment/1434 "2019-03-21T14:04:32Z")
I would like to make a new comment but it doesn’t work when I try it. it works as a detail within an account but it doesn’t work to put it as an template like liquid assets. How do I need to change this to be able to i… --- ## [Text-document retrieving info from bedrijfsparameters](https://community.silverfin.com/t/text-document-retrieving-info-from-bedrijfsparameters/1421)
**Author:** [@Francis](https://community.silverfin.com/u/Francis)\ **Replies:** 4\ **Last updated:** [March 14, 2019, 2:42pm UTC](https://community.silverfin.com/t/text-document-retrieving-info-from-bedrijfsparameters/1421 "2019-03-14T14:42:38Z")
Hi, I’ve constructed a text-document starting from the code of the standard text file for the AV. I know 0,00000 about programming and like anyone else I have 0,0000 time to spare to learn how to do that properly. So t… --- ## [Export disclosures](https://community.silverfin.com/t/export-disclosures/759)
**Author:** [@svalais](https://community.silverfin.com/u/svalais)\ **Replies:** 11\ **Last updated:** [March 5, 2019, 3:27pm UTC](https://community.silverfin.com/t/export-disclosures/759 "2019-03-05T15:27:25Z")
Hello, We have created a style where we export all the disclosures available in a dossier. The problem is that the unstared disclosures also are esported. Wat can we change in the following code to do this? \`\`{% capt… [Next page](https://community.silverfin.com/tag/drops/224.md?match_all_tags=true&page=1&tags%5B%5D=drops)