PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/26/2020 12:44 PM by  Raymundo Romero
AP160 and AP161
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Carlotta McCormick
Private
Private
Basic Member
(15 points)
Basic Member
Posts:7


Send Message:

--
02/28/2011 10:21 AM
    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
    Private
    Private
    Veteran Member
    (1157 points)
    Veteran Member
    Posts:403


    Send Message:

    --
    02/28/2011 11:48 AM
    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
    Private
    Private
    Veteran Member
    (324 points)
    Veteran Member
    Posts:108


    Send Message:

    --
    03/01/2011 9:53 AM
    I have built a custom AP160 that includes the Remit info if you want to take a look at it.
    Bill Ianni
    Private
    Private
    Veteran Member
    (324 points)
    Veteran Member
    Posts:108


    Send Message:

    --
    03/01/2011 9:54 AM
    Actually Ragu built this. Sorry, Ragu, didn't see your post!
    LucyC
    Systems Analyst
    Siemens
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    03/29/2011 12:54 PM
    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
    Sr Application Developer
    Bluegreen Corporation
    Veteran Member
    (124 points)
    Veteran Member
    Posts:44


    Send Message:

    --
    03/29/2011 2:12 PM
    Where do you locate the file descriptions of the AP160ACH. Navigating thru mylawson.com can be very cumbersome. Thanks.
    Mark F. Hardy
    Sr Application Developer
    Bluegreen Corporation
    Veteran Member
    (124 points)
    Veteran Member
    Posts:44


    Send Message:

    --
    03/29/2011 3:08 PM
    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
    Systems Analyst
    Holland Hospital
    Basic Member
    (19 points)
    Basic Member
    Posts:9


    Send Message:

    --
    04/23/2012 10:34 AM
    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
    Private
    Private
    Veteran Member
    (1157 points)
    Veteran Member
    Posts:403


    Send Message:

    --
    04/23/2012 12:54 PM
    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
    Technology Implementation Manager
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    04/08/2015 10:37 AM
    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
    System Analyst II
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    08/26/2020 12:44 PM
    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
    You are not authorized to post a reply.