PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/24/2018 4:29 PM by  Raymundo Romero
Add-Ins Upload to AP20.1 & Need Comments
 6 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/financial/s3-financials/ap20-comments/

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


    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
    Raymundo Romero
    System Analyst II
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    08/23/2018 3: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
    (1194 points)
    Veteran Member
    Posts:428


    Send Message:

    --
    08/24/2018 5:02 AM
    On top of what you are doing we load comments into APCATTACH and then run AP520.
    Raymundo Romero
    System Analyst II
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    08/24/2018 4:29 PM
    Thank you JimY
    You are not authorized to post a reply.