What is IaaS?

Infrastructure as a Service

Imagine owning a luxury car with free maintenance and low monthly payments. That’s Infrastructure as a Service (IaaS) in a nutshell when it comes to Enterprise computing. Organization can now enjoy the benefits of utilizing state of the art computing resource in a virtual environment.

The cost savings Organizations benefit from include power, cooling and maintenance in addition to other tangible savings. Small and medium size businesses can scale their infrastructure in accordance with their growth and business needs with cloud IaaS.

Business and consumer are relieved from the physical infrastructure responsibilities that are associated with owning and maintaining computing hardware.

With IaaS you rent cloud infrastructure- servers, storage and networking based on your needs and a variety of different payment options are available.

Imagine moving or relocating offices without system downtime, which can cost a business thousands of dollars in potential business and revenue.

Hosted Microsoft Dynamics AX, Dynamics GP and Dynamics CRM are great candidates for IaaS.

Manage your accounting, finance and operations with Microsoft Dynamics combined with a hosted IaaS platform can transform your business to achieve measurable results.

A recent survey of small and midsize businesses found that companies are looking to technology to provide and seek a competitive advantage. More than half of the companies admitted that technology is critical to their company’s future.

Create a competitive edge with IaaS and Microsoft Dynamics …. Do more, grow faster.

This article was written by Osei Owusu, Technical Consultant for  Tridea Partners. Tridea is a leading Microsoft Dynamics provider. www.trideapartners.com

Dynamics GP: FRx Migration to Management Reporter

In Microsoft Dynamics GP,  FRx has a Management Reporter (MR) migration wizard that will bring over reports into the new Management Reporter system. With a FRx migration, formatting usually comes over clean, but there are other differences between how this data is shown within the Row and Tree formats that may need some manual intervention.

In FRx, only the account number were referenced in the Financial Dimension link column within the row format.

FRx example:

15000

FRx ranges were indicated as follows:

(11511 TO 11599)

In MR, they reference the account segment name as well. When indicating a range, TO is no longer used.

MR example:

+Main Account = [15000]

MR ranges are indicated as follows:

+Main Account = [11511:11599]

The best way to quickly update these, is to copy the entire Financial Dimension column into Excel. First, do a find and replace for parenthesis and replace with brackets. Find ‘(‘ and replace with ‘[‘. Find ‘)’ and replace with ‘]’. Next, add a column for the plus (+) or negative (–) sign, the account segment name and the equal sign (=). Add the closing bracket in a separate column and then concatenate all three columns together to form what is shown in the examples above.

HINT: When entering ‘+Main Account = ‘ in Excel – it will give you an error because it thinks it is a calculation. Enter an apostrophe (‘) prior to the plus sign and it will recognize it as text.

This will get you most of the way there! Unfortunately there can still be some issues with the codes used in the Format Code column. In addition to replacing the TO with a colon as shown above, we often times need to update the TOT code as well. TOT was used a lot in FRx, but if we are adding two totals together in MR, we need to use the CAL format code and update the row references to include an ampersand (@) prior to the number.

FRx example:

TOT                       520 TO 820

TOT                       1480 + 1690

MR example:

TOT                       520:820

TOT                       @1480+@1690

Hope this helps everyone update their MR reports! If you need help updating MR reports, Tridea Partners would be happy to help! Our team has decades of experience in Dynamics GP!

This article was written by Kaydee Baker, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider serving CA, AZ, UT, CO, New England and surrounding regions.

 

Focus on Your Company’s Future, Let Dynamics GP Focus on Accounting Tasks

How can Microsoft Dynamics GP help you spend less time focusing on individual accounting tasks, and more time focusing on your company’s growth and future planning?  Dynamics GP can help you automate some processes, minimizing data entry error and allowing expenses to be effectively tracked and reported.

Here are a few items in Dynamics GP which can assist with efficiency and accuracy.

  1. Setup Control Account Management. This feature allows the company to determine which account segment to use for analyzing payables or receivables information.
  2. Assigning Accounts in Vendor and Customer Cards.  In customer and vendor cards, there is an option to enter in GL accounts and payment terms.  This enables GP to automatically populate distributions resulting in more accurate reporting and reduced processing time.
  3. Establish Variable Allocation Costs and Fixed Allocation Costs.  Variable Allocation and Fixed Allocation costs can reduce data entry errors and improve expense reporting. Costs can be distributed based on unit accounts such as square footage or number of employees.
  4. Workflow. GP’s workflow feature can establish approval settings for items such as purchase orders and batches.  A company may have multiple approvers, or may have approval settings based on amounts.

To learn more about these features, reach out to Tridea Partners and let us help you improve your business processes so you can focus on your company’s business strategy!

This article was written by Teresa Cortez, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider. www.trideapartners.com

Change User Defined Labels on Sales Transaction Entry Window

In  Microsoft Dynamics GP– Go to Sales > Setup > Sales Order Processing

In the Sales Order Processing Setup window, click on the User-Defined button.

Dynamics GP Sales Transaction Entry window

 

In the Sales User-Defined Fields Setup window, you can type in a label name for any of the User-Defined Entry fields and those will show on the Sales Transaction Entry window.

Dynamics GP Sales Transaction Entry window

 

Open the Sales Transaction Entry window, by going to Sales > Transactions > Sales Transaction Entry. Click on Go To and select User Defined.

Shannon 07 # 3

The User-Defined labels now reflect the changes you entered in the SOP setup window.

Dynamics GP Sales Transaction Entry window

This article was written by Shannon Hernandez, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider. www.trideapartners.com

 

Automating Conversion to Standard Cost in Dynamics GP

Tridea had a request from a customer to help change their Inventory Evaluation Method from Average Perpetual to Standard Cost. This would involve Dynamics GP implementations in three different countries over a weekend for over eight thousand inventory items for each country. When the Evaluation Method is changed in GP you cannot have any allocated transactions for the inventory items. The customer was able to complete all Transfers and Purchase Orders before the conversion weekend; however Sales Orders were a different story. The customer could not close their Sales Orders as they loan out medical devices for surgeries keeping the orders open until a surgery is complete. So in order to process the change in Evaluation Method the lines on the Sales Orders would need to be deleted then added back after the costs and method were updated. Due to the timing and volume of the data, that would not be possible to do manually. Our solution was to create a custom Windows Application that would step the user through the conversion process and automate the changes to the GP data. The Application performed the following tasks:

  • Bring in the new Standard Cost from SAP and allow the customer to add any missing costs
  • Copy the lines and all related data in the Open Sales Transactions to temp tables
  • Delete all the lines on the open Sales transactions through eConnect
  • Confirm that no open or allocated inventory transactions existed in GP
  • Update the Standard Cost of the inventory items in GP through eConnect with the new Standard Cost brought in from SAP
  • Direct the user to switch the evaluation method in GP
  • Confirm that all the items were now on Standard Cost
  • Direct User to Run the HITB Reset Tool
  • Bring the SOP lines and related data back into GP using eConnect and temp tables

The customer was able to run the application for all three countries concurrently. The whole process took about 6 hours per country.

This article was written by Patti Vuz, Dynamics Technical Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider in the United States.