Showing posts with label Tips and Tricks. Show all posts
Showing posts with label Tips and Tricks. Show all posts

Monday, November 16, 2009

Weekly Tip's




  1. Correct Journal Entries


  2. Account Rollups


  3. Macro Basics


  4. Auto Populate Account Descriptions


  5. Free Your Data With Excel Reports


  6. Let Smartlist Alerts Warn You


  7. Limit Records to Speed SmartList Processing


  8. Reconcile Bank Account Daily


  9. Speed up the Populate of the JE numbers on the Correct / Copy Journal Entry Screen


  10. Track Use Tax in Payables or P.O.'s


  11. Fix Your Auto Complete


  12. Leverage the List View for Reporting


  13. Sub-Ledger Reconcile - V10


  14. Backup, Backup, Backup


  15. Protect yourselft with Account Security


  16. Budgets Can Now be Tracked across Years


  17. Reduce the time it takes to create and distribute reports


  18. Copy a Journal EntryUse Account Aliases


  19. Prioritize Your Vendors


  20. Use the new Historical Inventory Trial Balance Report


  21. Business Alerts

Tip of the week from Brenda Hopkins – Week 22

Business Alerts

Business Alerts can be used to setup a notification when a set of defined conditions are met. These conditions can be defined on a specific database.

Business Alerts takes advantage of the query features of Microsoft SQL Server to monitor your data for specific conditions. For example, suppose that you want to be notified when a customer’s credit limit has been exceeded. In that case, you can use the Business Alert wizard to create a query that compares the credit limit amounts to the current amounts for your customers.

You can use the wizard to set up the schedule for the alert—that is, when, how often, and for how long you want Microsoft Dynamics GP to check whether the conditions you’ve defined exist. You also can specify a list of people to notify when those conditions occur.

You can create an unlimited number of business alerts, combining information from any of the tables in company or system databases. For example, you can compare the outstanding commissions per salesperson from the sales tables to commissions paid in the payroll tables.

Once you have created and enabled a business alert, the conditions will be checked according to the schedule you set up. Whenever the alert condition is found, an e-mail message is sent to the people or groups that you specified or a task is created for the user that you specified.

You can use any of the notification methods supported by your messaging system with Business Alerts. For example, you can notify alert recipients e-mail. You also can create tasks that will be displayed on their home pages and their task list whenever an alert condition is found.

Alert schedule and notification
Use the Schedule and Notification window to modify when, how often, and for how long Microsoft Dynamics GP will check whether the business alert conditions exist. Microsoft Dynamics GP will check your data for the conditions specified in the business alert formula at the intervals you set up here. You also can add or remove e-mail addresses or user IDs from the list of recipients for this business alert.





Wednesday, September 30, 2009

To Tweet or not to Tweet: Can Social Networking Channels Enhance or Hinder you CRM Initiative?

 

By Michael Dodd, BroadPoint Consultant

At first I was skeptical of Twitter. From what I read, the term “micro-blogging” seemed to me to be a fancy word for SMS message (even less so, seeing as you cannot exceed 140 characters). When I first started reading about Twitter in the New York Times, the thought of “Tweeting” seemed rather silly and solipsistic, not to mention somewhat unprofessional. However, 5 years ago I felt the same way about the blogging and Instant Messaging. But once these 2 social fads matured, they became an invaluable tool for professional internet communities.

Discussions about integrating Social Networks in Dynamics CRM is not a new concept. If you Wikipedia Social Media, you’ll find that almost anything in an online, user created context can be considered “Social Media” which can be used in a networking context.

And as history will show, it’s the simplest uses of web-based media that makes it into long lasting, mainstream networking channels (Newsgroups, IM, blogs).

So it came as no shock when I discovered that the new addition to the Dynamics CRM Accelerator for Social Networking’s primary focus was on Twitter. My skepticism in the use of Twitter as a CRM worthy social networking tool revolves around the fact that is has a distinct lack of structure. Yet it’s simplicity is undeniably its biggest asset.

So, despite my skepticism (and due in no small part to a recent update to my iPhone’s IM+ application which now includes Twitter integration) I decided to kick the tires. After all, how can I criticize that which I have not yet tried? It seems I have a duty to embrace all new forms of web based media.

Well, it’s been 2 months since I started using Twitter and I’m still skeptical.

How do you begin to use that information effectively?

Organizations that fit the B2C model probably have the most to benefit.

When used properly, social media can be a targeted approach to getting instant feedback from your clients.

First and foremost, anecdotal data (narrative text), it is subject to interpretation, bias, and inconsistencies. But the nature of Social Media anecdotes presents a number of potential pitfalls when used in the context of CRM:

1.) Visibility and transparency: Your are just as transparent as your clients. Transparency allows for more agile communications, but may also expose aspects of your business that are better handled 1 on 1.

2.) Anecdotal data from a social media source can prove difficult to compile/analyze: Whether verbose or succinct, it is difficult to aggregate Text data and even more difficult to report on it. How would you filter this data and under which CRM entity would it be stored? How will the user be able to relate this data to a pertinent CRM record? How will you organize the wealth of data that comes from LinkedIn discussions or Facebook status updates? Who will maintain this data?

3.) Reliability: Anecdotal data can be skewed by your own personal interpretation. So the key questions when it comes to integrating this data into Dynamics CRM is who will have access to this data and how will it be used? As a business process, who will be responsible for making decisions on such matters?

4.) Inconsistent Updates: Obviously, people using social media feel different things at different times. What they expose in a tweet one day may be recanted the next. Moreover, the nature of social media does not require one to be vigilant in their documentation. I may hate the service at XYZ restaurant and then Tweet about it. But the next day, I may have a splendid experience with XYZ Restaurant, but I have no obligation to update my view point the next time I tweet. How can such "Mood Ring" data prove a reliable source of personal information?

5.) One’s Social Persona is not their Professional Persona: People behave differently in their social life. Some tend to be bolder in what they Tweet than what they would say in person. And they don’t always think in a professional manner when they post on social media site the way they do when they write an email (or a blog article). It’s nice to know the social demeanor of your customer, but is this really going to be useful in a professional setting? Moreover, Is the information divulged in a social context appropriate for your next conversation? Finally, albeit public, would you customer feel comfortable that you’re monitoring their social (internet) life?

6.) Finally, will your company is your engagement in your client’s social media going to be a two-way street? If so, how do you present yourself in such a forum, knowing that you’re also speaking for your company when you speak with your client.

I would take a step back and think hard about using Social Media in your business endeavors. Twitter may not be the best place to gather insight into your clients. While it seems like an clever method of personal business intelligence, you need to consider:

Is it reliable?

Is it appropriate?

Is their significant ROI over traditional intelligence gather (face to face

Some people will take their clients out to lunch or to dinner and have good time, share personal information. But would they really want you to leverage that information in a professional setting? Moreover, how would that person feel about passing that information along to your entire company in CRM? This information could easily be misused by the wrong person.

Potential Challenges:

1.) Whimsical: Sometimes, it takes me up to a half hour to construct a Tweet. Sometimes less than a minute.

2.) Responses and tweet “chains”

3.) Tweets can be hard to analyze: For eg, “AT&T frustrates me to no end”. How would one respond to this tweet? Can we afford to spend the personnel hours to continue to follow this tweeter for more information? What if the user was simply having a bad day and takes it out on AT&T?

4.) Analysis of “soft” data can be subject to interpretation.

5.) What type of algorithm can dictate a meaningful tweet (eg, data that can be acted upon to increase sales, maintain satisfaction, solve an issue, gain insight, find useful suggestions, etc.

6.) Volume can be distracting.

Tuesday, September 15, 2009

Help with the MMREF format for Virginia Employment Commision

By Tunesia Winn

Have you received a notice from The Virginia Employment Commission (VEC) stating that as of 1/1/09 if you have more than 100 employees you are required to electronically file magnetic media and the wage information must be in the MMREF format for the quarterly VEC report?

If so you among hundreds of others getting this notification. The VEC is now mandating this and taking actions on those not in compliance. We’ve received emails and calls for quite a few clients in regards to whether it can be accomplished within MS Dynamics GP. While GP does not have the capability to complete the task, MS works with a 3rd party vendor, Greenshades that has a product to suit your needs. It’s called the State Filing Package and its cost is dependent upon the # of states in which you file.

Because of the high # of inquires we’ve received, we have reached out to Greenshades to provide discount pricing. They have approved a 15% discount on all State Filing Packages for BroadPoint clients only.

Please let me know if you would like more information and we can setup a time to chat.

Tuesday, September 8, 2009

Tip of the week from Brenda Hopkins – Week 21


Use the new Historical Inventory Trial Balance Report

The new Historical Inventory Trial Balance (HITB) report is designed to help balance inventory to the GL regardless of the inventory valuation method.

The Historical Inventory Trial Balance (HITB) report shows your inventory value as of a specific date or date range and the value of the five different quantity types. You can use this report to tie your inventory balance to General Ledger based on a specific date.

If you want to use this report, you will need to use the HITB reset Tool for Microsoft Dynamics GP 10.0, Service Pack 2.

In order to track historical inventory information a new table was added in Dynamics GP 10.0, Service Pack 2. The tool will populate this table and it will also find a starting point where the value of your Inventory and General Ledger are the same.

Before running the tool, you will want to complete the process on a test company first.

Contact BroadPoint for help downloading this tool.

Tuesday, September 1, 2009

Tip of the week from Brenda Hopkins – Week 20

Prioritize Your Vendors
  • Payables Management includes a 3 digit alphanumeric field used to prioritize vendors.


  • A simple ABC is generally more effective than a bunch of 3 digit numbers
    For example: If you are a Newspaper Company ‘A’ could be used for highest priority vendors like a newsprint supplier.


  • Use this to actively decide which vendors are critical now, not when a crisis hits.


  • This field can be used to select vendors during he check selection process.

    Cards > Vendor > Options
    Payment Priority Field

Monday, August 24, 2009

Tip of the week from Brenda Hopkins – Week 19

Use Account Aliases

Account Aliases are shortcut names for accounts and are setup in Cards > Financial > Account.

In transactions, instead of entering an account, click the blue arrow next to the account tile and enter the alias. If you're using a long account structure, aliases provide a quicker method of data entry.



Thursday, August 20, 2009

On Demand FastPath Webinars due to popularity

By Nadia Isata, Account Manager, BroadPoint Technologies

BroadPoint will be conducting a second on demand FastPath webcast for select customers, since the first was extremely popular. This webcast will show how Fastpath Audit Trail offers superior performance and configurability. Within a few hours, you can quickly know what was

changed, who changed it and the before and after values.

* Tracks changes made from inside Dynamics and external sources

* Extensive list of audit trail templates

* Quick implementation and ROI

* Best available performance and reporting for Microsoft Dynamics

Fastpath Config AD moves all user management to the IT help desk and eliminates potential security conflicts by taking all user administration out of Dynamics.

* Eliminates use of 'sa' and Administrator for better security management

* Streamline new hire, termination, and user change management.

* Fastpath has the only single sign on product for Dynamics GP

* Decrease user maintenance costs by 65%

Sessions will be scheduled on demand.  If you would like to attend, please contact Nadia Isata at nisata@broadpoint.net or at (301) 634-2403.

Monday, August 17, 2009

Tip of the week from Brenda Hopkins – Week 18


Duplicate a Journal Entry


Let’s say that last month you keyed a journal entry that was 100 lines long. Then next month, you find out that you need to enter this same journal entry again this month but with a few changes. Is there an easy way to key it again? Even with a few changes?

SURE!

By using the Copy a Journal Entry functionality found in Transactions>Financial>General>Copy.

In version 8.0 Microsoft introduced Journal Entry corrections and copies. You now have the ability to copy a journal entry, easily.


In Transactions->Financial->General, select Copy
You now have an option to Copy a Journal Entry.


You will need the Journal Entry number (you can look it up) and year of the entry you want to copy.


**The look up on the JE Number can be time consuming; it would be faster if you know the Journal Entry Number.



By default, Copy only works for transactions that originated in the General Ledger. However, the administrator can change this behavior.

Tools>Setup>Financial>General Ledger now has new check boxes to control this functionality.

Voiding/Correcting of Subsidiary Transactions
Mark this option to allow transactions originating in other modules to be copied in General Ledger.

Tuesday, August 11, 2009

ASP:Menu will not work with IE8 / Chrome / Safari.

An iMIS Tips and Tricks by Venketesh Subramony

Consultant, BroadPoint Technologies

Please add this in Master Page

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" >

protected override void AddedControl(Control control, int index)
{
if (Request.ServerVariables["http_user_agent"].IndexOf("Safari", StringComparison.CurrentCultureIgnoreCase) != -1)
{
this.Page.ClientTarget = "uplevel";
}
base.AddedControl(control, index);
}

Also use the Browsercap in webconfig

<system.web>
<browserCaps>

<!-- GECKO Based Browsers (Netscape 6+, Mozilla/Firefox, ...) //-->
<case match="^Mozilla/5\.0 \([^)]*\) (Gecko/[-\d]+)(?'VendorProductToken' (?'type'[^/\d]*)([\d]*)/(?'version'(?'major'\d+)(?'minor'\.\d+)(?'letters'\w*)))?">
browser=Gecko
<filter>
<case match="(Gecko/[-\d]+)(?'VendorProductToken' (?'type'[^/\d]*)([\d]*)/(?'version'(?'major'\d+)(?'minor'\.\d+)(?'letters'\w*)))">
type=${type}
</case>
<case> <!-- plain Mozilla if no VendorProductToken found -->
type=Mozilla
</case>
</filter>
frames=true
tables=true
cookies=true
javascript=true
javaapplets=true
ecmascriptversion=1.5
w3cdomversion=1.0
css1=true
css2=true
xml=true
tagwriter=System.Web.UI.HtmlTextWriter
<case match="rv:(?'version'(?'major'\d+)(?'minor'\.\d+)(?'letters'\w*))">
version=${version}
majorversion=0${major}
minorversion=0${minor}
<case match="^b" with="${letters}">
beta=true
</case>
</case>
</case>

<!-- AppleWebKit Based Browsers (Safari...) //-->
<case match="AppleWebKit/(?'version'(?'major'\d?)(?'minor'\d{2})(?'letters'\w*)?)">
browser=AppleWebKit
version=${version}
majorversion=0${major}
minorversion=0.${minor}
frames=true
tables=true
cookies=true
javascript=true
javaapplets=true
ecmascriptversion=1.5
w3cdomversion=1.0
css1=true
css2=true
xml=true
tagwriter=System.Web.UI.HtmlTextWriter
<case match="AppleWebKit/(?'version'(?'major'\d)(?'minor'\d+)(?'letters'\w*))(.* )?(?'type'[^/\d]*)/.*( |$)">
type=${type}
</case>
</case>

<!-- Konqueror //-->
<case match=".+[K|k]onqueror/(?'version'(?'major'\d+)(?'minor'(\.[\d])*)(?'letters'[^;]*));\s+(?'platform'[^;\)]*)(;|\))">
browser=Konqueror
version=${version}
majorversion=0${major}
minorversion=0${minor}
platform=${platform}
type=Konqueror
frames=true
tables=true
cookies=true
javascript=true
javaapplets=true
ecmascriptversion=1.5
w3cdomversion=1.0
css1=true
css2=true
xml=true
tagwriter=System.Web.UI.HtmlTextWriter
</case>

<!-- Opera //-->
<case match="Opera[ /](?'version'(?'major'\d+)(?'minor'\.(?'minorint'\d+))(?'letters'\w*))">
<filter match="[7-9]" with="${major}">
tagwriter=System.Web.UI.HtmlTextWriter
</filter>
<filter>
<case match="7" with="${major}">
<filter>
<case match="[5-9]" with="${minorint}">
ecmascriptversion=1.5
</case>
<case>
ecmascriptversion=1.4
</case>
</filter>
</case>
<case match="[8-9]" with="${major}">
ecmascriptversion=1.5
</case>
</filter>
</case>
<case match="Chrome/(?'version'(?'major'\d+)(?'minor'\.\d+)\.\d+.\d+)\sSafari/\d+\.\d+">
browser=Chrome
version=${version}
majorversion=${major}
minorversion=${minor}
</case>
</browserCaps>
<system.web>

Monday, August 10, 2009

Tip of the week from Brenda Hopkins – Week 17


Reduce the time it takes to create and distribute reports


SQL SERVER REPORTING SERVICES (SRS) helps summarize your data in Web-based charts and graphs. Build reports to support specific business activities, and share vital information across your organization.

Access reports easily from within Microsoft Dynamics GP or the Web. Let users log into the web site and access reports themselves, these reports can be printed or exported to excel.


ONLINE VIEWS offer forecasting insights that are easy to share across your organization or with designated vendors or contractors.

Microsoft SQL Server Reporting Services offers over 60 reports, you can use these sample reports either as-is or as templates for designing new reports.

Examples:
  • General Ledger Detail and Summary Trial Balance Reports.
  • Receivables Aged Trial Balance Report and Detail Historical Aged Trial Balance Reports.
  • Payables Aged Trial Balance Report and Detail Historical Aged Trial Balance Reports.
  • Open Purchase Orders Report: Purchase orders that have not been closed or canceled per vendor or for all vendors, including list views for the number, status, and date of each purchase order, assigned vendor, and line item detail.
  • Open Sales Orders Report: Unposted sales orders for a range of customers, including list views for the sales order number and date, customer information, requested ship date, amount remaining, assigned salesperson, and line item detail.
  • Customer Profitability Report: Sales, total profit, and gross margin percentage per customer for the selected year. Expandable customer ID offers a view of sales, total profit, and gross margin percentage by document number.
  • Inventory Value by Site Report: Bar graph of the value of inventory by site and the total inventory value for the company. Clickable inventory site bars display Inventory value by Site. Use the Item Number Report to view items and their total value for that site.
  • Item Quantity Back Order Report: Quantity of items that are back ordered, quantities allocated to purchase orders, and item quantities available for all sites.port to view items and their total value for that site.
  • Employee wage and Hour Report: Employee Pay Codes with hours and wage for each pay code.
  • Employee Pay History Report: Select Pay Codes and Departments to include showing historical employee pay history.
  • Employee Earnings Register: Snap shot of employee summary earnings.
  • Department Wage and Hour Report: Select departments and Pay Codes to include, hours and total paid for each department.

Thursday, August 6, 2009

Write a WebService using your notepad

 

An iMIS Tips and Tricks by Venketesh Subramony

Consultant, BroadPoint Technologies

 

You can write a webservice using a notepad editor. Also you can test this using your browser.

You can even test the webservice by browsing the asmx page in the browser.

<%@ WebService Language="C#" class="MyWebService" %>

using System;

using System.Web.Services;

using System.Web;

using System.Web.MySecureInfo;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

public struct MyInfo

{

public string variables;

}

[WebService(Namespace="http://microsoft.com/webservices/")]

public class MyWebService : WebService

{

private MyInfo MySecureInfo;

public MyWebService()

{

MySecureInfo.variables = "";

}

private void AssignValues(string variables)

{

try

{

// your code

}

catch

{

MySecureInfo.variables= variables;

}

}

[WebMethod(Description="This method call will get the company name and the price for a given MySecureInfo pID.",EnableSession=true)]

public MyInfo GetMyInfo(string pUserid,string pPassword)

{

AssignValues(pUserid,pPassword);

MyInfo MySecureInfoDetails = new MyInfo();

MySecureInfoDetails.variables = MySecureInfo. variables;

return MySecureInfoDetails;

}

}

Tuesday, August 4, 2009

Webservice Easy to implement using JQuery.

An iMIS Tips and Tricks by Venketesh Subramony
Consultant, BroadPoint Technologies

The jQuery code is very simple and easy to learn.

Here are the features of jQuery

1. DOM element selections functions

2. DOM traversal and modification

3. Events

4. CSS manipulation

5. Effects and animations

6. Ajax

7. Extensibility

8. Utilities - such as browser version and the each function.

9. JavaScript Plugins

POST Method

function InfoByDate(sDate, eDate){
var divToBeWorkedOn = '#AjaxPlaceHolder';
var webMethod = 'http:// WebService/Web.asmx/GetInfoByDates'
var parameters = "{'sDate':'" + sDate + "','eDate':'" + eDate + "'}"
$.ajax({
type: "POST",
url: webMethod,
data: parameters,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(msg) {
$(divToBeWorkedOn).html(msg.d);
},
error: function(e){
$(divToBeWorkedOn).html("Unavailable");
}
});


GET Method

$.get("http://doman.com/webservice.asmx", { name: "John", time: "2pm" },
function(data){
alert("Data Loaded: " + data);
});

Monday, August 3, 2009

Tip of the week from Brenda Hopkins – Week 16

Budgets Can Now be Tracked across Years

There are times when a fund or grant does not start on the first day of the fiscal year or end on the last day of the fiscal year. The life of the fund or grant sometimes also crosses over fiscal years. This feature provides the ability to budget based on a start and an end date in Microsoft Dynamics GP Release 10.0.

Not for Profit and Public Sector organizations often have the need to track funds and grants to associate expenses against money received. Funds are typically tracked as a segment of the General Ledger account segment in Microsoft Dynamics GP, and grants are often tracked as a Transaction Dimension Code within Analytical Accounting.

A few changes have been made to the budgeting windows in Microsoft Dynamics GP Version 10 to accommodate the ability to enter budget start and end dates. The Budget Maintenance window was updated with these changes.


Cards > Financial >Budgets

To enter start and end dates for a budget, you will need to select the Date Range in the Based On field.

If Fiscal Year is selected in the Based On field, budget functionality works as before, and no budget start and end date can be entered.

Budgets created in the Single Account Budget Maintenance window, using the Budget Wizard for Excel or in Analytical Accounting Budget Maintenance can also be based on a fiscal year or date range and allow for start and end dates to be entered for budgets.

Monday, July 27, 2009

Tip of the week from Brenda Hopkins – Week 15


Protect yourself with Account Security


  • Account Security limits the accounts that users can access.
  • It requires setup via Organizational Structure.
  • If you don’t set up Organizational Structures prior to turning this on, it appears that the chart of accounts has been wiped out.
  • Know what you are doing before activating this.

Account security is designed to work with the Organizational Structure feature to limit access to certain accounts. Some organizations have a very complex account structure and it makes picking the right account easier if you limit a department to only be able to see their own accounts.

Organizational Structure provides information to define as many as four layers of structure within your business, and then to set up specific divisions, departments or other organizational groups. You can create relationships among different groups. You can assign accounts and users to different parts of the organizational structure.

Account Security is turned on with a check box in Tools->Setup->Company->Company.



You can see in the example below that this user is only allowed to see Department ‘200’ only.








Monday, July 20, 2009

Tip of the week from Brenda Hopkins – Week 14



Backup, Backup, Backup




If you are not backing up use the built in backup functionality in Microsoft Dynamics GP. This won’t get everything, you will still need to backup custom reports and forms, the Integrations Manager database and FRx reports, but backing up the database is a good start.

Dynamics GP 9.0 and 10.0 allows you to schedule backups from within the application. You'll need to be logged in to GP as an administrator and you'll need to be on the server.

Go to File> Backup [v9] / Maintenance > Backup [v10]

Enter the system password if you've set one.
When the backup window opens, pick Schedule.




  • Name the backup schedule
  • Pick the database to backup or backup the system databases
  • Enter the backup path (this must be a path on the local server)
  • Select the days to backup and the time. The time is entered is in a 24 hour format
  • Pick how often to delete old backups
  • Click Save. SQL Agent MUST be running when you click save

This process creates a job in the SQL agent with the information entered. You'll still need to move the backups off the server for real protection, that's easy with today's portable hard drives. There's no excuse for not backing up your Dynamics GP installation now.

Monday, July 13, 2009

Tip of the week from Brenda Hopkins – Week 13



Sub-Ledger Reconciler

Having issues reconciling the Payables Management or Receivable Manage sub-ledgers to the General Ledger? Version 10 has a new feature that helps with this.

Benefits:

  • Automatically match transactions for users
  • Identify any transaction discrepancies between the sub-ledger and the General Ledger

The Feature DOES NOT automatically do any of the below task to balance the sub-ledgers to the General Ledger:

  • Fix imbalances between the sub-ledgers and the General Ledger
  • Correct posted transactions
  • Back out posted transactions
  • Void existing transactions
  • Recreate new adjusting transaction

Reconcile to GL

You can select one or more Accounts Receivables or Accounts Payable Accounts from the General Ledger that hold the posted outstanding balances. The balance of all the accounts entered in this window is the amount to which the Sub-ledger balance is reconciled against.

For example you could have the Accounts Payable account and the Purchase Discounts Available Accounts.






Reconcile Process

The balances Include:

  • Beginning balances
  • The difference between the beginning balances
  • Transactions entered during the date range specified
  • The total ending balance
  • The difference between the ending balances

Microsoft Dynamics GP matches transactions from Payables or Receivables Management to the distribution line in the General Ledger.

  • Transactions that exist in both ether sub-ledger and General Ledger
  • Transactions that exist in either the sub-ledger or General Ledger, but not both
  • Transactions that potentially match, but don’t meet all the matching criteria


Reconcile Report


Analysis of the reconciliation results is an important aspect of the process. In order to provide the appropriate tools to perform an analysis the results are sent to an Excel spreadsheet. Excel provides the typical functionality of an spreadsheet.

You can save each spreadsheet to document your exceptions and how they were handled by adding a comment to your Journal Entry noting the action taken to fix the problem.













Newsgroups within PartnerSource

Hello BroadPoint Clients,

It’s me Tunesia Winn, VA Territory Account Manager. Have you looked for Newsgroups within PartnerSource lately?

If you are asking the questions:

1. Where are the unmanaged Newsgroups specifically for GP and FRX?

2. Why can a customer on a Business Ready Enhancement plan have access to Managed News Group?

The answer to the first and second question is that all managed groups are also unmanaged. In other words all managed and unmanaged users are now one and the same. If you post a question but do not receive an answer back from the MS Community within 24 hours a process will run notifying MS Support that the user has an unanswered question. Then MS Support will follow up with you.

Please take the time to visit CustomerSource, http://www.microsoft.com/dynamics/customersource.mspx. You will be able to find answers to your non-critical questions using this powerful tool!

If you do not have access and need assistance obtaining access to the site, please feel free to contact me or your dedicated Account Manager here at BroadPoint.

Thanks & Happy Searching!

Monday, July 6, 2009

Tip of the week from Brenda Hopkins – Week 12




Leverage the List View for Reporting


Have you ever scrolled through all report windows for a particular module looking for that special report that you know is there but you just can't find it? Something like the Historical Stock Status which is under Activity instead of History.
You can now search for a report, including all the options you have set for various reports.
V9 Select Reports >Report List
V10 Home >Administration>All Reports List

A box will come up with all the reports in the system. You can limit this list to various modules, search for reports and sort the list on the different criteria. From the Actions menu you can create new report options, review the option selections for a particular report and even import/export reports.








Monday, June 29, 2009

Inside Microsoft Dynamics GP


Have you checked out the Microsoft Dynamics GP community site? Online community sites are where you’ll find more relevant expert advice, FAQ pages, tips, interviews, live chats, webcasts, newsgroup threads, and RSS feeds—all designed to help you do your job better. This is an unsecure site that are open to all. Visit the Dynamics GP Community.

At the Dynamics GP community site, you can get the latest inside scoop directly from the Product Management & Marketing team! The Inside Dynamics GP section has always been chock full of great posts such as
Everyone, stop using the old navigation, please, but they have just started a weekly “Did You Know” series focuses on features and functions that already exist in Dynamics GP. This week they focus on the Historical Inventory Trial Balance (HITB) report. Ron Gressley, our Senior Consultant out of our D.C. offices says that this is his favorite place to go for insider information that even he didn’t know about.

Add this

Bookmark and Share