Dear Sir, I have Sales data as per Voucher Type - Sales, Now I want to change some selected voucher's voucher type from Sales to "Sales - Local" and from Sales to "Sales - Interstate". It is very difficult for me to edit records. Any code is there to reduce the rework ? On Selected Vouchers, how we can directly change voucher Type ?
Yes possible,but voucher number will be changed if method is automatic numbering and if you use ref then it will be also changed.
Follow the steps 1) Take tally backup. 2) Open Daybook. 3) Now export ( xml format) only those sales voucher which you want to change voucher type. 4) Now create two voucher type "Sales - Local" and "Sales - Interstate" in tally. 5)Open exported xml file (Daybook.xml) in text format and replace voucher type name "Sales" with "Sales - Local"/"Sales - Interstate" and save the xml file. 6) Now open tally and import the modified xml file ( Daybook.xml ). That's it.
Sir, Currently doing on the same method. But it is time consuming. To get the auto update directly from Tally, any codes available, ?
Yes Try This Code: [#Form : DayBook] Add : Button : Modify Parent,Modify Voucher [#Form: Ledger Vouchers] Add : Button : Modify Parent,Modify Voucher [#Report : DayBook] Variable: SV Parent Name [#Report : Ledger Vouchers] Variable: SV Parent Name [#Report : TA Audit List] Variable: SV Parent Name [#Report : DayBook] Variable: SV Voucher [#Report : Ledger Vouchers] Variable: SV Voucher [#Report : TA Audit List] Variable: SV Voucher [Button: Modify Voucher] Key : ALT+5 Title : $$LocaleString:"VCH Type Change" Action List : Accept VoucherType Name, Save Voucher Mode : Display Scope : Selected [Button:Accept Voucher Type Name] Key : ALT+5 Action : Alter : Accept Voucher Type Name [Button: Save Voucher] Key : ALT+5 Action : Modify Object :VoucherType Name: ##SVVoucher Mode : Display Scope :Selected [Report: Modify Remote Object] Title : "Modifying Remote Object" Form : Modify Remote Object Variable: SV Voucher Local : Collection : Voucher Type : Fetch : VoucherType Name, Voucher [Form: Modify Remote Object] Part : Modify Remote Object Buttons : Modify Voucher Height : 100 % Screen Width : 100 % Screen [Part: Modify Remote Object] Line : MRO Title, MRO Details Repeat : MRO Details : Voucher Type Scroll : Vertical [Line: MRO Title] Use : MRO Details Local : Field : Name Field : Set as : "Name" Local : Field : Simple Field : Set aS : "Parent" Border : Column Titles [Line: MRO Details] Field : Name Field, Simple Field Local : Field : Name Field : Set as : $VoucherType Name Local : Field : Simple Field : Set as : $Voucher [Report: Accept Voucher Type Name] ;;Auto Report Auto : Yes Title : $$LocaleString:"Select Parent" Form : Accept Voucher Type Name [Form: Accept Voucher Type Name] Background : @@SV_REPSTAT Parts : Accept Voucher Type Name Space Bottom : 1 Full Width : No Full Height : No Horizontal Align: Centre Vertical Align : Centre Space Top : 1 [Part: Accept Voucher Type Name] Lines : Accept Voucher Type Name [Line: Accept Voucher Type Name] Fields : Simple Prompt Right Fields: Name Field Local : Field : Simple Prompt : Set as : "Parent :" Local : Field : Name Field : Variable : SVVoucher Local : Field : Name Field : Modifies : SVVoucher Local : Field : Name Field : Table : Voucher Type Local : Field : Name Field : Show Table: Always Space Top : 1 [Button : Modify Parent] Key : Alt+F4 Title : $$LocaleString:"Change Narration" Action List : Accept Parent Name,Save Parent Mode : Display Scope : Selected [Button : Accept Parent Name] Key : Alt+F4 Action : Alter : Accept Parent Name Mode : Display [Key : Save Parent] Key : Alt+F4 Action : Modify Object : Narration : ##SVParentName Mode : Display Scope : Selected [Report : Accept Parent Name] ;;Auto Report Auto : Yes Title : $$LocaleString:"Narration" Form : Accept Parent Name [Form : Accept Parent Name] Background : @@SV_REPSTAT Parts : Accept Parent Name Space Bottom : 1 Full Width : No Full Height : No Horizontal Align: Centre Vertical Align : Centre Option : Small Size Form Space Top : 1 [Part : Accept Parent Name] Line : Accept Parent Name [Line : Accept Parent Name] Field : Simple Prompt Right Field : Name Field Local : Field : Simple Prompt : Set as : "Narration :" Local : Field : Name Field : Lines : 2 Local : Field : Name Field : Max : 600 Local : Field : Name Field : SetAs : $VoucherNumber Local : Field : Name Field : Variable : SVParentName Local : Field : Name Field : Modifies : SVParentName Local : Field : Name Field : Show Table: Always Space Top : 1 [Variable : SV Parent Name] Type : String [Variable: SVVoucher] Type : String
Thanks a lot Sattam Sir.. Great Work sirji. Sir currently it is working only at Day book. But the said button I am getting at many places. How the said function work at all the places where the button ALT+5 VCH Type Change is showing ?