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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is it feasible to run ...
Microsoft Dynamics GP (Archived)

Is it feasible to run a SQL query to apply invoices and credits in a specific Vendor in the AP tables or sub ledger?

(0) ShareShare
ReportReport
Posted on by Community Member

We have two vendors that are being used as a clearing account for one of our integrations, the number of invoices and credits continues to grow exponentially. Our AP team is already stretched very thin and I was hoping I might be able to run a script to update these vendors only internal application of invoices and credits.

Thank you for your help

Mark

*This post is locked for comments

I have the same question (0)
  • Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,552 on at

    Hi,

    When you say Clearing Account, do you have Inter-Fund Management Setup using those accounts?

    I hope you already have Distributions passed to such accounts, in that case it wont let you change the Clearing Account and corresponding To/From Due Account will be passed to respective Clearing Accounts only.

  • Verified answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,552 on at

    Hi,

    It is not a best practice to override any functionality from Back-end approach.

    The justification is there is high possibilities of human error when doing such update.

    Alternatively you can try to create a new set of Accounts for these vendors which differs from Clearing Account, and have a cut-off date to start using these new accounts.

    Once you make these Accounts up and use for all your AP Transactions, then TB will have properly distributed values.

    Thanks,

    Praveen

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans