Skip to main content

How can I locate an invoice if the matter is archived in LeanLaw?

Custom Fields Allow You to Map Fields in LeanLaw to Fields in QuickBooks Online

Jessica McCullough avatar
Written by Jessica McCullough
Updated over 2 weeks ago

The following will be covered in this article:

  • What are Custom Fields

  • Custom Fields setup in QuickBooks Online

  • Custom Fields linking in LeanLaw

  • How to clear a LeanLaw value field, how to disable custom field overall

  • Using Custom Fields in Reports

  • Troubleshooting missing matter numbers on invoices

  • Locating missing matters or invoices

Note: Want to use this feature? You'll need to have upgraded to QuickBooks Online Advanced. If you don't have QuickBooks Online Advanced, here's how to add custom fields for other QuickBooks versions.

What are Custom Fields

The Custom Fields Tool allows you to link fields in LeanLaw to fields in QuickBooks Online. The ability to create and link custom fields for Invoices has been present for a while in all versions of QuickBooks Online. Now, a user that is setup for QuickBooks Online Advanced account can utilize mapping custom fields in LeanLaw to QuickBooks Online report fields.


Custom Fields setup in QuickBooks Online

Custom Fields are accessed in Settings in QuickBooks Online.

  1. Open QuickBooks Online

  2. Go to the Settings

  3. Select Custom Fields from the Lists Column

  4. Select the green Add Field button

  5. Using Custom Fields in Reports

From here you will need to Create a Name, Data Type, Category, and select the Forms you would like to apply the Custom Field to. The Name you give is what will show in the Custom Fields setup in LeanLaw on the next step and show as the column name wherever you map the Custom Field to.

There are four Data Types that you can choose from:

Data Type

Example

More Info

Text and Number

Norman1292

Text and Number

Number Only

34294

Numbers Only

Date

1/21/21

Date Format

Dropdown List

Originating Attorney

Responsible Attorney

Allows a Dropdown to select from a List

While most of the Data Types are self explanatory, if you choose a Data Type of Dropdown, you will need to add the Dropdown options. You will want to ensure that you create the same number of options as you have in LeanLaw, and name them the same as you did in LeanLaw.

The Category will designate whether the field will show in the Customer, Transaction, or Vendor Category. The Form selection will designate what Forms the Custom Field will be on.


Once you Save the Custom Field, you will have access to Edit it and Activate/ Inactivate the Custom Field. If the Custom Field is inactive, it will not be available in the Custom Fields in LeanLaw.


Custom Fields linking in LeanLaw

Custom Fields can be accessed in the Firm Settings in LeanLaw.

  1. Open the LeanLaw Settings page βš™

  2. Under the Firm Settings section, select the Invoice Presentation option.

  3. Click the Custom Fields button towards the bottom of the page.

If your QuickBooks Online Custom Field is Active, you will see it in the LeanLaw Custom Fields. You will need select a LeanLaw Value and then Map the Values.


How to clear a LeanLaw value field, how to disable custom field overall

To keep a Custom Field from displaying in the LeanLaw Custom Fields, it must be disabled in QuickBooks Online. In LeanLaw, only Custom Fields with the checkbox checked will be active in reports.

If a Custom Field needs to be edited in LeanLaw, you can clear out the Value Field and re-create the LeanLaw Custom Field. If you clear a Value Field that is a Dropdown, you will need to also re-map after selecting a new Value Field. Troubleshooting Custom Fields Issues

Missing Matter Numbers on Invoices

If matter numbers are not appearing on your invoices despite being mapped correctly, the issue could be due to a mismatch in field data types between QuickBooks and LeanLaw.

Steps to Resolve:

  1. Create a New Custom Field in QuickBooks:

    • Go to QuickBooks and create a new custom field with the data type set to Text.

  2. Map the New Field in LeanLaw:

    • Go to Custom Field Mapping in LeanLaw.

    • Map the new custom field in QuickBooks to the "Matter Number" field in LeanLaw.

  3. Update Your Invoice Template in LeanLaw:

    • Navigate to Settings > Invoice Email in LeanLaw and open your invoice template.

    • Click 'Configure' and select KL Matter #.

    • Go to Custom Field Settings and choose Matter ID as the LeanLaw value for the KL Matter # field.

    • Click 'Save'.

  4. Sync and Test the Changes:

    • Bring one invoice back to draft status and send it to QuickBooks to sync the changes. The matter number should now appear properly on the invoice.

Locating Missing Matters or Invoices

If you cannot find a matter or its invoices in LeanLaw but they are visible in QuickBooks, the issue may be due to the matter being archived.

How to Check and Resolve:

  • Archived matters in LeanLaw are hidden by default, which also hides their associated invoices.

  • To view or manage archived matters:

    1. Navigate to the section listing archived matters in LeanLaw.

    2. Ensure the filters for active/archived matters are set appropriately.

    3. Unarchive the relevant matter as necessary to restore its visibility.


What's Next?

Go ahead and learn How to Use Custom Fields in QuickBooks Online Reports. Additionally, explore how to troubleshoot Missing Matter Numbers on Invoices and Locating Missing Matters or Invoices in LeanLaw for a more complete understanding.

Did this answer your question?