Dear Experts please help me to identify the part which contains bill reference details in ledger (when we enable the option show bill wise details in ledger f12 configuration) to get the mode of payment or receipt from voucher bill allocation table the respective images are attached plz help me in this regard ;;JAI GANESHAYA NAMAHA [#Line: VCHBILL CTLineTwo] Add:Right Field:Before:VCH AmtTitle:MODE [Field:MODE] Use:NAME FIELD Set as:"CHQ/ CASH" Color:BLUE Skip:Yes [#Line: VCHBILL MainLine] Add:Right Field:Before:VCHBILLAmt:MODE1 [Field:MODE1] Use:name field Storage:udfmode Color:blue Table:mode [Table:mode] Title : $$LocaleString:"Mode of Payment" List Name :Cash , Cheque [System:UDF] udfmode:String:880 ;;;=================================for displaying the table list after saving voucher==== [#Line: VCHBILL ExplLine] add: Fields : before:VCHBILLDateate1,proj1 [Field: Date1] Use : name field Storage :udfmode Set as : if ##VCHShowBillTables AND $$IsSysNameEqual:AgstRef:$BillType then @TableDate else $udfmode TableDate : if NOT $$IsEmpty:$$Value AND $$IsEmpty:$$Table:VCHBILLName:$udfmode then $$Value else $$Table:VCHBillName:$udfmode Set always : Yes Invisible : No Color:blue Skip : Yes [Field: proj1] Use : name Field Storage : proj1 Set always : Yes Invisible : No Skip : Yes Color:blue [System:UDF] proj:String:10125 ;;;====changing color for table list items amount after saving voucher=== [#Field: VCHBILL Amt] Use : Amount Forex Field Width : @@VCHAmountWidth Storage : Amount Color:blue Set always : Yes Inactive : $$IsEnd:$BillType [#Field: VCHBILL DrCr] Use : Amount DrCr Field Color:blue ;;;;=====from voucher to ledger (bill allocation table)
FINALLY GOT THE ANSWER FOR THE PROBLEM ;;JAI GANESHAYA NAMAHA [#Line: VCHBILL CTLineTwo] Add:Right Field:Before:VCH AmtTitle:MODE [Field:MODE] Use:NAME FIELD Set as:"CHQ/ CASH" Color:BLUE Skip:Yes [#Line: VCHBILL MainLine] Add:Right Field:Before:VCHBILLAmt:MODE1 [Field:MODE1] Use:name field Storage:udfmode Color:blue Table:mode [Table:mode] Title : $$LocaleString:"Mode of Payment" List Name :Cash , Cheque [System:UDF] udfmode:String:880 ;;;=================================for displaying the table list after saving voucher==== [#Line: VCHBILL ExplLine] add: Fields : before:VCHBILLDateate1,proj1 [Field: Date1] Use : name field Storage :udfmode Set as : if ##VCHShowBillTables AND $$IsSysNameEqual:AgstRef:$BillType then @TableDate else $udfmode TableDate : if NOT $$IsEmpty:$$Value AND $$IsEmpty:$$Table:VCHBILLName:$udfmode then $$Value else $$Table:VCHBillName:$udfmode Set always : Yes Invisible : No Color:blue Skip : Yes [Field: proj1] Use : name Field Storage : proj1 Set always : Yes Invisible : No Skip : Yes Color:blue [System:UDF] proj:String:10125 ;;;====changing color for table list items amount after saving voucher=== [#Field: VCHBILL Amt] Use : Amount Forex Field Width : @@VCHAmountWidth Storage : Amount Color:blue Set always : Yes Inactive : $$IsEnd:$BillType [#Field: VCHBILL DrCr] Use : Amount DrCr Field Color:blue ;;;;=====from voucher to ledger (bill allocation table) [#Line: DSPVCHBILAllocExplosion] Add:Field:Before:VCHBILLAmt:mode2 [Field:mode2] Use: name field Set as: if @@IsAccVch AND ($$IsBillWiseOn) AND ($IsBillWiseOn:Ledger:$LedgerName) then $udfmode else "" Set always : Yes Color:blue
thank you sir but during the checking process i got stucked with a problem, shown in the picture, where for the agst ref i am not able adjust same voucher number for cash as well as cheque eg: if i receive 100/- as 50/- in cash and 50/- as cheque for the old outstanding of 100 then i need to adjust agst ref old bf in cash as well as chq but the tally is not giving option to do so, please help me in this context
Obviously, coz Tally is following accounting principles..... One cannot have two voucher mode in one single ledger entry. Your entry actually should be like this...... Party A/c DR 100/* ------- to Cash A/c 50/- ------- to Bank A/c 50/- Since you are getting part payment in Cash and Cheque.... Above is the right way of doing entry. Hence Tally's validation is correct for "referencing". In above entry, you can select your reference and put the mode.
Dear Amit ji i got it and as you said it belongs to validation as well as unique function also thanks for support and guidance sir
Dear Amit ji please correct my code to get the value instead of udf name in the ledger please guide me sir the code is follows; ;;;jai ganeshaya namaha [#Line: ACLSTitle] Add:Right Field:Before:VCH DebitTitle:Mode [Field:mode] Use:name field Set as:"CASH / CHEQUE " Border:column titles Color:blue [#Line: ACLSInfo] Add:Right Field:Before:ACLSAmt:mode1 [Field:mode1] Use:name field Table:mode Set as: If $$IsEmpty:$$Value then " " else $$Value Storage: udfmode Set Always:Yes Color:blue [Table:mode] Title : $$LocaleString:"Mode of Payment" List Name :Cash , Cheque [System:UDF] udfmode:String:880 ;;;=creation of title in ledger for mode of payment program;;;===== [#Line: DSP VchAccTitles] Add:Right Field:BeforeSP VchTypeTitle:cash,chq [Field:cash] Use:name field Set as:"CASH" Skip:Yes Color:blue [Field:chq] Use:name field Set as:"chq" Skip:Yes Color:blue [#LineSP VchDetail] Add:Right Field:BeforeSP VchType:cash1,chq1 [Field:cash1] Use:name field Set as: $mymode Color:blue [Field:chq1] Use:name field Set as: $mymode2 Color:blue [#Collection : Vouchers of Ledger] Compute : mymode : $$CollectionField:$mymodeobj:1:LedgerEntries Compute : mymode2 : $$CollectionField:$mymode2obj:2:LedgerEntries [#Object : Ledger Entry] mymodeobj : $udfmode mymode2obj : $udfmode
You have to do it yourself........... If Value="Cash" then Amount else 0 .......... this is an example....... you have to do it yourself.... If you ask and ask, then you lose a learning opportunity. This is a simple one..........so am sure you can do it. Good Luck buddy.
Dear Sir We explore bill details in Ledger voucher reports. It is not a bill Type(UDF Value) show. How to solve this? ;;;;;; [#Line: VCHBILL CTLineTwo] Add:Right Field:Before:VCH AmtTitle:Mode Table [Field:Mode Table] Use:NAME FIELD Set as:"CHQ/ CASH" Color:BLUE Skip:Yes [#Line: VCHBILL MainLine] Add:Right Field:Before:VCHBILLAmt:Bill Mode [Field:Bill Mode] Use:name field Storage:BillModeUDF Color:blue Table:Mode Table [Table:Mode Table] Title : $$LocaleString:"Mode of Payment" List Name :Cash , Cheque [System:UDF] BillModeUDF:String:2000 [#Line: VCHBILL ExplLine] add: Fields : before:VCHBILLDateateBillds [Field: DateBillds] Use : name field Storage :BillModeUDF Set as : if ##VCHShowBillTables AND $$IsSysNameEqual:AgstRef:$BillType then @TableDate else $BillModeUDF TableDate : if NOT $$IsEmpty:$$Value AND $$IsEmpty:$$Table:VCHBILLName:$BillModeUDF then $$Value else $$Table:VCHBillName:$BillModeUDF Set always : Yes Invisible : No Color:blue Skip : Yes [#Line: DSPVCHBILAllocExplosion] Add:Field:Before:VCHBILLAmtiplay Bill Mode Local:Fieldefault:Color:Blue [Fieldiplay Bill Mode] Use: name field Set as: if @@IsAccVch AND ($$IsBillWiseOn) AND ($IsBillWiseOn:Ledger:$LedgerName) then $BillModeUDF else "" Set always : Yes Color:blue