Key Features :
- Sr. No.
- Date
- Transaction ID
- Transaction Type
- Item Code
- Item Name
- Category
- Unit
- Qty In
- Qty Out
- Running Balance
- Unit Cost
- Transaction Value
- Supplier / Department
- Location
- Status
- Remarks
Formulas:
Sr. No.
=ROW()-4
Item Name
=IFERROR(@XLOOKUP(E5,’Item Master’!$A$4:$A$1000,’Item Master’!$B$4:$B$1000,””),””)
Category
=IFERROR(@XLOOKUP(E5,’Item Master’!$A$4:$A$1000,’Item Master’!$C$4:$C$1000,””),””)
Unit
=IFERROR(@XLOOKUP(E5,’Item Master’!$A$4:$A$1000,’Item Master’!$D$4:$D$1000,””),””)
Running Balance
=IF(E5=””,””,IFERROR(@XLOOKUP(E5,’Item Master’!$A$4:$A$1000,’Item Master’!$E$4:$E$1000,0),0)+SUMIFS($I$5:I5,$E$5:E5,E5)-SUMIFS($J$5:J5,$E$5:E5,E5))
Unit Cost
=IFERROR(@XLOOKUP(E5,’Item Master’!$A$4:$A$1000,’Item Master’!$G$4:$G$1000,0),0)
Total Transactions
=COUNTA(‘Store Register’!$C$5:$C$999)
Total Qty In
=SUM(‘Store Register’!$I$5:$I$999)
Total Qty Out
=SUM(‘Store Register’!$J$5:$J$999)
Transaction Value
=SUM(‘Store Register’!$M$5:$M$999)
Pending Transactions
=COUNTIF(‘Store Register’!$P$5:$P$999,”Pending”)
Item Master Count
=COUNTA(‘Item Master’!$A$4:$A$1000)
