Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Effects on Cash
Microsoft Dynamics GP (Archived)

Effects on Cash

(0) ShareShare
ReportReport
Posted on by Sue Loach 245

Hi again!

I am looking for a way to get a report that shows the expense account that is hit when cash goes out the door.  The closest I have come is to look at invoices for the period.  That will show me the vendor, and account hit - but only if there is a default purchase account in the vendor record.  I want the expense account from the transaction.  I don't want to see the payable hit - it is always a payable that is hit.  When the invoice is entered, the payable is created and the expense is hit.  Why can't I see THAT account?  I hope I am making sense.  This shouldn't be so hard to find...

Sue

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: Re: Effects on Cash

    I think the Check Distribution report Leslie points out is as close as you're going to get out-of-the-box to this type of information without looking up each transaction individually.  But if you're doing analysis on monthly basis for all your vendors, this may not be very helpful.  Also, this will only show checks - what about vendors you pay by wire or credit card?

    We have created these types of reports for customers in the past - you can combine the following 2 SQL views to accomplish something like this:

    Payment Apply Detail

    GL Distribution for AP Transactions    

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Effects on Cash

    Have you looked at the Check Distribution report?

    Reports>>Purchasing>>Check Information then select Check Distribution from Reports drop down?

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Effects on Cash

    Ouch,

    I feel for you :). There is a 3rd party software that is used by many municipalities that do this. I can't recall the name just now, but if you do an Internet search - or visit ISV Central - I'm sure it will pop up.

    Kind regards,

    Leslie

  • Sue Loach Profile Picture
    Sue Loach 245 on at
    Re: Re: Effects on Cash

     Thanks much!  We are basically trying to convert accrual accounting to cash accounting for a needed report.  Not fun!

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Effects on Cash

    Hi Sue,

    This is hard to find just because the expense is not generated when the check is written but rather when the vendor invoice is posted. It could take months for the invoice to be paid, but then expense has been incurred. Also, a check can be written to partially pay invoices - how would the expense accounts be allocated? If a check pays more than one invoice, then you have a similar problem going the other way.

    That said, take a look at KB 865483 and 856849. These discuss how to get the distribution account from the invoice on the check. They are old KB articles but I think it will get you headed in the right direction.

    Kind regards,

    Leslie

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