Keyword Rule Automation

Keyword Rule Automation

Keyword Rules Automation allows you to set custom rules up at a supplier level to determine how bills are coded (GL, Categories...) and even route bills to certain approvers based on a keyword. This keyword can be anything, an account number, an address, a PO reference or any unique string of characters.

As an example, picture a restaurant group of 3 locations running all their bills through 1 Lightyear account, ordering beverage stock through one supplier. The addresses of the restaurants are as follows:
  1. 32 Salt Street
  2. 15 Tomato Terrace
  3. 3 Apple Avenue
Keyword rules automation will allow them to have their bills automatically coded with unique GL Codes, Tracking Categories and/or assigned to a specific approver by simply adding the above addresses as the keywords, looking like this:



The above configuration overrides the defaults setup at supplier level based on the address that Lightyear detects and automatically generates an Approval Task to the relevant Manager within 1 second of the bill hitting the mail server. Simple.

Setting up Keyword Rules Automation

Before you can start setting your rules, you need to enable Keyword Rules Automation in Company Settings


Once on, head into edit any Supplier, and you'll see the new Keyword Rules automation table at the bottom of the "Profile" tab. This is where you can start setting your rules.



The set up is simple. Under "Doc Keyword(s)", enter a string of text found on bills from that supplier that's unique to that site. This would typically be an address or a post code, but you can enter anything that's unique to that specific location. The system will try to find anything that is close to matching the Keyword(s) , ignoring punctuation, capital letters and spacing, but an exact match would be preferred.

Once that's done, set the GL,  Tracking Category or Approver you'd like to see automatically populated for that unique identifier. 

Note - you do not have to set all the drop downs.  You can choose to just automate the Approver for example, and leave the other options blank.  in this scenario, the default Supplier level bookkeeping rules will activated if the Keyword drop down is blank.

WARNING - If you want your Line by Line Rules to apply at product level , then do not set Keyword automation for that supplier.  The Keyword rule will over-ride your product level automation rules settings. 



Please note, that under the "PROJECTS" Header, you can update and customs each to the relevant project name. Here, for tutorial purposes, we have used numbers. 

That's all there is to it! Once a bill from that supplier is mapped and sent to your approvals tab, we'll scan the document for the keyword and automatically apply your chosen GL and Tracking Category defaults to each line on the bill. This will override any defaults set at the supplier level, and in the Product List.


      

    Check out release notes for Q3 2021

     June  July  August 


      • Related Articles

      • Step 5: Customise your settings

        After you've connected to your Accounting Software, you'll need to visit Company Settings and customise your Lightyear account. Simply select Settings > Company Settings from the options on the left of your Lightyear user interface. The options that ...
      • Step 1: Connect your accounting software

        Lightyear is an award winning automation application, but ultimately you will want to get your payables data into your accounting software.  In order to sync with your accounting software's suppliers, tax rates etc, and send your purchase data to ...
      • Step 3: Send a document into Lightyear

        Here, we'll take you through how to get your first bills into Lightyear and then what to do with them. Use the table of contents above to skip ahead to the section you need. Alternatively, you can watch this video: Get your first bill in from ...
      • START: Registering your first company

        Signing up for Lightyear Congratulations and thank you for deciding to check out Lightyear! Getting started with a new software can be daunting, so we've composed this guide to help you find your feet. This article will walk you through giving us the ...
      • Processing Tab

        Processing, this is where it all begins, and where users teach Lightyear the 'mapping rules' you want the system to follow forevermore. Watch this help video on the Processing Tab The first time a PDF arrives in your Lightyear account, it will be ...