NAV Views - Stock and Sale Report with Variances

• Enter date range
• Report shows opening stock as at starting date
• All stock sales, receipts, adjustments, etc.
• Closing Stock as at ending date
• Stock on all locations as at ending date
• Total on the side to show any variance between sales and stock actual calculated and system values
• SQL views to give all required data
• Item List
• Opening Stock
• All movements
• Closing Stock
• All stock in all locations in columns (autoupdates when new locations added)