Microsoft Dynamics GP’s Project Accounting suite is a robust, highly configurable and flexible module which is fully integrated with other modules within the Dynamics GP product suite. The flexibility of configuration, setup and integration to other modules makes it an attractive choice for tracking financial data by contract, project and cost category. It allows you to maintain complete control over project costs and execution, while also maintaining control over project budgets.
Being a developer I often find myself in situations where I need to troubleshoot SQL queries that are not performing well and generally need optimizations. I would like to share some interesting tips on how SQL Server handles queries and what execution plans might be better than others. A query execution plan is an ordered set of steps that are used to access the data in SQL server. If you are working with SQL Server Management Studio once you have started a new query window click the following button (or CTRL + M) so you can enable execution plans. In the examples below I will be using tables from AdventureWorks database which is a sample database provided by Microsoft.
As accountants the end of the year accounting is a big deal. There are a lot of factors that go into the prep to make sure that everything gets accounted for prior to closing the books for a year. The most important step to being audit ready is to be prepared. Typically the documentation requirements for audits do not change year on year so you can use your documentation from the prior year as a guideline to get started. Here are some steps that you can take to verify that you are ready to close your year as well as prepared for auditors to come in and evaluate your books.
Nexus —the connection between a company and taxing jurisdictions that triggers a sales tax liability—gets thornier the faster your company grows. Surprisingly, more revenue can mean more complexity and potentially greater risk of sales tax audit (more money, more problems?).
Here are 5 areas of sales tax risk relating to business growth and what you can do to address them:
For many companies selling online, figuring out where to collect and remit sales tax requires the expertise and bandwidth of the Amazon legal department. Given that most companies don’t have access to those kinds of resources, this quick list will help determine whether you’re overlooking sales tax obligations.
1. Drop shipping
In some states, use of an in-state third-party shipper by an out of state retailer can trigger a sales tax obligation. In California, New York, Texas, and Florida for example, if a drop shipper delivers goods on your behalf, you could be obligated to collect tax.
Sales tax filing and reporting rules vary between jurisdictions in material ways. Each state has unique filing schedules, forms, payment thresholds and other administrative requirements that can trip you up. Here are some common filing and registration errors and what you can do about them.
Regardless of the report writer you are using, the most commonly asked question is, “How can I get my reports to print faster?” There are some options in the build of the reports that can help with performance. Here are my top five ideas on how to get your BI360 reports in running time!