Watch the videos: Lookups Grid Reports How to email invoices
Hover the mouse over the different menu options. If the cursor changes to a hand (
), then click to go to the subject.

![]()
Invoice Lookup
Go to Invoice > Invoice Lookup
Overview
The Invoice Lookup form provides a complete list of invoices processed in Smart-IT (SI).
This screen allows users to:
•Search and filter invoices
•Print invoices
•Send invoices by email
•Export invoice data
•Monitor unpaid invoices
•Analyze sales activity
•Track discounts and payment status
The Invoice Lookup form is one of the primary tools used for:
•Accounts receivable management
•Customer follow-up
•Sales analysis
•Bulk print multiple invoices at once.
Note:
By default, only the latest 1,000 invoices are displayed. To view more, adjust the Records Per Page setting at the bottom of the form.
Hover the mouse over the different fields on the form. If the cursor changes to a hand (
) , click to get more information.

Menu Bar On The Invoice Lookup Form |
|
|
Print the invoice lookup form. Before printing you can remove columns and rearrange it to suit your needs. See Lookup |
Print Analysis |
Analysis – Summary of Data Tab Useful for: •Sales summaries •Invoice analysis •Performance reporting
|
Export to XLSX |
Export the Invoice Lookup data to Excel.
|
Recalculate Paid |
|
Print Filter |
Displays a list of invoices that cannot be emailed, possibly due to the absence of an email address.
|
Email Filter |
Shows a list of invoices that can be emailed. Check the "Emailable" column for details.
|
Bulk Actions in Invoice Lookup.The Invoice Lookup screen allows you to perform bulk actions on selected invoices quickly and efficiently. Select Invoices for Bulk Actions: Use the checkbox graphic on the left-hand side of the screen to select individual invoices. You can also apply filters to narrow down results, then click Select All to bulk-select the filtered list. With selected: |
Prints all selected invoices.
|
Email DirectSends multiple invoices to multiple customers simultaneously using the Email Direct option.
•Each invoice is sent individually, using your configured email server. •The default email message is defined under: Invoice > Invoice Options > Email tab. •The following substitutions are available:: Company Name , Document number & Customer Name. •❌ No additional Attachments can be made. •✅ Setup required under: Company > Application Options > Email.
|
Email ComposeSends multiple invoices to multiple customers with advanced customization. •Each invoice is sent individually, using your configured email server. •Customize the message using saved templates on the Compose Email screen. •Up to 16 substitutions available, including: •Tracking Number, Sales Order No., Invoice Number, Invoice Date •And More ... •✅ Add attachments as needed. •✅ Import and send a pre-designed HTML email. •✅ Attach the invoice using the substitution {invoice_attachment} (see the image:Email Compose). •✅ Setup required under: Company > Application Options > Email.
|
Attach to EmailSends multiple invoices to a single customer as attachments. Behavior depends on your settings in Company > Application Options > Email:
Option 1: ✅ Use Outlook if Available → Opens Outlook with all selected documents attached. → Emails are saved in your Sent Items folder.
Option 2: ✅ Use “SI send email instead of default email program” → Emails are sent via your SMTP server. → ❌ Not saved in your Sent folder.
•Enable the “Sent – Save Copy in Sent Folder” checkbox. •Make sure your Mailbox is set up via the Mailbox Setup button.
Important Note: Only select invoices that belong to one customer for this action.
•The email is stored in the Sent Log. •View or delete sent emails at: Company > SI Emails > Sent Emails.
|
Export SIEExport selected invoices in SIE format to your hard drive. These can be imported directly into another SI+ system via Goods Receive Notes.
|
Export PDF'sSaves each selected invoice as a separate PDF file to your hard drive. |
|
Invoice Lookup ColumnsMost columns in the Invoice Lookup screen are self-explanatory. The following columns provide additional functionality and are commonly used for filtering, and reporting.
|
|
Discount Amount and % |
Discount Amount and %Displays: •Discount Amount •Discount Percentage applied to the invoice.
Common Uses•Monitor discounting activity •Analyze salesperson discounts •Audit pricing adjustments |
Edit Date |
Edit DateDisplays the: System Date and System Time when the invoice was created or edited. Common Uses•Audit invoice activity •Track processing times •Verify transaction history |
Emailable |
EmailableIndicates whether the invoice can be emailed from the Invoice Lookup screen. Requirements for a Checkmark
A checkmark appears when:1. The customer has a valid email address, and 2. The Invoice option is enabled under: Customer > Contacts & Address Tab Common Uses•Filter invoices ready for emailing •Identify customers missing email setup •Bulk email invoice processing |
Image |
ImageAllows images or supporting documents to be linked to the invoice. How to Add an ImageDouble-click the Add Button in the Image column. Common Uses•Attach signed documents •Store proof of delivery •Save supporting paperwork •Link customer documentation |
Invoice Payment Balance |
Invoice Payment BalanceDisplays the outstanding invoice balance per invoice.
Common Uses•View unpaid invoices •View partially paid invoices •View overdue invoices
|
Job Card Number |
Displays the related Job Card Number if the invoice originated from a Job Card. Common Uses•Trace workshop invoices •Open linked job card records •Analyze workshop billing |
Payments Due |
Payments DueInvoices with overdue payments are displayed in Red.
The payment due date is configured on: Invoice > Payment Tab Common Uses•Identify overdue invoices •Follow up on unpaid customers •Monitor credit control |
Quote Number |
Quote NumberDisplays the related Quote Number if the invoice originated from a quotation. Common Uses•Track quote-to-invoice conversions •Analyze quote success rates •Open linked quotations |
Recurring Invoice |
Recurring InvoiceDisplays the Recurring Invoice Number if the invoice was generated from a recurring invoice setup. Double-click the recurring invoice number to open the linked recurring invoice setup. Common Uses•Identify automatically generated invoices •Track recurring billing customers •Open recurring invoice templates
|
Sales Order Number |
Sales Order NumberDisplays the related Sales Order Number if the invoice originated from a Sales Order. Common Uses•Trace order processing history •Verify sales workflow •Link invoices to sales orders |
Send Email Date |
Send Email DateDisplays the date the invoice was emailed from the:Invoice Lookup Form Common Uses•Verify invoice delivery •Track customer communication •Identify invoices not yet emailed • |
Type (Cash vs On Account) |
Type (Cash vs On Account)Indicates whether the invoice was processed as: •Cash Sale or •On Account Common Uses•Separate cash and account sales •Analyze customer credit activity •Financial reporting |
Payment Due Date Options in SI+.
Smart-IT provides multiple methods for calculating invoice due dates.
✪ Option 1: Based on Payment Terms
•Default Method.
•The due date = Invoice Date + Payment Terms (e.g., 30 days).
✪ Option 2: Statement Date Method (Recommended):
•Go to Invoice > Invoice Options and select the General Tab.
•Enable "Calculate Due Date From Statement Date (End of Month)".
•Calculation Example:
1.Get End of the Invoice Month
Invoice Date: 5 May --- End of month = 31 May
2.Add 1 day = 1 June
3.Add payment terms (e.g., 14 days).
4.Resulting due date = 15 June.
✪ Option 3: Fixed Day of the Month
Set an automatic invoice due date "same calender date every month"
•Go to: Customer Form > Credit Control tab.
•Enter a value in the Salary Payday field (e.g., 7).
•The due date will be set to the 7th of each month.
✪ Option 4: Manual Override
•While creating the invoice:
•Go to the Customer / More tab.
•Manually edit the Due Date.
Viewing Due Invoices
•The Invoice Lookup form displays all due invoices.
•The Age Analysis report includes a “Due” column, showing a summary of total outstanding amounts per customer.
This makes it easy to track unpaid invoices and follow up with customers efficiently.
Invoice Lookup Tab – Available Reports
These reports help analyze sales, monitor staff performance, and track financial health:
✪ Performance & Sales Reports
1. Invoices Below a Certain Amount
•Set a threshold (e.g., R20), filter by date and rep.
•Use: Identify sales needing upselling.
•Analysis Tab > Sales per Salesperson
2. Invoices with High Discount %
•Filter all invoices where discount > 10%.
3. Sum of Today's Invoices
•Total value of today’s invoices.
4.Today's Invoices
•View only today’s processed invoices.
5. This Week’s Invoices
•Filter: Date column > Is This Week / Is Yesterday
✪ Payment Status Reports
6. Credit Notes Only
•Show only invoices marked as credit notes.
7. Unpaid Invoices
•Use the Due Date column to filter unpaid entries.
8. Invoices Not Emailed This Month
•Identify invoices pending email dispatch.
9. Invoices That Can’t Be Mailed
•Filter to show email-restricted invoices.
10. Credit Notes by Salesperson
•Group and analyze credit notes per rep.
11. Invoices From Quotes/Job Cards
•Show origin-based invoice filtering.
12. Unpaid Invoices Not Signed
•Filter: Paid column = No, Signed column = No
✅ Use Case: Helps management enforce sales discipline, monitor customer follow-up, and ensure proper documentation.
Scriv Bot Routing Rules: Intent Mapping
User Intent / Question |
Route To |
View unpaid invoices |
|
