PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/21/2016 1:30 PM by  Kris
Add-Ins Upload to AP20.1 & Need Comments
 3 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:

--
07/08/2016 12: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.com/forums/f...-comments/

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


    Send Message:

    --
    07/08/2016 12: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.
    Basia
    Analyst
    CHOC
    Basic Member
    (22 points)
    Basic Member
    Posts:10


    Send Message:

    --
    07/08/2016 12: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:

    --
    07/21/2016 1: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
    You are not authorized to post a reply.