Dear experts, anyone can help me to how retive the voucher no of purchase voucher in payment agnst bills. eg. purchase bill vch no 11 , supplier ref no is abc/002233 dt 10-08-13 amt rs.15000 when we pay to them , in payment voucher it shows agnst reg abc/02233 amt rs. 15000 I able to fetch voucher date in payment voucher but can not fetch the voucher no as in above eg. vch no is 11 pl see attached code , in that case accountant can be know in which file or sequense that perticlar pur bill is filled and he got it out of fole for verification of payment for owner. ;;----------- for Purchase voucher number in payment voucher billwise------- [#Line: VCHBILL ExplLine] Add: Field:flddt,fld1 [Field:flddt] Set as : "PV Dt " + $$LocaleString:$billdate [Field: fld1] Use : Short Name Field Set As : $$CollectionField$$CollectionField:$Name-1)BillAllocations)):1:LedgerEntries Storage:mystr [System:udf] mystr:String:10022 [#Collection: Pending Bills] Title : $$LocaleString:"Pending Bills" Sub Title : $$LocaleString:"Name", $$LocaleString:"Date", $$LocaleString:"Balance" ,$$LocaleString:"PV No" Source Collection : Pending Bills SRC Fetch : Name, BillDate, BillCreditPeriod, BaseClosing, FinalBalance ,billid,LedgerEntries.* Unique : $$Name Format : $$Name, 10 Format : $BillDate, 8 : Universal Date Format : $BaseClosing,-30 : "AllSymbols, DrCr" Format : $mystr ,10 Client Only : Yes Keep Source : ... ;; Keep the source at Bill allocations subform Level regards mithari 9325509009
You are not fetching any voucher date either. What you are fetching is 'bill date'. Even though fetched values are same , both are different data storage. for clarity you can see the "Schema Tab of Tally developer".Voucher date & No must be obtained from voucher colection
very nice sir, its working and now easy to user to got that voucher, can we add the same collectonfield in payment voucher ? how?