[#Menu: Gateway of Tally]
Add : Key Item : Search Vouchers: H : Alter : RajivSVch
[Report:RajivSVch]
Form : FrmFindVoucher
Title : $$LocaleString:"Search Vouchers"
[Form: FrmFindVoucher]
Part : PrtFindVoucher
Full Width : No
Space Right : 2
Space Left : 2
Option : Small Size Form
Background : Light Yellow
On: Form Accept : Yes : Form Accept
On: Form Accept : Yes : Display : RajivSVch Entries in Daybook
[Part: PrtFindVoucher]
Line :LinImpReceiptV,LinImpReceiptV1,LinImpReceiptV2
[Line: LinImpReceiptV]
Fields : Long Prompt, Name Field;, vaibhfield
Local: Field: Long Prompt : Set As : "Type Narration or Voucher No. here"
Local: Field: Name Field : Modifies : xlsFilePath : Yes
[Line: LinImpReceiptV1]
Fields : custslipfld
[field : custslipfld]
info : "Subscribe our Channel "
full width : yes
align : centre
;;width : 75% screen
style : large
[Line: LinImpReceiptV2]
Fields : custslipfld1
[field : custslipfld1]
info : "Rajiv Mishra YouTube Channel "
full width : yes
align : centre
;;width : 75% screen
style : large
; Fields :vntfield1
; Space Top : 0.4
;[Field: vntfield1]
; Set as : $$LocaleString:"Thank you for watching"
; Border : Thin Bottom
[Report: RajivSVch Entries in Daybook]
Use : Daybook
Set : SVFromDate : $$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany
Set : SVToDate : $$FinYearEnd:##StartDate:$StartingFrom:Company:##SVCurrentCompany
Set : ExplodeNarrFlag : Yes
Local : Collection : Default : Add : Filter : Dup Filter
; FetchValues : Date, VoucherTypeName, Narration
[System: Formula]
;Dup Filter : $Narration CONTAINS "Duplicated"
Dup Filter :if NOT $$IsEmpty:##xlsFilePath then $VoucherNumber CONTAINS ##xlsFilePath or $Narration CONTAINS ##xlsFilePath else $Narration CONTAINS "Duplicated"
[Function: Voucher Duplication]
10 : WALK COLLECTION : TSPL Smp Company Vch
20 : SET : SVViewName : $$SysName:AcctgVchView
30 : NEW OBJECT : Voucher
40 : SET VALUE : Date : $Date
50 : SET VALUE : VoucherTypeName : $VoucherTypeName
60 : SET VALUE : Narration : $Narration + " Duplicated"
70 : SET VALUE : PersistedView : ##SVViewName
80 : WALK COLLECTION : LedgerEntries
90 : INSERT COLLECTION OBJECT : Ledger Entries
100 : SET VALUE : Ledger Name : $LedgerName
110 : SET VALUE : IsDeemedPositive : $IsDeemedPositive
120 : SET VALUE : Amount : $Amount
130 : SET TARGET : ..
140 : END WALK
150 : CREATE TARGET
160 : END WALK
170 : DISPLAY : RajivSVch Entries in Daybook
180 : RETURN
[Collection: TSPL Smp Company Vch]
Source Collection : Company Vouchers
Fetch : Date, VoucherTypeName, Narration, LedgerEntries.*
[System: Variable]
xlsFilePath: ""
.jpg)
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें