Link AP Record To Another Application

 10 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Galacticnoise
New Member
Posts: 2
New Member

    Hello, this is my first posting to the forum so my appologies if I've made any forum etiquette transgressions. I am architecting a Sharepoint application which will manage the workflow for each line of business (LOB) for the approval and routing of invoices to Lawson AP. The Sharepoint application will be the repository for the LOB approvals and supporting documentation including, scanned impages.

    What I need is a way of linking the invoice in Lawson AP to the Sharepoint application to make the Lawson end-user experience as joyful as possible. Ideally, it would be nice if the user while viewing an invoice in Lawson, could click on a link or button on the Lawson screen that would seemlessly bring up the relevent data from the Sharepoint application or directly from the database into which the Sharepoint application has placed the data.

    I have looked at some of the tools on the market such as OnBase but want to see if there is anything simple we could do in-house before exploring a purchased solution.

    Any suggestions or pointers to help focus my research would be much appreciated. Thanks!  

     

     

    tomkeller8@gmail.com
    Advanced Member
    Posts: 42
    Advanced Member
      Doug, That's an excellent question. I was hoping to do the same thing here. I had heard that a link could be included in the comments field. That might be an option for the end user to view the scanned image. Once I started working this objective at BioScrip I was going to investigate it first. I would love to find out how you resolve your question so I can take some best practice in place you might have learned about workflow.
      Galacticnoise
      New Member
      Posts: 2
      New Member

        Hello Tom,

        I'll certainly keep you informed about anything I find out.

        Regards
        Doug

         

         

        John Henley
        Posts: 3353

          make the Lawson end-user experience as joyful as possible. 

          Now that's a good one!
          Thanks for using the LawsonGuru.com forums!
          John
          tomkeller8@gmail.com
          Advanced Member
          Posts: 42
          Advanced Member
            A joyful end user is a much better business partner than a bitter and frustrated one. Trust me, I've met plenty of the later.
            John Henley
            Posts: 3353
              BTW, the answer to your original question is that you will want to look at using the writeattachrec.exe IOS utility, creating URL attachments to the APINVOICE table. This will then give the end-users drill-around access back to the images you are storing within Sharepoint.
              Thanks for using the LawsonGuru.com forums!
              John
              nlmoran
              Veteran Member
              Posts: 53
              Veteran Member
                Not sure if this is the same thing:
                But Using Lawson's Attachment feature in AP90 I was able to link via URL to another
                system to pull up images scanned into a third party system.
                I am doing this for AP,GL,AM, PO Apps.
                etu
                Veteran Member
                Posts: 50
                Veteran Member
                  this is good to know....
                  SHAWNP
                  Basic Member
                  Posts: 4
                  Basic Member

                    Did you access the file on your microsoft file server, or did you have the scanned images stored on a webserver?  I want to provide a link to a scanned image on our file server but not sure how to indicate the path to the file.

                    Norm Moran
                    Veteran Member
                    Posts: 53
                    Veteran Member
                      I wrote a batch program using Standard Lawson API's
                      to create the URL that is attached to the
                      Invoice segment for AP

                      Using the attachment Button within lawson the
                      url is lanched to out third party system AIX (kofax)
                      We are also doing this for HR
                      GL
                      AM
                      Will share code works on 8.03
                      I understand API's will change with 9.0
                      John Henley
                      Posts: 3353
                        I have done same type of thing for PO, AP and AR (for AR uses a custom table because URL attachments not supported in AROIHDR or AROITEMS).
                        Have used same code in 8.0,8.1,9.0 apps--no problems in 9.0.
                        Thanks for using the LawsonGuru.com forums!
                        John