QRG - Upload transaction spreadsheet (UPDOCS)
Introduction
Similar to the current process of using Spreadsheet Upload (SSLD) to upload documents from a spreadsheet into FINET, users with appropriate security will use the Upload Transaction Spreadsheet (UPDOCS) page to bulk upload transactions via spreadsheets into FINET. These uploads create one or more transactions in FINET using the populated fields within the spreadsheet template.
Worklist search
Pre-configured templates
Spreadsheet templates exist for several transactions. These templates are streamlined to include required and commonly entered data for the transaction. To view the available templates, navigate to the UPDOCS page, click the 3-dot menu on the top right, and click Transaction Upload Template. On the Transaction Upload Template page, click the Template File Name link to download an existing template.
How to prepare the spreadsheet template for upload
- Populate the template with the transaction information. Review the spreadsheet to confirm all required fields are populated and the data is accurate.
- For each unique transaction, specify a sequential number starting at one and copy that number for all lines (rows) for that transaction. For subsequent transactions, increment this number by one.
Tips for populating the spreadsheet template
- FINET templates use a hierarchy of vendor and accounting lines allowing for multiple vendor lines or multiple accounting lines on the transactions.
- The first column, Spreadsheet Transaction ID is used to associate each row to a single transaction.
- Auto Numbering and Prefixes can also be used with templates. The field is included in the templates but is not required.
Upload the populated spreadsheet
- In the Search field, enter UPDOCS.
- From the results list, click Upload Transaction Spreadsheet (Financial).
Click the 3-dot menu and then click Upload Spreadsheet to upload a completed template spreadsheet.
On the Upload Spreadsheet page, in the Transaction Code field, enter the Transaction Code for the template that is being uploaded.
Click the Submit Transaction checkbox to submit the transactions after they are created. (Note: If this is not selected, documents will submit in draft phase and will require manual Submit)
Click Apply Overrides to apply overrides to the transactions, if needed. (Note: Bypass Automatic Numbering and Bypass Approval are not available.
Click Upload. The Upload file has now been queued for processing successfully. Click Cancel to return to the Upload Transaction Spreadsheet page.
On your record, click the 3-dot menu. hover on Related Pages, and click View Logs to check the upload status.
On the Spreadsheet Upload Log, review the status at the top of the page.
Scroll down to review the individual transactions.
Click the Transaction ID link to open rejected transactions to correct and submit.
(Note: You will need to submit transactions if they were created in draft status.)
Related Articles
QRG - Item Transaction History
Description and Purpose Have you ever wanted to know the specific history of a stock item and figuring it out was not easy? You would have to jump around to the various transactions and tables to assess what happened. FINET now has a new query page ...
QRG - Advanced Grid
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/116oOJ-4_38GP4BXP2MtlW9X2BqpIjRZb/view ) Introduction The Advanced Grid allows you to change the view of the results from a Transaction Catalog search for more ...
QRG - Table Export All Available Columns
Description and Purpose When working with pages that have grids, sometimes it is easier to export the data to a spreadsheet which allows easy manipulation of the data to get the desired results. When selecting Export All. FINET allows you to either ...
QRG - Creating Transactions
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1aa4QyUy2V4gvdL3BXxz-KXcmnH9OzT52/view ) Introduction This quick reference guide describes how to search for and create transactions in FINET. Creating a ...
QRG - Creating a PRC transaction
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1aFAJIMFDNd_4H2MVZChVQxA2LsfLRmSG/view ) Introduction This quick reference guide describes how to create a Commodity-based Payment Request (PRC) transaction in new ...