PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/2/2022 1:25 PM by  Cactus
Add-Ins Upload to AP20.1 & Need Comments
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kris
Private
Private
New Member
(7 points)
New Member
Posts:3


Send Message:

--
7/8/2016 4:23 PM
    We are mass uploading invoices to AP20.1 and would like to include Check Comments in the upload to get printed on the Cheques. Has anyone been successful in doing this?
    Found this post, but don't know if anyone has been successful.
    https://www.lawsonguru.co...cials/ap20-comments/

    Any help would be greatly appreciated!
    Thanks
    Kris
    Bob Canham
    Private
    Private
    Veteran Member
    (599 points)
    Veteran Member
    Posts:217


    Send Message:

    --
    7/8/2016 4:32 PM
    We upload invoices with comments using the AP52 process. We don't use addins, but use the import tables APCINVOICE, APCDISTRIB, and APCATTACH to load everything and then run the AP520 to process it. I don't know of a way to attach comments using add-ins.
    Maria
    Analyst
    Kline
    Basic Member
    (25 points)
    Basic Member
    Posts:11


    Send Message:

    --
    7/8/2016 4:46 PM
    Hi Kris,
    If you need to upload invoice comments in AP20, you can use a macro-enabled workbook in Excel. Then you will need to map the invoice comments to your check printing software which may be tricky since its a comment field and there's no character limit.
    If you need an AP20 field to add a comment to place on the checks, I've seen the description field in AP20 used as a check comment. It is easy to map if you use MHC as your check printing software and there's a character limit.
    B
    Kris
    Private
    Private
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    7/21/2016 5:30 PM
    Thanks for the responses.
    We will take a look at AP52 and loading via csv files. good idea!
    We did offer them the description field for comments but it is already being used and will get messy.
    Cheers
    Raymundo Romero
    System Analyst II
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    8/23/2018 7:09 PM
    Hi Bob,

    We are trying to do the same than you did , I been looking how to do it, what I have at the moment is: Load a flat file with the list of invoices, create the CSV files with an application than I wrote following the specs for the APCINVOICE AND APCDISTRIB , now the next steps is call the IMPORTDB , load the files and then run the AP520? is there anything than you see than I'm not taking in consideration?

    Thank you for your help
    JimY
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    8/24/2018 9:02 AM
    On top of what you are doing we load comments into APCATTACH and then run AP520.
    Raymundo Romero
    System Analyst II
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    8/24/2018 8:29 PM
    Thank you JimY
    Patricia Mane
    Systems Analyst II
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:24


    Send Message:

    --
    4/17/2019 5:12 PM
    We need to use an add-in to do mass uploads for a specific vendor into AP20.
    Currently today we have a vendor that pulls payments twice a month. The pull will include invoices related to purchases orders. I need a process to close the PO and match to the invoice,. If not these PO's remain on the PO135.

    Any thoughts and help would be greatly appreciated.
    Cactus
    Programmer Analyst III
    Private
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    12/2/2022 1:25 PM
    Just tried uploading a record to AP20.1 via add-in and got, "Add complete - Voucher # 767533". But the problem is the matching on MA43.1. We get an error. Is there a way to update MA43.1 at the same time? Do we have to upload to MA43.1 first? Thank you in advance.
    You are not authorized to post a reply.