SambaClub Forum

Some Reports (Custom Reports)

Version 4 V4 Custom Reports

emre August 20, 2015, 11:19am 8

Stock Report With Unit Conversion and Cost Calculation V4 Custom Reports

Hope that works for everyone… Report: [Stock:2, 1, 1, 1] >Item|Stock Fisico|Stock UNI|Costo @@Stock >TOTAL|||@@TotalStock SQL @@Stock: SELECT [InventoryItemName], ([InStock]+[Added]-[Removed]-[Consumption]) as StockFisico, CONVERT(INT,([InStock]+[Added]-[Removed]-[Consumption])*[UnitMultiplier]) as StockFisicoUN, CONVERT(numeric(6,2),([Cost]*([InStock]+[Added]-[Removed]-[Consumption]))) as Costo FROM [PeriodicConsumptionItems] WHERE [WarehouseConsumptionId] = (SELECT T…

1 Like

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled