Add-Ins Upload to AP20.1 & Need Comments

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.

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

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

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

On top of what you are doing we load comments into APCATTACH and then run AP520.

Thank you JimY

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.

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.