.jpg)
Watch the full video to get full coding
[Form:TallyPrimeParty]
Use : DSP Template
Parts :PQWSTitle,PQWSPeriod,TallyPrimeParty
Button : ExplodeFlag,ChangePeriod
Bottom Toolbar Buttons : EnterToEdit,BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:StockItemNameRepeat
Set Always : SV Print Orientation : "Landscape"
Width : 100% Page
Space Left : 2 mms
Space Right : 2 mms
[Key: EnterToEdit]
Key : Enter
Title : $$LocaleString:"Explode"
Type : BottomToolBarBtn2
Action : Explode
[Part:PQWSTitle]
Line : PQWSTitle
Horizontal Align : Center
[Part:PQWSPeriod]
Line : PQWSPeriod
[Line:PQWSTitle]
Field : Simple Field
Local : Field : Simple Field : Style : Large Bold
Local : Field : Simple Field : Info : "PARTY WISE TOTAL SALES AMOUNT"
Local : Field : Simple Field : Border: Thin Bottom
Local : Field : Simple Field : Align : Center
[Line:PQWSPeriod]
Right Field : Name Field
Local : Field : Name Field : Info : @@DSPDateStr
Local : Field : Name Field : Width : 60
Local : Field : Name Field : Align : Right
[!Form: Set Auto Vch Option]
[Part:TallyPrimeParty]
Lines :TallyPrimeParty Title,TallyPrimeParty Details
BottomLines :TallyPrimeParty Total
Repeat :TallyPrimeParty Details : Party Name Repeat
Scroll : Vertical
CommonBorder: Yes
Total :TallyPrimeParty Party,TallyPrimeParty Col Total
[Line:TallyPrimeParty Title]
Use :TallyPrimeParty Details
Local : Field : Default : Type : String
Local : Field : Default : Align : RIGHT
Local : Field : PGWSSno : Set as : "SNO"
Local : Field : PGWSSno : Border : Thin Left Right
Local : Field :TallyPrimeParty Name : Set as : "Product Name"
Local : Field :TallyPrimeParty Name : ALIGN : LEFT
Local : Field :TallyPrimeParty Name : Widespaced: Yes
Local : Field :TallyPrimeParty Party : Set as : ##StockItemNameRepeat
Local : Field :TallyPrimeParty Party : Lines : 0
Local : Field :TallyPrimeParty ColTotal : Set as : "Total"
Local : Field :TallyPrimeParty ColTotal : Border : Thin Left Right
Border : COLUMN TITLES
[Line:TallyPrimeParty Details]
Fields :PGWSSno,TallyPrimeParty Name,TallyPrimeParty Party,TallyPrimeParty Col Total
Repeat :TallyPrimeParty Party
Total :TallyPrimeParty Party
Explode : PIMDExplodee : ($$KeyExplode OR ##ExplodeFlag) ; problem in exploding
[Part:PIMDExplodee]
Line : PIMDExplodee
Repeat : PIMDExplodee:PIMDPartyExplodee
Border : Thin Bottom
[Line:PIMDExplodee]
Use :TallyPrimeParty Details
Local : Field : Default : Type : String
Local : Field : Default : Align : RIGHT
Local : Field : PGWSSno : Set as : ""
Local : Field : PGWSSno : Border : Thin Left Right
Local : Field :TallyPrimeParty Name : Set as : $stockitemexp
Local : Field :TallyPrimeParty Name : ALIGN : LEFT
Local : Field :TallyPrimeParty Party : Set as : $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormulaa:SalesVoucherPartyItemWiseTotalAmountCollexp
Local : Field :TallyPrimeParty ColTotal : Set as : $$Total:TallyPrimePartyParty
Local : Field :TallyPrimeParty ColTotal : Border : Thin Left Right
[system : formula]
MyFormulaa : ##StockItemNameRepeat + #TallyPrimePartyNam
[Field:PGWSSno]
Use : NUMBER FIELD
Set as : $$Line
Width : if $$inprintmode then 5 else 4
Align : Center
Border : Thin Left Right
[Field:TallyPrimeParty Name]
Use : Name Field
Set as : $PartyLedgerRepeatNew
Variable : Stock Item Name
[Field:TallyPrimeParty Party]
Use : Amount Field
Set as : $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormula:SalesVoucherPartyItemWiseTotalAmountColl
MyFormula : ##StockItemNameRepeat + #TallyPrimePartyName
Format : "NoZero"
Border : Thin Left
[Field:TallyPrimeParty Col Total]
Use : Amount Field
Set as : $$Total:TallyPrimePartyParty
Border : Thin Left RIGHT
[Line:TallyPrimeParty Total]
Fields :PGWSSno,TallyPrimeParty Name,TallyPrimeParty Party,TallyPrimeParty Col Total
Repeat :TallyPrimeParty Party
Local : Field : Default : Type : String
Local : Field : Default : Align : RIGHT
Local : Field :PGWSSno : Set as : ""
Local : Field :TallyPrimeParty Name : Set as : "Total"
Local : Field :TallyPrimeParty Name : ALIGN : LEFT
Local : Field :TallyPrimeParty Name : Widespaced: Yes
Local : Field :TallyPrimeParty Party : Set as : $$Total:TallyPrimePartyParty
Local : Field :TallyPrimeParty ColTotal : Set as : $$Total:TallyPrimePartyColTotal
Local : Field :TallyPrimeParty ColTotal : Border : Thin Left Right
Border : TOTALS
[Collection: SALES VOUCHER COLL]
Type : Voucher
Filter : SalesVoucherFilter
[Collection: SalesVoucherPartyItemWiseTotalAmountColl]
Source Collection : SALES VOUCHER COLL
Walk : Inventory Entries
By : StockItemNameRepeat : $PartyLedgerName
By : PartyLedgerRepeatNew : $Parent:STOCKITEM:$StockItemName
Aggr Compute : Amount : SUM : $Amount
Search Key : $StockItemNameRepeat + $PartyLedgerRepeatNew
; exploded part collection
[Collection: SalesVoucherPartyItemWiseTotalAmountCollEXP]
Source Collection : SALES VOUCHER COLL
Walk : Inventory Entries
By : StockItemNameRepeat : $PartyLedgerName
By : PartyLedgerRepeatNew : $Parent:STOCKITEM:$StockItemName
By : StockItemexp : $StockItemName
Aggr Compute : Amount : SUM : $Amount
Search Key : $StockItemNameRepeat + $StockItemexp
[Collection: Party Name Repeat]
Source Collection : SALES VOUCHER COLL
Walk : Inventory Entries
By : PartyLedgerRepeatNew : $Parent:STOCKITEM:$StockItemName
Aggr Compute : Amount : SUM : $Amount
[Collection: Item Name Repeat Coll]
Source Collection : SALES VOUCHER COLL
Walk : Inventory Entries
By : StockItemNameRepeat : $PartyLedgerName
Aggr Compute : Amount : SUM : $Amount
; explode collection
[Collection: PIMDPartyExplodee]
Source Collection : SALES VOUCHER COLL
Walk : Inventory Entries
By : PartyLedgerRepeatNew : $Parent:STOCKITEM:$StockItemName
By : StockItemexp : $StockItemName
Aggr Compute : Amount : SUM : $Amount
[Variable: StockItemNameRepeat]
Type : String
Repeat : ##DSPRepeatCollection
[System: Formula]
SalesVoucherFilter : $$IsSales:$VoucherTypeName
.jpg)
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें