Broker Wise Details Not Shown

Dear Friends
Here is file i create brokers at sales voucher
but in report i not able get the details of each individual broker
can any body please help me
thanking you
----------------------------------------------------
;;;; Broker Wise Text file
---------------------------------------------------

[#Menu: Accounts Info.]
Add: Item :Before : @@locQuit:Brokers: Alter:BrokersCreate
[Report:BrokersCreate]
Form: BCForm
Title: "Broker Details"
object : Company
[Form: BCForm]
Width: 60% Screen
Height: 60% Screen
Background: FormClr
Part:BCPart
[Part:BCPart ]
Line: BCInfo
Repeat:BCInfo:BrokerInfo
Break on : $$IsEmpty:$BrokerName
Scroll: Vertical
[Line:BCInfo]
Fields : Multi SNo, BCName
Local : Field : Default : Delete : Border
[Field: BCName]
Use : Short Name Field
Storage : BrokerName
Unique : Yes
[System: UDF]
BrokerInfo: Aggregate: 110
BrokerName: String: 100:Yes
[Collection: List of Broker]
Type : BrokerInfo:Company
Child Of: ##SVCurrentCompany
Format: $BrokerName, 20
Title: "List of Broker"
Fetch: BrokerName
[#Part: EI BaseInfo]
Option: BrokerEIBaseInfo:$$IsSales:$vouchertypeName
[!Part: BrokerEIBaseInfo]
Add : Lines : BrokerNameLine
Local: Field : Name Field : Skip : yes
[Line:BrokerNameLine]
Field : Name Field, BrokerNameFld
Local : Field : Name Field : Set as : "Broker Name:"
[Field:BrokerNameFld]
Use : Name Field
Width: 20
Table: List of Broker, Not Applicable
Show Table: Always
Storage: BrokernameUDF
[System:UDF]
BrokerNameUDF : String: 101
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[#menu:gateway of tally]
Add :Key item: All Broker Sales Report:Lisplay :All Broker Sales
Add :Key item: Brokerwise Sales Report:Lisplay Collection :MyBrokerSales
[Collection:MyBrokerSales]
Type: BrokerInfo : Company
Belongs To: ##SVCurrenCompany
Variable: ACBroker Name
Report:ACSalesReport
Trigger: ACBrokerTrigger
Fetch: BrokerName
[Report:ACBrokerTrigger]
Form: ACBrokerForm
Variable: ACBroker Name
[Form: ACBrokerForm]
Part: ACBrokerPart
Height: 100% Page
Width: 20% Page
[Part: ACBrokerPart]
Line:ACBrokerLineTitle, ACBrokerLine
[Line:ACBrokerLineTitle]
Fields: Form SubTitle
Local : Field: Form SubTitle : Set as: "Select Broker"
Space Bottom : 1
[Line:ACBrokerLine]
Field:AcBrokerFld
[Field:AcBrokerFld]
Use : Name Field
Width: 20
Table: List of Broker, Not Applicable
;Show Table: Always
;Table:MyBrokerSales
;Variable:ACBroker Name
Modify:ACBroker Name
Show Table:Always
[Report: ACSalesReport]
Form:ACSalesForm
Variable: SVFromDate, SVTodate
Set : SVFromDate : #SVFromDate
Set : SVToDate : #SVToDate
[Form: ACSalesForm]
Part: ACSalesPart
Buttons: F2 Change Period
Width: 100% Screen
[Part:AcSalesPart]
Line: AcSalesLineTitle, AcSalesDetails
Repeat: AcSalesDetails : MySalesCollection
Scroll:Vertical
Common Border: Yes
[Line: AcSalesLineTitle]
Use: AcSalesDetails
Local: Field: Default :Line: 2
Local: Field: Default :Type : String
Local: Field: Default : Align: Center
Local: Field: B_Date : Set as: "Date"
Local: Field: B_No: Set as: "BillNo"
Local: Field: B_Party : Set as: "Particular"
Local: Field: Pary_Broker: Set as: "Broker"
Local: Field:B_Prod: Set as: "Product"
Local: Field: B_Amount: Set as: "Amount"
Border: Column Titles
[Line: AcSalesDetails ]
Left Field: B_Date, B_No, B_Party,Pary_Broker, B_Prod
Right Field: B_Amount
[Field:B_Date]
Use:Short Date Field
Set as: $Date
Border: Thin Right
[Field:B_No]
Use: Number Field
Set as: $VoucherNumber
Width: 5
Border: Thin Right

[Field:B_Party]
Use: Name Field
Set as: $PartyLedgerName
Width: 20
Border: Thin Right
[Fieldary_Broker]
Use: Name Field
Set as: $BrokernameUDF
Width: 20
Border: Thin Right
[Field:B_Prod]
Set as: $stockitemName
Width: 10
Border: Thin Right
[Field:B_Amount]
Use: Amount Field
Set as: $Amount
Width: 7
[Collection:MySalesCollection]
Type: Voucher
Fetch: Date, PartyLedgerName, VoucherNumber, BrokerNameUDF, +
StockitemName, Amount
Filter:SaleVCH
Filter:Ledfil
[Variable : ACBroker Name]
Type: String
[System:Formula]
SaleVCH : $$IsSales:$VoucherTypeName
Ledfil: $BrokerNameUDF contains ##ACBrokerName

[Report:All Broker Sales]
Use: ACSalesReport
[*Part:AcSalesPart]
Line: AcSalesLineTitle, AcSalesDetails
Repeat: AcSalesDetails : MySalesCollection1
Scroll:Vertical
Common Border: Yes
[Collection:MySalesCollection1]
Use:MySalesCollection
Delete: Filter
Add: Filter: SaleVCH

 

Dear Sir,

Thanks for sharing but few components not working in it, such as broker wise sales report. also it would be great if you add following features such as:
1. Printing of Agent name in sales invoice.
2. Default allocation of agent in master ledger.
3. Fully working of Sales report agent wise.
4. Commision of agent on sales total value or total quantity.
5. Total commision due / payable report.

I think these additions will make your module full complete.

Thanks for contributing

 

Dear kuber
i have some minor rectification so i not get report
from the program
can you do it form my self

 

I am not able to find out.

 

individual broker details not comming in invoice alos broker name is not printing

 

so that it was pending these days
for proper suggestion

 

that is very good can u add broker to purchase invoice in the same report and i want to can print and export to text can u help me

 

IT'S WORKING BUT HOW MANY PERCENT DISCOUNT GIVEN BROKER IT'S NOT SPECIFY......???

hELP Me

 

How to collect data like i want to make Broker-wise report. I tried but failed. Any body can help me please?????

 

sir,
how to add code to it that the person who is making entry can only exit once he enters all the fields or else system will not accept the entry in otherwords will only allow entry to posted on full filling all the fields.

 

You can put validations to all fields so user can not go further unless filled the field

aaradhya.tallysolutions@gmail.com

 

Did try but codes were not working. Plz provide the codes.

 

what did you try? can you please let me know?

aaradhya.tallysolutions@gmail.com

 

what did you try? can you please let me know?

aaradhya.tallysolutions@gmail.com

 

[#Field: VCH DrAmt]
;[#Field : VCH Particulars]
Sub Form : APLVATVCHMODI : $$IsPurchase:##SVVoucherType OR $$IsJournal:##SVVoucherType AND ($$IsLedofGrp:$LedgerName:"Duties & Taxes")
Background : red

[#Field: VCH CrAmt]

Sub Form : APLVATVCHMODI : $$IsPurchase:##SVVoucherType OR $$IsJournal:##SVVoucherType AND ($$IsLedofGrp:$LedgerName:"Duties & Taxes")
Background : red

[Report : APLVATVCHMODI]
Title : "INPUT VAT DETAILS"
Forms : APLVATVCHMODI
Object : Company : ##SVCurrentCompany
Use : DSPTemplate

[Form : APLVATVCHMODI]

Parts : APLVATVCHMODITM,APLVATVCHMODI
Width : 80% Page
Height : 30% Page
Background : Light Grey

[Part : APLVATVCHMODITM]

Line : APLVATVCHMODITM

[Line : APLVATVCHMODITM]

Field : APLVATVCHMODITM

[Field : APLVATVCHMODITM]
Use : Name Title Field
Info : "INPUT VAT DETAILS"
Style : APLSTL1
Align : Center
Color : Dark Green
Background : Light Lily Yellow
Width : 100 % page

[Part : APLVATVCHMODI]

Lines : ALPVCHMODITIT,ALPVCHMODIBODY
Repeat : ALPVCHMODITIT :APLAGGRGATECOLl
Scroll : Vertical
Common Borders : Yes
Break On : $$IsEndOfList:$ALPPARTYNAME
Border : Thin Box


[Style : APLSTL1]
Font : "Tohoma"
Height : 12
Bold : Yes


[Line : ALPVCHMODITIT]

Use : ALPVCHMODIBODY
Local : Field : ALPPARTYNAME : Info : "Supplier Name"
Local : Field : APLTINNO : Info : "TIN No. "
Local : Field : ALPVRNNO : Info : "VRN No."
Local : Field : ALPINVNO : Info : "Invoice / Fical Reciept No."
Local : Field : APLFICALDATE : Info : "Invoice / Fical Reciept Date"
Local : Field : ALPDESC : Info : "Good Descreption"
Local : Field : ALPINVAMT : Info : "Invoice Amount Excluding VAT"
Local : Field : ALPVATAMT : Info : "VAT Amount"
Local : Field : APLinvtotal : Info : "Total Invoice Amount"
Local : Field : Default : Align : Centre
Local : Field : Default : Line : 0
Local : Field : Default : Delete : Storage
Local : Field : Default : Style : Normal Serif Bold
Local : Field : Default : Delete : Inactive
Local : Field : Default : Type : String
Local : Field : Default : Skip : Yes
Local : Field : Default : Background: Lily Yellow
Local : Field : Default : Color : Red
Border : Thin Top Bottom


[Line : ALPVCHMODIBODY]

Field : ALPPARTYNAME,APLTINNO,ALPVRNNO,ALPINVNO, APLFICALDATE,ALPDESC,ALPINVAMT,ALPVATAMT,APLinvtotal

[Field : ALPPARTYNAME]

Use : Name Field
Storage : Setaplpartyname
Width : 20
Show Table : Always
Max : 20
Color : Blue
Border : Thin Left

[Field : APLTINNO]

Use : Name Field
Storage : SETapltinno
Width : 12
Max : 9
Set Always : Yes
Align : Center
Color : Blue
Border : Thin Left

[Field: ALPVRNNO]
Use : Name Field
Storage : SETaplvrnno
Color : Blue
Border : Thin Left
Width : 12
Max : 9

[Field : ALPINVNO]

Use : Name Field
Storage : SETaplinvno
Width : 15
Max : 15
Align : Right
Color : Blue
Border : Thin Left


[Field : APLFICALDATE]
Use : Uni Date Field
Storage : SETapldate
Width : 12
Max : 8
Align : Right
Border : Thin Left
Color : Blue


[Field : ALPDESC]
Use : Name Field
Storage : SETapldesc
Width : 29
Align : Right
Color : Blue
Border : Thin Left

[Field : ALPINVAMT]
Use : Amount Field
Storage : SETaplinvamount
Set : $Amount * 100/18
Width : 20
Skip : Yes
Align : Right
Color : Blue
Border : Thin Left

[Field: ALPVATAMT]
Use : Amount Field
Set : $Amount
Storage : SETaplvatamt
Skip : Yes
Color : Blue
Border : Thin Left Right


[Field: APLinvtotal]
Use : Amount Field
Set as : #ALPINVAMT + #ALPVATAMT
Storage : SETAPLinvtotal
Color : Blue
Border : Thin Left Right


[System : UDF]

APLAGGRGATECOLL : Aggregate : 24124
Setaplpartyname : String : 24125
SETapltinno : String : 24126
SETaplvrnno : String : 24127
SETaplinvno : String : 24128
SETapldate : Date : 24129
SETapldesc : String : 24130
SETaplinvamount : Amount : 24131
SETaplvatamt : Amount : 24132
SETAPLinvtotal : Amount : 24133


[Collection: APLAGGRGATECOLL]

Type : APLAGGRGATECOLL :Company
Childof : ##SVCurrentCompany
Format : $Setaplpartyname,20
format : $SETapltinno,20
Format : $SETaplvrnno,20
Format : $SETaplinvno,20
Format : $SETapldate,20
Format : $SETapldesc,20
Format : $SETaplinvamount,20
Format : $SETaplvatamt,
Format : $SETAPLinvtotal. 20
Title : "INPUT VAT DETAILS"
;Fetch : Setaplpartyname,SETapltinno,SETaplvrnno,SETaplvrnno,SETapldate, SETapldesc,SETaplinvamount,SETaplvatamt,SETAPLinvtotal,date,stockitem,VoucherNumber,ledger,APLAGGRGATECOLl,SETAPLremarkv


;REPORT===========

[#Menu: Display Menu]
Add: Item: Input Vat Ragister : Display: APLVATDISREPORT


[Report : APLVATDISREPORT]
Form : APLVATDISREPORT
Title : "Input Vat Ragister"
Use : DSP Template
Variable : SVFromDate,SVToDate,SVCurrentCompany
Set : SVCurrentCompany : ##SVCurrentCompany
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVTodate : $$MonthEnd:##SVCurrentDate

[Form : APLVATDISREPORT]
Parts : APLVATDISREPORTtitle, APLVATDISREPORBODY
Height : 100% Screen
Width : 100% Screen
Background : Light Autumn Green
Use : DSP Template

[Part: APLVATDISREPORTtitle]

Line: APLVATDISREPORTtitle, APLVATDISREPORTtitle1

[Line: APLVATDISREPORTtitle]
Left Field : APLCOMFLD
Right Field : APLCOMFLDNAME
Space Bottom: 3 mms

[Field: APLCOMFLD]
Use : Name Field
Set as : ##SVCurrentCompany
Full Width : Yes
Style : @@SV_TABLE_TITLE_STYLE
Color : Blue

[Field: APLCOMFLDNAME]
Use : Name Field
Set As : "Input Vat Ragister For the Period : " + $$String:##SVFromDate + " to " + $$String:##SVToDate
Full Width : Yes
Align : Right
Style : @@SV_TABLE_TITLE_STYLE
Color : Blue

[Line : APLVATDISREPORTtitle1]

Use: APLVATDISREPORBODY
Local: Field: Default : Style : @@SV_TABLE_SUB_TITLE_STYLE
Local: Field: Default : Align : Center
Local: Field: Default : Color : Red
Local: Field: Default : Background: Light Autumn Green
Local: Field: Default : Lines : 2
Local: Field: APLDISSUP : Info : "SUPPLIER_NAME"
Local: Field: APLDISVRN : Info : "SUPPLIER_VRN"
Local: Field: APLDISINVNO : Info : "TAX_INVOICE_ NUMBER"
Local: Field: APLDISINVDATE : Info : "DATE_OF_INVOICE"
Local: Field: APLDISDECRIP : Info : "GOOD DESCRIPTION "
Local: Field: APLDISEXAMT : Info : "AMOUNT VAT EXCLUDING"
Local: Field: APLDISVATAMT : Info : "VAT_AMT"
Border: Flush Column Titles

[Part : APLVATDISREPORBODY]
Lines : APLVATDISREPORBODY
Repeat : APLVATDISREPORBODY : APLVATDISREPORBODYColl
Scroll : Vertical
Common Border : Yes

[Line : APLVATDISREPORBODY]

Field : APLDISSUP,APLDISVRN,APLDISINVNO,APLDISINVDATE
Right Field : APLDISDECRIP,APLDISEXAMT,APLDISVATAMT
Space Bottom : 0.75
Local : Field: Default : Style : @@SV_CMP_LIST_MAIN_TITLE_STYLE

[Field : APLDISSUP]
Use : Name Field
Set as : $Setaplpartyname
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 30
Align : Center
Color : Blue
Border : Thin Left


[Field : APLDISVRN]
Use : Name Field
Set as : $SETaplvrnno
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 15
Align : Center
Color : Blue
Border : Thin Left

[Field : APLDISINVNO]
Use : Name Field
Set as : $SETaplinvno
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 20
Align : Center
Color : Blue
Border : Thin Left


[Field : APLDISINVDATE]

Use : Uni Date Field
Set as : $SETapldate
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 18
Align : Center
Color : Blue
Border : Thin Left


[Field : APLDISDECRIP]
Use : Name Field
Set as : $SETapldesc
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 40
Align : Center
Color : Blue
Border : Thin Left


[Field : APLDISEXAMT]
Use : Amount Field
Set as : $SETaplinvamount
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 25
Align : Center
Color : Blue
Border : Thin Left


[Field : APLDISVATAMT]
Use : Amount Field
Set as : $SETaplvatamt
Style : @@SV_TABLE_SUB_TITLE_STYLE
Width : 20
Align : Center
Color : Blue
Border : Thin Left



[Collection: APLPAYVOUCHERCOLL]
Type : Vouchers : VoucherType
Child Of : $$VchTypePayment
Belongs To : Yes


[Collection: APLPRUVOUCHERCOLL]
Type : Vouchers : VoucherType
Child Of : $$VchTypePurchase
Belongs To : Yes

[Collection: APLPJOUOUCHERCOLL]
Type : Vouchers : VoucherType
Child Of : $$VchTypeJournal
Belongs To : Yes

[Collection : APLVATDISREPORBODYColl]
Source Collection : APLPAYVOUCHERCOLL, APLPRUVOUCHERCOLL,APLPJOUOUCHERCOLL
Walk : LedgerEntries,APLAGGRGATECOLL
Fetch : Setaplpartyname,SETapltinno,SETaplvrnno,SETaplvrnno,SETapldate, SETapldesc,SETaplinvamount,SETaplvatamt,SETAPLinvtotal,date,stockitem,VoucherNumber,ledger,APLAGGRGATECOLl,SETAPLremarkv
ParmVar : SVFromDate : Date : ##SVFromDate
ParmVar : SVToDate : Date : ##SVToDate
Filter : APLVATREPORTA

[System : formula]

APLVATREPORTA : $$IsPayment:$VoucherTypeName and $$IsPurchase:$VoucherTypeName and $$IsJournal:$VoucherTypeName

 

dear sir

kindly see my above code i have create vat report but same problem in collection in display report so kindly please grid me

 

can any body Plz provide the codes.