This article describes the Power BI solution used to generate certificates of analysis for Singapore.

The solution is intended to support the creation of a certificate of analysis documents by pulling the necessary data from Labvantage Prod and M3 live data.

For this,  the report uses 2 connections:

• Connection to the Production Labvantage database (used to pull COA details)
• Connection to M3 live data database (used to pull lot number information using the item number and invoice number)

The solution is available at the following link: CoA Report Generator - Power BI

The report requires 2 inputs to be executed:

• Item number (for example 009936-37-US)
• Lot number (for example 21001435)

After entering the two values, you need to click on View report on the right corner.

Once the output is generated you can export to a PDF file by clicking on Export and then PDF (.pdf) 

The pdf version of the certificate will be downloaded to the \Downloads folder on your computer.