Login     Register

        Contact Us     Search

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.

Search Blogs

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service