How to add Fund Type (or another existing attribute) to document lines?

iplicit comes with a set of existing attributes, including Fund Type, that can be enabled on document lines. If Fund Type isn't appearing when you're entering a document, or the dropdown is empty when it does appear, it's because either the Fund Types and Funds haven't been set up yet, or the Chart of Account Rule on the account being used doesn't include the attribute. This article covers the full setup.

This applies across all document types such as Sales Invoices, Purchase Invoices, Purchase Orders, Sales Orders, and Journals, because attribute visibility is driven by the Chart of Account, not the document itself.

Step one - Set up your Fund Types

Fund Types are the top-level groupings your individual Funds sit under. For most organisations these are 'Restricted' and 'Unrestricted', but you can create whatever types suit your reporting needs.

We have a user guide available with the steps to create fund types: Fund Types | iplicit

Step two - Set up your Funds

Once your Fund Types exist, add the individual Funds that sit under each type.

We have a user guide available with the steps to create & import your funds list: Funds | iplicit 

Step three - Identify the Chart of Account Rule in use

Attribute visibility is controlled at the rule level, so the next step is to find the rule attached to the accounts you want to update.

1. Navigate to the Chart of Accounts and open one of the accounts where you want Fund (or the attribute you're adding) to appear
2. Drill into the Chart of Account Rule attached to it (ctrl & click on the rule)
3. If multiple accounts share the same rule, updating that rule once will apply the change across all of them

Step four - Add the attribute to the Chart of Account Rule

1. Enter edit mode
2. Add the existing attribute you want available on document lines, for example Fund 
3. Save the rule

Step five - Check the attribute appears on the document line

1. Open a test document (for example a Sales Invoice or Purchase Order) and add a line
2. Code the line to a Chart of Account that uses the updated rule
3. Fund Type (or the attribute you added) should now be visible on the line, with the Funds you set up available to select

Things to know

• Fund Types and Funds only need setting up once. After that, any Chart of Account Rule you add Fund Type to will display the full list of Funds on document lines
• If Funds appears on the line but the dropdown is empty, it usually means Funds haven't been added under the Fund Types yet. Revisit step two
• This applies across Sales Invoices, Purchase Invoices, Purchase Orders, Sales Orders, Journals, and all other document types. Any document line coded to an account using the updated rule will display the attribute
• The same process applies if you want to add a Custom Posting Attribute you've created yourself. See 'How to create Custom Posting Attributes' for the steps to create one, then follow this article to make it appear on document lines