Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Information about how variable allocation accounts are calculated in Microsoft Dynamics GP

Information about how variable allocation accounts are calculated in Microsoft Dynamics GP

View products that this article applies to.

INTRODUCTION

This article describes how variable allocation accounts are calculated in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0. Variable allocation accounts use the absolute value of the breakdown accounts in Microsoft Dynamics GP. Variable allocation accounts do not consider whether the breakdown accounts have a debit balance or a credit balance.

↑ Back to the top

MORE INFORMATION

The following tables provide an example of how Microsoft Dynamics GP calculates the allocation by using the absolute value of the breakdown accounts.

 

Variable allocation account 000-6180-00

Distribution accounts Breakdown accounts Breakdown balance
100-6180-00 100-9010-00 $200 debit
200-6180-00 200-9010-00 $200 debit
300-6180-00 300-9010-00 $400 debit
400-6180-00 400-9010-00                          $200 credit
If you post a $10,000 debit to the variable allocation account, Microsoft Dynamics GP uses the absolute values of the breakdown accounts to determine the breakdown account balances. If you add the absolute values, the total of all the breakdown accounts is $1,000.
Breakdown accounts Total
100-9010-00 $200 ÷ $1,000 = 20%
200-9010-00 $200 ÷ $1,000 = 20%
300-9010-00 $400 ÷ $1,000 = 40%
400-9010-00 $200 ÷ $1,000 = 20%
The following information is posted to the distribution accounts.
Distribution accounts Total
100-6180-00 $10,000 × 20% = $2,000
200-6180-00 $10,000 × 20% = $2,000
300-6180-00 $10,000 × 40% = $4,000
400-6180-00 $10,000 × 20% = $2,000
Total amount that is posted $10,000

↑ Back to the top

APPLIES TO:

Microsoft Dynamics GP 9.0

Microsoft Business Solutions- Great Plains 8.0

General Ledger

↑ Back to the top

Keywords: kb, gp, kbmbsmigrate, kbmbspartner

↑ Back to the top

Article Info
Article ID : 922058
Revision : 4
Created on : 5/3/2018
Published on : 5/3/2018
Exists online : False
Views : 169