Party wise sales Report

Party Wise Sales Report In Tally

<br /> [Collection : Area Wise Groups]<br /> TYpe : Group<br /> Variable : GroupName<br /> Childof : $$GroupSundryDebtors<br /> BelongsTo : Yes<br /> Fetch : Name<br /> Trigger : Area Wise Trigger<br /> Report : Area Wise Sales<br /> Title : "List of Areas"<br /> <br /> [Report : Area Wise Trigger]<br /> <br /> Use : Collection Variable<br /> Local : Line : Collection Variable : Field : Area Wise GroupName<br /> Local : Field : MV Title : Info : $$LocaleString:"Name of Group"<br /> <br /> [Field : Area Wise GroupName]<br /> <br /> Use : Name Field<br /> Table : Area Wise Groups<br /> Variable : GroupName<br /> Modifies : GroupName<br /> Show Table : Always<br /> <br /> [Report : Area Wise Sales]<br /> <br /> Use : DSP template<br /> Form : Area Wise Sales<br /> Variable : StockItemName, DoSetAutocolumn, StockGroupName,Show Value Only, Show CN Value<br /> Repeat : StockItemName<br /> Set : DSPRepeatCollection : "StockItemBelongsToGroupName"<br /> Local : Variable : StockItemName : Repeat : ##DSPRepeatCollection<br /> Set : SV From Date : $$MonthStart:##SVCurrentDate <br /> Set : SV To Date : $$MonthEnd:##SVCurrentDate <br /> ; Set : SVFromDate : $BooksFrom:Company:##SVCurrentCompany<br /> ; Set : SVToDate : $LastVoucherDate:Company:##SVCurrentCompany <br /> Set : Show Value Only : No<br /> Set : IsCategoryReport : No<br /> Set : IsGodownReport : No<br /> Set : IsItemReport : No<br /> Set : Show CN Value : No <br /> Set : IsStockReport : Yes<br /> Local : Collection : StockItemBelongsToGroupName : Sort : Default : $Parent, $$Name<br /> Local : Collection : StockItemBelongsToGroupName : Filter : EmptyValueFilter<br /> <br /> [System : Formula]<br /> <br /> EmptyValueFilter: NOT $$IsEmpty:$TrSaleValue<br /> <br /> [Form : Area Wise Sales]<br /> <br /> Use : DSP Template<br /> Part : Area Wise Sales Titles, Area Wise Sales ;, AWS BodyTotals<br /> Set : DoSetAutoColumn : Yes<br /> Local : Variable : DSPRepeatCollection : Repeat : "StockItemBelongsToGroupName"<br /> Option : Set AWSA Auto Option : ##DoSetAutoColumn AND $$SetAutoColumns:StockItemName<br /> Button : Change Stk Grp,Change LedGrp,Show Value Only,Show CN Value<br /> ; Button : SetStkGroup<br /> Delete : Bottom Button<br /> Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12<br /> <br /> [Button : Change Stk Grp]<br /> Title :"Stk Group"<br /> Key : F4<br /> Action : Modify Variable : Stock Group Name<br /> <br /> <br /> [Button : Change LedGrp]<br /> Title :"Group"<br /> Key : F5<br /> Action : Modify Variable : Area Wise Trigger<br /> <br /> [Button :Show Value Only]<br /> Title : IF NOT ##ShowValueOnly Then "Show Val" Else "Hide Val"<br /> Key : ALT + A<br /> Action : Set : ShowValueOnly : NOT ##ShowValueOnly<br /> <br /> [Button :Show CN Value]<br /> Title : IF ##ShowCNValue Then "Sales Val" Else "C/N Val"<br /> Key : ALT + S<br /> Action : Set : ShowCNValue : NOT ##ShowCNValue<br /> <br /> [Variable : Show Value Only]<br /> Type : Logical<br /> <br /> [Variable :Show CN Value]<br /> Type : Logical <br /> <br /> [System : Variable]<br /> Show Value Only : Yes<br /> Show CN Value : NO<br /> <br /> [!Form : Set AWSA Auto Option]<br /> <br /> Set : DoSetAutoColumn : No<br /> <br /> [Part : Area Wise Sales Titles]<br /> <br /> Line : AWS DatePeriod, Area Wise Group Name, Area Wise Sales Titles,Area Wise Sales Titles1<br /> <br /> [Line : AWS DatePeriod]<br /> <br /> Right Field : AWS DatePeriod<br /> <br /> [Field: AWS DatePeriod]<br /> <br /> Use : Name Field<br /> Set as : @@DSPDateStr<br /> Style : Normal Italic<br /> Align : Right<br /> <br /> [Line : Area Wise Group Name]<br /> <br /> Field : Short Prompt, DSP Area Wise Group Name,AllStkGrpName<br /> Local : Field : Short Prompt : Set as : "Area : "<br /> Right Fiel d: Simple Prompt, DSP SHowStkGrp<br /> Local : Field : Simple PRompt : Set as : "Stock Group : "<br /> <br /> [Field : DSP SHowStkGrp]<br /> <br /> Use : Short Name Field<br /> Set as : if $$IsEmpty:##StockGroupName then $$SysName:Primary else ##StockGroupName<br /> <br /> [Field : AllStkGrpName]<br /> Set as : $$Owner:$$FullList:SelectedGrpColl:$StkGroups<br /> Border : Thin Box<br /> Invisible: Yes<br /> <br /> <br /> [Field : DSP Area Wise Group Name]<br /> <br /> Use : Name Field<br /> Set as : ##GroupName<br /> <br /> <br /> [Line : Area Wise Sales Titles]<br /> <br /> Use : Area Wise Sales<br /> Local : Field : Default : Type : String<br /> Local : Field : Default : Lines : 0<br /> Local : Field : Default : Align : centre<br /> Local : Field : Default : Style : Tiny Bold<br /> Local : Field : AWS Name : Set as : "Particulars"<br /> Local : Field : AWSGrpName : Set as : "Group Name"<br /> Local : Field : AWS Qty : Set as : ##StockItemName<br /> Local : Field : AWS Qty : Background:Lily Yellow<br /> Local : Field : AWS Qty : Color : Red<br /> Local : Field : AWS Qty : Delete : Field<br /> Local : Field : AWS Qty : Cell : IF ##ShowValueOnly = Yes Then 2 Else 1<br /> Local : Field : AWS Qty : Border : PWS Border<br /> <br /> Local : Field : AWS QTY Total: Delete:Field<br /> Local : Field : AWS QTY Total: Set as: "Total"<br /> Local : Field : AWS QTY Total: Background:Lily Yellow<br /> Local : Field : AWS QTY Total: Color : Red <br /> Local : Field : AWS QTY Total: Border :PWS Border<br /> Local : Field : AWS QTY Total: Cell : 2<br /> <br /> Delete : Total<br /> Delete : Empty<br /> Delete : Explode<br /> Border : Thin Top<br /> <br /> [Line : Area Wise Sales Titles1]<br /> Use : Area Wise Sales<br /> Local : Field : Default : Type : String<br /> Local : Field : Default : Lines : 0<br /> Local : Field : Default : Align : centre<br /> Local : Field : Default : Style : Tiny Bold<br /> Local : Field : AWS Name : Set as : ""<br /> Local : Field : AWSGrpName : Set as : "" <br /> Local : Field : AWS B Qty: Set as : "B Qty"<br /> Local : Field : AWS B Qty: color : Blue<br /> Local : Field : AWS B Val: Set as : "B Val"<br /> Local : Field : AWS B Val: Color : Blue<br /> <br /> Local : Field : AWSBQTYTotal: Set as : "Qty Tot"<br /> Local : Field : AWSBQTYTotal: Color : Blue<br /> Local : Field : AWSBValTotal: Set as : "Val Tot"<br /> Local : Field : AWSBValTotal: Color : Blue<br /> <br /> Delete : Empty<br /> Delete : Explode<br /> Delete : Total<br /> Border : Thin Bottom<br /> <br /> <br /> [Part : Area Wise Sales]<br /> Part : AWS BodyDetails,AWS BodyTotals<br /> Vertical : Yes<br /> Scroll : Vertical<br /> CommonBorder: Yes <br /> ; Border : Thin Left Right<br /> <br /> [Part : AWS BodyDetails]<br /> Line : Area Wise Sales<br /> Repeat : Area Wise Sales : Area Wise Ledgers <br /> Scroll : Vertical<br /> Total : AWS Qty,AWS B Qty,AWS B Val<br /> Total : AWS B QTY Total,AWS B Val Total<br /> <br /> [Collection : Area Wise Ledgers]<br /> Type : Ledger<br /> Childof : ##GroupName<br /> BelongsTo : Yes<br /> Fetch : Name<br /> <br /> Compute : Parent : $Parent:Ledger:$LedgerName<br /> <br /> [Line : Area Wise Sales]<br /> <br /> Field : AWS Name, AWS GrpName,AWS Qty ,AWS QTY Total<br /> Repeat : AWS Qty<br /> Empty : $$IsEMpty:$TBalDebits<br /> Total : AWS B Qty,AWS B Val<br /> Border : Thin Bottom<br /> <br /> [Field : AWS Name]<br /> <br /> Use : NAme Field<br /> Set as : $NAme<br /> Variable : LEdgerName<br /> Style : Small <br /> Display : LEdger Vouchers<br /> <br /> [Field : AWS GrpName]<br /> Use : Name Field<br /> Set as : $Parent<br /> Border : Thin Left<br /> Width : 15<br /> <br /> [Field : AWS Qty]<br /> Field : AWS B Qty,AWS B Val<br /> Display : Item Monthly Summary<br /> <br /> [Field : AWS B Qty]<br /> Use : Qty Primary Field<br /> Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:SrcItemSummColl<br /> MyFormula : #AWSName + #StockItemName<br /> Style : Small<br /> Border : Thin Left<br /> Format : "No Zero,NoSymbol"<br /> Width : 12<br /> Type : Number<br /> Option : AWS CN B Qty : ##ShowCNValue<br /> <br /> [!Field : AWS CN B Qty]<br /> Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:SrcItemSummCNColl<br /> MyFormula : #AWSName + #StockItemName <br /> <br /> [Field : AWS B Val]<br /> Use : Amount Field<br /> Set as : $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormula:SrcItemSummColl<br /> MyFormula : #AWSName + #StockItemName<br /> Style : Small<br /> Border : Thin Left<br /> Format : "NoSymbol"<br /> Width : 12<br /> Invisible : NOT ##ShowValueOnly<br /> Option : AWS CN B Val : ##ShowCNValue<br /> <br /> [!Field : AWS CN B Val]<br /> Set as : $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormula:SrcItemSummCNColl<br /> MyFormula : #AWSName + #StockItemName <br /> <br /> <br /> [Field : AWS QTY Total]<br /> Field : AWS B QTY Total,AWS B Val Total<br /> <br /> [Field : AWS B QTY Total]<br /> Use : Number Field<br /> Set as : $$Number:$$Total:AWSBQty<br /> Style : Small<br /> Border : Thin Left<br /> Format : "No Comma,No zero,NoSymbol"<br /> Width : 12<br /> <br /> [Field : AWS B Val Total]<br /> Use : Number Field<br /> Set as : $$Total:AWSBVal<br /> Style : Small<br /> Border : Thin Left<br /> Format : "No Comma,No zero,NoSymbol"<br /> Width : 12<br /> Invisible : NOT ##ShowValueOnly<br /> <br /> ; ---------------------------------------------------------------------<br /> [Collection : Base SalesVoucher]<br /> Type : Voucher<br /> Filter : IsSalesVoucher<br /> <br /> [Collection : Src Item Summ Coll]<br /> Source Collection : Base SalesVoucher<br /> Fetch : VoucherNumber,Date,VoucherTypeName,MasterId<br /> Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName<br /> <br /> Walk : Inventory Entries<br /> By : PName : $PartyLedgerName<br /> By : IName : $StockItemName<br /> <br /> Aggr Compute : BilledQty : Sum : $BilledQty<br /> Aggr Compute : Amount : Sum : $Amount<br /> Search Key : $PName + $IName<br /> <br /> [System: Formula]<br /> <br /> IsSalesVoucher : $Parent:VoucherType:$VoucherTypeName = $$VchTypeSales <br /> IsCreditNoteVCH : $Parent:VoucherType:$VoucherTypeName = $$VchTypeCreditNote<br /> <br /> [System : Formula]<br /> SalesCNQty : IF NOT ##ShowCNValue Then $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:SrcItemSummColl Else $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:SrcItemSummCNColl<br /> SalesCNVal : IF NOT ##ShowCNValue Then $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormula:SrcItemSummColl Else $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormula:SrcItemSummCNColl<br /> <br /> [Collection : Base CNVoucher]<br /> Type : Voucher<br /> Filter : IsCreditNoteVCH<br /> <br /> [Collection : Src Item Summ CN Coll]<br /> Source Collection : Base CNVoucher<br /> <br /> Walk : Inventory Entries<br /> By : PName : $PartyLedgerName<br /> By : IName : $StockItemName<br /> Aggr Compute : BilledQty : Sum : $BilledQty<br /> Aggr Compute : Amount : Sum : $Amount<br /> Search Key : $PName + $IName <br /> <br /> ;; --------------------------------------------------------------------<br /> [Part : AWS BodyTotals]<br /> <br /> Line : AWS BodyTotals<br /> <br /> [Line : AWS BodyTotals]<br /> <br /> Use : Area Wise Sales <br /> Delete : Empty<br /> Delete : Explode<br /> Delete : Total<br /> Local : Field : Default : STyle : Small Bold<br /> Local : Field : AWS Name : Set as : "Totals" <br /> Local : Field : AWS Name : Align : Right<br /> Local : Field : AWSGrpName : Set as : "" <br /> Local : Field : AWS Qty : Set as : $$Total:AWSQty<br /> Local : Field : AWS BQty : Set as : $$Total:AWSBQty<br /> Local : Field : AWS B Val : Set as : $$Total:AWSBVal<br /> <br /> Local : Field : AWSBQTYTotal: Set as : $$Total:AWSBQTYTotal<br /> Local : Field : AWSBValTotal: Set as : $$Total:AWSBValTotal<br /> <br /> Border : Totals<br /> Delete : Total<br /> <br /> <br /> [Variable : ShowQtyOnly]<br /> <br /> Type : String<br /> <br /> [System : Variable]<br /> <br /> ShowQtyOnly : "Yes"<br /> <br /> <br /> [Border : PWS Border]<br /> Use : Full Thin Bottom<br /> Left : Thin<br /> <br /> ; ......................<br /> <br /> ;; End-of-File<br /> <br /> <br /> ;; ITEM WISE PARTY SALES ------------------------------------------------<br /> <br /> [Collection : CFBK Stock Grp Coll]<br /> Use : Extract Alias Collection<br /> Source Collection : List of StockGroups<br /> Collection : Primary <br /> Title : $$LocaleString:"List of Stock Groups"<br /> Fetch : Name<br /> <br /> Variable : Stock Group Name<br /> Report : CFBK Rep<br /> Trigger : Stock Group Name<br /> Fetch : Name<br /> <br /> [Report: CFBK Rep]<br /> Title : "Party Item Wise Sales"<br /> Use : DSP Template<br /> Form : CFBK Rep<br /> Variable : DoSetAutoColumn, CFBK PartyName,GroupName,StockItemName<br /> Repeat : CFBK PartyName<br /> Set : DoSetAutoColumn : Yes<br /> Set : DSPRepeatCollection : "CFBK Party"<br /> <br /> [Form: CFBK Rep]<br /> <br /> Use : DSP Template<br /> Parts : CFBK Top Titles,CFBK Rep Body<br /> Background : Crystal Blue<br /> Button : Change Stk Grp,Show Value Only ;,Change LedGroup<br /> Option : Set AutoA Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:CFBKPartyName<br /> Delete : Bottom Button<br /> Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12<br /> <br /> [!Form: Set AutoA Vch Option]<br /> <br /> [Button : Change LedGroup]<br /> Title :"Group"<br /> Key : F5<br /> Action : Modify Variable : Area Wise Trigger<br /> <br /> [Part : CFBK Top Titles]<br /> <br /> Line : AWS DatePeriod, CFBK Group Name,CFBK Rep Title,CFBK Rep Title1<br /> <br /> [Line : CFBK Group Name]<br /> <br /> Field : Short Prompt, DSP SHowStkGrp<br /> Right Field : Simple Prompt, DSP Area Wise Group Name<br /> Local : Field : Short Prompt : Set as : "Stock Group :"<br /> Local : Field : Simple PRompt : Set as : "Area :"<br /> <br /> [Part: CFBK Rep Body]<br /> Part : CFBK BodyDetails,CFBK BodyTotals<br /> Vertical : Yes<br /> Scroll : Vertical<br /> CommonBorder: Yes <br /> <br /> [Part : CFBK BodyDetails]<br /> Lines : CFBK Rep Details<br /> Repeat : CFBK Rep Details : StockItemChildOfGroupName<br /> Scroll : Vertical<br /> CommonBorder: Yes<br /> Total : CFBK B Qty,CFBK B Val<br /> <br /> <br /> [Line: CFBK Rep Title]<br /> <br /> Use : CFBK Rep Details<br /> Local : Field : Default : Type : String<br /> Local : Field : Default : Lines : 0<br /> Local : Field : Default : Align : centre<br /> Local : Field : Default : Style : Tiny Bold<br /> <br /> Local : Field : CFBK Rep Name : Set as : "Particulars" <br /> Local : Field : CFBK Party : Set as : #CFBKPartyName<br /> Local : Field : CFBK Party : Lines : 0 <br /> Local : Field : CFBK Party : Background:Lily Yellow<br /> Local : Field : CFBK Party : Color : Red<br /> Local : Field : CFBK Party : Delete : Field<br /> Local : Field : CFBK Party : Cell : IF ##ShowValueOnly = Yes Then 2 Else 1<br /> Local : Field : CFBK Party : Border : PWS Border<br /> Delete : Empty<br /> Delete : Explode<br /> Delete : Option<br /> Border : Thin Top<br /> <br /> [Line : CFBK Rep Title1]<br /> Use : CFBK Rep Details<br /> Local : Field : Default : Type : String<br /> Local : Field : Default : Lines : 0<br /> Local : Field : Default : Align : centre<br /> Local : Field : Default : Style : Tiny Bold<br /> <br /> Local : Field : CFBK Rep Name : Set as : ""<br /> Local : Field : CFBK B Qty : Set as : "B Qty"<br /> Local : Field : CFBK B Qty : color : Blue<br /> Local : Field : CFBK B Val : Set as : "B Val"<br /> Local : Field : CFBK B Val : Color : Blue<br /> Delete : Empty<br /> Delete : Option<br /> Delete : Explode<br /> Border : Thin Bottom<br /> <br /> <br /> [Part : CFBK BodyTotals]<br /> Line : CFBK BodyTotals<br /> <br /> [Line : CFBK BodyTotals]<br /> Use : CFBK Rep Details<br /> Local : Field : Default : Style : Small Bold<br /> <br /> Local : Field : CFBK Rep Name : Set as : "Totals"<br /> Local : Field : CFBK Rep Name : Align : Right <br /> Local : Field : CFBK B Qty : Set as : $$Total:CFBKBQty<br /> Local : Field : CFBK B Val : Set as : $$Total:CFBKBVal<br /> Delete : Empty<br /> Delete : Option<br /> Delete : Explode<br /> Fixed : Yes<br /> Border : Totals<br /> <br /> <br /> [Line: CFBK Rep Details]<br /> <br /> Fields : CFBK Rep Name, CFBK Party<br /> Repeat : CFBK Party<br /> Local : Field : Default : Style : Normal<br /> Border : Thin Bottom<br /> <br /> [Field: CFBK Rep Name]<br /> <br /> Use : Name Field<br /> Set as : $StockItemName<br /> <br /> [Field : CFBK Party]<br /> Field : CFBK B Qty,CFBK B Val<br /> <br /> [Field : CFBK B Qty]<br /> Use : Qty Primary Field<br /> Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:CFBKSummVoucher<br /> MyFormula : #CFBKPartyName + #CFBKRepName<br /> Format : "NoSymbol"<br /> Border : Thin Left<br /> Width : 12<br /> <br /> [Field : CFBK B Val]<br /> Use : Amount Field<br /> Set as : $$ReportObject:$$CollectionFieldByKey:$Amount:@MyFormula:CFBKSummVoucher<br /> MyFormula : #CFBKPartyName + #CFBKRepName<br /> Style : Small<br /> Border : Thin Left<br /> Width : 12<br /> Invisible : NOT ##ShowValueOnly<br /> <br /> <br /> ;; Collection Definition<br /> <br /> [Collection: CFBK Voucher]<br /> <br /> Type : Voucher<br /> Filter : IsSalesVT<br /> <br /> [Collection: CFBK Summ Voucher]<br /> <br /> Source Collection : CFBK Voucher<br /> <br /> Walk : Inventory Entries<br /> By : PName : $PartyLedgerName<br /> By : IName : $StockItemName<br /> Aggr Compute : BilledQty : Sum : $BilledQty<br /> Aggr Compute : Amount : Sum : $Amount <br /> Search Key : $PName + $IName<br /> <br /> [Collection: CFBK Party]<br /> <br /> Type : Ledger<br /> Child Of : $$GroupSundryDebtors<br /> Belongs To : Yes<br /> <br /> [#Object: Ledger]<br /> <br /> CFBK PartyName : $Name<br /> <br /> ;; Variable Definition<br /> <br /> [Variable: CFBK PartyName]<br /> <br /> Type : String<br /> Repeat : ##DSPRepeatCollection<br /> <br /> ;; System Formula<br /> <br /> [System: Formula]<br /> <br /> IsSalesVT : $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName<br /> <br /> ;; End-of-File<br /> <br /> <br /> ;; -----------------<br /> <br /> [Button: SetStkGroup]<br /> Key : Alt + S<br /> Title : $$LocaleString:"Set Group"<br /> Action : Alter : Set Groups<br /> <br /> [Report: Set Groups] ;;Auto Report<br /> Use : DSP Template<br /> Object : Company <br /> Title : $$LocaleString:"Select Item Group"<br /> Form : Set Groups<br /> <br /> [Form: Set Groups]<br /> Use : DSP Template <br /> Part : Set Groups<br /> Full Width : No<br /> Space Left : 1<br /> Space Right : 1<br /> Space Top : 1<br /> Space Bottom: 1<br /> Height : 70 % Screen<br /> Delete : Button<br /> Delete : Bottom Button<br /> <br /> <br /> [Part: Set Groups]<br /> Lines : Form SubTitle, Set Groups<br /> Repeat : Set Groups : Stk Groups<br /> Scroll : Vertical<br /> Breakon : $$IsEnd:$StkGroups<br /> Local : Field : Form SubTitle : Info : $$LocaleString:"Select Groups"<br /> <br /> [Line: Set Groups]<br /> Fields : Set Groups<br /> <br /> [Field: Set Groups]<br /> Use : Name Field<br /> Case : Title Case<br /> Storage : Stk Groups<br /> Set as : IF $$Line = 1 Then $$SysName:Primary Else ""<br /> Style : Normal Bold<br /> Unique : Yes<br /> Table : Stock Group Summary,End of List<br /> Show Table : Always<br /> <br /> [Collection : Selected Grp Coll]<br /> Type : StkGroups : Company<br /> ChildOF : ##SvCurrentCompany<br /> Format : $StkGroups,15<br /> <br /> [System : UDF]<br /> Stk Groups : String : 1010<br /> <br /> <br />