Vendor price agreements load (PO536/PO25)

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
kesarla
New Member
Posts: 2
New Member

    Hi -

    We are attempting to automate the Lawson Vendor Agreement loads to eliminate the manual upload process using lawson upload wizard and spreadsheets.

    The catch here is the file we  receive will have records related to multiple vendor agreements.  In this scenario I ccan't use PO536 because vendor agreement reference is required field on the screen.  We are exploring options to develop a custom program to invoke PO25.  

    If someone has already been through this process or have a suggestion from any of best practices you have come across please share.  Any suggestion is also welcome.  Thank you.

     

     

    Rob Conrad
    Veteran Member
    Posts: 73
    Veteran Member
      Hi there -

      One way to do this would be using Infor Process Automation (or Lawson PFI) to read/parse your files with the multiple vendor agreements and automate the data upload process using the Lawson API's for PO25. (this would work basically like a systematic MS Add-In that you do not need to manually format in Excel. You can probably leverage the mapping you already have in you manual upload). Tack on some error handling and email notification and you would be good to go for an automated upload.

      You would need the File Access Node, Data Iterator, Assign and the AGS (Transaction) nodes.

      You could also enhance with workflow type approvals before uploading the data, if you wanted this type of control.

      Good luck!
      Rob
      kesarla
      New Member
      Posts: 2
      New Member
        Thank you, Rob.