Level up with Formula Queries for Inventory! Average Cost of On Hand Inventory, Sequential PO Line Numbering, Summary and Drilldown without Relationships, Cost Allocation, and more!
Release 2.0 includes First In, First Out Cost Allocation for calculation of Profit in terms of Dollars and Margin. This solution requires use of Formula Queries and Pipelines with regex. The YAML is attached.