The Inventory KPI Add-On by Dhyey provides a detailed breakdown of the landed cost and analysis of purchased items. It includes the latest three receipts and their corresponding invoices with cost breakdowns such as direct cost, transport, insurance, etc. These costs are applied to each receipt and are shown along with unit cost, actual cost amount, and expected cost amount (if the invoice has not yet been entered into the system) for each vendor from whom the item is purchased within the selected date period.
The report also includes variant-wise item details, vendor information, location, purchase receipt number, posting date, quantity, applied invoice number, and the landed unit cost for each invoice. Additionally, it provides a detailed breakdown of each cost head such as direct cost and charge items, along with the expected cost amount (if the invoice is not yet posted in the system) and the actual cost amount. If a charge item’s vendor is different from the purchased vendor, the report includes vendor details for both.Moreover, the best part is that it can be seamlessly integrated with Microsoft Dynamics 365 Business Central.