Approval Line Item Comments Export
During the approval process for requisitions, packing lists, and invoices, approvers have the ability to enter in line item based comments. However a number of clients have expressed the need to be able to export these comments out of Certify AP and into their ERP systems or AP packages.
We have now added each comment type as a new Data Column to the Custom Export Builder as:
- Requisition Line Item Comments
- Packing List Line Item Comments
- Invoice Line Item Comments
- Accounting Review Line Item Comments
These new columns may be added to your saved invoice export templates and then any comments the approvers make on any lines exported will display.
The format line item comments are exported in follows this pattern:
Date MM/DD/YYYY - Approver Name (Approval Type - Transaction Type): Comment Text
If there are multiple approvers on a transaction and they each make line items comments we will concatenate them together in the column when exported and delimited by a dash (-).
Exported Examples:
Requisition Line Item Comments
Packing List Line Item Comments
Invoice Line Item Comments - Multiple Approvers
Accounting Review Line Item Comments
Automated Invoice Assignment (AIA)
Most our clients make use of our Invoice Capture service to have their invoices scanned and run through OCR for them and then we create their invoices for them in the application. Previously there were two options Administrators could set in Company Preferences to have these invoices created in the application.
- Single User - assign all invoices created from the capture service to the same user
- Unassigned Invoice Queue - create all invoices from the capture service in a common queue that all users can pull from
Many clients would like to assign invoices from the capture service though to different users based on various characteristics of the invoice. Thus Automated Invoice Assignment has been created.
AIA allows Administrators to create rule templates with criteria that will trigger when the criteria are met and assign to a specific user associated with the rule template.
Please note that if AIA is in use and a rule is not found that can be evaluated for an incoming invoice we will then default to the base Invoice Capture settings above and assign that invoice to either the Single User option if chosen or the Unassigned Queue option.
Administrators have access to the new Manage Invoice Assignments page in the Configuration module.
Once the page has been accessed Administrators have the ability to:
- Create new rule templates
- Edit existing rule templates
- Rearrange the order of existing templates
- Disable/Enable existing templates
- Delete existing templates
Creating New Rules
To create a new rule template begins with clicking the New Rule Template button as seen in the image above. This will open the new rule page.
- Provide a name for the new rule
- Set the rule as Active or Disabled, this can be changed later without editing if necc.
- Click the New Rule Criteria button to add parameterization for the rule
- For multiple rule criterion you may click the New Rule Criteria button more than once and multiple criteria are applied as sequential OR statements
Now you may start to add the criteria which the rule will use to evaluate incoming invoices.
The criteria begin with choosing which column or element in the incoming invoice data you want to evaluate against. The list of columns available is:
Column |
Description |
Bill To Address 1 |
Bill to address of the client extracted from the address the invoice is sent to. |
Bill To Address 2 |
Bill to address of the client extracted from the address the invoice is sent to. |
Bill To City |
Bill to city of the client extracted from the address the invoice is sent to. |
Bill To Contact |
Contact person extracted from the invoice if addressed to a person. |
Bill To Country |
Bill to country of the client extracted from the address the invoice is sent to. |
BIll To Email |
Email address extracted from the invoice if present. |
Bill To Fax |
Bill to fax of the client extracted from the address the invoice is sent to. |
Bill To Name |
Typically the root department / client name, but can be a department address for companies that use Bill to Department functionality. |
Bill To Phone |
Bill to phone of the client extracted from the address the invoice is sent to. |
Bill To State |
Bill to state of the client extracted from the address the invoice is sent to. |
Bill To Zip |
Bill to zip of the client extracted from the address the invoice is sent to. |
Currency Type |
The currency that the invoice is submitted in. |
FooterType |
Value used to tell us if a line is an invoice line item detail or an invoice footer line item detail. There are four footer types TAXES, MISC, HANDLING, FREIGHT. |
Invoice Amount |
The invoice total amount. |
Invoice Date |
The invoice date. |
Invoice Number |
The invoice number. |
Model Number |
The product Model Number |
PO Number |
The PO number from the invoice if present. |
Product Category |
The category that a product is assigned to in the product catalog. |
Product Description |
The product description. |
Quantity |
The quantity of the invoice line item. |
SKU |
The product SKU number. |
Vendor Address 1 |
Vendor address |
Vendor Address 2 |
Vendor address |
Vendor City |
Vendor city |
Vendor Contact |
Vendor contact person |
Vendor Country |
Vendor country |
Vendor Email |
Vendor email |
Vendor Fax |
Vendor fax |
Vendor Name |
Vendor name |
Vendor Phone |
Vendor phone |
Vendor State |
Vendor state |
Vendor Zip |
Vendor zip |
Once the criteria column is chosen then you will move on to choosing a comparator. Depending on the column chosen comparators will change in order to appropriately evaluate the data in the column.
The available comparators are:
Comparator |
Description |
= |
Equals - evaluates the received value and looks for an exact match |
≠ |
Does not equal - evaluates the received value and looks for anything not an exact match |
< |
Less than - evaluates the received value for a number and looks for lesser values |
≤ |
Less than or equal to - evaluates the received value for a number and looks for lesser or equal values |
> |
Greater than - evaluates the received value for a number and looks for greater values |
≥ |
Greater than or equal to - evaluates the received value for a number and looks for greater or equal values |
Starts with... |
Evaluates the received value and looks at the beginning of the expression and an exact match |
Ends with... |
Evaluates the received value and looks at the ending of the expression and an exact match |
Contains |
Evaluates the received value and looks at the entire expression and an exact match contained anywhere in it |
After choosing the comparator you are now ready to enter in the value that will be used to evaluate the criteria. This is a free text field and allows you to enter any ASCII value. Such as numbers, letters and symbols.
For example if I wanted to write a criteria for a rule where all my invoices for a certain vendor, say Unique Office Supplies, are assigned to a user I would complete my criteria like this:
This would evaluate to any time we receive an invoice with a vendor name that exactly matches Unique Office Supplies would register as true and the assignment rule would be applied.
However what if my vendor doesn’t use their entire vendor name on their invoices or has subsidiaries with slight variant names such as Unique Office Express and Unique Office Tech. Then I might want to use a criteria more like this:
This would evaluate to any time we receive an invoice with a vendor name that matches this text anywhere in the entire string would register as true and the assignment rule would be applied.
The last step is to choose the user which the invoices should be assigned to when the rule evaluates to true. This can be done with the User drop down at the bottom of the page. All users that have been assigned the Enter Invoice permission will be available in this list.
Once you have selected the user simply click the Save button and the rule is ready to be used.
Invoice Assignment
When invoices come in and are evaluated against AIA rules as true they are assigned to the user from the rule. That user will be notified via email that a new invoice has been assigned to them and when they log into Certify AP they will find a new queue has been created to collect and display their auto-assigned invoices.
Bug Fix Notes
Issue |
Description |
CAP-3995 | Reports: Unable to generate Spending Reports with type - By Product CategoryDate |
An issue was found with the Spending Report affecting the Product Category option and preventing it from being run. This was corrected. |
CAP-3978 | POI:/Purchasing/POImport.aspx: Unable to create or edit template. Clicking New Template button or Edit button displays PO Import Preview view |
An issue was found with our PO Import functionality where new templates could not be created. This was corrected. |
CAP-3923 | EE: Unable to approve/disapprove invoice and accounting review |
An issue was found where certain invoices where unable to be approved/disapproved in the accounting review stage. This has been corrected. |
CAP-3886 | EE Approval Email: Invoice: Line items: Vendor and QTY are missing in the Line items |
This was an outstanding issue with our recent Enhanced Email Approvals feature where these columns were blank. We removed the Vendor column as that data was already available in the email header and the quantity has been fixed to display properly. |