2
Hi,
I have about 1,000 AP invoices that I need to offset with credit memos as I don't want the checks in the reconcilation. Client does not own Integration Manager, so I was going to write a macro to apply the CMs. However, many of the vendors have more than one open invoice and I know that macros don't handle one-to-many transactions very well.
Running GP 10.00.? Any suggestions?
Thanks in advance!
Jim
*This post is locked for comments
We ended up just going vendor by vendor and manually paying the open invoices. We turned off Post Through, posted the manual check batch and then deleted the GL batch that was created.
IMPORTANT NOTE: The client is using Cashbook Bank Management (CBM) which is normally used in the UK. When using the normal GP AP function, the bank (CBM) is NOT updated. So we were able to post the manual checks and not worry about them showing up in the reconcile.
Let me know if anyone needs any more info on this as I will do my best to assist. Thanks!
Jim Lines
Leslie,
I think I am going to have a problem with this because of the account distributions. I built a macro that entered all of the Credit Memos, but when I ran the batch edit list, there were distribution errors on all the transactions. All distribution accounts in the CM were blank. Is that because I was entering the CM and not applying it? My plan was to do this and then do what you suggested about running the check process and have everything be offset by the credit.
On my second approach, I wrote a macro to enter AND auto apply the CM, but I still ran into distribution problems again. I think some of this may have to do with project accounting.
Do you think I missed anything on either of these?
I appreciate your feedback.
Thanks.
Jim
Hi Leslie,
Thanks for responding. I have not put the credit memos in the system yet. Sounds like I would need to do that and then do a check run with the apply CM option marked? And if everything is correct, it should not produce any physical checks, yes?
What I had tried doing when I wrote my macro was to use the auto apply option since everything is being paid and it really doesn't matter what order the $ are applied. But the client is running project accounting, so for some credit memos, a message comes up asking if its PA related.
Your suggestion on breaking up the data into groups sounds like it would work. I had not thought of it that way.
I'll follow up on the case so everyone knows how it went.
Thanks again and have a nice weekend!
JL
Hi Jim,
I presume the automatic application of credit memos during the Select Checks process will not work for you. It's an easy way to take care of what you've described if you can Autoapply according to your set ups in Payables Management. Absent that, I suggest you break up your data into groups that have the same number of open invoices and proceed along the macro path in batches.
Kind regards,
leslie
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
