Many Suppliers
...
can provide you with copies of your Invoices in CSV or PDF format. You can configure Ascora to accept CSV or PDF Invoices and have these invoices automatically process against a Purchase Order, then update the Job Card (as required) and push the Supplier Invoice details across to your accounting package.
Note:
...
To make automatic import work, a supplier invoice must be part of the
...
supported formats but if you need an extra format added for one of your suppliers, you can purchase one by accessing the Ascora Shop. See Supplier Invoice Format Supported for a complete list of readily supported formats.
...
Establish Automatic Supplier Invoice Importing
You can configure Ascora to automatically identify, import and process Supplier Invoices that are sent to you via email from your Suppliers.
...
Connecting your Email Account - Office 365
1. Go to Administration → System Settings. 
2. Under the Automatic Import Email Settings area, tick , do steps A, B, and C with some references below.
A. Tick the Supplier Invoice Importing checkbox, then configure the required email settings. When you are ready, click the Connect button.
3. Click the Save button once your Automatic Import Email Settings are configured.
| Warning | ||
|---|---|---|
| ||
If you are using Gmail, you will also need to enable less secure apps by going to your Gmail and click a link from there. Alternatively you can use the following link to enable less secure apps. |
Configure the Supplier Record
B. Click Connect to Office 365 and sign in using the popup.
C. Click the Connect button when you're ready to proceed.
If you are using "Use Own Email Server" with Gmail, please read the dedicated article for Gmail here.
3. Connection between your Ascora account and your email account will be established and you'll see the following pop up box indicating it's testing your email settings.
4. Another pop up box appears confirming that connection is successful.
| Warning |
|---|
NOTE: Automatic Importing should be assigned to a dedicated inbox as all emails will be marked as deleted once they have been processed by the importer. If you need a copy of each supplier invoice, you can configure your email account to automatically forward copies to a different mailbox. Alternatively you can configure your email to keep the deleted emails in the DELETED folder after a certain period. |
Configuring the Supplier Record
After successfully connecting your email account for supplier invoice automatic import, you will need to configure your supplier record to ensure that emails will be imported correctly.
1. Choose the Inventory Icon on the Top Menu and select the Suppliers option.
...
2. Locate the applicable Supplier in the list then click the View button.
...
to display the details. In this example we select Reece which is one of the supported formats.
3. The Supplier’s Details Screen will display. Scroll down to the Supplier Invoice Format option and select the applicable format from the list.
| Warning |
|---|
Note: If the Supplier Format you're after is not shown in the list, we can create this format for you by creating a special processor that understands the format the invoice has been sent in - where to read elements like the Supplier Invoice Number, Order Reference, Invoice Date and the various lines on the Invoice. The Processor can read invoices in both CSV or PDF format (providing the PDF is not generated as an unreadable image). Due to the length of time it can take to create, test and deploy the Supplier Invoice processor we charge $350 EX GST per Supplier Format. You can purchase one by accessing the Ascora Shop. |
4. Under the Automatic Supplier Invoice Importing section on in the Supplier screen, tick the checkbox to beside Enable the automatic import from Ascora inbox. The inbox you configured in Step 2 will be displayed in brackets and the Email Sender textbox will appear. Enter the email address used by the Supplier to send your Invoices in the Email Sender textbox.
Ascora is now configured to automatically import and process Supplier Invoices for the particular Supplier. Repeat these steps for any other Suppliers for which you wish to enable Automatic Supplier Invoice Importing.
Supplier Invoice Format Supported
5. The following list refers to suppliers with invoice formats that are supported by Ascora either via manual import or automatic import. When you try to import a supplier invoice, you should be able to select any of the suppliers included in the list below.
...
Template Name
...
Read Csv Formats
...
Read PDf Formats*
...
Reece
...
Yes
...
Yes
...
Middy Data & Electrical
...
No
...
Yes
...
Tradezone
...
Yes
...
Only Invoices
...
Samios Plumbing Supplies
...
Yes
...
Only Invoices
...
K & R Plumbing Supplies
...
No
...
Only Invoices
...
Saveur Pacific Pty Ltd
...
No
...
Only Invoices
...
Airefrig Australia Pty Ltd
...
No
...
Yes
...
Bitzer Australia Pty Ltd
...
No
...
Only Invoices
...
Tradelink Pty Limited
...
No
...
Yes
...
Harris Trade Plumbing Supplies
...
Yes
...
Only Invoices
...
Burdens Plumbing Victoria Pty Ltd
...
No
...
Only Invoices
...
Centre Plumbing Plus
...
No
...
Yes
...
CNW Electrical Wholesale
...
No
...
Only Invoices
...
Bunnings Warehouse
...
No
...
Yes
...
D & J Hull Plumbing
...
No
...
Only Invoices
...
Aquaclear
...
No
...
Only Invoices
...
Fujitsu
...
No
...
Yes
...
Daikin Air Conditioning Ltd
...
No
...
Yes
...
Mitsubishi Electric Australia Pty Ltd
...
No
...
Only Invoices
...
The Good Guys Discount Warehouses Australia
...
No
...
Only Invoices
...
Beijer Ref Australia Pty Ltd
...
No
...
Only Invoices
...
Kirby HVAC&R Pty Ltd
...
No
...
Only Invoices
...
Total Tools
...
No
...
Only Invoices
...
Ideal Electrical Suppliers
...
No
...
Only Invoices
...
MM Electrical Merchandising
...
No
...
Yes
...
Actrol
...
Yes
...
No
...
Ezzybills
...
Yes
...
No
...
Galvins Plumbing Supplies
...
Yes
...
No
...
Haymans
...
Yes
...
No
...
Lawrence and Hanson
...
Yes
...
Yes
...
P & R Electrical Wholesalers Pty Ltd
...
Yes
...
No
...
Plumbers Supplies Co-Op
...
Yes
...
No
...
Voltex [NZ]
...
Yes
...
Only Invoices
...
Rexel Electrical Supplies
...
No
...
Only Invoices
...
City Electric Supply
...
Yes
...
No
...
AWM Electrical
...
No
...
Yes
...
Boral Construction Materials Group Limited
...
No
...
Only Invoices
...
Uniquip Electrical Supplies
...
No
...
Only Invoices
...
Pickard Building Supplies
...
No
...
Only Invoices
...
Lighting Options Design & Supply
...
No
...
Yes
...
Resene Paints Ltd
...
No
...
Only Invoices
...
Dulux
...
No
...
Only Invoices
...
NHP Electrical Engineering Products Pty Ltd
...
No
...
Only Invoices
...
NAW Controls Pty Ltd
...
No
...
Only Invoices
...
BJS Roofing Supplies
...
No
...
Only Invoices
...
Bayline Roofing
...
No
...
Only Invoices
...
J. A. Russell Ltd [NZ]
...
Yes
...
Yes
...
Bunnings [NZ]
...
No
...
Yes
...
Argent Cables [NZ]
...
No
...
Yes
...
Computer Dynamics [NZ]
...
No
...
Yes
...
Lentune Group [NZ]
...
Yes
...
Yes
...
Smoooth Air Products Ltd [NZ]
...
No
...
Yes
...
Mitre 10 [NZ]
...
No
...
Yes
...
Ideal Electrical Suppliers [NZ]
...
No
...
Only Invoices
...
Eagles Bathroom Kitchen Plumbing
...
No
...
Yes
...
Crisp N Co Pty Ltd
...
No
...
Yes
...
Fielders
...
No
...
Only Invoices
...
Westflex Pty Ltd
...
No
...
Only Invoices
...
Web Industrial
...
No
...
Only Invoices
...
Voltex
...
Yes
...
Only Invoices
...
AHI Carrier
...
No
...
Yes
...
AirOWorld
...
No
...
Only Invoices
...
Anzor
...
No
...
Yes
...
Black Diamond Technologies
...
No
...
Yes
...
Corys Electrical
...
No
...
Yes
...
Able Solar Ltd
...
No
...
Only Invoices
...
Agile Networks Ltd
...
No
...
Only Invoices
...
All Fast Solutions
...
No
...
Yes
...
Asmuss
...
No
...
Only Invoices
...
CableWays Ltd
...
No
...
Only Invoices
...
Express Sheetmetals
...
No
...
Yes
...
Fantech Ltd
...
No
...
Yes
...
Franklin Smith
...
No
...
Only Invoices
...
Gas Works And PlumbingLtd
...
No
...
Only Invoices
...
Cherry Picker Services
...
No
...
Only Invoices
...
Complete Coms Ltd
...
No
...
Only Invoices
...
Connectplay Ltd
...
No
...
Only Invoices
...
Enatel Ltd
...
No
...
Only Invoices
...
Go Wireless Ltd[NZ]
...
No
...
Yes
...
Infab Ltd
...
No
...
Only Invoices
...
Konnect Fastening Systems
...
No
...
Yes
...
Mico Ltd [NZ]
...
No
...
Only Invoices
...
Hirepool Ltd
...
No
...
Only Invoices
...
Ingram Micro Limited [NZ]
...
No
...
Only Invoices
...
Jaycar Pty Ltd
...
No
...
Only Invoices
...
Kea Trailers Ltd [NZ]
...
No
...
Only Invoices
...
Simx Ltd
...
No
...
Yes
...
Laser Electrical Putaruru
...
No
...
Only Invoices
...
MH Power Specific Ltd
...
No
...
Yes
...
McGowan Services Ltd
...
No
...
Only Invoices
...
PB Technologies Ltd
...
No
...
Only Invoices
...
Placemakers
...
No
...
Only Invoices
...
Riequip Ltd
...
No
...
Only Invoices
...
Rotational Plastics
...
No
...
Only Invoices
...
Stainless Design Group
...
No
...
Yes
...
Tait Controls Ltd
...
No
...
Only Invoices
...
Teletronics Ltd
...
No
...
Only Invoices
...
Honda Hamilton Ltd
...
No
...
Only Invoices
...
Polytec
...
No
...
Only Invoices
...
FGW Corporation Pty Ltd
...
No
...
Only Invoices
...
Think Water Alice Springs
...
No
...
Only Invoices
...
Steely Sales
...
No
...
Only Invoices
...
APJ Concrete
...
No
...
Only Invoices
...
Rockcote Resene Ltd
...
No
...
Yes
...
Trade Direct
...
No
...
Only Invoices
...
Specialized Construction Products Ltd
...
No
...
Only Invoices
...
As a summary, the requirements for setting up automatic import for supplier invoices are:
- Supplier must have a supported format available.
- You account is successfully connected to a dedicated mailbox that receives supplier invoices type of emails.
- You have configured the necessary settings in the supplier details screen.
Congratulations! You have now successfully configured automatic import for your supplier invoices which helps save a huge amount of time compared to manually creating/importing your supplier invoices.
Updated by Raymond McConville 25/09/24