Dear All, I have written a code for printing the details of sales order voucher but i needed to display only the pending sales order details in the report.Please help me out. [#Menu: GateWayOfTally] Add: Key Item: Before: @@LocDisplay: FSales Order Report: F: Display: Furniture Mall [Report: TSPL SGroup] ;;Auto Report Use : Group Name Title : $$LocaleString:"Select Group" Local : Field : Group Name : Delete: Table Local : Field : Group Name : Add : Table : Furniture Mall Sales Local : Field : Group Name : Set as: ##GroupName [Report: Furniture Mall] Use : DSP Template Title : "Furniture Mall Sales" Form : Furniture Mall Set : SVFromDate: ##SVCurrentDate Set : SVToDate : ##SVCurrentDate Form : Furniture Mall Variable : Group Name Trigger : TSPL SGroup [Form: Furniture Mall] Height : 100% Page Width : 100% Page Space Left : 5% page Space Right : 5% Page Space Bottom: 5% Page Space Top : 5% Page Button : Print Button,Export Button,Mail Button,Upload Button Button : F2ChangePeriod,ChangePeriod Key : F2ChangePeriod Part : Furniture Mall Copy Part : Furniture Mall TOP part Part : Furniture Mall body Page Break : Furniture Mall ClPB,Furniture Mall OpPB [Part: Furniture Mall Copy] Line: Furniture Mall Copy [Line: Furniture Mall Copy] Field: Furniture Mall Copy [Part: Furniture Mall ClPB] Line: Furniture Mall ClPB [Line: Furniture Mall ClPB] Border : Thin Top Right Field: Furniture Mall ClPB [Field: Furniture Mall ClPB] Use : Name Field Align : Right Set as : "Continue..." Width : 100% Page [Part: Furniture Mall OpPB] Part : Furniture Mall title Vertical: yes Border : Thin Box [Field: Furniture Mall Copy] FullWidth: Yes Set As : @CopyInfo CopyInfo : If $$SetNo = 1 Then $$LocaleString:"(Original)" Else + If $$SetNo = 2 Then $$LocaleString:"(Duplicate)" Else + If $$SetNo = 3 Then $$LocaleString:"(Triplicate)" Else + If $$SetNo = 4 Then $$LocaleString:"(Quadruplicate)" Else $$LocaleString:"(Extra Copy)" Style : Small Italic Align : Right [Part: Furniture Mall TOP part] Part : Furniture Mall CMP Part : Furniture Mall title Vertical: yes [Part: Furniture Mall CMP] Line: Furniture Mall CMP [Line: Furniture Mall CMP] Field: simple field Local: Field: simple field: Set as : @@CMPMailName Local: Field: simple field: Align : Center Local: Field: simple field: Full Width: Yes Local: Field: simple field: Wide Space: Yes Local: Field: simple field: Style : CMP Style [Style: CMP Style] Use : large Bold : Yes Height: 15 [Part: Furniture Mall title] Line : Furniture Mall title Border: thin box [Part: Furniture Mall body] Part : Furniture Mall Inventory Entries Part : Furniture Mall Ledger Entries Vertical : Yes Common Border: Yes Float : No Scroll : Vertical Border : Thin box [Part: Furniture Mall Inventory Entries] Line : Furniture Mall Inventory Entries Repeat: Furniture Mall Inventory Entries: VCHOrd Scroll: Vertical [Line: Furniture Mall title] Field: Furniture Mall orderno Field: Furniture Mall bookingdate Field: Furniture Mall partyname Field: Furniture Mall particulars Field: Furniture Mall totalamt Field: Furniture Mall advanceamt Field: Furniture Mall balance Field: Furniture Mall deliverydate Local: Field: Default: Type : String Local: Field: Default: Style: Small Bold Local: Field: Default: Color: black Local: Field: Furniture Mall orderno : Set as: "OrderNo" Local: Field: Furniture Mall bookingdate : Set as: "Booking Date" Local: Field: Furniture Mall partyname : Set as: "Party Name" Local: Field: Furniture Mall particulars : Set as: "Particulars" Local: Field: Furniture Mall totalamt : Set as: " Bill Value" Local: Field: Furniture Mall advanceamt : Set as: "Advance Amount" Local: Field: Furniture Mall balance : Set as: "Balance" Local: Field: Furniture Mall deliverydate: Set as: "Delivery Date" Border:Column Titles [System: Formula] IsNotEmptyItem:NOT $$IsEnd:$StockItemName [Line: Furniture Mall Inventory Entries] Field : Furniture Mall orderno Field : Furniture Mall bookingdate Field : Furniture Mall partyname Field : Furniture Mall particulars Field : Furniture Mall totalamt Field : Furniture Mall advanceamt Field : Furniture Mall balance Field : Furniture Mall deliverydate Explode: Furniture Mall BatchAllocations : NOT $$IsEmptyCollection:BatchAllocations Explode: Furniture Mall BasicUserDescription: NOT $$IsEmptyCollection:BasicUserDescription [Field: Furniture Mall orderno] Use : Name Field Set as: $VoucherNumber Width : 8% Page Style : Small Border: thin right [Field: Furniture Mall bookingdate] Use : uni date Field Set as : ##svcurrentdate Width : 10% Page Style : Small Invisible: $$IsEndOfList:#FurnitureMallbookingdate [Field: Furniture Mall partyname] Use : name field Set as: $partyledgername Width : 20% Page Style : Small Align : Right Border: thin left right [Field: Furniture Mall particulars] Use : name field Set as: $stockitemname Width : 20% Page Style : Small Align : Right Border: thin right [Field: Furniture Mall advanceamt] Use : Amount field Set as: $RAdvance1 Width : 12% Page Style : Small Align : Right Border: thin right [Field: Furniture Mall totalamt] Use : amount Field Set as: $amount Width : 10% Page Style : Small Align : Right Border: thin right [Field: Furniture Mall balance] Use : amount field Set as: ($amount-$RAdvance1) Width : 10% Page Style : Small Align : Right Border: thin right [Field: Furniture Mall deliverydate] Use : due date field Width : 10% Page Align : Right Set as: $Ddate1 Style : Small Bold Color : if $$machinedate>#FurnitureMalldeliverydate then @@SV_FIELD1 else blue [System: Formula] Isparticularstockitem: $$IsBelongsTo:$$GroupSundryDebtors Or $$IsBelongsTo:$$GroupCash Or $$IsBelongsTo:$$GroupBank Or $$IsBelongsTo:$$GroupSundryCreditors [#Object: StockItem] TSPLItemCode: $$Alias [Part: Furniture Mall BatchAllocations] Line : Furniture Mall BatchAllocations Repeat: Furniture Mall BatchAllocations: BatchAllocations Scroll: Vertical [Line: Furniture Mall BatchAllocations] Field: Furniture Mall orderno Field: Furniture Mall bookingdate Field: Furniture Mall partyname Field: Furniture Mall particulars Field: Furniture Mall totalamt Field: Furniture Mall advanceamt Field: Furniture Mall balance Field: Furniture Mall deliverydate Local: Field: Default: Style: Small Italic Local: Field: Furniture Mall orderno : Set as: "" Local: Field: Furniture Mall bookingdate : Set as: "" Local: Field: Furniture Mall partyname : Set as: "" Local: Field: Furniture Mall particulars : Set as: "" Local: Field: Furniture Mall totalamt : Set as: "" Local: Field: Furniture Mall advanceamt : Set as: #RAdvance Local: Field: Furniture Mall balance : Set as: "" Local: Field: Furniture Mall deliverydate: Set as: #Ddate [Part: Furniture Mall BasicUserDescription] Line :Furniture Mall BasicUserDescription Repeat:Furniture Mall BasicUserDescription: BasicUserDescription Scroll:Vertical [Line: Furniture Mall BasicUserDescription] Field: Furniture Mall orderno Field: Furniture Mall bookingdate Field: Furniture Mall partyname Field: Furniture Mall particulars Field: Furniture Mall totalamt Field: Furniture Mall advanceamt Field: Furniture Mall balance Field: Furniture Mall deliverydate Local: Field: Default: Type : String Local: Field: Default: Style: Small Bold Local: Field: Furniture Mall orderno : Set as: "" Local: Field: Furniture Mall bookingdate : Set as: "" Local: Field: Furniture Mall partyname : Set as: "" Local: Field: Furniture Mall particulars : Set as: "" Local: Field: Furniture Mall totalamt : Set as: "" Local: Field: Furniture Mall advanceamt : Set as: #RAdvance Local: Field: Furniture Mall balance : Set as: "" Local: Field: Furniture Mall deliverydate: Set as: #Ddate [Part: Furniture Mall Ledger Entries] Line :Furniture Mall Ledger Entries Repeat:Furniture Mall Ledger Entries: Ledger Entries Scroll:Vertical [Line: Furniture Mall Ledger Entries] Field: Furniture Mall orderno Field: Furniture Mall bookingdate Field: Furniture Mall partyname Field: Furniture Mall particulars Field: Furniture Mall totalamt Field: Furniture Mall advanceamt Field: Furniture Mall balance Field: Furniture Mall deliverydate Local: Field: Furniture Mall orderno : Set as : $BasicPurchaseOrderNo Local: Field: Furniture Mall bookingdate : Set as : "" Local: Field: Furniture Mall partyname : Set as : "" Local: Field: Furniture Mall particulars : Set as : "" Local: Field: Furniture Mall totalamt : Set as : $Amount Local: Field: Furniture Mall totalamt : Inactive: $LedgerName=$PartyLedgerName Local: Field: Furniture Mall advanceamt : Set as : #RAdvance Local: Field: Furniture Mall balance : Set as : "" Local: Field: Furniture Mall deliverydate: Set as : #Ddate ;...................................Sales Order Customization......................................................; [#Part: DBLLINE Narration] Option: SO Custm: $$IsSalesOrder:##SVVoucherType [!Part: SO Custm] Add: Line: Before: VCH NarrPrompt: DDate,RAdvance [Line: DDate] Fields : Simple Field,DDate Local : Field : Simple Field : Set : "Delivery Date: " Local : Field : Simple Field : Skip : Yes Local : Field : Simple Field : Style: Normal Bold Space Bottom: 1 [Field: DDate] Use : uni Date Field Color : Blue Set as : $Ddate Align : Left Storage: DDate [Line: RAdvance] Fields : Simple Field,RAdvance Local : Field : Simple Field : Set : "Advance Received:" Local : Field : Simple Field : Skip : Yes Local : Field : Simple Field : Style: Normal Bold Space Bottom : 1 [Field: RAdvance] Use : Amount Field Color : red Set as : $RAdvance Align : Left Storage: RAdvance [System: UDF] DDate : Date : 5101 RAdvance: Amount: 5102 [Collection: Furniture Mall Src] Type : Vouchers : VoucherType Child Of : $$VchTypeSalesOrder Belongs To: Yes Fetch : OrderDueDate,Date,Amount,VoucherNumber,InventoryEntries.* Fetch : RAdvance,DDate [#Collection: VCHOrd] Source Collection: Furniture Mall Src Walk : InventoryEntries By : VoucherNumber : $VoucherNumber Aggr Compute : Amount :Sum : $Amount Compute : PartyLedgerName: $PartyLedgerName Compute : VoucherNumber : $VoucherNumber Compute : stockitemname : $stockitemname Compute : OrderDueDate : $OrderDueDate Compute : RAdvance1 : $..RAdvance Compute : DDate1 : $..DDate Filter : PatyOfSameGroup Fetch : RAdvance,DDate [System: Formula] PatyOfSameGroup :$Parent:Ledger:$PartyLedgerName Contains ##GroupName
you need to change many things. 1st is collection should be Pending Sales Orders. then parent is itemname ; trackledger is ledgername ; closingbalance is qty ; pendingvalue is amt also walk : inventory entries will not be there. please see tally default use of : [Collection: Pending Sales Orders]
thanks Mr. mpal2311 this file is already use but attach this file after some other form size is showing large for example date , company path...
No its not working. Because when we pass the entry for more than one Item. The advance amounts get fetch in each items and its coming seperately. I think it should be given explode at part level for itemwise. The concept is little bit confusing and need to be understood well.
item 1 10000 item 2 3000 total = 13000, advance = 2000, balance = 11000, in that case, how do you want to show the advance for each item.
if this is voucherno-1 and customer1 is partyname item1 3000 item2 50000 advanceamount is 20000 voucherno bookingdate partyname particulars billvalue advanceamount balance deliverydate 1 10-12-2013 customer1 item1 53000 20000 33000 15-12-2013 like this sir
then if the same customer again make a voucher entry it should come as difft entry even if partyname is same it should come based on vouchernumber
In that case, treat my collectiob as source collection, walk by $name and comput advance. It will work.
SIR I WANT FIRST STOCK ITEM NAME AFTER THAT STOCK ITEM RATE OF VAT AND CLOSING STOCK THANKING YOU SIR, please send the code to srinu.mrk123@gmail.com
SIR I WANT FIRST STOCK ITEM NAME AFTER THAT STOCK ITEM RATE OF VAT AND CLOSING STOCK THANKING YOU SIR, please send the code to srinu.mrk123@gmail.com
SIR I WANT FIRST STOCK ITEM NAME AFTER THAT STOCK ITEM RATE OF VAT AND CLOSING STOCK THANKING YOU SIR, please send the code to srinu.mrk123@gmail.com