eLibrary IAS Inventory IAS Aug 2022.xlsx

NTSS

SAP

AGENCY LARC Transition Agency LARC (COMET) to NSSC Training Purchases automation Create an RCP to process incoming external training requests from a csv file, create the SF-182 in SATERN, capture the SATERN tracking number and enter in csv file, then email the report back to LARC. RCPs are created to process incoming external training requests; SF-182s are created in SATERN; SATERN tracking numbers are captured; the csv report is emailed to LARC POCs. Completed Production Unattended RPA-BOT NEW Agency 180 9:30 AM Weekdays SATERN Microsoft Excel Microsoft Outlook Internet Explorer

Microsoft Excel Agency Business Support Service (BAD) BAD IPAC's - Updates/Enhancements Updates to AP IPAC processing due to changes with the IPAC .pdf and PPS rollout updates to current automation to account for system changes. Completed Production SCRIPT U SP FUP NA NA NA Excel

SAP

Adobe Acrobat Internet Explorer - Ipac.gov

Access

SAP

Agency Business Support Service (BAD) BAD Invoice/IPAC Distribution process to spread the cost of an invoice/IPAC across multiple lines of accounting on a contract/PO time efficiency, less human error Completed Production SCRIPT N CS NA NA NA Microsoft Excel

SAP

ServiceNow Internet Explorer Agency Business Support Service (BAD) BAD NEST - Update ITBS Scripts for the NEST Transition NEST Transition - Identify existing ITBS Scripts that need to be updated for the NEST Transition. Work with IT SOD Team to make sure they are aware of the updates needed. Make updates as needed for the NEST Transition. Completed Production SCRIPT U CS NA NA NA Excel

SAP

Agency Business Support Service (BAD) BAD Bridge/NEST Invoice Reconciliation Process Add additional employee status information to the existing consolidated Invoice Workbook Tab. Centers will be able to view employee status to dermine if assets are assigned to an employee that no longer work for NASA. Will assist centers in retiring assets Completed Production SCRIPT U CS NA NA NA Excel

SAP

Agency Business Support Service (BAD) BAD Automated Identification and Assignment of Cost/Goods Receipts/Funding IRIS Requests NSSC as a Center's IRIS queue for Cost, Goods Receipts, and Funding items are filled with requests for contracts that are managed by other NASA Centers. Currently when working the IRIS queue, the reviewer must look-up of every contract request in SAP to identify the Plant and Contract Type. This process takes several hours and, at times, it will take a whole day. This request is to find an automated solution to import the IRIS queues and identify the Plant and Contract Type for each contract that has a request in IRIS. The automation solution could also identify the BAD assignee based off the contract type and/or contract number IRIS queues for cost, goods receipts, and funding items are imported, and the Plant, Contract Type, and correct POC for each contract are identified. Completed Production Unattended RPA-BOT NEW CS 75 2:00 AM Monday & Wednesday IRIS

SAP

Microsoft Outlook Microsoft Excel Google Chrome

Microsoft Excel

SAP

Microsoft Excel

SAP

Agency Business Support Service (BAD) BAD Create a NEST Databas Create a NEST Microsoft Access Database To create/update workbooks with invoice, funding and liquidation amounts. Completed Production Dbase SP LOE NA NA NA Microsoft Access Microsoft Excel o Microsoft Excel COM Add-In: Analysis for BOBJ

Update to Legacy Script into IAS Portfolio as a result of GSA PSC Code Changes impacted SAP Material Groups and PCard Category Codes

1. Remove column Y "Verified Status" required from the import file into the NEST Database. ITBS will remove the column from the Invoice Details Files ran in Service Now

Microsoft Excel Microsoft Outlook Google Chrome ES - Enterprise Services IAS ORCHESTRATOR QUEUE ARCHIVE PROCESS REQUESTING AUTOMATION THAT WOULD DOWNLOAD ALL QUEUES FROM UI-PATH ORCHESTRATOR AND DOWNLOAD AND SAVE ON THE N:DRIVE (N:\Intelligent Automation Services\UiPath\Production) AND WOULD THEN DELETE ALL EXISTING QUEUES AND RECREATE NEW QUEUES WITH SAME QUEUE PARAMETERS. Decommissioned Decommission/End of Life Attended RPA-BOT NEW SP LOE NA NA NA UiPath Orchestrator MS Excel Internet Explorer

SAP

SNOW

Microsoft Excel Adobe 2017 Microsoft Outlook Google Chrome

Microsoft Excel Over the Counter Channel App Microsoft Outlook Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Automate the AP CMP 6.9 Macro to include the SAP AP eInvoice report(ZFI_AP_EINVOICE) AP CMP 6.9 macro be updated to include the SAP AP eInvoice report(ZFI_AP_EINVOICE) Completed Production SCRIPT U SP FUP NA NA NA Excel

SAP

FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other FM Transition July 2018-Automate the VPP steps of executing the SAP ZIPP_PO_EXTRACT report to identify IPP invoice CLIN data New Invoice Processing Platform ( IPP) requirement - validate and post invoices to specific CLIN PLI (s): Automate the VPP steps of executing the SAP ZIPP_PO_EXTRACT report to identify IPP invoice CLIN PLI (s), determine which PLI (s) are associated to the invoiced CLIN (s), execute the ZFI_OLA_PO to determine available cost or insufficient amount. Once cost is available, auto populate PO and PLI numbers in the SAP document for posting. Run an SAP PO report to identify IPP invoice CLIN PLIs; determine which PLIs are tied to the invoiced CLINs; determine available costs; populate PO and PLI numbers in the SAP document. Completed Production Unattended RPA-BOT NEW SP LOE 480 7:00 PM Weekdays / No Holidays Systems, Applications and Products (SAP)

IRIS

Microsoft Excel Internet Explorer Microsoft Outlook FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other AP IPAC - Request Macro to search for Duplicate Payments Would like to request macro to search for duplicate IPAC payments similar to macro Accounts Payable uses that is named "Duplicate Invoice Review" Completed Production SCRIPT U SP FUP NA NA NA Excel

SAP

Adobe Acrobat Internet Explorer - Ipac.gov FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other FM Transition July 2019- STRY0388242 - AP Invoice Escalation - Execute SAP and IRIS reports As a result of the NSSC Study and the AP Invoice Escalation process transitioning to NSSC AP, each day 1. Execute the SAP Invoice Stat Report (ZFI_AP_INVC_STAT) and the IRIS Escalation Report in Invoice Routing and Information System (IRIS) (https://iris.nasa.gov), export to Excel and save the reports on the shared drive. 2. Perform a task to look up the "Assign To" person in each Pending queue in (IRIS), add a column to the Daily IRIS Escalation Report and populate the Assign To associated with the Doc Number on the IRIS Escalation report. 3) If the Assign To field in the IRIS pending queue is blank, populate "Unassigned" in the applicable Assign To field on the IRIS Escalation report. Run the SAP Invoice Stat Report and the IRIS Escalation Report, export the files to Excel, complete the 'Assign To' fields, and save the files on the shared drive on a daily basis. Completed Production Unattended RPA-BOT NEW SP LOE 120 3:00 AM Weekdays / No Holidays IEM00100 (SAP) bReady Invoice Routing and Information System (IRIS) ServiceNow (SNOW( Microsoft Excel Microsoft Outlook Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Automate SPS import for AP Payment Proposals - Attended BOT Update the AP Payment Proposal process to Automate the SPS import process of the Pre-edit file. Create a new Subcategory in ServiceNow where the AP CS will assign the task when the Pre-edit / SPS entry is ready to be imported. For payments assigned in this Subcategory, an automation can identify the center Payment Proposal Run ID, access the Pre-edit file in WAT, read the data elements, import the data in SPS, save the pre-edit report to the Ndrive and assign the task back to the AP CS to complete the payment proposal. Completed Production Unattended RPA-BOT NEW SP FUP 60 8:45 AM Weekdays / No Holidays IEM00100 Core Financial SAP

WAT EAI

WAT USER

Service Now Microsoft Outlook Adobe 2017 Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Automate daily Accounts Payable Payment Proposals I I'm requesting a BOT execute and perform quality checks for the daily Account's Payable vendor Payment Proposal process. Each business day, the BOT executes the Invc Stat report for posted invoices, extracts invoices matching the calendar for next payment proposal date, separate invoices per doc. type, create a Payment Proposal in SAP per payment type (vendor=D/C, foreign+F, employee=E, legal, freight=T,etc.), preform quality checks on the payment proposal (interest, alternate payee, vendor/KRED partnership, record blocked vendors for additional proposals, suggest JPMC credit card payment-if due add step to processed with creating a payment proposal for each center). Create center ServiceNow daily payment proposal case and task for each SAP payment proposal, assign to a Payment Proposal L2 Subcategory for the VPP/Lead to validate the payment proposal and assign each task to L3 for processing Invc Stat reports are run, invoices are extracted, payment proposals are created, and quality checks are performed on payment proposal. Completed Production Unattended RPA-BOT NEW SP FUP 240 12:00 AM Weekdays / No Holidays ServiceNow Systems, Applications and Products (SAP) Microsoft Excel Microsoft Outlook Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Automate Invoice Reversal process I'm requesting a automated solution where the VPP will interact during certain steps of the invoice reversal process (add SNOW # to DRN, reverse clearing, add payment block, reverse DRN, clear cm/debit DRNs, reenter new DRN, print FD tab and attach to reversed and new DRNs, add new DRN as manual adjustment for same month reversals) The VPP performs certain steps of the invoice reversal process, such as reversing clearing and DRNs, adding payment blocks, and reentering new DRNs. Completed Production Attended RPA-BOT NEW SP FUP NA NA NA Microsoft Outlook Internet Explorer ServiceNow IEM00100 Core Financial (SAP) Microsoft Excel Adobe Acrobat 2017

Microsoft Outlook Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Tax Withholding amount update Process Need a macro to update the tax withholding amount to the correct amount paid using FB02 in SAP. Completed Production SCRIPT U SP FUP NA NA NA Excel

SAP

FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Transition July 2019- AP Invoice Escalation - Automate email and phone communications from SNOW to IRIS Create an automated solution to capture daily escalation emails and phone communication/notes from daily SNOW Escalation activity and attach the communication to the DRN in IRIS. Escalation emails and phone communications/notes regarding ServiceNow escalation activities are captured on a daily basis and attached to the DRN in IRIS. Completed Production Unattended RPA-BOT NEW SP LOE 180 6:30 PM Weekdays / No Holidays ServiceNow

IRIS

Microsoft Outlook Adobe 2017 Internet Explorer FM - Accounts Payable AP FM Extract CMP 6.11 Exceptions, combine and upload to SNOW AP Escalation AP is requesting an automated solution to export all center CMP 6.11 reports from the NSSC CMP Tool, combine exceptions under Exceptions-Items greater than 30 days; (exclude Text field = CR, FIN, $, SBIR, SD) and upload the Excel file into SNOW CMP Escalation Center CMP 6.11 Reports are exported from the NSSC CMP Tool, exceptions are consolidated, and the Excel file is uploaded into ServiceNow CMP Escalation. Completed Production Unattended RPA-BOT NEW SP LOE 120 6:15 AM Monthly Microsoft Excel Microsoft Outlook ServiceNow (SNOW) Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other FM Transition - AP Invoice Escalation - STRY0497431 - Extract CMP 6.2 Exceptions, combine and upload to SNOW Escalation AP is requesting an automated solution to export all center CMP 6.2 reports from the NSSC CMP Tool, combine exceptions from columns 31-60 days, 61-90 days, 91-120 days 121-180 days 181-365 days, 1-2 yrs, Over 2 yrs and the Account Document number and Vendor and upload the Excel file into SNOW CMP Escalation Center CMP 6.2 Reports are exported from the NSSC CMP Tool, exceptions are consolidated, and the Excel file is uploaded into ServiceNow CMP Escalation. Completed Production Unattended RPA-BOT NEW SP LOE 120 6:00 AM Monthly Microsoft Excel Microsoft Outlook ServiceNow (SNOW) Internet Explorer FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other Part 2 of IDEA 3357-Automate Accounts Payable FI Interest Vendor Invoices I am requesting an automated solution that will identify a "budget exceeded error" for interest due vendors after executing the payment proposal, exclude the blocked DRN from PPA, and park the FI interest DRN for interest due the vendor. Execute Automatic Payment Transactions, identify "budget exceeded", "amount exceeded", Exclude Items from PPA Calculations and Enter Vendor Invoice. Budget exceeded error issues are identified regarding interest due to vendors after executing the payment proposal; follow-on remediation steps are taken to correct the issues. Completed Production Unattended RPA-BOT Enhancement SP FUP 60 6:00 AM Weekdays / No Holidays Microsoft Excel

SAP

Microsoft Outlook FM - Accounts Payable Contracts/PO/Central Bill, Simp Ac/Travel/Other FM IPAC - BOT to pull IPAC Received All Centers and import to Techdoc/IPAC Download Spreadsheet/Park/attach/Pos AS FM IPAC Manager, I would like a BOT to: 1. Pull all IPACs received and process DI function to import to Techdoc. 2. Run the AP IPAC download report and save as excel spreadsheet in each center's IPAC daily folder. 3. use exciting AP IPAC macro to Auto park IPACs 4. Use existing macro to attach IPACs to parked invoices 5. use existing macro to auto post IPACs IPACs are pulled and imported into the TechDoc repository; AP IPAC Download Report is run and saved as an Excel file in each Center's IPAC folder; and macros are run to address IPACs. Completed Production Unattended RPA-BOT NEW SP FUP 120 4:00 AM Weekdays / No Holidays SAP

IPAC

Adobe Acrobat 2017 Microsoft Excel Microsoft Outlook Internet Explorer or Google Chrome (both)

NSSC CMP Tool Microsoft Excel Internet Explorer Microsoft Outlook

Notepad

Systems, Applications and Products (SAP) Microsoft Excel Microsoft Outlook Internet Explorer

SAP

TechDoc Microsoft Excel Microsoft Outlook Internet Explorer FM - Accounts Receivable Billings, Collections, and Write offs Automate Accounts Receivable Dunning Process for current NASA Employee Travel Debts Automate Accounts Receivable Dunning Process for current NASA Employee Travel Debts. Current Process: Accounts Receivable issues a Travel Bill of Collection to a NASA Employee. AR L2 runs Aging Report out of SAP weekly and statuses all Consumer debts. If a NASA employee's debt is outstanding between 25 to 26 days on the Aging Report, Accounts Receivable L2 manually marks calendars for each debt that could reach the 30 day deadline. When the calendar reminder occurs, AR L2 prepares a task to issue the "Friendly Reminder" notification via Service Now to the employee. AR L2 runs the Aging Report out of SAP weekly, if the debt isn't paid between 55 and 60 days old, AR L2 once again marks their calendar for each NASA employee that is outstanding and could reach the 60 day deadline. If the debt reaches the 60 day deadline, the debt is sent for "Involuntary Salary offset" using form "A-04 Collection of Gov Indebtedness" via Service Now. A weekly accounts receivable aging report is run out of SAP and all consumer travel debts are checked; depending on the age of the debt, different actions are performed. Completed Production Unattended RPA-BOT NEW SP FUP 120 7:00 AM Weekdays / No Holidays ServiceNow

SAP

Microsoft Excel Microsoft Outlook Internet Explorer FM - Accounts Receivable Billings, Collections, and Write offs Journal Voucher Legacy Macro UpdatesI Update required for a FINANCE/AR LEGACY Journal Voucher Macro Update --- THIS WAS WORKED UNDER INC000002886259 AND WAS RESOLVED ON 02/05/19 Completed Production SCRIPT U SP FUP NA NA NA Excel

SAP