Skip to main content

Notifications

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) / Need to automatically ...
Microsoft Dynamics GP (Archived)

Need to automatically add addl distribution lines in Payables Transaction Entry

(0) ShareShare
ReportReport
Posted on by Community Member

HI - A client wants to perform the following distribution when entering a utility invoice for their Admin building (Ex $1000).  Maintenance is responsible for the expense but they also want to see the expense on the Admin side.  It is easy enough to perform this manually but the volume of these transactions are growing quickly.  Without a development effort, is there a way to automate the allocation part of this entry, which is to Dr. Utilities Exp - Administration and Cr. Exp Allocation - Maintenance?  Client is on GP 10.

Dr. Utilities Exp - Maintenance             $1000

Cr. Exp Allocation - Maintenance        -$1000  (Allocation)

Dr. Utilities Exp - Administration          $1000  (Allocation)

Cr. A/P                                                 -$1000

Thanks,

Mike V.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: Need to automatically add addl distribution lines in Payables Transaction Entry

    Hi Leslie and Dan - I actually tried both before posting this.  The RevExpDef product has to tie to the account that is being deferred and I need two separate lines, similar to when a SOP invoice kicks out a Dr. Commissions Exp and Cr. Commissions Payable entry.

    I did attempt the macro with limited success so I think I will continue down that road.  I have to conquer possible multiple distributions.

    Thanks for the help, Mike.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Need to automatically add addl distribution lines in Payables Transaction Entry

    Why not use a macro?

    You can copy and paste the amount-use a shortcut key to invoke the macro.

    Kind regards,

    Leslie

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Need to automatically add addl distribution lines in Payables Transaction Entry

    Is it always going through the utilities expense?  I would ask a question as to why it hits the Maint account if it is then zeroed out.  What is the purpose?    If always the utiities expense, Rev Exp Deferrals sounds like the way to go.   If not cannot think of a way to do it without a custom.  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans