Purchasing

Get Involved. Join the Conversation.

Topic

    Ramesh Radhakrishnan
    Close Schedules using Spreadsheet
    Topic posted May 15, 2018 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged How-To, Orders 
    178 Views, 4 Comments
    Title:
    Close Schedules using Spreadsheet
    Summary:
    Close schedules in spreadsheet
    Content:

    Hi,

    We are looking for options to use custom report to pull the close schedules for PO as the parameter to pull in the close schedule is not sufficeient to pull the right data like pulling PO based on Supplier etc.

    Can we copy paste the custom output and delete the data pulled by the standard parameter and upload it? Will this worrkaround work?

    I tried few iterations to upload but that did not work. I deleted the existing rows in the ADF excel and inserted new rows with the action as Close. That did not work. Any ideas on how to manage this?

    I also see a Bug 27843777> - closing purchase order schedules using a spreadsheet for adding some additional parameters  like supplier, Order status etc.

     

    Thanks

    Ramesh

    Comment

     

    • Ivan Pena

      Hi Ramesh,

      You cannot insert custom data into the close schedules spreadsheet and perform any action on them. You can only close/final close schedules that are fetched by the application. 

      Ivan

       

    • Ramesh Radhakrishnan

      Hi Ivan,

      Thanks for the update. Can this be considered as an Enhancement request as the parameters in the Close schedule program is not sufficient for getting any specific groups. Hence users can run a custom report and populate the output to the ADFI excel template and upload specific PO's.

      Thanks

      Ramesh

       

    • Ivan Pena

      Hi Ramesh,

      Sure. Feel free to post it to the ideas lab so that other customers can weight in.

      Ivan

    • Ramesh Radhakrishnan

      Hi Ivan,

      I submitted it to the Idea lab. Hope this idea will be considered and provide a fix for this in future release.

      Thanks

      Ramesh