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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Modify the vendor acco...
Microsoft Dynamics GP (Archived)

Modify the vendor accounts number

(0) ShareShare
ReportReport
Posted on by Rashed Alhakimi 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

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,319 on at

    Hi Rashed,

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

     

    Thanks

    Sandip

     

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at

    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

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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

    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

     

  • Community Member Profile Picture
    Community Member on at

    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,

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans