AP160 and AP161

Author
Messages
Carlotta McCormick
Basic Member
Posts: 7
Basic Member
    You've probably all hashed this to death, but I need assistance.
    We are using the AP160 currently for our ACH transmission to the bank. We want to use the Remit file to send electronic remittances using MHC's e-Remit software. Our problem is that the Remit file doesn't include vendor location information so that I can link to the databases to pull email information. Example: We have a vendor on AP10.1 that gets checks, but one of their locations on AP10.2 gets ACH. The AP160 Remit doesn't include anything but the vendor number and name--no location info to link to.

    The AP161 remittance has the vendor info as well as the email address, so I don't even have to link to pull additional info, but the ACH file doesn't actually include all of the ACH information.

    How are others getting around this problem? We are not a custom shop, so changing Lawson code is a no-no.
    Thanks.
    Ragu Raghavan
    Veteran Member
    Posts: 468
    Veteran Member
      What I have done at most sites is create a 4GL process that follows AP160 or AP161. This will read the remittance or ACH file created and massage the data as needed before transmitting to third party application.
      No Lawson code is changed.
      Bill Ianni
      Veteran Member
      Posts: 111
      Veteran Member
        I have built a custom AP160 that includes the Remit info if you want to take a look at it.
        Bill Ianni
        Veteran Member
        Posts: 111
        Veteran Member
          Actually Ragu built this. Sorry, Ragu, didn't see your post!
          LucyC
          New Member
          Posts: 1
          New Member
            I want to do something similar but we only process checks, no ACH, so I was going to massage AP155 to create the Interface file following the format our Bank (Wells Fargo) needs but have been getting errors relating to the program being in transaction state. Has any one else encountered this or can anyone assist?

            Thanks LucyC
            Mark F. Hardy
            Veteran Member
            Posts: 44
            Veteran Member
              Where do you locate the file descriptions of the AP160ACH. Navigating thru mylawson.com can be very cumbersome. Thanks.
              Mark F. Hardy
              Veteran Member
              Posts: 44
              Veteran Member
                I found it by opening a new case in Lawson CASE. They said to search AP160ACH in the NEW Knowledge Base. Then select Product Documentaion. It took me right to the manual. I see the upside to the new tool, now.
                bman
                Basic Member
                Posts: 9
                Basic Member
                  Ragu - Would you be willing to share more details as to how your 4GL process was accomplished. We are specifically looking to add the "7" record

                  We are looking to take the AP161 output file (since this file has invoice numbers) and re-format it to the ACH format. The difference is the AP160 job does not include invoice numbers. We need to add the invoice number information into the re-formatted file.

                  Based on what I have learned, Lawson does not support CCD+ or CTX format. This format would include invoice information in the file so vendors can apply the payment to the correct invoices. Currently, the only way to accompish this is to add the "7" records after the file is generated.
                  Ragu Raghavan
                  Veteran Member
                  Posts: 468
                  Veteran Member
                    bman,
                    In the instance that Bill and I worked on, a custom 4GL program reads the file created by AP160, does some DB lookups and populates the Remit to information.
                    At another site, I developed custom 4GL Code to read the output from AP161 and reformat it to satisfy the bank's requirements.
                    what details are you looking for ?
                    DebbieAmEx
                    New Member
                    Posts: 1
                    New Member
                      Forgive me if this is not posted in the correct Forum. I am working with a client that uses Lawson Portal 9. Our company consumses the AP161 as a payment file. However, currently we do not accept the Record Type 5 (AP20 screen Invoice Comments) in the AP161 file. We ususally ask the client to supress this record type. However, we are looking at accepting this Record Type in the future. What I do know is that each Record Type 5 row holds 20 comment characters, and that multiple Record Type 5 rows will appear if the comments exceed 20 characters. What I don't know is this: 1) How many characters will the AP20 Invoice Comments hold? 2) Will all those comments appear on the AP161? 3) Ultimately, I am looking for the maximum number of Record Type 5 rows possible in an AP161 file. Thank you in advance for your consideration.
                      Raymundo Romero
                      Basic Member
                      Posts: 4
                      Basic Member
                        Hi Bill,

                        I'm in this route of ACH for AP , and just saw your post, is there any way now than Lawson can add remittance for a PPD file from the AP160 . I know than we can do it with AP161 but the SEC is CTX and is ok for companies , but for our contractors we need to have PPD but we are having problems adding remittance? is there a way after your post from 9 years ago? did you still has to use a walk around like the script? if you need to use it, could you please share ?

                        Thank you very much
                        ---