Dynamics Business Central / NAV Developer Digest - Vol. 443
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes calculations used when evaluating inventory figures, debugging Azure Function apps in production, and using the Magic Number 9 in AL.
The Dynamics 365 Business Central community comprises professionals devoted to advancing the success of their customers. Developers, project managers, and consultants collaborate to share helpful information across blogs, forums, and social media sites. From discovering new solutions to finding answers to complex issues, these dedicated individuals are constantly sharing their knowledge with others. At ArcherPoint, we recognize and appreciate this highly engaged community’s creativity, hard work, and collective intelligence. To ensure all users can benefit from their expertise, we want to share their wealth of information with everyone.
Calculations used when evaluating inventory figures
Question: Can someone provide the formulas for “Remaining Quantity,” “Unit Cost,” and “Inventory Value” from Inv Valuation report? Thanks!
Answer: It really comes down to calculations involving the Item Ledger Entry, Value Entry, and Item Application Entry tables.
For each Item Ledger up to the As Of Date:
- To get the Remaining Quantity, take the remaining quantity on the Item Ledger Entry and then add any quantities applied after the As Of Date (the current version uses the Item Application Entry table to determine this).
- To get Inventory Value, take the Costs (Actual + Expected) from the Value Entries for that entry that occurred up to the As Of Date. Note that this is the full inventory value, not pro-rated for the Remaining Quantity.
- The Unit Cost is just the Inventory Value / Remaining Quantity.
Debug Azure Function apps in production
Ever wonder if you can debug an Azure Function in production? Yes, it’s possible!
Stefano Demiliani walks through steps to safely debug your apps in production.
Read his blog, Azure Functions: How to debug remotely in production, to learn more.
Magic Number 9
Erik Hougaard shows an interesting use of the “magic number 9” to make sure numerical values will always evaluate properly in AL. Check out his YouTube video, Nine Is a Magic Number in AL.
Cannot delete obsolete fields on tables in BC SaaS
Dzoka Mitrov asks the Twitterverse if you still cannot delete individual fields on tables, even though it was removed long ago. He was offered the reason why (schema) and a suggested workaround if you are bothered with the same issue.
Interested in Dynamics NAV and Business Central development? Be sure to see our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.