Audience: Accounting Manager and/or technical lead
Summary: Reviews the different folders and their functions in the SFTP site
SFTP Folder Structure
When you connect to the SFTP site through the Site Manager, you'll be presented with this view. The "Filename" section contains folders that you will utilize at specific times throughout your AP workflow detailed below.
Universal Connector Workflow
1. Assemble file templates from data in your ERP
Information that comes out of your ERP must be configured in a specific file format in order to be accepted into the MineralTree platform. The files that you generate are for different data sets within MineralTree and your ERP (e.g. Items, Vendors, Invoices, Purchase Order etc).
2. Getting Information into MineralTree
Once your files are correctly assembled, drop them into the unprocessed Folder in the SFTP. MineralTree will pick up any files in this folder once every three hours between the hours of 4am and 8pm ET.
- If your file is correct: it will move to the processed folder after the data is extracted and put into the MineralTree platform.
- If your entire file is incorrect: the file will move to the error_files folder (e.g. file name or type are invalid). From here you can download it, correct it, and put it back in unprocessed.
- If some parts of the file are incorrect: those specific lines will go to the error_records folder (e.g. column order, non-compliance with template order, duplicate values etc.) and the correct lines will move to the processed folder.
3. Getting information out of MineralTree
When you are working in MineralTree, posting invoices and authorizing payments automatically generate files in the exports folder of the SFTP as noted below in the workflow. Please note that when your payment files generate from a payment run, there will be one file per payment type.
You will have to take these files from the export folder and import the data back into your ERP.
4. Getting information back into your ERP
Getting the information back into your ERP is unique to your Universal Connector configuration. Essentially you will have to take the files from the exports folder either manually or through an automation process. Due to the complexities of various operating systems, security protocols, and ERP configurations, MineralTree is not responsible for how the data gets back into your ERP. If you choose to automate this step, you will have to determine how that can be accomplished with the technical lead on your team.