Advanced Rental Module Setup in Key2Act EMS Equipment Management: Rental Accounts

by | Updated August 17, 2020 | Dynamics GP, Field Service, Key2Act

Rental account distributions

Rental account distributions in Key2Act allow you to distribute the income from rental agreement lines into multiple accounts, depending on who owns the equipment and who is renting the equipment or based on the equipment ID, model, category, and/or item number.

You can have unlimited account distributions for each rental agreement line. In addition, you can specify an ownership percentage, based on who owns the equipment and who is renting the equipment.

This feature is for customers who want to distribute rental income:

  • Into multiple accounts.
  • Between different branches and divisions, depending on who owns the equipment, and who is renting the equipment.
  • By model, category, equipment, and/or item.

About rental account distributions

When you create an agreement, default account distributions filter down to the agreement header and agreement lines based on how the following options have been set up:

  • Account distribution templates–Account distributions have been grouped and assigned a Rental Distribution ID, which, when selected for use on the agreement, automatically fills in the distribution lines from the template.
  • Account distribution defaults–Account distributions fill in automatically if assigned to the equipment ID, category, model and/or item number that is used on the agreement.
  • Distribution default groups–Account distributions fill in automatically if assigned to the agreement type or branch and division used on the agreement.

How account distributions fill into the agreement

When an agreement is first created, account distributions fill from either the distribution default group assigned to the agreement type or, if distributions are not set up per agreement type, from general rental setup. Once an agreement line is created, the system uses the distribution default that is associated with the equipment ID, category, model, or item number. If no defaults are set up there, the initial distributions used in the agreement header will be retained

About rental account allocation

When you choose to allocate accounts, you must do so for every rate type (Rate, Insurance, Overage, and Markdown), and the account distributions for each type must add up to 100%. This applies to every window/area in which you enter account distributions.

If rental account distributions are not fully allocated, a message will display asking if you would like to continue to close.

  • Choose Continue to close the window.
  • Choose Cancel to return to the window, where you can continue to allocate distributions.

Note: If you are using Receivables Management Posting (Rental Setup option), Markdowns will not appear as a type for which you can assign account distributions.

About rental distribution percentages

You can specify what percentage of ownership is attributed to each owning and renting branch and each owning and renting division and split the revenue accordingly. For example, 35% may go to the owning branch and 65% to the renting branch.

You can also specify what percentage of revenue is assigned to each account, for each account type. For example, you might have two accounts set up on an agreement line for the account type called Rate; 50% can be distributed to one Rate account and 50% to the other Rate account. You can do the same for the remaining rental account types: Insurance, Overage, and Markdown.

For one Rate account, the owning branch would get 35% of the 50% share, or 17.5% of the total. The renting branch would get 65% of 50%, or 32.5%. The distributions would be the same for the second-Rate account, since that too is set up for 50%.

If the owning and renting branches are different, branches will take precedence over divisions for the percent on ownership calculation. If the owning and renting branches are the same, the owning division percentages will be used.

Setting up account distribution defaults

You can set up default distributions to be associated with an equipment ID, category, model, and/or item number. You can choose an account distribution template (Rental Distribution ID) to fill in, or manually choose the accounts on the setup window.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Equipment > Rental > Distribution Defaults.
  2. Choose a radio button and choose the Category, Model, Equipment ID or Item Number to which you wish to assign distributions.

Note: If Equipment ID, Category, or Model is selected, only Equipment accounts will fill in from the Rental Distribution ID. If Item Number is selected, only Non-Equipment accounts will display.

  1. When you’re finished assigning distribution defaults, choose OK.

Copying account distributions from one equipment entity to another

To save time, you can copy account distribution defaults from one equipment ID/category/model to another equipment ID/category/model, or from one item number to another. You cannot copy from a category, model, or equipment ID to an item number, or vice versa. You can only copy from an item number to another item number.

  1. On the Rental Distribution Default Setup window, choose an Equipment ID, Category, Model or Item Number from which to copy.
  2. Choose Copy to open the Copy Distribution Default Setup window.You could have also left the Rental Distribution Default Setup window blank BEFORE choosing the Copy button. In this case, you would have to enter a From and To entity on the window below.
  3. Complete the following fields. An indicates a required field:
    • Filter Type–Choose a type from which to copy (Category, Model, Equipment ID, Item Number).
    • Copy From–Choose a Category, Model, Equipment, or Item record from which to copy.
    • Filter Type–Choose a type to which to copy (Category, Model, Equipment ID, Item Number).
    • Copy To–Choose a Category, Model, Equipment, or Item record to which to copy.
  4. Choose Copy.

Setting up distribution default groups

You can set up distribution default groups by agreement type or renting branch and renting division. You can choose an account distribution template (Rental Distribution ID) to fill in, or manually choose the accounts on the setup window.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Equipment Management> Rental > Agreement Types.
  2. Choose an agreement type and choose Accounts to open the Rental Agreement Type Account Setup window.
  3. Enter a Renting Branch and/or Renting Division.
  4. When you are finished assigning distribution default groups, choose Save.

Default setup

Rental Agreement Type Accounts Setupe

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive


01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

14jul2:00 pm3:00 pmMastering the Production Floor

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

28jul2:00 pm2:30 pmConsiderations for Successful Testing Plans for Major Releases of Dynamics 365 Finance and Supply Chain Management

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!