Catagory name on colmnar register reg

Dear admin

[#Part: DB Columnar]
Total : DBC LedAmt, DBC GrossAmt,EI AccAllocAmt, DBCAmount, DBC AddlCost, DBC Qty, DBC Revenue, DBC Cost, DBC Profit

[#Line: DSP ColVchTitle]
Local:Field:fldArea:info:$$LocaleString:"Catagory"
Local:Field:Align:Center
Local : Field: Width: 20

[#Line: DSP ColVchDetail]
add: Fields :Atend :fldArea

[Field:fldArea]
Use : Namefield
Set as: $StockCatagoryName:Stock Item: $StockItemName
Border: Thin Left
Align: Left
width :10

;----------------


/*
[#Line: DSP ColVchTotal]
Use : DSP ColVchDetail
Delete : Explode
Delete : Empty
Delete : Total
Border : Flush Totals
Space Top : if $$InPrintMode then 0.25 else 0
Fixed : Yes
Local : Field : Default : Inactive: No
Local : Field : DBC LedAmt : Set as : If $$IsRemoteCompany then @@AsLedColtotVal Else $$TotalBCLedAmt
Local : Field : DBC Date : Set as : ""
Local : Field : DBC Party : Set as : $$LocaleString:"Grand Total"
Local : Field : DBC VchType : Set as : ""
Local : Field : DBC VchNo : Set as : ""
Local : Field : DBC BookName : Set as : ""
Local : Field : DBC BookSlNo : Set as : ""
Local : Field : DBCPartyExciseRegNo : Set as : ""
Local : Field : DBC VchRef : Set as : ""
Local : Field : DBC STNo : Set as : ""
Local : Field : DBC ServiceTaxNo : Set as : ""
Local : Field : DBC Narr : Set as : ""
Local : Field : DBC ExciseRegNo : Set as : ""
Local : Field : DBC PANNo : Set as : ""
Local : Field : DBC CSTNo : Set as : ""
Local : Field : DBC Qty : Set as : $$TotalBCQty
Local : Field : DBC Rate : Set as : ""
Local : Field : DBC GrossAmt : Set as : $$TotalBCGrossAmt
Local : Field : EI AccAllocAmt : Set as : $$Total:amount
Local : Field : DBC Amount : Set as : $$TotalBCAmount
Local : Field : DBC AddlCost : Set as : $$TotalBCAddlCost
Local : Field : DBC Revenue : Set as : $$TotalBCRevenue
Local : Field : DBC Cost : Set as : $$TotalBCCost
Local : Field : DBC Profit : Set as : $$TotalBCProfit
/*

 

Try This,

Code:

Set As : $Category:StockItem:$StockItemName

 

Maulik sir,

Thanks your reply but not reflect the report , please developer help me thanks in advance

 

Mr. Murali,

I am attaching the fixed code, u need to add the field in Explode Line
ie. DSP ColVchDetailAlt , then it will work

 

Please helpme experts

thanks in advance

 

Dear all experts

till i am not recived solution please help me

 

Mr.Murthy,

Semm my post, I hv attached the fixed code.

 

sir, not working your code in tally ErP9 4.91 release

please give me a solution

Thanks advance

 

Mr. Murthy,
It will work on all Relases.
Go to
Sales Register
Columnar
Alt + F! (Detailed)
I am attaching Screen Shot

 

Sir,

DSP ColVchDetailAlt i will not understand please alter the tdl and then send me i will cheqe it

Thanks

 

in Columnar Report
DSP ColVchDetail is a Repeat Line in DB Columnar

in this line no qty info available
it will show u only , vchno,party,sales ledger n other ledgers amout

Inv. Party Stock item, Qty, Rate is in
Explode part
DSP ColVchDetailAlt , which is repeating Inventoryentries of each voucher

Stock category is in stockitem master table
so if u add a field in DSP ColVchDetailAlt Line it will show u.

 

Hi experts,

how we can add godown name and batch name column in above columnar report.