Stock Summary Report of Tally

Table Specific Information

Select

The 本製品 will use the Tally API to process WHERE clause conditions built with the following column and operator. The STOCKGROUPNAME is required to make a request and the rest of the filter is executed client side within the 本製品.

• STOCKGROUPNAME supports the '=' comparisons.
• FromDate supports the '=' comparisons.
• ToDate supports the '=' comparisons.

For example these queries are processed server side:

SELECT * FROM Report_StockItemSummary WHERE STOCKGROUPNAME = 'StockItem1'

SELECT * FROM Report_StockItemSummary WHERE STOCKGROUPNAME = 'StockItem1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'

Columns