Does your organization prefer technological upgrades?

If no then you should. Regular technological advances are the key for success of any organization and such upgrade decisions in an organization are basically taken care by the Top Management like CEO’s and CFO’s, as they are well versed with the right time  for implementing such changes.

If we talk about Chief Financial Officer’s [CFO’s] they are always trapped in-between data.  Lots of Data entry gives them a lot of burden and sometimes even creates confusion due to double Entry. DBSync works to resolve such kind of problems by reducing the double data entry for customers and increasing the visibility of multiple applications. Cloud Computing is one of the fastest growing fields according to a new Microsoft-funded survey it shows that spending on cloud deployment could double in the next 5 years.

Let’s have a look what these terminologies actually mean:

SaaS-Software as a Service, sometimes referred to as “on-demand software”, is a software delivery model in which software and associated data are centrally hosted in the cloud. SaaS is typically accessed by users using a thin client via a web browser.

Examples of common SaaS applications are:

• CRM (customer relationship management) systems such as Salesforce, Microsoft Dynamics CRM
• Intacct or NetSuite for Accounting
• Google Docs and Apps and many more

PaaS- Platform as a Service (PaaS) is a category of cloud computing services that provide a computing platform and a solution stack (a solution stack is a set of components needed to deliver a fully functional solution, e.g. A product or service.) as a service. In this model, the consumer creates the software using tools and libraries from the provider. The consumer also controls software deployment and configuration settings. The provider provides the networks, servers and storage.

An example of PaaS is Facebook.

• Force.com or database.com from Salesforce
• Microsoft XRM
• Intacct, NetSuite, Intuit – extension to standard accounting

iPaaS-Integration Platform as a Service iPaaS is a platform for building and deploying integrations within the cloud and between the cloud and enterprise. With iPaaS, users can develop integration flows that connect applications residing in the cloud or on-premise and then deploy them without installing or managing any hardware or middleware.

Example- DBSync (www.mydbsync.com)

IaaS- Infrastructure as a Service (IaaS) sometimes referred to as “hardware as a service”, IaaS is an outsourcing model under which users rent equipment accessed via the Internet to support their operations, including storage, hardware, servers and networking components. One of the most well known forms of IaaS is Amazon.com .According to a Survey it was projected that the overall market for dedicated hosting and cloud infrastructure-as-a-service (IaaS) could hit the $3.8 billion mark by the end of 2012, with a 14 percent compound annual growth rate.

Examples include

• Amazon EC2, S3
• Microsoft Azure

Let’s look into few doubts which may arise in a CFO’s mind while thinking about Cloud.

• Reason 1- What Cloud integration ?

Cloud integration is the provision of interface and data exchange between a hosted computing service and any other endpoint. The Typical functions of Cloud integration include loading, synchronizing, cleansing and replicating data. Example: DBSync and salesforce.com integration. Around 33% of World Business has today implemented Cloud Integration and this percentage is growing.

• Reason 2-Is Cloud integration growing Proficiency for the CFO’s?

Integration is emerging as a proficiency which should be adopted by the Business. Cloud integration allows business leaders to break free from legacy infrastructure with surrounding legacy solutions with new and innovative cloud-based approaches. CFOs should take an interest as cloud integration impacts financial reporting, regulatory compliance, audit trails and the bottom line. If we analyze the small business regarding their payments made for reducing the double data entry we could find that the cost paid to the employee for it is around $ 20 an hour and they work around 10 hours in a week. Hence in 1 year (52 weeks) the company would spend

52weeks X 10 hours/week X $20 = $10400/ year

it’s a huge amount for a company spending on reducing the double data entry where as software’s like DBSync would cost the organization around $1500 a year. Not only does such integrated solutions save money, but also provides visibility across application. Further, the cost of starting up is very minimal as there is no upfront capital cost for servers, the cloud provider takes care of it for you.

• Reason 3-Do Cloud integration costs much?

The question to be asked should be what is the Total Cost of Ownership (TCO). Lets look at a traditional Integration setup

Item	Cost($)
Server (Primary and backup)	$5,000-$10,000
Software	$3,000-$15,000
Administrator/Engineer	$40,000-$90,000/year
Software Upgrades and Maintenance	$1,000-$3,000/year

So, given a scenario above, we see a startup cost of $50,000 or more with an annual cost of $90,000-$95,000.

Now, if we compare the above with Cloud Integration, you do not need servers, purchase software licenses, hire administrators or worry about upgrades. All these are normally part of you subscription licensing fees and perhaps a annual maintenance fee of $500-$1000/month. So, with everything deployed you are looking at $15k/year as compared to $90k+ / year.

So, the cost of Cloud Integration doesn’t cost much, as compared to the services and the benefits provided by it. In fact Cloud integration, also bring in inherent advantages  like data security, scalability and a flexible subscription model of expanding use – pay as you use.

• Reason 4-Is Integration approach suitable for the long run?

Enterprises choose one of the four forms of integration

1. In-House Developed Integration
2. Purchase a Middle ware to perform point-to-point integration
3. Use a 3rd-party provider to manage an integration by providing Remote access in  infrastructure provided by your firm.
4. Cloud Integration, where a Integation Platform-as-a-Service (iPaaS) provider provides template based integration as a service.

As business leaders procure more and more SaaS/cloud applications, managing the ever-changing landscape of point-to-point integrations raises the total cost of ownership (TCO). Quite frankly, point-to-point integration is not scalable and is costly in the long run. CFOs can exert leadership by suggesting a more comprehensive approach to cloud integration that accounts for starting small and growing to meet demand. The worst thing a CFO can do is rip out a short-term tactical solution in couple of months after it proves not to meet data volumes or scale to meet complexity.

Hence these points may clear some doubts which would have arrived in the Mind of CFO’s. As a result, CFOs who have made decision authority to move to the cloud need an integration architecture approach that aligns with the security and regulatory compliance issues that go with protecting business assets, reducing operational for both IT and other processes, while delivering a high level of agility and scalability. A multipoint cloud-integration with a subscription based pricing approach will deliver the best ROI and align most closely with the architectural and technical benefits of consumerization of IT. More importantly, CFOs play a key role in articulating the benefits of overall cost savings and increased productivity and helping the business and IT effectively collaborate.

For more such interesting Details and discussions log on to www.mydbsync.com .

As part of our quarterly review process of all the FAQs, we have decided to touch upon the most frequently talked about subject, ETL vs EAI. In this article we look to address some of the pain points involved in the decision making process between the two, what they mean to your Business and when you should draw boundaries between these two  integration techniques.

As part of any data integration strategy, it is a golden rule of thumb to follow ‘prevent and prepare rather than repent and repair’. In most cases concerning Business Intelligence initiatives, if you know what you don’t need, you are already half way through in the quest to what you want to achieve. Business Enterprises invest millions of dollars on BI initiatives and Data Warehousing and hence rely on a consistent, accurate and reliable data. Thus following proper integration techniques becomes all the more vital. With concerned to enterprise-integration strategy, EAI is essential for maintaining a perfect harmony between business needs and IT solutions where as Data integration, a function of ETL is a constant need as inconsistent data at the heart of any BI initiative fails to provide an accurate picture of the Business. Hence the vital question EAI or ETL?

What is EAI (Enterprise Application Integration)?

EAI may be defined as a process of aligning a business’s strategic vision with its information technology. In other words EAI is mainly process integration that exists to allow client applications to operate on data from across the business through API calls without regard to its location, encapsulating technology or format. It involves integration of incompatible business applications within and beyond enterprise to allow them to talk to each other seamlessly and to share data in real time.

EAI solutions enable the automation of end-to-end business processes by coordinating sequences of tasks and resources (both systems and people) that perform them. EAI solutions support sophisticated exception management and the dynamic modification of processes even when processes are underway. EAI involves developing a ‘unified view’ of an enterprise’s business and its applications, seeing how existing applications fit into the scheme of things, and then devising ways to efficiently reuse what already exists while adding new applications and data.

EAI integration is mostly message-based, transaction-oriented, point-to-hub, brokering and transformation for application-to-application integration. Some of the core benefits offered by Enterprise Application Integration are.

1. A focus on integrating both business-level processes and data
2. A focus on reuse and distribution of business processes and data
3. A focus on simplifying application integration by reducing the amount of detailed, application specific knowledge required by the users

What is ETL (Extraction, Transformation & Loading)?

As the acronym stands, ETL is a process of extraction / reading a database, transforming or validating the data, and lastly loading / writing to a database. Extract, Tranform & Load are three database functions that are combined into one tool (like DBSync) to pull data out of source databases and place it into target databases. ETL is used to migrate data from databases to others, to form data marts and data warehouses and also to convert databases from one format or type to another.

Extract - The process of reading data from source systems. Data can be extracted in schedule-driven pull mode or event–driven push mode. Pull mode operation supports data consolidation and is typically done in batch. Push mode operation is one online by propagating data changes to target data stores.

Transform - the process of converting the extracted data from its existing form into the format it needs to be in so that it can be placed into other systems or databases. Transformation occurs by using rules or lookup tables or by combining the data with other data.

Load - The process of creation and execution of workflows to write data into the target systems. Data loading may cause a complete refresh of a target data store or may be done by updating the target destination. Interfaces here include de facto standards like ODBC, JBDC, JMS, or application interfaces.

ETL is mainly designed to process very large amounts of data, ETL provides a suitable platform for

1. Improved productivity by reuse of objects and transformations
2. Strict Methodology
3. Better Metadata Support, including impact analysis.

Drawing Boundaries for ETL & EAI

As mentioned in the above sections, both techniques rely on the concept of a unified view and the definition of a mapping that allows data from many disparate sources to be “projected” onto that view. But what differ are the purpose, speed and direction and amount of data that are transformed and placed within the unified view from the external sources.

Process-level integration mainly deals with building enterprise-wide business workflows and processes and incorporating existing applications into those processes. EAI middleware acts as the workflow engine integrating applications in near real time, passing small amounts of data through message queues and a series of stages. EAI tools provide much more complete workflow capabilities than ETL tools, which provide simple workflow.  EAI tools, and especially their workflow components, provide very sophisticated GUI development environments that enable design and management of very complex business processes. Here transformations are focused on ensuring a common understanding of the context and meaning (semantics) of the data involved within the message, the more likely a proven EAI is more appropriate.

With regards to data integration, ETL tools and also next generation ETL clearly holds an advantage whether in batch or real time. Synchronizing data between two applications involves a lot more data manipulation than simply moving data from point Source to Target. It involves data intense tasks that depend upon either RDBMS efficiencies/scalability or in-memory data caching to achieve the necessary throughput. Typically, enterprise data warehousing projects require you to move large amounts of data within relatively small windows of time. Also since ETL tools were born out of the relational database world, and thus are adept at performing SQL oriented transformations. They deal mainly with pulling data out of multiple relational tables, understanding the meaning and relationships between the tables, combining, merging, or joining that data, and augmenting it with data from their sources. Since this is more than just moving data from Source to Target, ETL is more appropriate.

When EAI	When ETL
High number of transactions	Large amounts of data
Message transforms	Complex transformations
Transformation act on a single row of data	Transformation is data-set oriented
Little data augmentation	Large data augmentation
1 to n ; m to n	Point-to-point
Suitable for real-time data needs	Suitable for large amounts of data
High volume, low footprint data exchange	Generally used to move data between 2 or more databases / data repositories

You create purchase order from your sales order. You do it every time if you are in certain in industry. But why doesn’t accounting systems let you automate it?

We saw this behavior in many accounting application from – QuickBooks to Intacct and Microsoft Dynamics GP (aka GreatPlains).

We ran into this requirement with quite a few times and ended up using our DBSync application to build out these automated processes.

Here are some of the use cases
1. CRM application creates an opportunity
2. Opportunity flows into accounting as a Sales Order
3. Invoices can be created from these Sales Orders
4. Purchase Orders can be created using the Sales Order

To create Purchase Orders, you will need to make sure that all items have associated item vendors in it and in certain accounting applications, it should also need to be “Purchased” and not in stock.

In most of accounting system, you will have to read Sales Orders (SO) and translate to Purchase Orders (PO). Fortunately Microsoft Dynamics GP (GreatPlains) makes it easy for it when using with eConnect API. Microsoft Dynamics provides a SOP Transaction for creating PO from Sales Order (nice !!!). There seems to be a misconception in GP community that taSopToPopLink only links the two documents which is not true. It actually does create the PO for you.

The following eConnect XML request creates PO from a Sales Order (SOPNUMBE)

<eConnect xmlns:dt=”urn:schemas-microsoft-com:datatypes”>

Once you run it, you get back true or false (with error). Error is quite self descriptive for you to trouble shoot it.

You can find the records in POP10100 (header) and POP10110 (line item).

Hope to post the video of it working in due course. Hope this article helps.

Enjoy integrating…

We ran into a problem with upgrading to Microsoft Dynamics GP 2010 and did not find much documentation to solve it.

We were consistently getting error at

The following SQL statement produced an error:
CREATE VIEW GL10000CurrencyTranslationView AS select [GL10000Final].[OPENYEAR], [GL10000Final].[ACTINDX], [GL10000Final].[CRDTAMNT], [GL10000Final].[DEBITAMT], [GL10000Final].[ORCRDAMT], [GL10000Final].[ORDBTAMT], [GL10000Final].[TRXDATE], [GL10000Final].[DSCRIPTN], ...


After looking under the hood we ran the following 2 scripts to get over it -
Script 1

GO

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [dbo].[MC40600](
[CURNCYID] [char](15) NOT NULL,
[CurrentExchangeTableID] [char](15) NOT NULL,
[HistoricalExchgTableID] [char](15) NOT NULL,
[AverageExchangeTableID] [char](15) NOT NULL,
[BudgetExchangeTableID] [char](15) NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PKMC40600] PRIMARY KEY NONCLUSTERED
(
[CURNCYID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Script 2

GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO

CREATE VIEW [dbo].[GL10000CurrencyTranslationView] AS select [GL10000Final].[OPENYEAR], [GL10000Final].[ACTINDX], [GL10000Final].[CRDTAMNT], [GL10000Final].[DEBITAMT], [GL10000Final].[ORCRDAMT], [GL10000Final].[ORDBTAMT], [GL10000Final].[TRXDATE], [GL10000Final].[DSCRIPTN], [GL10000Final].[REFRENCE], [GL10000Final].[CURNCYID], [GL10000Final].[Original_Exchange_Rate], [GL10000Final].[JRNENTRY], [GL10000Final].[TRXSORCE], [GL10000Final].[SOURCDOC], [GL10000Final].[ORDOCNUM], [GL10000Final].[ORTRXSRC], [GL10000Final].[ORMSTRID], [GL10000Final].[ORMSTRNM], [GL10000Final].[ORTRXTYP], [GL10000Final].[SERIES], [GL10000Final].[VOIDED], [GL10000Final].[Ledger_ID], [GL10000Final].[TranslationCurrencyID], [GL10000Final].[CurrencyTranslationType], [GL10000Final].[PERDENDT], [GL10000Final].[TranslationExchangeRate], case GL10000Final.CRDTAMNT when 0.0 then 0.0 else dbo.mcFuncCalculateAmountExtended([GL10000Final].[RTCLCMTD], 3, [GL10000Final].[TranslationExchangeRate], [GL10000Final].[DENXRATE], [GL10000Final].[MCTRXSTT], [GL10000Final].[DECPLCUR], [GL10000Final].[CRDTAMNT]) end as TranslationCreditAmount, case GL10000Final.DEBITAMT when 0.0 then 0.0 else dbo.mcFuncCalculateAmountExtended([GL10000Final].[RTCLCMTD], 3, [GL10000Final].[TranslationExchangeRate], [GL10000Final].[DENXRATE], [GL10000Final].[MCTRXSTT], [GL10000Final].[DECPLCUR], [GL10000Final].[DEBITAMT]) end as TranslationDebitAmount, [GL10000Final].[SequenceNumber], [GL10000Final].[PERIODID], [GL10000Final].[CURRNIDX], [GL10000Final].[DECPLCUR], [GL10000Final].[RATETPID], [GL10000Final].[EXGTBLID], [GL10000Final].[EXCHDATE], [GL10000Final].[TIME1], [GL10000Final].[RTCLCMTD], [GL10000Final].[DENXRATE], [GL10000Final].[MCTRXSTT], [GL10000Final].[Adjustment_Transaction] from (select distinct [GL_TRX_WORK].[OPENYEAR], [GL_TRX_WORK].[ACTINDX], [GL_TRX_WORK].[CRDTAMNT], [GL_TRX_WORK].[DEBITAMT], [GL_TRX_WORK].[ORCRDAMT], [GL_TRX_WORK].[ORDBTAMT], [GL_TRX_WORK].[TRXDATE], [GL_TRX_WORK].[DSCRIPTN], [GL_TRX_WORK].[REFRENCE], [GL_TRX_WORK].[CURNCYID], [GL_TRX_WORK].[XCHGRATE] as Original_Exchange_Rate, [GL_TRX_WORK].[JRNENTRY], [GL_TRX_WORK].[TRXSORCE], [GL_TRX_WORK].[SOURCDOC], [GL_TRX_WORK].[ORDOCNUM], [GL_TRX_WORK].[ORTRXSRC], [GL_TRX_WORK].[ORMSTRID], [GL_TRX_WORK].[ORMSTRNM], [GL_TRX_WORK].[ORTRXTYP], [GL_TRX_WORK].[SERIES], [GL_TRX_WORK].[VOIDED], [GL_TRX_WORK].[Ledger_ID], [GL_TRX_WORK].[TranslationCurrencyID], [GL_TRX_WORK].[CurrencyTranslationType], [GL_TRX_WORK].[PERDENDT], F.XCHGRATE as TranslationExchangeRate, [GL_TRX_WORK].[SQNCLINE] as SequenceNumber, [GL_TRX_WORK].[PERIODID], E.[CURRNIDX], (E.[DECPLCUR]-1) as DECPLCUR, [GL_TRX_WORK].[RATETPID], [GL_TRX_WORK].[EXGTBLID], F.[EXCHDATE], F.[TIME1], D.[RTCLCMTD], dbo.mcFuncGetDenExchRate(GL_TRX_WORK.TranslationCurrencyID,D.RTCLCMTD) as DENXRATE, [GL_TRX_WORK].[MCTRXSTT], [GL_TRX_WORK].[Adjustment_Transaction] from DYNAMICS..MC40200 E, DYNAMICS..MC40300 D cross apply (select e.YEAR1 as OPENYEAR,a.JRNENTRY,a.SOURCDOC,a.REFRENCE,f.DSCRIPTN,a.TRXDATE, a.TRXSORCE,f.ACTINDX,a.SERIES,f.ORTRXTYP,f.ORMSTRID,f.ORMSTRNM, f.ORDOCNUM,a.ORTRXSRC,a.SQNCLINE,a.CURNCYID,b.CURNCYID as TranslationCurrencyID, a.CURRNIDX,a.RATETPID,b.ExchangeTableID as EXGTBLID,a.XCHGRATE, a.EXCHDATE,a.TIME1,a.RTCLCMTD,dbo.glFuncGetPeriodID(a.TRXDATE,a.OPENYEAR,2) as PERIODID,f.CRDTAMNT,f.DEBITAMT,f.ORCRDAMT,f.ORDBTAMT, e.PERDENDT, dbo.mcFuncGetMCTrxState(b.CURNCYID) as MCTRXSTT,b.CurrencyTranslationType, a.VOIDED,a.Ledger_ID, a.Adjustment_Transaction, case b.CurrencyTranslationType when 1 then e.PERDENDT when 3 then a.TRXDATE end as ExchangeRateDate from GL10000 a, GL10001 f, (select c.ACTINDX,b.CURNCYID, ExchangeTableID= case CurrencyTranslationType when 1 then b.AverageExchangeTableID when 3 then b.HistoricalExchgTableID end, c.CurrencyTranslationType from MC00200 c,MC40600 b where c.CURNCYID='' and c.CurrencyTranslationType<>2) b, (select distinct b.PERIODID, a.YEAR1,a.FSTFSCDY,a.LSTFSCDY, b.PERIODDT,b.PERDENDT from SY40101 a, SY40100 b where a.YEAR1=b.YEAR1 and b.SERIES=2) e where a.JRNENTRY=f.JRNENTRY and f.ACTINDX=b.ACTINDX and a.PERIODID=e.PERIODID and e.YEAR1=e.YEAR1 and a.TRXDATE >=e.FSTFSCDY and a.TRXDATE <=e.LSTFSCDY) GL_TRX_WORK cross apply dbo.mcFuncGetExchangeRateTable(GL_TRX_WORK.ExchangeRateDate, GL_TRX_WORK.EXGTBLID, D.TRXDTDEF, D.DATELMTS,D.PRVDSLMT,D.Base_Exchange_Rate_On,GL_TRX_WORK.MCTRXSTT) F where GL_TRX_WORK.EXGTBLID = D.EXGTBLID and D.CURNCYID=E.CURNCYID) GL10000Final
GO


This got us past this hurdle.

Hope this helps you get started with Microsoft Dyanamics GP 2010.

As you grow into your business, you add applications. You start off with Quickbooks, then add eCommerce applications and more as you start to organize your business and life. Then you realize “Geez” I have all these data all across and I am sitting down copying data from one application to the other, reconciling payments and more. Every business we have spoken to have its own story…

While we are trying to address most of these issues, lately we have received a lot of interest in our Intacct Integration Connector. Intacct themselves provide Salesforce.com integration with a pre-built setup, works for most case and does not in others. But a bigger problem is integrating with existing in-house application like Shopping carts and others. If you look at the Intacct ecosystem, there are not many, actually none which are cost effective.

We had a similar experience with one of our prospects and we recorded our session to show you all how we can easily use DBSync to integrate with in-house databases. We have also used the same mechanism to integrate with other CRM’s like SugarCRM and vTiger. We hope you find this informative.

This is a two part YouTube video.

Part 1:

Part 2:

Please feel free to contact us if you have any questions. You can also register at www.mydbsync.com to get access to our Wiki for more examples.

Many of our customers are not use on how best to streamline business process between CRM like Salesforce.com or Microsoft CRM or eCommerce or shopping carts with accounting systems like Quickbooks, Intacct or Microsoft Dynamcs GP.

A “typical” business flow is like

Opportunity -> Estimate/Quotes  ->Sales Order -> Invoice ->Credit

Here is how they should think about it -

Do you carry inventory?

If Yes (manufacturing, retail etc)

Holding inventory has a all sort of new ounces to worry about like managing adequate Inventory levels, supply chain – remember – holding inventory is not a good idea as it locks up working capital. From a standpoint of online orders or CRM Opportunity integration, they should always use “Sales Order”. Here are some are benefits -

• Sales Order does not hit GL and usually is a “notification” for fulfillment to deliver
• As you ship or deliver goods, you can generate multiple Invoices against a Sales Order
• Sales Order will deduct from inventory but not necessarily commit shipped on Inventory. This gives you a better count of inventory on hand vs commited.

So the recommendation is

Opportunity -> Quotes -> Sales Order -> Invoice (on or more) -> Credits or RMA (Return Merchandise)

If No (Services companies, Professional Services, Consulting etc)

You deal with people most of the time and billing is usually a function of scope of work or time spent.  Normally you would have many contract terms on billing as mile stone based, retainers and others. So in your case you can have multiple setups of invoicing and would trigger at different times.

• If you receive retainers, you can apply towards an Asset account and as you invoice it, move it from the asset account to the income account
• You can use Estimate to hold the hours allocated
• Invoices (and PO or Bills on AP if you are sub contracting) can be generated from Time & Expense modules
• The same can be done if you invoice based on milestones. You can deduct hours or Unit of work against your Estimate towards invoicing

So the recommendation is

Opportunity -> Estimate (hold hours) -> Invoice (invoice on spent time on milestone and track against Estimate) -> Credits

These are some simple rule of thumb when designing your business process flow. Hope this helps our audience.

Most of us are aware Master Data Management is not just managing data, but it’s beyond just MDM, it actually requires use of technology, data integration tools & processes to create and maintain consistent and accurate list of master data in organizations. Master Data Management or MDM typically called as might become a nightmare for many organizations either large or small if it’s not planned and implemented at the right time. So how organizations need to plan for it?

3 Steps to Plan for Master Data Management

1. Identify Master Data Requirements – First and foremost thing when you have decided to go for master data management is the need to evaluate your existing systems, processes, infrastructure, organization structure and more, then try to find out if your organization actually requires an MDM and start identifying the requirements by asking questions as what’s are the business values to be achieved with this information from MDM & more.

2. Business Process Requirements – Once you have identified your MDM requirement your next immediate things to do is to start asking questions related to business process like what needs to be managed, who would be managing the MDM, what are the processes to be considered, what are the integration tools required, who can access the information, what’s the format of display, who can alter or edit the information, how to maintain the master list should it be in single format or multiple formats/copies, what locations to be maintained and more.

3. Type of Analytical requirements – Next would be to find out what types of analytical requirements for your organizational MDM plan like for areas as business intelligence & management reporting for accurate information for various roles and responsibilities.

From these steps and information start building the MDM project plan & look out for vendors like IBM, Informatica, Oracle, SAP & others who can implement MDM for your organization. During the next few years Master data management might become mandatory due to increase in mergers & acquisitions worldwide. Developing a strong MDM for large or small business helps in organizations success.

Learn more about DBSync

All major auto manufacturing companies either large or mid size have implemented JIT (Just in Time) concept for their manufacturing units across the globe. JIT was pioneered, implemented and practiced by Toyota few decades back. JIT (Just in Time) concept is nothing but ensuring inventory to be available on time for its manufacturing or assembling units. Though these manufacturing organizations use JIT concept do they need sales & inventory forecasting software as they run on JIT (Just in Time).

Four Reasons why it’s crucial:

• Accurate inventory forecasting – For organizations running on JIT system it’s very important to have its inventory to be forecast accurately to keep its manufacturing or assembling units be running on schedule or the system would get collapsed due to wrong forecasting methods.

 

• Critical components on JIT – Not all components can be made to run on JIT system as few of the components play a critical role in final output of the product. So it’s better to have forecast these components on higher level for usage at critical juncture with a small percentage of inventory in the system

 

• Collaborating with Suppliers – Suppliers supplying components or materials to JIT (Just in Time) organizations need to collaborate with vendors for accurate forecasting of components or materials and need forecasting software which works with suppliers and vendors IT infrastructure.

 

• After Sales Service – Although JIT (Just in Time) can be implemented for manufacturing components what about for after sales service? For parts to be used in after sales service organizations cannot implement JIT (Just in Time) as it would cripple the entire system of service and organizations image. So in order to have better after sales service support organizations need forecasting software with sufficient inventory levels for day to day operations.

 

JIT (Just in Time) has been implemented successfully by few major manufacturing units across the globe, but not 100% successful. So manufacturing organizations need forecasting software for forecasting inventory required for its day to day operation, critical components & components for after sales service.

For more on inventory level forecasting visit www.mydbsync.com

Most of the large & medium size manufacturing companies & retail chain stores have inventory forecasting software’s for forecasting inventory & future sales number based on past data, industry trends & economic conditions All statistical based inventory and sales forecasting models or software’s aren’t 100% accurate but have you ever thought this inventory forecasting software’s fail completely.

 3 reasons for failure:

• Negative sales – In many products based organizations sales happens during last few days of the month or year for achieving numbers. Few of these sales are called negative sales as they would be reversed back at a later date. Does your sales and inventory forecasting software accept stock reversing if yes then it failed to forecast sales accurately? So the sale happened isn’t actual sale and all forecast done for future dates in invalid due to negative sales. Do you still rely on the data?

 

• Promotional offers – Does your sales and inventory forecasting software consider your organizations promotional offers while forecasting sales and inventory? If yes, what’s the base for such forecasting as each promotional offer is unique to attract more and more customers and varies depending on the sales trend, market scenario and geography?

 

• Newly Launched products. All products have specific product life cycle from launching stage, growth stage, maturity stage and finally phase out stage. But few products are launched which wouldn’t fall into any existing product category as they have been launched to create a new product category itself like world cheapest car. In such new launches does your forecasting software forecast sales & inventory. If yes what’s the basis for such forecasting or does it considers competitors most similar products. If yes it’s not forecasting for your product but for your competitor products. Do you really need such forecasting data?

 

Considering these facts under which sales and inventory forecasting software’s fail, let’s assume we would soon have sales and inventory forecasting software which forecasts up-to 99.99% accurately.  Till then we need to rely on our old forecasting software’s only.

For detailed sales &inventory forecasting software visit www.mydbsync.com 

Learn more about DBSync & Lokad

If you are starting to feel that your current accounting and business solution is slowly but surely becoming inadequate, not catering to your business needs entirely and also isn’t keeping up pace with your organization growth, then you have just outgrown the entry-level accounting software. In such a scenario if you’re seeking a solution that can overcome these limitations then, Microsoft’s ERP solution,  Dynamics GP (Great Plains) is an ideal upgrade that can cater to your business needs and perhaps more.

With the advent of cloud, there has been a fundamental shift in the way businesses are being operated these days. This change is more evident than ever before as more and more organizations require both on-premise and online solutions. In most cases these processes are interconnected, leading to the integration of financial systems, supply chain management, CRM, e-selling, and other key business processes. In view of this, GP provides great flexibility for small and mid-sized businesses alike to deal with the IT challenges they face in the new interconnected economy. Being a Microsoft Certified partner, we have managed to make better use of features incorporated in GP and has enabled us to provide successful integration with host of applications.

With DBSync, Microsoft Dynamics GP users can connect to databases, on-demand CRM tools and a variety of other applications to improve productivity and data visibility. Some of the features that customers can make use of are as follows,

• Synchronize Customer Master Databases with Microsoft Dynamics GP
• Convert Opportunities Won to Order generated in MS Dynamics GP
• Convert Opportunities Won to Invoice in MS Dynamics GP
• Integrate E-commerce website orders to MS Dynamics GP
• Integrated payments received from online payment systems for reconciliation.

DBSync for Salesforce.com & Microsoft Dynamics GP integrates Salesforce objects like Accounts, Contacts, Products and Opportunities to GP as Customers, Sales Order Processing (SOP), Purchasing Order Processing (POP ), Receivables (RM), Items, Invoicing Transactions, and many more, while preserving links between tables.