2.1.4.8.11.3.3. IMPORT INVOICES FROM A FILE:Use this option to import invoices from a TXT file into TimberScan. If your vendor can send you invoices in a comma-delimited format that matches Sage 300 CRE’s AP import invoice format, you can use this feature in TimberScan to import data from a file. After the import, invoices can be matched to images and routed through TimberScan’s approval process. When importing into the program, TimberScan is expecting a comma-delimited TXT file.
Setup: Import invoices from a file does not need any of the Invoices Uploaded from AP options checked:
![]() In Routing Settings, check the Final Review Mandatory For Imported Invoices box. NOTE: If you are also importing invoices from Sage 300 CRE, that option should not be checked.
![]() In User Maintenance, check the Import Invoices permission:
![]() WORKFLOW:
1. Acquire the invoice images:
Acquire – Imported Invoices
![]() When prompted, enter a description for the batch of invoice images.
2. Import the invoices from a comma-delimited TXT file:
Invoice Entry > Import Invoices from AP > Import Invoices from File
Import File – browse to the comma-delimited TXT file
Rejected Records File – TimberScan automatically creates the name for the reject TXT file
Batch Description - enter the same description used for the Acquire process. This will make it easier to match the images to the invoices in Step 3.
Data Entry Group – select a data entry group
Invoice Type: Optional; if you acquired images using an invoice type, select the same invoice type here.
![]() Select the Start button.
3. Match Images to Invoices:
Invoice Entry > Import Invoices from AP > Match Imported Invoices
Enter the batch name for the invoice images.
Enter the batch name for the imported invoices.
Select OK.
![]() The invoices will be routed according to their coded information. Afterwards, invoices go to Final Review to be queued for Export and exported into Sage 300 CRE Accounts Payable.
|