web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,306 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

     

  • 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

     

  • 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: 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

     

  • Community Member Profile Picture
    Community Member 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,

  • 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.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans