By Charles Flock on
5/10/2017 2:34 PM
In 2013 we introduced 3 XLeratorDB/windowing functions for inventory calculations: FIFO; LIFO; and WAC. In March of 2017 we added new table-valued functions to XLeratorDB/fin08 to do the same calculations as well as a few new functions to provide more detail about the ending inventory balances. In this article we go through some examples to explore the details of inventory valuation techniques and discuss the perils of triangular joins and why you probably don't want to try these calculations in native SQL.