Dear sir, payment v ch import from excel successfully with bank allocation ,but I have a small issue how to adjust bill allocation with multiply ref no.please guide.also in narration field I have to set chq date, I tried $$String:$_1:Shortdate but it takes like 2018-10-25 00:00:00 but I only need 25-10-18/25-10-2018
;Use This Function For Excel Date To Tally Date [Function: Fun_ExcelDateToTallyDate] Parameter : pInputDate : String Variable : vReturnDate : Date 01 : SET : vReturnDate : $$Date($$StringPart:##pInputDate:8:2) + "-" + ($$StringPart:##pInputDate:5:2) + "-" + + ($$StringPart:##pInputDate:0:4)) 10 : RETURN: ##vReturnDate
misunderstanding sir, I have to set Vch date ie cheque date in narration field. $$Date:$_1 shows action execution failed.
You Declare a Variable/Local Variable in and use $$Date Function. While Set to Narration, you change to string
[Function : Import BankPay] 001 : Call : Import of Bank Payment Voucher Variable : SVViewname : String [Function : Import of Bank Payment Voucher] Variable : Counter : Number 00 : SET : Counter : 0 01 : START PROGRESS : ($$NumItems:BankPayInfo) : "Vouchers Importing " : @@CmpMailName : "BankPayVCH Importing ..." 02 : WALK COLLECTION : BankPay Info 03 : SET : SVViewName : $$SysName:AcctgVchView 04 : NEW OBJECT : Voucher 150 : SET VALUE : NARRATION :"Ch. No. : "+$DSDVchNo3 +" Dt. " +$$Date:calbilldate+ +" Paid By Bank to The Party "+$DSDCrLed3 155 : Save Target 170 : INCREMENT : Counter 180 : SHOW PROGRESS : ##Counter 190 : END WALK 200 : END PROGRESS 210 : RETURN [System : Formula] CalBilldate : @@SCVdt1 + "-" + @@SCVMonth1 + "-" + @@SCVYear1 SCVYear1 : $$Stringpart:$_1:0:4 SCVMonth1 : $$Stringpart:$_1:5:2 SCVdt1 : $$Stringpart:$_1:8:2 ;;End-of-File
[Function : Import of Bank Payment Voucher] Variable : Counter : Number Variable : MyDate : Date 00 : SET : Counter : 0 01 : START PROGRESS : ($$NumItems:BankPayInfo) : "Vouchers Importing " : @@CmpMailName : "BankPayVCH Importing ..." 02 : WALK COLLECTION : BankPay Info 03 : SET : SVViewName : $$SysName:AcctgVchView 04 : NEW OBJECT : Voucher 140: Set : MyDate : $$Date:calbilldate 150 : SET VALUE : NARRATION :"Ch. No. : "+$DSDVchNo3 +" Dt. " + ( $$String:##MyDate:ShortDate) +" Paid By Bank to The Party "+$DSDCrLed3 155 : Save Target 170 : INCREMENT : Counter 180 : SHOW PROGRESS : ##Counter 190 : END WALK 200 : END PROGRESS 210 : RETURN [System : Formula] CalBilldate : @@SCVdt1 + "-" + @@SCVMonth1 + "-" + @@SCVYear1 SCVYear1 : $$Stringpart:$_1:0:4 SCVMonth1 : $$Stringpart:$_1:5:2 SCVdt1 : $$Stringpart:$_1:8:2
Sir this problem get solved. Please help me how to set multiply bill reference against one payment voucher.
[Collection : BankPayInfo] Source Collection : BankPay Info Excel Fetch : *.* By : DSDDATE : $_1 Compute : DSDVchNo3 : $_2 Aggr Compute : DSDVchAmt3 : Sum : If $$IsEmpty:$_3 Then $$AsAmount:0 Else $$AsAmount:$_3 Aggr Compute : DSDAmt13 : Sum : If $$IsEmpty:$_4 Then $$AsAmount:0 Else $$AsAmount:$_4 Compute : DSDDrLed3 : $_5 Compute : DSDCrLed3 : $_6 Compute : DSDREF : $$String :$_7 Aggr Compute : DSDREFAMT : Sum : If $$IsEmpty:$_8 Then $$AsAmount:0 Else $$AsAmount:$_8 Compute : DSDCHRANGE : $_9 Compute : DSDVchAmt3 : $$AsAmount:$_3 Compute : DSDAmt13 : $$AsAmount:$_4 Compute : DSDREFAMT : $$AsAmount:$_8 ;Compute : DSDREF : $$String :$_7 [Function : Import BankPay] Variable : SVViewname : String Variable : ProgressCount : Number Variable : Counter : Number Variable : DSDDATE : String Variable : DSDVchNo3 : String Variable : DSDVchAmt3 : Amount Variable : DSDAmt13 : Amount Variable : DSDDrLed3 : String Variable : DSDCrLed3 : String Variable : DSDREF : String Variable : DSDREFAMT : Amount Variable : DSDCHRANGE : String 00 : SET : Counter : 0 01 : START PROGRESS : ($$NumItems:BankPayInfo) : "Vouchers Importing " : @@CmpMailName : "BankPayVCH Importing ..." 02 : SET : SVViewName : $$SysName:AcctgVchView 03 : WALK COLLECTION : BankPayInfo 08 : Set : DSDDATE : $DSDDATE 09 : Set : DSDVchNo3 : $DSDVchNo3 10 : Set : DSDVchAmt3 : $DSDVchAmt3 11 : Set : DSDAmt13 : $DSDAmt13 12 : Set : DSDDrLed3 : $DSDDrLed3 13 : Set : DSDCrLed3 : $DSDCrLed3 14 : Set : DSDREF : $DSDREF 15 : Set : DSDREFAMT : $DSDREFAMT 16 : Set : DSDCHRANGE : $DSDCHRANGE 17 : NEW OBJECT : Voucher 18 : SET VALUE : Date : $$Date@CalBilldate 19 : SET VALUE : VoucherTypeName :"GST Bank Pay" 41 : INSERT COLLECTION OBJECT : BillAllocations 42 : SET VALUE : BillType :"AgstRef" 43 : SET VALUE : Name : ##DSDREF 44 : SET VALUE : Amount $$TgtObject##DSDREFAMT)) 45 : SET TARGET : ... I have to set Multiply bill ref expert please help me