Pending Sales order report

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

 

not working

 

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]

 

no sir i am not getting i did everythink but also m not getting

 

ok, attach the code in txt file, and let me try.

 

ok sir here is the file

 

dear expert i need to outstanding bill wise report in "gird line" please guid us

 

Use the attached file to get the Gridlines as desired.

A very good file for Gridlines for Free.

 

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...

 

please find attached the modified file.

 

good work

 

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.

 

ya sir whatever thaufeeq jee told is correct

 

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 there is 3 item in 1 voucher entry they should show in combine form not seperate

 

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.

 

not working sir

 

Check your code. IT will work.

 

how do we add total supplied and pending quantity in this report?

 

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