dear sir, how to add Consumption and Production quantity colomn in stk summary report for manufacture journal or stock journal
Hi Kamal, i didnt understand ur query. Do You Want To Add New field In that Report Or What. NOTE : In Stock Summary There is Opening Balance ,Inwards ,Outwards And Closing Balance. The Production Qty Will Come in "Inwards" The Consumtion Qty Will Come in "Outwads" You can Get that By Pressing f12 in that Report--->Configuration-->Just Enable Yes for Opening Balance,goods Inwards and Goods outwards. NOTE 2: Both manufacture journal or stock journal value will Come In the Inwards(Production) and Outwards(Consumption)
Dear sir, thanks for ur reply I want to show inward as Production and Outwards as Consumption for stock journal plz find the attachment.
Hi Kamal, If Your Trying to add the two Seperate Fields in Stock Summary Report.Its Not Suggested. Because In Default Report Only, You can Achive That By Pressing Ctrl + F12 (Value Button) and Just filter with that 2 Voucher Type "Stock Journal" And "Mfg Journal" Ex. Using Voucher having Voucher Type with Name Containing Stock Journal or with Name Containing Mfg Journal By Doing This The Value Form Stock Journal And MFG Journal Only will display in Inward and Outward.
Try This ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara ;; Codes to fetch Voucher Manufacturing Journal, Stock Journal as Production or Consumption [System : UDF] IsItemWiseInOutBreakupCSknl: logical: 35 [#Menu: Inventory Books] Add: Key Item :After: @@locPhysicalStockRegister: Item-Wise In-Out Breakup + : W : Display : STQueryCSknl : NOT $$IsEmpty:$$SelectedCmps ;; + ;; AND $IsItemWiseInOutBreakupCSknl:Company:##SVCurrentCompany [Report: STQueryCSknl] Use : DSP Template Form : STQueryCSknl Title : "Itemwise Breakup" PrintSet : Report Title : "Itemwise Breakup" [Form: STQueryCsKnl] Use : DSP Template Parts : DB Title, STQueryCSknl Delete : Buttons : ExplodeFlag Delete : Bottom Buttons : DSPAutoColumns, BudgetAnalysis, ReportConfig Local: Line : DB Title : Local : Field : Name Field: Set as : "Itemwise Columnar Breakup" [Part: STQueryCSknl] Lines : STQueryCSknlT, STQueryCSknl Repeat : STQueryCSknl : SItemCollCSknl Scroll : Vertical Common Borders : Yes Total : OpQtyCSknl, InQtyCSknl, ConsQtyCSknl, ProdQtyCSknl, OutwQtyCSknl, ClosQtyCSknl [Line: STQueryCSknlT] Use : STQueryCSknl Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Lines : 0 Local : Field : ItemNameCSknl : Align : Left Local : Field : ItemNameCSknl : Set as: "Particulars" Local : Field : OpQtyCSknl : Set as: "Opening Quantity" Local : Field : InQtyCSknl : Set as: "Inwards Quantity" Local : Field : ConsQtyCSknl : Set as: "Consumption Quantity" Local : Field : ProdQtyCSknl : Set as: "Production Quantity" Local : Field : OutwQtyCSknl : Set as: "Outwards Quantity" Local : Field : ClosQtyCSknl : Set as: "Closing Quantity" Border : Thin Top Bottom [Line: STQueryCSknl] Fields : ItemNameCSknl, OpQtyCSknl, InQtyCSknl, ConsQtyCSknl + , ProdQtyCSknl, OutwQtyCSknl, ClosQtyCSknl Repeat : ClosQtyCSknl Option : AlterOnEnter [Field: ItemNameCSknl] ;; Stock Item Name Use : Name Field Style : Normal Width : 30 Maximum : 30 Set As : $Name Fixed : Yes Option : DisplayOnEnter ;;AlterOnEnter [Field: OpQtyCSknl] ;; Opening Qty Use : Qty Primary Field Style : Normal Format : "No Zero" Set as : $ItOpQty Border : Thin Left Right Width : 13 Scroll : Yes Display : Stock Summary [Field: InQtyCSknl] ;; Purchase Qty Use : OpQtyCSknl Set As : $TrPurcQty Border : Thin Right [Field: ConsQtyCSknl] ;; Consumption of Stock journal Use : InQtyCSknl Set As : $TrTranOutQty Border : Thin Right [Field: ProdQtyCSknl] ;; Production of Stock journal Use : InQtyCSknl Set As : $TrTranInQty [Field: OutwQtyCSknl] ;; Sales Qty Use : InQtyCSknl Set As : $TrSaleQty [Field: ClosQtyCSknl] ;; Closing Qty Use : InQtyCSknl Set As : $ItClQty Delete : Border Style : Normal Bold ;; Collection Definition [Collection: Voucher CollectionCSknl] Type : Voucher [Collection: SItemCollCSknl] Source Collection : Voucher CollectionCSknl Walk : All Inventory Entries By : Name : $StockItemName ;; Grouping done by Stock Item Aggr Compute : TrPurcQty : Sum : If @@CSknlPurcVr Then $BilledQty Else 0 Aggr Compute : TrSaleQty : Sum : If @@CSknlSaleVr Then $BilledQty Else 0 Aggr Compute : TrTranOutQty : Sum : If @@CSknlStockJrnlVr And NOT $$IsInwards:$BilledQty Then $BilledQty Else 0 Aggr Compute : TrTranInQty : Sum : If @@CSknlStockJrnlVr And $$IsInwards:$BilledQty Then $BilledQty Else 0 ;; Aggregation done on Stock Item to compute Purchase, Sales, Consumption and Production quantities Compute : ItClQty : $StkClBalance:StockItem:$StockItemName Compute : ItOpQty : $StkOpBalance:StockItem:$StockItemName Sort : @@SortAlphaIncr : $Name ;; System Formula [System: Formula] CSknlPurc Vr : $$IsPurchase:$VoucherTypeName CSknlSale Vr : $$IsSales:$VoucherTypeName CSknlStock Jrnl Vr : $$IsStockJrnl:$VoucherTypeName ;; End-of-File
Hi Kamal, As vimal is given a seperate report. you can use it. this is what you required it seems. and also thanks Vimal,
Verry Good Solutions But Bottom Line Total Is Not Available If Possible Add Every Column Bottom Gross Total Qty.
Good for tdl knowledge, but as an accountant I must tell you that this will not help , calculation of production & consumption value are being done in msexcel.
If you are an accountant , then you must know that "cost of consumption " value comes from purchase price plus other expenses. Similarly COST OF PRODUCTION depends on other factors like conversion cost.
Hi kamal Just to update if u have Tally developer the default is already available just load the sample.txt into Tally select ur company goto - TDL+The development Language option then goto object & collection goto grouping & aggregation here u can c the option Itemwise inout breakup just use it also u can modifiy the code as per your need https://www.youtube.com/channel/UCj8bRBymZTuvVVTqXR6ZT7g?view_as=subscriber