Konnect SQL Reports

Inventory Reports

Group	Report Name	Columns
Material	Minimum & Maximum Stock	Type,Locator,Product,Qty On Hand,Minimum Level,Maximum Level
Material	Material Stock with Value (All Product)	Organization,Product,Qty,Amount
Material	Stores Ledger Register	Organisation,Product Category,Product,UOM,Opening Qty,Opening Value,Purchase Qty,Purchase Value,Sales Qty,Sales Value,Production Qty,Production Value,Closing Qty,Closing Value,Average Cost
Material	Stores Ledger Material Folio	Type,Product,Date,Document No,Description,Docstatus,Qty,Value,Avg Cost
Material	Material Stock with Value	Organisation,Product,Amount,Issueqty,Receiptqty,Qty,Sort
Registers	Stock Register with Value	Organisation,Product Category,Product,UOM,Opening Value,Opening qty,Purchase Qty,Purchase Value,Sales Qty,Sales Value,Transfer Qty,Production Qty, Closing Qty,Closing Value,Average
Registers	Stock Register Qty Only	Product Category,Product,Unit,Locator,Qty

Group	Report Name	Columns
HR	EPF Report	UAN,Member Name,Gross Wages,EPF Wages,EPF Contribution remitted(employee),EPF Contribution remitted(employer),Total
HR	ESI Report	ESI No, Employee Name, Present Days, ESI Salary, ESI(employee), ESI Contribution remitted(employer),Total
HR	Payroll Report	Employee, Rule, Amount
HR	Activity Rate Payment Report	Organization, Operation, Employee Code, Employee Name, PF, ESI, Total Days, Total Production, Net Amount
HR	Activity Rate Report Daily	Organization, Operation, Employee Code, Employee Name, PF, ESI, Day Wise Values, Total Days, Total Wages, Net Amount

Group	Report Name	Columns
Finance	Subcontract Cost(New RV)	Documentno,Vendor,Product,UOM,Qty,Amount,Avg Cost
Finance	GSTR1 (Material)	HSN/SAC Codes,Quantity,Unique Quantity Code,Grand Total,Taxable Value,Tax Amount,Rate
Finance	GSTR2	GSTIN of supplier,Supplier Name,Document type,Document number,Document date,Taxable Value,Integrated tax,Central tax,State/ UT tax,Cess
Finance	DayBook	Date,Type,DocumentNo/Lineno,Ledger,Name,Customer/Vendor,Charge,Debit,Credit,Balance,Docstatus
Finance	GSTR1	GSTIN/UIN of Recipient,Receiver Name,Invoice No,Invoice Date,Invoice Value, Place Of Supply,Reverse Charge,Invoice Type,Tax Name,Rate,Taxable Value,CessAmount
Finance	TCS	Organization,Invoice/Paymemt(Document No),Business Partner,Pan Number,Tax,Percent,Tax base Amount,Tax Amount,Transaction Date,Description
Finance	Product Costs	Organisation,Product Category,Search Key,Name,Cost Element,Current Cost,Current Qty,Cumm Qty,Cumm Amount
Finance	Un Allocated Invoices and payments	Company,Group,Customer/Vendor,Unallocated Invoices,Unallocated Payments
Finance	Missing Product Costs	Product Category,Search Key,Name
Finance	TDS	Organization,Invoice/Paymemt(Document No),Business Partner,Pan Number,Tax,Percent,Tax base Amount,Tax Amount,Transaction Date,Description
Finance	Unallocated Receipts & Payments	Customer/Vendor Name, Opening Balance, Debit, Credit, Closing Balance