Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Problem with updating ...
Microsoft Dynamics GP (Archived)

Problem with updating AP Distribution account

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have a Payables Transaction Entry with distribution account 000-2100-00. I'm trying to update the distribution account but i can't. I've updated in both vendor cards and posting accounts

1. Cards -> Vendors -> Accounts - updated the Accounts Payable account

2. Tools-> Setup -> Posting -> Posting Accounts - updated the Accounts Payable account

after updating i created a new one still it shows the old account (000-2100-00) instead of new account (000-2101-01). Am i missing any step?

4336.Account.png

Thanks in advance

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with updating AP Distribution account

    Thanks Mick and Leslie.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Problem with updating AP Distribution account

    Hi,

    If most of your vendors use the new account, the account shouldn't be entered in both account windows. Clear the vendor card's account and leave it at the Company level. If there isn't an account on the vendor card, the system defaults to the Posting Account setting.

    Leslie

  • Verified answer
    Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Problem with updating AP Distribution account

    On further investigation this transaction looks like a Payment and not a Payables Transaction Entry.

    I can replicate this situation by posting an invoice with the original account, and then changing the Account on the vendor.

    When applying the Payment to the Invoice, the Account will not switch, as the Payment is picking up the Account from the Invoice distribution.

    As a side note, if you don't apply the full amount the account will switch by selecting Default, or by opening the Distribution Window first before Applying, and then performing the Apply.

    The same Distribution Window is used for Payables and Manual Payments.

    Mick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with updating AP Distribution account

    Hi Mick,

    No, it is not a custom window

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Problem with updating AP Distribution account

    Is there any chance this Window is a Custom Window, as I don't see the "Show the Payment Distribution Information" on my setup.

    Mick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with updating AP Distribution account

    Hi Mariano,

    I've checked there is no trigger on the distribution work table. And when i click on Default button it still shows the old account (000-2100-00) instead of new account (000-2101-01).

    Thanks.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Problem with updating AP Distribution account

    Check to make sure you don't have a SQL Server trigger on the Payables Distribution Work table. Also, what happens when you click the Default button on that window?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans