web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Can you change auto apply of AP credit memos?

(0) ShareShare
ReportReport
Posted on by 90

We have vendors that would like us to apply a AP credit memo to specific invoices not the oldest however the default setting in GP is autoapply to the oldest. How can we change this default setting?

Thank you greatly in advance for any assistance!

Kind regards,

Angela Reinhold

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mike Smith Profile Picture
    6,840 on at

    The default setting for GP's auto-apply is under Purchasing > Setup > Payables.  Changes to this will not impact the process required to manually apply payments (outside of clicking the Auto-Apply button).  

    To manually apply the credit memo, from Purchasing > Transactions > Transaction Entry, enter the data for the credit memo and click apply.  From here, you can manually apply the credit memo by clicking the checkbox next to any document in the details section.  Just don't click the Auto-Apply button.

    You can go through the same process from Purchasing > Transactions > Apply Payables Documents as well.

    You will need to do this work outside of the Select Payables Check process as this will auto-apply documents if selected.

  • Bradley Gehrls Profile Picture
    on at

    Hello Angela,

    Thank you for using Microsoft Online Communities.  I understand that you were wondering if there is a way to change the auto apply credit memos in payables.  There are two ways to apply credit memos in Payables Document Date or Due Date.  The system will choose the oldest documents based on this setting in the Payables Management Setup window.

    There are two places to auto apply these documents either in the Apply Payables Document window.  If you click auto apply the system will apply the credit memo or payment to the oldest documents based on the setting in the setup window.  These second place is the Select Payables Checks window if you have the Automatically Apply Existing Unapplied checkboxes marked.

    If these options do not work for you then you will have to manually choose what invoices you want applied to these credit memos when you enter them or in the Apply Payables Documents window.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    social.microsoft.com/.../threads

    This posting is provided AS IS with no warranties, and confers no rights

  • Community Member Profile Picture
    on at

    There is no way to change this default in Payables setup window. The only way to do it by using Modifier.

  • Sheilajr Profile Picture
    745 on at

    Marlena,

    I'd be interested to find out how you used modifier to change this.  I have a client who really needs to manually apply all credits and sometime can't apply at the time they enter the credit.  

    Thanks in advance,

    Sheila

  • Suggested answer
    Community Member Profile Picture
    on at

    Sheilajr,

    In VBA Code editor add the following lines:

    Private Sub Window_BeforeActivate()

    AutomaticallyApplyExistingUnapplied = False

    AutomaticallyApplyExistingUnapplied1 = False

    AutomaticallyApplyExistingUnapplied2 = False

    End Sub

    Once back in GP close and reopen select checks. I would recommend testing it first.

    Thank you.

    Marlena

  • Community Member Profile Picture
    on at

    Hi, this works, the check marks disappear. However, when check boxes or Apply Date is changed, or anything and the next step is selected we receive the following warning: Changing the Batch ID field removes all restrictions in the window. Do you wish to continue?

    Of course, if you continue everything is reset to default, with no boxes checked and no Apply Date, etc. Any ideas here would be appreciated.

    Thanks! Vernon

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans