Hello, I’ve been able to create an SQL Query that gives me the Stock Value both at Cost as well as at Sale. Could someone help me create a report from it. [image] Use SambaPOS5 SELECT TOP (100) PERCENT dbo.PeriodicConsumptionItems.InventoryItemName, CONVERT(INT, ROUND(CASE WHEN [BaseUni…

Stock Value Report

sezgin July 10, 2026, 7:35am 2

Simple SQL Report Format & Filters V5 Question

If you want to use a view, in your where clause you can pass ‘{Start}’ and ‘{End}’ and those will be replaced with the date constraints behind the scenes. I can’t get REPORT SQL DETAILS to work when formatting dates. So this is what I did: Create a script: [image] code DECLARE @StartDate NVARCHAR(25) = N'{Start}'; DECLARE @EndDate NVARCHAR(25) = N'{End}'; SELECT UserId, UserName, ISNULL(FORMAT(ClockIn, 'dd/MM/yyyy hh:mm:ss'), 'N/A') AS ClockIn, ISNULL(FORMAT(ClockOut…

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled