In a previous blog post we covered how we can hold ourselves accountable to the promises we make to our customers. We specifically looked and tracking late shipments.
This blog post will review the purchasing side of on time delivery allowing you to track in Microsoft Dynamics Business Central which of your suppliers are missing their delivery date and impacting your business operations.
Why track Vendor late receipts in Business Central?
Keeping production operations running smoothly requires a consistent flow of raw materials and accurate timing for planning purposes.
Business Central provides the ability to track our vendors ability to delivery on time. Using Power BI we can flag late receipts so you can focus on remedying these delivery issues with your vendors.
Where to track late receipts from Vendors?
When creating a purchase order, Business Central provides us the ability to track if the items we ordered were actually delivered on time.
By pulling this data into Power BI we can create an easy way to evaluate our vendors, items, and various other parameters as they relate to the on time delivery of our items and inventory.
Operationally, your team will need to input the relevant information so that it can be tracked in Power Bi and give you the information needed to plan and hold your vendors accountable.
Now that you have worked in the process of adding your vendor promises and requests, you will need to pull this data out into PowerBI in order to monitor and track your KPIs.
The table is called workflowPurchaseDocuments.