Partywise Sales Report

Partywise sales Report Including Broker,Trasnport,Loadman Details

 

Thankyou knsivam89 sir, This tdl very help me

Thanking you

 

Thank you for sharing such a wonderful codes.

 

This all credits Goes to our Experts Only sir. They all are very much of help me. Thanks to all Our Experts.....

 

Dear knsivam89 sir

Can you make a Customer wise VAT Report which shows Invoice Date, Invoice Number, Particulars (Sales/Sales Return), Accessible Amount, VAT Amount, Invoice Amount .

Thanks

Aloke Debnath

 

Dear ALOKE DEBNATH sir,

Can u try ur own. I think this site is a knowledge sharing site.

 

problem in stock summary

sir
I have come to the cause of the problem
The problem occurs because of the cost of each separate godown
For example
i have tow godowns (godown 1 and godown 2)
and i have one item ( item a ) and i will use cost avg
If i buy 10 item a in godown 1 rate 10 total amount will be in godown 1 100
and If i buy item a in godown 2 rate 9 total amount will be in godown 2 90
total amount in all 190 this good but the problem is in separate cost to each godown
in this case if i transfer 5 unit from godown 2 to godown 1 the rate cost in godown 1 is 9.67 total amount in godown 1 = 15*9.67=145 and the rate cost in godown 2 is 9 total amount in godown 2 =5*9=45
to now no problem
but now if i transfer stock 10 unit from godwn 1 to godwn 2 this is the problem here u can find loss 1.64 and cost to godwon 1 will be 5 unit*9.67=48 and cost to godwon 2 will be 15 unit *9.34=140.03
in first i had stock in total in all company =190
now my stock in total company is 188.36
no sales this is just transfer
sir solution this problem is very easy
1- transfer stock in stock jv must be without rate and amount
2- if i buy the same item in more than godown in Different rate must be find allocation this cost in each godown (means not godown 1 10 unit *10 =100 and in godown 2 10 unit * 9=90 this is very wrong this is the problem must tally give me cost like in godwon 1 10 unit *9.5= 950 and in godown 2 10 unit * 9.5=950 auto allocation cost in all godowns if tally to that this problem will done )
sir separate cost in each godwon is very wrong must be when purchase by Different rate in any godown must be change all rate in other godown must be the in all godwns is the same
1-sir if we buy stock in godwn 1( 10 unit rate 10 amount will be 100 )
and if i buy the same item in godown 2 (10 unit rate 9 amount will be 90)
total amount in godown 1( 100) and total amount in godwn 2 (90) and rate in godown 1 will be (10) and rate in godown 2 will be (9) this is Reason the problem in consumption the is the wrong
i want the same rate in all godown ( rate must be in godown 1 (9.5) and in godown 2 ( 9.5)
this is no.1 to solution my problem
2-and after that remove stock jv from stock summary
3-and in stock jv voucher i want hidden rate and amount (that in voucher stock jv entry )
this all i want ​

 

HI,
You have developed one of the best reports. in addition, I have modified further to add up with Alternate Qty against the Sales amount. Which will give additional information and control check on my daily/periodic realization for sales.
But I have got stuck with code which gives me result of per Kg Realisation. In last column I am looking for value SaleAmount /Billed Weight.
I am giving formula to calculate but the calculation it is taking on Primary Unit Qty, instead of secondary unit Qty. That is why result is showing the Item wise Average rate and not the realization which I am looking against per Kg (Secondary Unit)
Can you please help me with the same.

--- I am unable to load modified the file on this forum.























































































Local : Field : BWRRealisation : Set as : $SubAmount / $SubActQty Local : Field : BWRAvgRate : Set as : $SubAmount / $SubActQty Local : Field : BWRAmount : Set as : $SubAmount Local : Field : BWRActualQty2 : Set as : $SubActQty Local : Field : BWRActualQty : Set as : $SubActQty Local : Field : BWRPartyName : Align : Right Local : Field : BWRPartyName : Set as : $ItemName Local : Field : Default : Style : Normal Italic Local : Field : SWSno : Set as : "" Delete : Border Use : BWRDetails[Line:BWRExplode] Border : Thin Bottom Repeat : BWRExplode:BWRPartyExplode Line : BWRExplode[Part:BWRExplode] Local : Field : BWRRealisation : Align : Right Local : Field : BWRRealisation : Border : Thin Left Right Local : Field : BWRRealisation : Set as : $$Total:BWRRealisation Local : Field : BWRAmount : Align : Right Local : Field : BWRAmount : Set as : $$Total:BWRAmount Local : Field : BWRActualQty2 : Set as : $$Total:BWRActualQty2 Local : Field : BWRActualQty2 : Type : Quantity : Secondary Units Local : Field : BWRActualQty : Set as : $$Total:BWRActualQty Local : Field : BWRPartyName : Set as : "Grand Total" Local : Field : SWSno : Set as : "" Local : Field : Default : Border : Thin Left Local : Field : Default : Style : Large Bold Local : Field : Default : Align : Right Local : Field : Default : Type : String Use : BWRDetails Border : Totals[Line:BWRTotal] Line : BWRTotal[Part:BWRTotals] Border : Thin Right Space Left : 2 mms Width : 16 Align : Right Set as : $TotAmount / $TotActQty2 ;VoucherTypeName Type : Number : Quantity Use : Qty Secondary Field[Field:BWRRealisation] Max : @@MaxNumberWidth Key : Calculator Align : Right Format : "No Zero, Symbol," + ##ShowForex Width : @@AmountWidth Set as : $TotAmount / $TotActQty ;VoucherTypeName Type : Number Use : Qty Field[Field:BWRAvgRate] Tooltip : "Amount Without TAX" Border : Thin Right Space Right : 2 mms Width : 16 Max : @@MaxNumberWidth Key : Calculator Align : Right Format : "No Zero, Symbol," + ##ShowForex Width : @@AmountWidth Type : Amount Set as : $TotAmount Use : BWRDefault[Field:BWRAmount] Border : Thin Right Space Left : 2 mms Width : 16 Set as : $TotActQty2 ;VoucherTypeName Use : Qty Secondary Field[Field:BWRActualQty2] Border : Thin Left Right Space Left : 2 mms Width : 16 Set as : $TotActQty;VoucherTypeName Type : Quantity Use : Qty Field[Field:BWRActualQty]

 

error while loading
duplicate description in 'party name'
please help i am newer in this
thanks in advance
with best regards,
Balkrishna

 

Dear Sir,
Please remove any other tdl u r using from "manage local tdl" it is colliding with the tdl u already loaded.

 

Thansk for Very useful TDL , once Again Thanks Knsivam and Admin too

 

i am getting this error ""(494): error T0044: duplicate description name variable - PartyName in user TDL .
There is no another tdl added.

 

;===============================================================
;======================= F11 Feature ===========================
;===============================================================

[#Part: CMP TallyShopFeatures Left]
Add : Line : At End : CMP EnableBrokerLine

[Line:CMP EnableBrokerLine]
Space Bottom : 1.5 mms
Field : Long Prompt,CMP EnableBrokerLine
Local : Field : Long Prompt : Set as : "Enable Broker wise Report.?:"

[Field:CMP EnableBrokerLine]
Use : Logical Field
Storage : EnableBroker
Set as : If $$IsEmpty:$$Value then "No" else $$Value
Sub Form: CMP BrokerNameReport: $$Value = "Yes"

[Report: CMP BrokerNameReport]
Form : CMP BrokerNameForm
Object : Company

[Form: CMP BrokerNameForm]
Part : CMPBrokerDetails
Background : White, Petal Pink

[Field:CMPName Field]
Use : Name Field
Skip : Yes
Align : Center
Border : Thin Bottom

[Part:CMPBrokerDetails]
Part : CMP BrokerNamePart,CMP TransportPart,CMP LoadManPart
Vertical : No
Common Border : Yes

[Part: CMP BrokerNamePart]
Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails
Repeat : CMP BrokerName LineDetails: BrokerNameList
BreakOn : $$IsEmpty:$BrokerNameList
Height : 10
Scroll : Vertical
CommonBorder: Yes
Space Left : 2 mms
Space Right : 2 mms
Border : Thin Right

[Line:CMP BrokerNamePartTit]
Field : CMPName Field
Local : Field : CMPName Field : Set as : "Broker Name"

[Line: CMP BrokerName LineDetails]
Field : CMP BrokerNameList;,CMP TransportList,CMP LoadmanList;,CMP Broker CommissionField

[Field: CMP BrokerNameList]
Use : Name Field
Storage : BrokerNameList
Style : Small Bold

[Part:CMP TransportPart]
Line : CMP TransportPartTit,CMP TransportPart
Repeat : CMP TransportPart: TransportList
BreakOn : $$IsEmpty:$TransportList
Height : 10
Scroll : Vertical
CommonBorder: Yes
Space Left : 2 mms
Space Right : 2 mms
Border : Thin Right

[Line:CMP TransportPartTit]
Field : CMPName Field
Local : Field : CMPName Field : Set as : "Transport Name"

[Line:CMP TransportPart]
Field : CMP TransportList

[Field: CMP TransportList]
Use : Name Field
Storage : TransportList
Style : Small Bold

[Part:CMP LoadManPart]
Line : CMP LoadmanListTit,CMP LoadmanList
Repeat : CMP LoadmanList: LoadmanList
BreakOn : $$IsEmpty:$LoadmanList
Height : 15
Scroll : Vertical
CommonBorder: Yes
Space Left : 2 mms
Space Right : 2 mms

[Line:CMP LoadmanListTit]
Field : CMPName Field
Local : Field : CMPName Field : Set as : "Loadman Name"

[Line:CMP LoadmanList]
Field : CMP LoadmanList

[Field: CMP LoadmanList]
Use : Name Field
Storage : LoadmanList
Style : Small Bold

;===============================================================
;======================= Add Fields ===========================
;===============================================================

[#PartBLLINE Narration]
Add : Line : Before : VCH NarrPrompt : VCHBrokerLine

[Line:VCHBrokerLine]
Invisible : NOT $EnableBroker:Company:##SVCurrentCompany OR NOT $$IsSales:##SVVoucherType
Field : VCHBrokerNameTit,VCHBrokerName,VCHTransportTit,VCHTransport,VCHLoadManTit,VCHLoadMan

[Field:VCHBrokerNameTit]
Use : Meduim Prompt
Set as : "Broker Name :"
Skip : Yes

[Field:VCHTransportTit]
Use : VCHBrokerNameTit
Set as : "Transport Name :"

[Field:VCHLoadManTit]
Use : VCHBrokerNameTit
Set as : "Loadman Name :"

[Field:VCHBrokerName]
Use : Name Field
Storage : BrokerName
Table : BrokerNameColl,EndofList
Show Table : Always
Key : CreateBroker

[Field:VCHTransport]
Use : Name Field
Storage : TransportName
Table : TransportNameColl,EndofList
Show Table : Always
Key : CreateBroker

[Field:VCHLoadMan]
Use : Name Field
Storage : LoadmanName
Table : LoadmanNameColl,EndofList
Show Table : Always
Key : CreateBroker

[Key:CreateBroker]
Key : Alt + C
Action : Alter : CMP BrokerNameReport

;;=========================================================
;;================= Broker wise Report ==================
;;=========================================================
[#Menu: Gateway of Tally]
Add : Key Item : After : @@locSalesRegister : "Broker Report" : R : Display : BrokerReport
;Control : BrokerReport : $EnableBroker:Company:##SVCurrentCompany

[Report:BrokerReport]
Use : DSP Template
Title : "Broker Report"
Variable: SVFromDate, SVToDate
Repeat : PartyName
Form : BrokerReport
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Set : FilterBroker : ""
Set : FilterTransport : ""
Set : FilterLoadman : ""

[Form:BrokerReport]
Button : PrintButton, ExportButton
Button : ExplodeFlag,ChangePeriod,BtnBroker
Bottom Toolbar Buttons : EnterToEdit, BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
Part : BWRTitle,BWRPeriod,BWRFilter,BWRDetails
Bottom Part :BWRTotals
Width : 75% Page
Space Left : 2 mms
Space Right : 2 mms

[Key: EnterToEdit]
Key : Enter
Title : $$LocaleString:"Explode"
Type : BottomToolBarBtn2
Action : Explode

[Part:BWRTitle]
Line : BWRTitle
Horizontal Align : Center

[Part:BWRPeriod]
Line : BWRPeriod

[Line:BWRTitle]
Field : Simple Field
Local : Field : Simple Field : Style : Large Bold
Local : Field : Simple Field : Info : "Sales Report"
Local : Field : Simple Field : Border: Thin Bottom
Local : Field : Simple Field : Align : Center

[Line:BWRPeriod]
Right Field : Name Field
Left Field : Short Prompt,RPTBrokerFilter
Local : Field : Name Field : Info : @@DSPDateStr
Local : Field : Name Field : Width : 50
Local : Field : Name Field : Align : Right
Local : Field : Short Prompt : Set as: "Broker:"
Local : Field : Short Prompt : Inactive: Not $EnableBroker:Company:##SVCurrentCompany

[Part:BWRFilter]
Line : BWRTranFilter,BWRLMFilter
Invisible : Not $EnableBroker:Company:##SVCurrentCompany

[Line:BWRTranFilter]
Field : Short Prompt,RPTTransportFilter
Space Top : 1 mms
Local : Field : Default : Use : Simple Field
Local : Field : Short Prompt : Set as : "Transport:"

[Line:BWRLMFilter]
Field : Short Prompt,RPTLoadManFilter
Space Top : 1 mms
Local : Field : Default : Use : Simple Field
Local : Field : Short Prompt : Set as : "Loadman:"

[Field:RPTBrokerFilter]
Inactive : Not $EnableBroker:Company:##SVCurrentCompany
Use : Simple Field
Style : Normal Bold
Set as : @VCHBrokerName
Set Always : Yes
VCHBrokerName : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then "Show All" Else ##FilterBroker

[Field:RPTTransportFilter]
Use : RPTBrokerFilter
Set as : @VCHTransport
VCHTransport : if ##FilterTransport="" or $$IsEndOfList:##FilterTransport Then "Show All" Else ##FilterTransport

[Field:RPTLoadManFilter]
Use : RPTBrokerFilter
Set as : @VCHLoadMan
VCHLoadMan : if ##FilterLoadman="" or $$IsEndOfList:##FilterLoadman Then "Show All" Else ##FilterLoadman


[Line:BWRHead]
Use : BWRDetails
Border : Column Titles
Local : Field : Default : Type : String
Local : Field : Default : Align : Center
Local : Field : Default : Border : Thin Left
Local : Field : Default : Style : Normal Bold
Local : Field : SWSno : Set as : "Sno"
Local : Field : SWSno : Border : Thin Left Right
Local : Field : BWRPartyName : Set as : "Party Name"
Local : Field : BWRPartyName : Align : Left
Local : Field : BWRActulQty : Set as : "Actual Qty"
Local : Field : BWRActulQty : Align : Left
Local : Field : BWRBilledQty : Set as : "Billed Qty"
Local : Field : BWRBilledQty : Align : Left
Local : Field : BWRAmount : Set as : "Amount"
Local : Field : BWRAmount : Border : Thin Left Right
Space Top : 1.5 mms
Space Bottom: 1.5 mms

[Part:BWRDetails]
Line : BWRHead,BWRDetails
Repeat : BWRDetails:BWRPartyWise
Scroll : Vertical
Total : BWRActulQty,BWRBilledQty,BWRAmount
Common Border : Yes

[Line:BWRDetails]
Field : SWSno,BWRPartyName
Right Field : BWRActulQty,BWRBilledQty,BWRAmount
Option : AlterOnEnter : $$IsVoucher
Space Bottom: 0.5 mms
Space Top : 0.5 mms
Border : Thin Top
Explode : BWRExplode : ($$KeyExplode OR ##ExplodeFlag)

[Field:BWRDefault]
Use : Name Field
Style : Normal Bold

[Field:SWSno]
Use : BWRDefault
Set as : $$Line
Width : 1.5 cm
Align : Center
Border : Thin Left Right

[Field:BWRPartyName]
Use : BWRDefault
Set as : $PartyName
Width : 60
Quick Search: Yes
Space Left : 2 mms

[Field:BWRActulQty]
Use : Qty Field
Type : Number
Set as : $TotActQty;VoucherTypeName
Width : 16
Space Left : 2 mms
Border : Thin Left Right

[Field:BWRBilledQty]
Use : BWRActulQty
Set as : $TotBillQty
Width : 16
Space Left : 2 mms
Border : Thin Right

[Field:BWRAmount]
Use : BWRDefault
Set as : $TotAmount
Type : Amount
Width : @@AmountWidth
Format : "No Zero, Symbol," + ##ShowForex
Align : Right
Key : Calculator
Max : @@MaxNumberWidth
Width : 16
Space Right : 2 mms
Border : Thin Right
Tooltip : "Amount Without TAX"

[Part:BWRTotals]
Line : BWRTotal

[Line:BWRTotal]
Border : Totals
Use : BWRDetails
Local : Field : Default : Type : String
Local : Field : Default : Align : Right
Local : Field : Default : Style : Large Bold
Local : Field : Default : Border : Thin Left
Local : Field : SWSno : Set as : ""
Local : Field : BWRPartyName : Set as : "Grand Total"
Local : Field : BWRActulQty : Set as : $$Total:BWRActulQty
Local : Field : BWRBilledQty : Set as : $$Total:BWRBilledQty
Local : Field : BWRAmount : Set as : $$Total:BWRAmount
Local : Field : BWRAmount : Border : Thin Left Right
Local : Field : BWRAmount : Align : Right

[Part:BWRExplode]
Line : BWRExplode
Repeat : BWRExplode:BWRPartyExplode
Border : Thin Bottom

[Line:BWRExplode]
Use : BWRDetails
Delete : Border
Local : Field : SWSno : Set as : ""
Local : Field : Default : Style : Normal Italic
Local : Field : BWRPartyName : Set as : $ItemName
Local : Field : BWRPartyName : Align : Right
Local : Field : BWRActulQty : Type : Quantity
Local : Field : BWRActulQty : Set as : $SubActQty
Local : Field : BWRBilledQty : Type : Quantity
Local : Field : BWRBilledQty : Set as : $SubBillQty
Local : Field : BWRAmount : Set as : $SubAmount

;===============================================================
;======================= Add Filters ===========================
;===============================================================

[Button:BtnBroker]
Key : F5
Action : Execute : BrokerReportWise
Title : Broker Wise
Inactive: Not $EnableBroker:Company:##SVCurrentCompany

[Report:BrokerReportWise]
Form : BrokerReportWise

[Form:BrokerReportWise]
Part : BrokerReportWise
Space Left : 2 mms
Space Right : 2 mms

[Part:BrokerReportWise]
Line : BrokerReportWise,FilterTransport,FilterLoadman

[Line:BrokerReportWise]
Field : Medium Prompt,BrokerReportWise
Local : Field : Medium Prompt : Set as : "Select Broker Name:"
Space Bottom : 2 mms

[Field:BrokerReportWise]
Table : BrokerNameColl,EndOfList
ShowTable : Always
Use : Name Field
Width : 20
Border : Thin Box
Variable : FilterBroker
Modifies : FilterBroker

[Line:FilterTransport]
Field : Medium Prompt,FilterTransport
Local : Field : Medium Prompt : Set as : "Select Transport Name:"
Space Bottom : 2 mms

[Field:FilterTransport]
Table : TransportNameColl,EndOfList
ShowTable : Always
Use : Name Field
Width : 20
Border : Thin Box
Variable : FilterTransport
Modifies : FilterTransport

[Line:FilterLoadman]
Field : Medium Prompt,FilterLoadman
Local : Field : Medium Prompt : Set as : "Select Loadman Name:"
Space Bottom : 2 mms

[Field:FilterLoadman]
Table : LoadmanNameColl,EndOfList
ShowTable : Always
Use : Name Field
Width : 20
Border : Thin Box
Variable : FilterLoadman
Modifies : FilterLoadman

;=============================================================
;================= System Functions =========================
;=============================================================

[System:UDF]
EnableBroker : Logical : 4566
BrokerNameList : String : 4567
TransportList : String : 4568
LoadmanList : String : 4569
BrokerName : String : 4570
TransportName : String : 4571
LoadmanName : String : 4572

[System:Formula]
BWRFilter : $BrokerName=@@BrokerWise AND $TransportName=@@TransportWise AND $LoadmanName=@@LoadmanWise
BrokerWise : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then $BrokerName Else ##FilterBroker
TransportWise : If $$IsEndOfList:##FilterTransport or ##FilterTransport="" Then $TransportName Else ##FilterTransport
LoadmanWise : If $$IsEndOfList:##FilterLoadman or ##FilterLoadman="" Then $LoadmanName Else ##FilterLoadman
BWRExplodeFilter: $PartyName=#BWRPartyName

[Collection: BWR Voucher]
Type : Vouchers : VoucherType
Child of : $$VchTypeSales
Belongs to : Yes
Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount,BrokerName,TransportName,LoadmanName
Filter : NOTIsOptionalVoucher,BWRFilter

[Collection:BWRPartyWise]
Source Collection : BWR Voucher
Walk : Inventory Entries
By : PartyName : $PartyLedgerName
Aggr Compute: TotActQty : Sum : $ActualQty
Aggr Compute: TotBillQty: Sum : $BilledQty
Aggr Compute: TotAmount : Sum : $Amount
Sort : Default : $PartyName

[Collection:BWRPartyExplode]
Source Collection : BWR Voucher
Walk : Inventory Entries
By : PartyName : $PartyLedgerName
By : ItemName : $StockItemName
Aggr Compute: SubActQty : Sum : $ActualQty
Aggr Compute: SubBillQty: Sum : $BilledQty
Aggr Compute: SubAmount : Sum : $Amount
Filter : BWRExplodeFilter

[Collection:BrokerNameColl]
Type : BrokerNameList: Company
Childof : ##SVCurrentCompany
Format : $BrokerNameList,25
Title : List of Brokers

[Collection:TransportNameColl]
Type : TransportList: Company
Childof : ##SVCurrentCompany
Format : $TransportList,25
Title : List of Transports

[Collection:LoadmanNameColl]
Type : LoadmanList: Company
Childof : ##SVCurrentCompany
Format : $LoadmanList,25
Title : List of Loadmans

[Variable: PartyName]
Type : String
Repeat : ##DSPRepeatCollection

[Variable:FilterBroker]
Type : String

[Variable:FilterTransport]
Type : String

[Variable:FilterLoadman]
Type : String

[System:Variables]
FilterBroker : ""
FilterTransport : ""
FilterLoadman : ""


when installing above tdl, we get an error saying duplicate description error and the screen shot is being uploaded for reference. please advice the solution for it to be made in tdl code.

 

Thanks Shivam
Its very nicely written code,
It helped me a lot to get some filter concepts for Collection.
Using those i can write code for my requirement,
Thanks Once Again

 

plz tell the solution for dublicate description error.

 

plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.

 

plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.

 

plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.

 

plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.

 

plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. plz advice.

 

plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. plz advice.

 

sir call 7879713424

 

cud not understand by this??/

 

cud not understand by this??/

plz provide the solution for the error faced in tally erp 9 v 6.2 duplicate description error with variable PartyName even though there are no TDL loaded.