مدونة منذر اسامة

العودة   منتديات جريت بلينز العربية Great Plains For Arab > Non Arabic forum > English GP Forum

English GP Forum English Forum contain general topics about Microsoft Dynamics GP / Microsoft Business Solutions Great Plains Q & A
Any article will translate to Arabic language
سيتم ترجمة بعض المقالات التي يتم كتابتها في هذا المنتدى في مكانها المناسب في المنتديات العربية

إضافة رد
 
أدوات الموضوع انواع عرض الموضوع
قديم 28-Jul-2014, 08:41 AM   #1
as_radwan
عضو مميز
 
تاريخ التسجيل: Nov 2007
المشاركات: 256
من مواضيعي  
Post Tip # 2 - Get drilldown information with Account Rollups

Tip # 2 - Get drilldown information with Account Rollups
If you need to look at groups of accounts this is the inquiry for you. You can even perform calculations!
What is it?
Account Rollup is an inquiry that you build which allows you to see different GL accounts rolled up together. Additionally, you can perform calculations on those accounts.
We use this for all kinds of things like:
• What's the Fixed Asset total across all divisions?
• What's the commission allocation based on sales?
FRx will do this, but freqently, users don't want to launch FRx and run financial statements just to get a breakdown of FA accounts. So how does this work?
In Dynamics GP, select Inquiry->Financial->Account Rollup
Enter an Option ID, tab and click yes to add the option.
You set the number of columns you want to see up in the right side. If all you want is totals, one column is fine. For calculations, use at least 2 columns.
In the center, you set the types of columns, but we'll come back to that. At the bottom, you add criteria like accounts, departments, divisions, etc. UNLIKE OTHER GP criteria areas, you can multiple independent criteria here. So if you want to see Chicago and New York but not LA. You add Chicago, then add New York.
Save and click redisplay. Controls on the right let you see net change or period balance totals. If you want to see what makes up the total number, select a month and click the blue column header.
Now, to get really fancy, you can ad calculated columns to a rollup. Simply create or modify (with the button) a rollup.
Change the type from Actual to Calculated. In the Selection column, click the More Info button. In v8.0 this is a little arrow.
Let's say, a user accrues 8.9% of sale as a commission accrual. The first column is the monthly sales. So they'll pick the only available column in the column box and hit the double arrows (>>) then add the multiply sign (*) then in the constant box they'll add .089 and hit the double arrows (>>).
Your formula now looks something like C1 * 0.089. Save and refresh and you get a report with sales and the commission allocation for each month.
This is great for all those estimates you do every month. You can just take the numbers and do a JE.
a. Account Rollups let you consolidate information from various accounts and then be able to drill down into the account details.
b. Useful for things like departmental totals with drilldowns
c. Accounts do not have to be consecutive
d. Rollups can include Actual, Budget and Calculated information
What's DynamicsCare? DynamicsCare is a brand of services from Microsoft Dynamics GP Worldwide Partner of the Year, I.B.I.S., Inc. For more info go to www.DynamicsCare.com or call 800-251-4192.
__________________
هذا الموضوع عبارة عن بذرة تحتاج للنمو والتحسين؛ فساهم في إثرائه بالمشاركة فيه
[LEFT]Best Regards
Ahmed Ibrahim
I.T Manager
http://ahmedibrahim.net
Mobile: +2 010-3438385
Microsoft Certified Business Management Solutions Specialist for Microsoft Dynamics AX 2009,Dynamics CRM4,GP10
Microsoft Certified Business Management Solutions Professional Applications for Microsoft Dynamics GP10
MCTS: SQL Server 2005,Windows SharePoint Services 3.0
ITIL Foundation V3
as_radwan غير متواجد حالياً   رد مع اقتباس
إضافة رد


يتصفح الموضوع حالياً : 1 (0 عضو و 1 ضيف)
 
أدوات الموضوع
انواع عرض الموضوع

ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا يمكنك اضافة مرفقات
لا يمكنك تعديل مشاركاتك

BB code متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع

المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى مشاركات آخر مشاركة
مشكلة في Apply Account Payable 3mor2045 مناقشة المشاكل والأخطاء في برنامج جريت بلينز 7 14-Jan-2014 10:25 AM
اماكنية تطبيق الموديل Project Account داخليا awad313 جزيئ محاسبة المشاريع (Project Account) 5 01-Dec-2013 08:58 AM
Account currencies mero الجزيئ المالي
(GL - AP - AR – BM - FA - AC ... ets.)
8 20-Feb-2013 02:47 PM
what is the largest and smallest account in GP alwahidi22 الجزيئ المالي
(GL - AP - AR – BM - FA - AC ... ets.)
2 12-Mar-2012 08:24 AM
بعض الملاحظات حول برنامج الذمم المدينــة:- Account Receivable osamamakled الجزيئ المالي
(GL - AP - AR – BM - FA - AC ... ets.)
6 25-Dec-2011 12:38 PM


جميع الأوقات بتوقيت GMT +3. الساعة الآن 10:49 PM.


Powered by vBulletin® Version 3.8.3

الموقع والمنتدى من تطوير » شركة المنذر للاستضافة والتصميم

Copyright © 2000-2010 Jelsoft Enterprises Limited.
الموقع لا يمثل أي جهة رسمية بل هو جهد شخصي يرمي الى تجميع القدرات في برنامج جريت بلينز