See Digital Invoice Import Process Setup for instructions in activating Xtracta.
Opening the Digital Import / Process
Select Suppliers / Digital Invoice Import/Process
The following screen will appear
Buttons on the sidebar:
- Import Invoices – Imports invoices from Xtracta and checks for rejects.
- Refresh Item – refreshes the Infusion data on the highlighted invoice.
- Re Import Item – reimports the original highlighted invoice back down from Xtracta. This will overwrite any amendments you have made.
- Delete – deletes an imported invoice. If you delete this invoice it cannot be downloaded again from Xtracta. The invoice can be emailed or uploaded to Xtracta again if required.
- Xtracta - Open Item – Opens a downloaded invoice for re-editing in Xtracta. After making any alterations, the invoice can be re-downloaded into Infusion using either “Re Import Item” or “Import Invoices” and selecting “All”.
- Xtracta – Exceptions – Opens the Xtracta site showing any invoices that have been rejected for failing import criteria. These will need to be opened individually and fixed before they will import into Infusion.
- Xtracta – Errors – Xtracta converts invoices to readable data, if there is a problem with the conversion process it will show the documents here. These invoices would need to be manually entered in Infusion or resent again.
- Convert to Credit Note – some suppliers sent through credit notes with positive amounts. This will change the invoice data to negative quantities that Infusion requires.
- Upload Invoices to Xtracta – will take you to the Xtracta site to manually upload invoices.
- Upload Updated Suppliers – when you register Xtracta in the default settings, some supplier information is uploaded. If you update supplier data in Infusion this button should be pressed to update information on Xtracta as well.
Uploading Invoices to Xtracta
Option 1 – Suppliers email invoices directly to the email address created in defaults.
Option 2 – Forward email from suppliers to the email address created in defaults.
Option 3 – Drag and drop or select saved PDFs onto the Xtracta website.
- Save PDFs to a file location.
- In the Suppliers/Digital Invoice Import screen, click on Upload Invoices to Xtracta.
- You can select all the PDFs and drag & drop them onto the cloud or you can click select files and browse for them.
As each file is successfully uploaded to Xtracta the status will have a green tick.
Exit the screen and return to Infusion.
Importing Invoices from Xtracta
Click on the Import Invoices button.
You will get a prompt box asking if you want to import All or New.
After importing invoices there are a few messages you can receive:
- “No Active Documents were found” – nothing was found to download
- “# - Are still being processed” – invoices have been uploaded to Xtracta but are still in the conversion process.
If there were invoices available for download they have now been imported into Infusion and the “Xtracta – Exceptions” button will turn red and show the quantity of invoices that were rejected or had errors.
Exceptions on Invoices
When initially importing invoices from each supplier, it is more than likely you will need to train Xtracta. Invoices will show up as rejected when they are missing required information. Email/Upload 3 invoices per supplier, train Xtracta and then wait a couple of hours before sending any more. After 3 invoices, Xtracta should be trained and all invoices should import.
Click the Xtracta – Exceptions button.
It will take you to the Xtracta website, listing all of the invoices that have been rejected.
Select FIX for each invoice
A copy of the PDF will open in the left hand panel. You can double click on it to make it larger. In the right hand panel (titled Data Extraction) is the data that has been converted. Some fields will be red, these are the ones requiring more information. On the invoice you will see areas that are highlighted in green. Matching data for this has already been filled in the Data Extraction section. Make sure to check that the correct information has been picked up. In the below example the Order Number incorrectly has picked up the Rep heading (highlighted in green).
To fix any incorrect mappings click in the Validation failed box then highlight the matching data on the invoice. The area you highlight will auto fill the Data Extraction screen.
Sometimes the supplier will have a logo rather than a typed company name, it is preferable to locate the typed name rather than the logo, as these can change more frequently. With either the GST/ABN numbers or supplier account, it will remember this after 3 times and be auto filled after that.
Scroll down the Data Extraction panel and you will see the line items, totals and save/cancel buttons.
Tip – Some suppliers’ invoices do not total correctly due to rounding or they may have GST inclusive line totals. If you click “Ignore maths check soft validation”, you can then save the invoice and push it through to Infusion anyway
Entering Transactions in the Digital Import Process
Highlight an imported invoice and the details will show in the bottom half of the screen.
TOP SECTION – Selecting an Invoice for Processing
We can right click on the highlighted invoice and view or email the original PDF document. A copy of the PDF is stored in the Infusion/Data/Documents/Suppliers/Digital folder (once invoices have been posted these can be reprinted from a right click in the main Purchase Order screen or a Supplier Enquiry in the invoices tab).
The supplier account, supplier enquiry and purchase order (if there is one linked to the invoice) can also be opened from the right click.
MIDDLE SECTION – Invoice Header
- Our Order # – If the downloaded invoice has an order number this box will be filled. You can also manually select outstanding purchase orders in Infusion.
- If it matches against an existing purchase order in Infusion these will be linked together and the products ordered/supplied are compared.
- If there is no purchase order in Infusion a checkbox appears in the bottom section where you can select “Our Order # not found, Use Order # from Imported Invoice as Our Order #?” If it is left unticked the next default next purchase order number from Infusion will be used.
- Supplier – For this to be filled automatically; there needs to be a link with either the GST/ABN number and/or the supplier account reference.
If the supplier is unknown:
- Select an existing supplier or create a new one from the Supplier dropdown.
- View the original PDF and take note of the GST/ABN number and account reference, then open the supplier and enter them under the terms tab.
- Click the “Upload Updated Suppliers” button
- Any future invoices received from that supplier should now be trained.
- Document Id – a number created by Xtracta for tracking purposes.
BOTTOM SECTION – Invoice Lines
- Lines 1 & 2 – show products that already exist in Infusion. These could be matched with the exact product code or to a product where the supplier code matches the invoice supplier.
- Lines 3 & 4 – these codes did not match to any existing product. This supplier has a pricebook associated with it and the codes matched. New products will be created from the pricebook when processing the invoice.
- All other lines – are new products that Infusion cannot match to an existing product or a pricebook. There are a few different processing options when in the “Code” field.
- F8 – opens the GL ID lookup to code directly to a financial general ledger code. A product will not be created. Tip – once you select the GL code you can right click again and auto fill the remaining lines with the same GL code.
- F9 – opens the product lookup, this will attach that suppliers code to an existing product in Infusion. This is useful when you can buy the same part off multiple suppliers and this invoice is not from the preferred supplier.
- Right Click
- Advertising (this example only) – if you have ever done a “Supplier Invoice No Products” for the supplier, Infusion remembers the GL code and it will show as the first option on right click. If you are processing an imported GL Invoice (not a product purchase order) and this code is known, you don’t have to select anything, the invoice will automatically code to “Advertising”.
- Freight Inwards – in Admin/Defaults/Financial Defaults an Inwards Freight code is set, this is what is used here.
- Purchases – in Admin/Defaults/Financial Defaults a Purchase code is set, this is what is used here.
- Create Product – Will create a new product with information from the imported invoice and open it for editing.
When you have highlighted a line item, more information shows in the bottom left hand corner. This will show information about the order, product code and serial numbers listed.
Processing the Invoice
Refer to the Set up Infusion Defaults section with regards to the “When Processing”.
When the invoice is balanced, click GL Invoice or PO Invoice where there are products.
Status Types
Blank - Code is recognised
Match - Not Received - The exact Code or quantity “Match” “Not Received” means that the product is on order and nothing has been received on it yet.
Potential Over - More products supplied than on the Order (this will also show when the Product is spread over two lines)
Potential Match - The product code matches but the quantities don't match.
Pricebook Code - The product code has been retrieved from the Pricebook and added to the Invoice.
Processing Serial Numbers
Xtracta can manually create imports for suppliers with serial numbers. At this stage Stihl New Zealand and Australia formats are available. Contact us if you need a supplier added.
Or you can manually highlight the serial numbers within Xtracta.
- Click the “Xtracta – Open Item” button. This will open the invoice up in Xtracta.
- On the “Data Extraction” pane, find the product with serial numbers and click in the Serials box.
On the invoice, highlight the related serial numbers. This will autofill the “Data Extraction” pane.
- Save the Xtracta invoice and return to Infusion Digital Invoice Import.
- Click the “Re Import Item” to import the new data.
- If you select the product, you will now see the serial numbers in the bottom left corner.
Processing the Invoice will prompt you for the serial numbers required.
The serial numbers will auto fill where it can and the remaining can be manually entered.
Using Job Number as an Order Number
Some businesses use the job number as the order number when purchasing parts off suppliers. If the order number does not match an existing purchase order, Infusion will then check if there is an open job with that order number. If it finds a matching open job a new check box will appear above the processing buttons.
This appears to be a Job Management Invoice for Job # 10129 for Martin Zen. Process as NEW Job Management Order? – This will create a new job management purchase order, each line on the purchase order will be auto filled with the job number.
Our Order # not found. User Order # from Imported Invoice as Our Order #? – This will create a new purchase order with the same number as the purchase order. Tip – this can be edited in the review stage if you have the default setting switched on in Supplier Defaults to allow overwriting of purchase order numbers.
International Invoices
If the supplier is set to be an International Supplier, then a new option will become available, Apply Exchange Rate.
If you enter an exchange rate in here, you will receive the following prompt
Selecting yes will change all line items and totals to the entered conversion.
Credit Notes
Credit notes in Infusion need the quantity to be zero. Some suppliers send through credit notes with positive amounts. These can be downloaded as normal invoices and then converted using the Convert to Credit Note button.
Comments
0 comments
Please sign in to leave a comment.