Dear All, ThaneVeera had made the following TDL in the below code Advance Amount & Delivery Date is not coming. I tried but not getting result. Kindly help for the below code :- [#Menu: GateWayOfTally] Add: Key Item: Before: @@LocDisplay: FSales Order Report:F : Display :Furniture Mall [Collection:Furniture Mall Sales] Use : Alias Collection ; Title : $$LocaleString:"List of Groups" Type : Group Child Of: $$GroupSundryDebtors Belongs To: Yes Report : Furniture Mall Variable : Group Name Trigger : TSPL SGroup Fetch: Name, TBalOpening, GrpOpeningBalance, Fetch: RAdvance Fetch: Ddate [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 ;[Field:Furniture Mall CMP] ; ;USe:name Field ;Set As@CMPMailName ;Width:100% screen ;Style:large Bold ;Space Right:100% page ;;Align : Centre ;Wide Space:Yes [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:Fieldefault:Type:String Local:Fieldefault:Style:Small Bold Local:Fieldefault: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: $$Owner:$BasicPurchaseOrderNo Width :8% Page Style :Small Border:thin right [Field:Furniture Mall bookingdate] Use:uni date Field Set as:##svcurrentdate Width:10% Page Style:Small ;Border:thin right 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:$RAdvance Width :12% Page Style rint Style 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-$RAdvance) 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:$Ddate Color:if $$machinedate>#FurnitureMalldeliverydate then @@SV_FIELD1 else blue ;;Set Always:Yes [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:Fieldefault: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:Fieldefault:Type:String Local:Fieldefault: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 ;....................................Sales Order Printing..................................; [#Part: EXPINV OtherRef] Option : EXPINV DeliDate : $$IsSalesOrder:##SVVoucherType [!Part: EXPINV DeliDate] Delete : Line : EXPINV SubTitle Lines : EXPINV SubTitleDDate BottomLines : EXPINV DDate Height : 9 mms Border : Full Thin Bottom [Line : EXPINV SubTitleDDate] Field : EXPINV SubTitleDDate [Field : EXPINV SubTitleDDate] Set as : $$LocaleString:"Delivery Date:" Width : 25% Page ; Cells : @@ExcelCellColumn - 3 * ($$Quotient@ExcelCellColumn:4) Preprinted : Yes ; Style : Print Style [Line: EXPINV DDate] Field : EXPINV DDate [Field : EXPINV DDate] Use : uni Date Field Set as : $DDate Width : 25% Page ; Cells : @@ExcelCellColumn - 3 * ($$Quotient@ExcelCellColumn:4) Storage: DDate Style : Print Style [Style : Print Style] Height :10 Use :Normal Bold [# Line: DSP EXPSMP Column2] Delete:Field: EXPINV DueTitle Add: Field: EXPINV DueTitle1 [Field:EXPINV DueTitle1] Info: $$LocaleString:"Delivery Date" [#Part: EXPINV Words] ;...............For Advance Amount Add:Line: At Beginning:EXPINV InvAdvance [Line:EXPINV InvAdvance] Field:Simple Field,EXPINV Advance Local:Field:Simple Field:Set as: "Advance Received:" Local:Field:Simple Field:Stylerint Style Local:Field:Simple Field:Width:25% Page [Field:EXPINV Advance] Use : Amount Field Set as : $RAdvance Style : Print Style Storage: RAdvance [Collection : Furniture Mall Src] Type : Vouchers : VoucherType Child Of : $$VchTypeSalesOrder Belongs To : Yes Fetch : OrderDueDate,Date,Amount,VoucherNumber,InventoryEntries.* [#Collection: VCHOrd] Source Collection: Furniture Mall Src Walk: InventoryEntries By: PartyLedgerName: $PartyLedgerName Aggr Compute: Amount : Sum: $Amount Compute : VoucherNumber : $VoucherNumber Compute : stockitemname : $stockitemname Compute : OrderDueDate : $OrderDueDate Filter : PatyOfSameGroup [System: Formula] PatyOfSameGroup :$Parent:Ledger:$PartyLedgerName Contains ##GroupName
Note : IN Collection U write compute method Compute : RAdvance1 : $..RAdvance Compute : DDate1 : $..DDate In Field level Use Set as That $RAdvance1 $DDate1
Still not coming i tried it in every collection. Done Compute & Fetch both but still not getting result. If you know please guide me i will do exactly at that level
write following lines in your VCHOrd collection. Compute : RAdvance : $$Owner:$<Your Advance Field Name> Compute : DDate : $$Owner:<Your Delivery Date Field Name>
Dear MPAL here it is :- [#Menu: GateWayOfTally] Add: Key Item: Before: @@LocDisplay: FSales Order Report:F : Display :Furniture Mall [Collection:Furniture Mall Sales] Use : Alias Collection ; Title : $$LocaleString:"List of Groups" Type : Group Child Of: $$GroupSundryDebtors Belongs To: Yes Report : Furniture Mall Variable : Group Name Trigger : TSPL SGroup Fetch: Name, TBalOpening, GrpOpeningBalance, Fetch: RAdvance Fetch: Ddate [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 ;[Field:Furniture Mall CMP] ; ;USe:name Field ;Set As@CMPMailName ;Width:100% screen ;Style:large Bold ;Space Right:100% page ;;Align : Centre ;Wide Space:Yes [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:Fieldefault:Type:String Local:Fieldefault:Style:Small Bold Local:Fieldefault: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:$$Owner:$BasicPurchaseOrderNo Width :8% Page Style :Small Border:thin right [Field:Furniture Mall bookingdate] Use:uni date Field Set as:##svcurrentdate Width:10% Page Style:Small ;Border:thin right 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 Stylerint Style 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-$RAdvance) 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 Color:if $$machinedate>#FurnitureMalldeliverydate then @@SV_FIELD1 else blue ;;Set Always:Yes [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:Fieldefault: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:Fieldefault:Type:String Local:Fieldefault: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 ;....................................Sales Order Printing..................................; [#Part: EXPINV OtherRef] Option : EXPINV DeliDate : $$IsSalesOrder:##SVVoucherType [!Part: EXPINV DeliDate] Delete : Line : EXPINV SubTitle Lines : EXPINV SubTitleDDate BottomLines : EXPINV DDate Height : 9 mms Border : Full Thin Bottom [Line : EXPINV SubTitleDDate] Field : EXPINV SubTitleDDate [Field : EXPINV SubTitleDDate] Set as : $$LocaleString:"Delivery Date:" Width : 25% Page ; Cells : @@ExcelCellColumn - 3 * ($$Quotient@ExcelCellColumn:4) Preprinted : Yes ; Style : Print Style [Line: EXPINV DDate] Field : EXPINV DDate [Field : EXPINV DDate] Use : uni Date Field Set as : $DDate Width : 25% Page ; Cells : @@ExcelCellColumn - 3 * ($$Quotient@ExcelCellColumn:4) Storage: DDate Style : Print Style [Style : Print Style] Height :10 Use :Normal Bold [# Line: DSP EXPSMP Column2] Delete:Field: EXPINV DueTitle Add: Field: EXPINV DueTitle1 [Field:EXPINV DueTitle1] Info: $$LocaleString:"Delivery Date" [#Part: EXPINV Words] ;...............For Advance Amount Add:Line: At Beginning:EXPINV InvAdvance [Line:EXPINV InvAdvance] Field:Simple Field,EXPINV Advance Local:Field:Simple Field:Set as: "Advance Received:" Local:Field:Simple Field:Stylerint Style Local:Field:Simple Field:Width:25% Page [Field:EXPINV Advance] Use: Amount Field Set as: $RAdvance Style: Print Style Storage: RAdvance [Collection : Furniture Mall Src] Type: Vouchers : VoucherType Child Of: $$VchTypeSalesOrder Belongs To: Yes Fetch: OrderDueDate,Date,Amount,VoucherNumber,InventoryEntries.* Fetch: RAdvance,DDate [#Collection: VCHOrd] ;[Collection: Inv Coll] Source Collection: Furniture Mall Src Walk: InventoryEntries By: PartyLedgerName: $PartyLedgerName Aggr Compute: Amount: Sum: $Amount Compute: VoucherNumber: $VoucherNumber Compute: stockitemname: $stockitemname Compute: OrderDueDate: $OrderDueDate Compute: RAdvance1: $..RAdvance Compute: DDate1: $..DDate Compute: BasicPurchaseOrderNo: $..BasicPurchaseOrderNo Filter: PatyOfSameGroup Fetch: RAdvance,DDate [System: Formula] PatyOfSameGroup :$Parent:Ledger:$PartyLedgerName Contains ##GroupName
Dear Laxman, Thanks for giving suggestion. The syntax for the Balance amount is as follows :- Set as:$Amount - $RAdvance1
You didn't computed so, How you will get it plus when you are at 2nd Level Collection then why you want to go to 0 level Collection there is no Collection at 0 level ?