3rd party Order-to-Pay To Lawson Interface

 6 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
RajR
Posts: 5
    Is there a way where we can interface our 3rd part software Order-to-Pay system and interface it to Lawson for Electronic payment?
    The idea is to pay electronically using our Order-to-Pay system and send over the transaction to Lawson AP for record purposes? Also I should be able to send info of Discount Codes from the Order-to-Pay system to Lawson.
    There won't be any transaction happening in Lawson, but I should be able to pull up the info in Lawson, if I have to see what electronic payments were made for any particular Vendor.

    Can it be done? Thanks in advance for sharing your thoughts and details.

    mark.cook
    Veteran Member
    Posts: 444
    Veteran Member
      It sounds like you are looking to pull invoice detail into the system as historical so no transactions are happening but the invoice detail is there for viewing. You could do this with the AP520 loading invoices as historical. Enter the payment information so you can see any transaction history on the payment side. This is similar to converting historical invoices at go-live.

      Let me know if that is what your looking for
      Rob Conrad
      Veteran Member
      Posts: 73
      Veteran Member
        Yes. Mark is correct - AP520 would be used and you can add the account distribution vs. using MA540. I just built such a flow using AP520 with PFI - the flow actually uses a script to poll a 3rd Party Invoice FTP Site, retrieves the APCINVOICE and APCDISTRIB into an internal directory and then uses BCI (scan file client) to kick off PFI on the internal file capture event. I created a virtual directory on IIS to present the APCDISTRIB and APCINVOICE data into a dynamic HTML file which is displayed in an Inbasket for an appropriate approver, so they can see the data before running AP520. On the Approve - the AP520 job kicks off from the WebRun node - I run in report mode first, review and then run in update mode with error handling thrown into the mix. You can get exotic with the approvals / category filtering and/or additioanl individual Invoice Approval if you need to do that as well.

        Let me know if you want more details - I'm testing and promoting this into Production next week for a client.
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
          If you want to electronically pay the invoices without running the payment cycle you can also use CB150 to rlease the invoices that are interfaced not into AP52 but into AP55 and then run CB554 to pay the invoices automatically by setting up electronic payments as the check type and a new cash code and bank code for the bank account from where the invoice will be ppaid.
          The cash code with be an EFT type code.
          Barry Ghotra
          Veteran Member
          Posts: 63
          Veteran Member
            Rob,

            Thank you for sharing the great work that you are doing. I am doing something similar, interfacing the AP data from a third party provider. This third party is used to bring in the employee expense and amex transactions. But in some cases where the third party pays or does a direct deposit for the customer, I still need to show a payment posting record into lawson. Any idea on how you are handling that. how you are actually creating electronic trx that gets done via AP55.1/AP55.2 manually? Any insight would be helpful.

            also sharing bit more details on how you use the BCI to get data into APCINVOICE & APCDISTRIB would be very much appreciated.

            Regards,

            Barry Ghotra
            Barry Ghotra
            Veteran Member
            Posts: 63
            Veteran Member
              Anyone wants to chime in??
              Barry Ghotra
              Veteran Member
              Posts: 63
              Veteran Member
                Can someone please shed some light on this. If I were to get the invoice data using AP520 as posted/closed/paid invoices and then run GL165 for the GL data via GLTRANSREL, will that accomplish the same results electronically as one would do by first creating an invoice in AP20, post payment in AP55.1 and then use AP55.2 TO RELEASE and eventually running AP265?

                Any feedback would be appreciated.

                Regards.