Intercompany Accounting Template & Spreadsheet Upload
This template is used for departments that send ICV uploads to the helpdesk.
Template example is saved here in case department users need an example before sending their upload to the Helpdesk:
\\ci.okc\OKC\FI-ASD\SystemsAndReporting\Oracle Conversion Folder\ICV Documents
Template example is saved here in case department users need an example before sending their upload to the Helpdesk:
\\ci.okc\OKC\FI-ASD\SystemsAndReporting\Oracle Conversion Folder\ICV Documents
1. Open OracleICVTemplate from ticket
2. Click Hamburger menu and select "Transactions" under Intercompany Accounting
Step 3: Click the task menu and select "Create Transactions in Spreadsheet"
Step 4: Spreadsheet will download to downloads folder. Open downloads folder, right click on the file, click properties, select the checkbox for unblock, and click OK.
Step 5: Open Spreadsheet and login
Step 6: Click on the "Multiple Batches" tab
Step 7: Copy rows and columns (C:T) from upload template
Step 8: Select Cell E9 on the "IntercompanySingleBatchEntry" spreadsheet (still on the Multiple Batches tab).
Step 9: Paste values into Cell E9
Step 10: Click Save under the "Create Intercompany Batches" ribbon at the top of the screen.
Step 11: Select "Import Transactions" and click "Submit" (DO NOT SELECT "Import Transactions and Submit for Approval because Oracle will not allow you to save ICV support to the batch).
Step 12: Ensure all rows uploaded successfully. If rows failed research to figure out why.
Step 13: Click Hamburger menu and select "Transactions" under Intercompany Accounting
Step 13: Click Hamburger menu and select "Transactions" under Intercompany Accounting
Step 14: The dashboard will show New Transactions that were uploaded. Go into each ICV batch and add support. Then submit for approval.
DataImage58.png
DataImage12.png
DataImage4.png
| Files | ||
|---|---|---|
|
|
DataImage58.png
30 KB
|
|
|
|
DataImage12.png
20 KB
|
|
|
|
DataImage4.png
8 KB
|