Home » Listing Details
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 400 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Dynamics CPM
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
| ID: | 9890 |
| Title: | Do Your Variable Allocation Accounts Vary Too Much? |
| URL: | http://computerationdynamics.blogspot.com/2009/02/do-your-variable-allocation-accounts.html |
| Description: | Addendum 6/24/2009 Key to this process working, the holding account must have an entry posted to it monthly. If a holding account balance is zero, the recurring clearing journal will not post. First an understanding of Dynamics GP’s allocation accounts (skip to “The Issue" if you understand GP allocation accounts) : Allocations help you spread overhead expenses based on revenue, cost of sales, units sold, square footage, employee count, or other deciding factors. There are two types of allocation accounts: Fixed Allocation and Variable Allocation accounts. Fixed Allocation accounts are straightforward with fixed percentages used to spread entries. An example would be to allocate a CEO’s salary between two locations with 40% against one location and 60% against the second location. Variable Allocation accounts spread entries based on the total percentage of breakdown accounts. An example would be to allocate a CEO’s salary between locations based on revenue per month. The Issue We find companies dislike that they have no audit trail of the entries through the allocation accounts. And they prefer to use period-to-date allocations, but they want the system to compute one percentage per month. An Example I'll use a simple format and example accounts: LL-AAAA represents a Location-Account format. We're going to allocate the CEO's salary. We select Location 90 as "owners and officers," location 95 as our allocation designator, and 2 store locations, 10 and 20. We want to allocate the salary based on revenue from the stores. That revenue accumulates throughout the month in the sales accounts 10-4000 and 20-4000. Account 90-5000 is a regular posting account named Executive Salary Holding Account. Gross salary is posted here each payday. Accounts 10-5000 and 20-5000 are regular posting accounts named Allocated Executive Salary. Account 95-5000 is the Variable Allocation Account named Executive Salary Variable Allocation. The Distribution Accounts are 10-5000 linked to the Breakdown Account 10-4000 and 20-5000 linked to the Breakdown Account 20-4000. Setup a Clearing Journal marked to clear the balance for "Trx Period." Attach it to a Batch Header marked to recur monthly. When the Clearing Journal is posted, it moves the balance of 90-5000 through 95-5000 to 10-5000 and 20-5000, based on the month-end percentage allocation the system computes between 10-4000 and 20-4000. This leaves a nice audit trail of a debit and credit in account 90-5000. It arrives at a good compromise between Variable and Fixed Allocation accounts. It leaves an audit trail which the standard use of allocation accounts doesn’t leave. The setup of the Clearing Journal is completed only once as long as the batch header is marked to recur monthly with no limit set to the number of recurring postings.  |
| Category: | TIPS AND TRICKS BY MODULES: GL (General Ledger) |
| Link Owner: | |
| Date Added: | June 17, 2010 05:10:52 AM |
| Number Hits: | 26 |
Latest links
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Attachment Reminder feature in Outlook 2013
- Taking Your Financial Reports to the Next Level with Management Reporter – Quarterly Tax Form (7 of 8)
- GP 2013: Why are my SmartLists not formatted when exported to Excel?
- Using Sparklines & Data Bars to Visualize Data in SQL Server Reporting Services Reports
- More Funny Microsoft Videos
- Technical Tips for Management Reporter 2012 with Data Mart | Dynamics GP Insights
- Taking Your Financial Reports to the Next Level with Management Reporter – Statement of Cash Flows (6 of 8) – Dynamics Corporate Performance Management – Site Home – MSDN Blogs
- Book Review: Instant Creating Data Models with PowerPivot How-to
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.