Forum Stats

  • 3,734,206 Users
  • 2,246,908 Discussions


Automation of excel invoice entries

3819965 Member Posts: 3
edited Jan 18, 2019 11:34AM in QA/Testing


We are curious to know if anyone has successfully automated the entry of excel based invoices and other docs/entries into peoplesoft? This means, instead of manually typing entries into the spreadsheet having the sheets pre-populated with functions to compute dates, etc. Then running the (I presume macro or VB Script) would load all the sheet/entries needed.  Thanks in advance for any assistance!


  • Thiruonnet-Oracle
    Thiruonnet-Oracle Member Posts: 44 Employee
    edited Jan 17, 2019 4:08AM

    Hi @3819964 ,

    I did a Load Test script for PeopleSoft Supplier invoice upload. Are you looking for some kind of functional testing script?



  • 3819965
    3819965 Member Posts: 3
    edited Jan 18, 2019 11:34AM

    Yes for functional testing, a team I work with is looking to automate the excel entries that are manually uploaded to PSFT - meaning create a sheet including updated fields (using functions or macros) and simply running a single macro or vb script to upload many sheets of entries into journal, etc. populating test data as they need it.

Sign In or Register to comment.