Dynamics AX – Accessing Data for Multiple Companies

Have you ever had to compare data for several companies? That is usually not a problem to change the company you are currently attached to. You just double-click the company on the bottom of your current work space, and change it.

 

 

 

This becomes more of a challenge when dealing with more than a handful of companies.

That is where the crossCompany and changeCompany keywords can be helpful.

The table DataArea stores the company Id for all companies configured in your environment. Using the crossCompany keyword, you can construct a query to retrieve all records, regardless of the company you are currently logged into. This example loops through all of the companies in the table DataArea, then calls a routine to do some work in that company.

while select crossCompany * from dataArea

{

info (strFmt(“%1 %2”

, dataArea.Id

, dataArea.name

));

showCompany(dataArea.Id);

}

In this example, I just want to know how many customer records exist in each company. This routine will use the changeCompany keyword to define the scope of work. Using this, I can run one job to interrogate all companies that are set up, or you can manually change companies and run the query in each company. You decide which is more efficient.

void showCompany(DataAreaId _dataAreaId)

{

CustTable   custTable;

;

changeCompany(_dataAreaId)

{

custTable = null;

select count(RecId) from custTable;

info (strFmt(”  Company: %1, # of Customers: %2″

, _dataAreaId

, custTable.RecId

));

}

return;

}

What Life Sciences can Accomplish in the Cloud

How does moving to the cloud help achieve your goals for growth, innovation, and competitiveness, and what are some of the main outcomes of transitioning to the cloud that you might want to anticipate and plan for?

Predictive maintenance ensures the uptime, productivity, and performance of your infrastructure

For many life sciences companies, evolving legacy systems from condition based to predictive, enabled with data insights from IoT, is an important use case for cloud technologies.  Your analysis of data coming from connected devices, and the IoT, allows for improved communications with your contract manufacturers, 3rd Party Logistics providers or in-house manufacturing team.  This connectivity allows for you to anticipate and avoid poor decisions on R&D and product movements throughout the enterprise.   That intelligence enables you to keep product innovation to occur quickly and/or fulfilment of orders to be as efficient as possible.

People, trading partners and market visibility enables complete, contextual intelligence to help you meet company objectives

In life sciences, the ability to compete as a viable, relevant business depends largely on your ability to understand and control product research and supply chain. This learning offers an avenue to intelligence that overcomes the practical and conceptual boundaries of individuals, who are easily misled by their selective awareness of events and trends. Instead of acquiring the tools and building your own intelligence systems, you can take advantage of the resources available in the cloud today. When you connect your industrial assets or the complex products to the IoT, storing and processing the data in the cloud, they become available to cloud intelligence that can combine with data from your entire operation.

At that point, your insight is not limited to your individual employees. You can surround it with contextual information about R&D, material planning, training and the supply chain. If you want to cast an even wider net, you can also assess customer behaviors, market trends, and competitive threats, and correlate those findings with your R&D and product management.

Collaborative innovation opens additional revenue streams and increases team efficiency

Predictive maintenance is a great achievement that your internal and external customers will appreciate. No need to stop there. Cloud-enabled, intelligence-driven collaboration with your customers can help you understand them much better, strengthen the relationships with them, and maintain your share of their attention and spending. It can also result in product enhancements that you might eventually launch to your entire market.

Within your organization, you can rely on the performance and scalability of cloud resources to enable scientists, partners and rest of the workforce collaborate from anywhere. They can use cloud-based virtual reality modeling to work together on new formulas and products. You save the expense and disruption of business travel by your skilled innovators, and you enable them to collaborate always, not just on special occasions.

Service provider expertise lets you make more strategic use of your own IT department

If your IT department is fully occupied with the day-to-day activities of keeping applications, networks, and infrastructures running and secure, you can move most of these routines to the cloud and let your service provider handle them. Instead, you can use your in-house IT resources to perform custom development and other high-value tasks that help you move forward. Working with a strong cloud service provider, your IT team can efficiently learn the skills of development, provisioning, resource management, and security in the cloud, especially if you maintain a hybrid environment that requires integrations between on-premise and cloud computing. You can draw on your service provider’s specializations, for instance, to enable advanced intelligence, collect and process large volumes of data, or take the complexity out of working in the IoT.

Worldwide resources and networks let you grow at your own pace while being compliant

Leading cloud providers maintain advanced cloud infrastructures in global networks of data centers. They will have a data center close to your headquarters, and, when your company reaches across the globe, they can support you wherever you go. That means you can grow in the cloud at your preferred pace. If you want to take a measured, low-risk approach, you could move just one workload into the cloud – product engineering, for example – to start with, and test the new infrastructure’s performance, reliability, and analytical capabilities. You continue your cloud migration at the right time.

When you’re ready to increase the momentum, you can take advantage of cloud-based ERP and CRM resources with multi-language and multicurrency features to reach customers and markets anywhere. If you’re operating production and distribution facilities in several countries and regions, the cloud offers an efficient way to make corporate systems and information available to them and connect their processes to the entire organization.

Transform your life sciences business in the cloud

Starting now, you can act on the cloud opportunities that offer the highest benefits. Together, Tridea Partners technology and expertise, Microsoft Dynamics 365, and the analytics resources available on the Microsoft Azure cloud can make life sciences business growth in the cloud practical, fast, and affordable. Before, during, and following your move to the cloud, we help you optimize processes, increase efficiencies, and reduce costs. We offer proven, practical solutions and approaches within an affordable subscription model that eliminates distractions and lets you focus on results.

At Tridea, we help our life science customers digitally transform their businesses and improve the value realization of their business application investments. We mitigate the inherent risks associated with implementing, upgrading and replacing legacy ERP systems. We lead our life science customers with best-practice consulting services we have refined over thousands of engagements. We take care of our customers and aspire to keep them for life.

To learn more about how Tridea can help you get the most out of your Microsoft solutions, visit https://www.columbusglobal.com/en-us/resources/landing-pages/us/tridea-lifesciences-erp/life-sciences-ebook  or contact us at info@trideapartners.com

CFO’s often ask “Why should I renew my Microsoft ERP’s Maintenance Plan”?

The answer is twofold – 1) There’s tremendous value associated with being on a current Maintenance plan and 2) there’s a significant downside to not renewing in a timely manner.

  • You maximize the solution value with ongoing Microsoft Dynamics product improvements.If your Maintenance Plan is current, you are entitled to new software upgrades, updates, product fixes, and service packs.  Microsoft often improves or adds functionality with new releases of the software.  These all enable your business to be up-to-date with Microsoft’s innovations.  If your plan is not current, you will miss out on these innovations.
  • You protect your Investment. Stay current on maintenance and your maintenance costs will be based upon the protected system list price (the initial cost of your system).  It’s useful to have a predictable cost to plan for…
  • You retain access to CustomerSource.CustomerSource is a large knowledge database supplied and maintained by Microsoft, and can be used to get essential information such as technical support, product updates and downloads, training, events, and provide access to community forums. It available 24/7. Many of our clients use CustomerSource to aid them as they configure or troubleshot issues that arise occasionally. This saves the client time and cost when they can perform the work themselves. 

     

Important NoteIf your organization decides to let the Maintenance Plan lapse, you will be no longer entitled to any of the services listed above. In addition you will not being able to purchase new modules or user licenses. It’s possible to re-institute a Maintenance Plan, but please be advised that Microsoft does charge a penalty.  We highly recommend that you stay current on your Maintenance Plan.

5 Key Features to Look for in ERP Software for Life Sciences

ERP for Life Sciences

The Life Sciences industry is unique in many ways, especially because it “evolves” as companies go through the life cycle from pre-clinical to market. Each of the phases of this life cycle have their own unique requirements, but commonly we come back to the same 5 key features that companies need to address with their business management and ERP systems:

  1. Compliance

When the FDA is in charge of the market you’re launching your new Life Sciences product into, patient and customer safety extends far beyond company guidelines. They set the standards for thresholds and validation of your business systems including security, manufacturing, quality controls, audit trails, and overall Good Informatics Practices.

  1. Traceability

You hope the day never comes where your product has quality issues or has some adverse effect, but you can’t be any too careful to ensure you have the right tools to minimize the impact on the patients or customers. It also makes good business sense to understand the quality of products that are going to the customer in order to make improvements to future products.

  1. Real-time access to information

There aren’t too many industries where change is so rapid or control of ‘spend’ is more important than in the Life Sciences industry. Therefore, you need a system that can give you the right information at the right time through powerful reporting tools.

  1. Cost Management

Access to funds isn’t quite as easy as it once was, and a significant amount of funding is needed to support R&D efforts for the creation of the next big drug or device. Therefore, you need a system that can monitor the ‘spend’ to vendors and provide visibility into day to day expenses.

  1. Commercialization Support

The big day comes with approval of your new drug or device and now you need to ramp up sales, production, and fulfillment. This needs to happen yesterday and you need a system that can support the many processes that come with the product going to market including; manufacturing (or integration to manufacturer), 3PL integration, sales and marketing, production planning and quality management.

Visit https://www.columbusglobal.com/en-us/resources/landing-pages/us/tridea-lifesciences-erp/infographic to learn more about ERP software for life sciences.

ERP and Tracking Aggregate Spending for the Pharmaceutical Industry

Pharmaceutical manufacturers that are looking to implement a new ERP system will invariably ask about options for meeting requirements of the Sunshine Act, which was enacted to protect consumers by ensuring transparency in the reporting of financial relationships between pharmaceutical companies and health care providers (HCPs). While pharmaceutical companies generally purchase a software system specifically designed to track their aggregate spending to HCPs, the ERP system generates much of the information that is fed into the aggregate spend system.

Typically, money flows from pharmaceutical manufacturers to healthcare providers in three forms that are generally handled in three very distinct manners:

  1. AP invoices directly to HCPs

Vendors that are HCPs are defined as such in the ERP system. Any expenses that are booked in the ERP system directly to HCP vendors are pushed to the aggregate spend system via an integration. Typically, a relatively small number of HCPs become direct vendors in the ERP system. The process of setting up new vendors is generally a highly controlled process that lends itself to accurately defining and identifying an HCP.

  1. Employee expense reimbursement

Employees of the pharmaceutical company meet with HCPs and incur expenses that need to be reimbursed to them by the company. Assuming the company has an expense reimbursement system (such as Concur, for example), the expense reimbursement software generally just feeds the core accounting (general ledger) data to the ERP system, and sends the HCP spend information directly to the aggregate spend software. It is therefore necessary to have the HCPs defined in the expense reimbursement system, but the ERP system is not involved in this process.

  1. AP invoices to 3rd party vendors that benefit HCPs

While it is possible to capture this data in the ERP system (on a custom field linked to the PO or invoice) and push it to the aggregate spend system, there are some complicating factors that lead many companies to opt to manually enter these transactions into the aggregate spend software or else upload vendor documents directly to the aggregate spend software in addition to recording the invoices in ERP:

3.1  Timing

At the time that a PO or invoice is entered, do we necessarily know which HCPs will benefit from the spend? For example, speaker bureau invoices often arrive in advance of the list of attendees (HCPs)

3.2  Accuracy

HCPs that benefit from expenses incurred with 3rd parties can be very large in quantity. Ensuring that the correct HCP is selected and linked to an expense can be difficult, especially when many health care providers may have similar names (or even the same names). In such cases, AP clerks that have no direct knowledge of the circumstances surrounding the expense could have a difficult time selecting the correct HCP. Aggregate spend software systems typically have matching algorithms to accurately identify HCPs.

 

Why Tridea Partners?

Tridea Partners helps companies unlock the value of their business applications. By engaging Tridea Partners, you gain a partner that is committed to your business success. We work with you to automate your company’s unique business processes, integrate existing systems and people, assist with necessary business practice adjustments, and ensure the solution will scale with your company’s growth.

Personnel: Tridea Partners focuses on hiring consultants with deep experience in the Life Sciences industry and has gained extensive experience through the completion of over 100 ERP implementations in the industry.

Solutions: Tridea Partners has developed custom software solutions that enhance and extend Microsoft Dynamics ERP to support the needs of the Life Sciences industry, specifically project accounting, quality assurance and order entry.

Implementation Methodology: Tridea Partners uses an implementation methodology that addresses the challenges within the Life Sciences industry. This implementation methodology focuses around a detailed understanding of key business processes, segregation of duties, security and audit trails, collaborative configuration, sign-off and finally testing and system validation.

To learn more about how Tridea Partners can help you get the most out of your Microsoft solution, visit our website or contact us at info@trideapartners.com