Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Modify the vendor accounts number

Posted on by 2,095

Dear All,

I recieved a request from Finance dep asking that they entered a wrong account number once creating the vendor so is there a possibility to change his account no he is still having two posts so is it possible to change it through the system or backend ..

Thank you ..

Rashed

 

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Re: Re: Modify the vendor accounts number

    Voiding the transactions leaves the voided document in history associated with the original account.  You could void all transactions, close the current account (put it on hold), and create a new account and re-create the transactions.  Do not delete the old account as postings have pushed through all the way to GL and you will be deleting the audit trails.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Modify the vendor accounts number

    Hi, if there are not too many transactions on his account, you could set up a new account, reverse the transactions in the old account and reenter them in the new account. Becomes a bit complicated if you are using Bank Rec etc and if transactions are gone to history.

    You could ignore the old account if its balanmce is zero and set up a new account. Enter the historical (cleared) transactions (Invoice as PM Invoice Transactions, payments as PM Credit Notes)...let them post through to th same GL accounts...This creates the history on the new account with no GL or Bank effect...and then carry on with the new transactions.

    It saves you investnig in the Professional Services Tools library just for this one issue. However if you will have an ongoing need for PSTL, then it makes sense to invest.

    Best regards,

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: Re: Modify the vendor accounts number

    Dear Rihard ,

     

    Thank you for your clarifications . is that meens i can't even void the two posts and delete the accounts using normal gp.

    Thank you .

    Rashed

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Modify the vendor accounts number

    It is too complicated and thus dangerous to try to change this number through the backend.  Missing a table and leaving a trace of the old number can cause CheckLinks to re-create the old vendor number in the future.

    Purchase and use the Professional Tools Library for this.

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Modify the vendor accounts number

    HI Sandip ,

     thank  you for ur answer , but i don't have this tool currently and as mentioned that i still have two transactions so is it possible to change the account no in the backend (Database) or not.

    Thank you ,

    Rashed

     

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Modify the vendor accounts number

    Hi Rashed,

    Yes its possible, but you need to use "Professional Service Libarary Tools", you need to buy it.

     

    Thanks

    Sandip

     

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans