Rose Business Solutions Dynamics GP

Archive for the ‘Dynamics GP’ Category

If you’re like most organizations, an automated sales tax solution is not one of your top priorities.  However, minimizing your risk for an audit is.  As sales tax rules and regulations continue to change and become increasingly complex, it is becoming more and more difficult to ensure compliance.  Couple that with the fact that the mere number of auditors is on the rise (an estimated growth of 22% according to the U.S. Bureau of Labor Statistics), and the realization is that sales tax should be a significant concern for just about any business.

On average, midsize companies spend over $40,000 of internal resources each year to try and achieve compliance.   And you can likely double that figure if you are one of the “unlucky” ones that falls subject to an audit.  Avalara’s cloud-based sales tax software can help you save both the time and money associated with an audit, while allowing you to focus on what really matters – your business.  Avalara’s AvaTax Suite works seamlessly with Microsoft Dynamics GP to reduce your audit risk by providing an end-to-end sales tax solution that makes it simple to calculate rates, manage exemption certificates, file forms and remit payments.

While there is no way to guarantee that you will never be audited, Avalara can provide your business peace of mind by providing up-to-date, accurate calculations, along with proper documentation for non-taxed transactions to ensure accurate sales tax returns.

To find out more about why businesses get audited and the typical areas of non-compliance, we recommend you attend a free educational webinar on Wednesday, February 29th at 11am PT, Evil Sales/Use Tax Audits vs. Find the Tax and Relax.  This webinar is part of Avalara’s recurring Sales Tax Management Thought Leadership Series.

Want to learn more?  Contact Rose Business Solutions to find out more about Avalara’s end-to-end sales tax compliance and automation solutions.

The folks over at the Dynamics Corporate Performance Management blog drew my attention to this video about the report scheduling functionality in Management Reporter.

Take a look at this video:

“Report scheduling offers a flexible and secure mechanism for automating the publishing of your financial reports from within Management Reporter. Report schedules are simple to setup and require little maintenance. In your business, Report scheduling can be used to eliminate the repetitive task of generating the same reports every day during the month end.”

MR 2012 Feature Overview – Report Scheduling

Let us send you new content automatically.

Simply select one or  more of the subscription options to the right.

These are the results of our January Poll:

So you want to modify a Dynamics GP Report Writer report. Do you feel lucky?

Report Writer is pretty easy to use. It’s pretty easy to modify existing reports.

Some people like it. Some don’t. And another from Mark.

But beware of corrupting the reports.dic file. Oh precious, you don’t know what that is?

Take a look at these:

The Achilles’ Heel of Dynamics GP

Recreating reports.dic in Dynamics GP

If you’re intrepid and barrel forward, take heed of Musgrave’s advice:

“My answer is simple and I have been saying for years. Don’t use shared Reports.dic. Use a synchronised one instead. See the article below for more info:”

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/08/20/automating-distribution-of-customisations-part-1.aspx

And if you want to see Harry in action, see it here (not for kids): http://youtu.be/daFb3J-cwLg

Do you feel lucky?

Hello everyone, I had a few weeks being tied out with projects, and trying to help everyone here in the office by solving issues and discovering bugs (not the rabbit).

But finally today I was able to spare some time and write about one of my favorite topics Dynamics GP.

 

Recently I was talking with my friends about movies, Yes!! my work allows me to have a life after 5 PM PST and weekends!!!. So one of the movies we were talking about was about: Journalist Mikael Blomkvist and how he is aided in his search for a woman who has been missing for forty years by Lisbeth Salander, a young computer hacker..

On one of the last scenes in the movie, there is a part where Lisbeth provides Mikael a folder with documents and financial records of a suspected criminal, to my surprise when the journalist was going over the papers he had the following prints:

 

As you can see, Dynamics GP along with mc2software, were shown on those documents, I waited until the end of the movie to see the credits, but I was unable to locate any reference to Microsoft or a VAR (in all honesty I was waiting for Ian Stewart MVP to appear but no he was not in the movie).

The movie is called “The Girl With The Dragon Tattoo” there are 2 versions one released in 2009 and another in 2011, I am referring to the 2009 movie.

 

Have a great day!!

The Dynamics GP Payroll module is a complete payroll processing module that allows you to maintain employee payroll information and process periodic payrolls for salary and hourly employees, with benefits and deductions, and tax calculations. We have many clients that run their payroll in Dynamics GP; ranging from 20 employees, to over 2,000.

I am not a payroll expert, so what follows is a quick overview of processing a salary payroll in Dynamics GP, where I deftly avoid the complicated parts and make it look like anybody can run payroll. The fact is that it takes a fair amount of Dynamics GP knowledge and a lot of non-system payroll knowledge to accurately run a successful payroll using Dynamics GP. We process our own payroll on Dynamics GP, but they don’t let me touch it.

These are the three basic steps:

1. Build Payroll Checks
2. Calculate Payroll Checks
3. Print Payroll Checks

These are the reports that print out. The system steps you through the process:

Here is a quick video that goes through the Dynamics GP Payroll Processing process: http://youtu.be/TfndeYhOpM8

The Inventory Available to Promise screen will give you insight into your current inventory situation for any item. For any item that you select in this screen you will see the supply and demand for the item in a time sorted list. You can drill back into any listed item to get more information.

The definition of Free-forward quantity is the total of available and pending quantities of an item, plus any additional quantities from purchase orders, assembly receipts, manufacturing orders, and sales returns displayed in the scrolling window. The total sum is reduced by the item quantities from unallocated sales orders, sales back orders, and unallocated manufacturing components displayed in the scrolling window.

There is a feature that allows you to forecast when a new specific quantity of the item will be available, and when you could start a manufacturing order to build the quantity, if needed. Here is a good example that shows the various attributes of the calculation, and displays the related transactions:

In this example I wanted to know when a quantity of 200 would be available. I entered 200 in the Required Quantity field, and the results show that there will be at least 200 available on 6/15/2017. By quickly reviewing the list of transaction you can see that the manufacturing order for a quantity of 8o is the limiting factor for this result. If you click on the Calc. Mfg. Date button, a report will run that shows you the items required for the manufacturing order. In this case the manufacturing order is waiting for a supply of Black Ink that will be delivered on 6/12/2017.

The Inventory Available to Promise screen is also accessible directly from the Sales Order Transaction Entry screen by clicking on the blue expansion arrow just to the right of the QTY Ordered field label.

Here is a soon-to-be ancient brochure from Microsoft. GP-Available-To-Promise

The Dynamics GP Fixed Assets module can easily depreciate assets and send that information to the general ledger. If you want to see what future asset depreciation will be you can run a depreciation projection report.

There are two steps to running the depreciation projection report:

1. Run the projection routine: Routines >> Fixed Assets >> Projection. Specify the date to which you want to run the projection.
2. Run the projection report: Reports >> Fixed Assets >> Projection. You can run the report at a summary or detail level, and show either annual or periodic depreciation amounts.

Depreciating the assets is simple. Just navigate to: Routines >> Fixed Assets >> Depreciate. Select the book(s) you want to run the depreciation for, and the “depreciate to” date. If you go back and look at an asset you will see the individual depreciation records created for each period.

Periodically you will want to transfer the Fixed Assets transactions to the general ledger. To do this, run the GL Posting routine: Routines >> Fixed Assets >> GL Posting. I generally specify 0000-000 as the beginning period to ensure that I pick up all transactions in the fixed assets system. You will want to be careful when you specify the Ending Period because this routine will only make one journal entry per run. So if you haven’t run this routine for awhile, you will want to run it separately for each period; starting with the earliest period first.

I have always liked the standard reports in the Fixed Assets module. The reports are basically lists of assets. These are handy to address requirements for financial audits and property tax returns. The Property Ledger is the one I find most useful: Reports >> Fixed Assets >>Inventory >> Property Ledger.

There are also three SmartList objects that are very useful. Each one has dozens of additional fields you can add as desired.

Here is a quick video about Dynamics GP Fixed Assets Depreciation and Reporting: http://youtu.be/Urd-wb54f_k

The Fixed Assets module in Dynamics GP is pretty easy to use. There are basically two screens that contain the asset and depreciation information. The General Information screen contains the descriptive information about the asset. The Asset ID is a unique key field in the database. It needs to be manually entered. You can specify location and custodian information if you want. There are 15 user defined fields available from the “Go To” button where you can record additional information about each asset.

You should set up Class ID’s to improve data entry speed and accuracy. You can also link Account Groups to Class ID’s and set your system up so that a default depreciation method and length of service are also defined when you add a new asset.

The asset book screen contains the depreciation information for each asset. You can specify as many depreciation books as you want. You will have at least one for your internal accounting needs. This one will link to your general ledger.

I recommend that you use the Book Class Setup screen to assign a default depreciation method and length of service for new assets when they are entered into the system.

The Fixed Asset module integrates with both the Purchase Order Processing and the Payables Management modules in Dynamics GP. If you plan on using Payables Management to enter fixed assets, you can set up one or more fixed assets clearing accounts to tie the payables invoice record to the fixed assets record. This will make the payables information for each new asset available to be turned into a fixed asset.

The Fixed Assets module is easy to use, and if you don’t already use it, you should try it out.

Here is a video to show Dynamics GP Fixed Assets in action: http://youtu.be/6biLxClmo3c