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

Leave a Reply

Your email address will not be published. Required fields are marked *