PAYMENT VCH IMP FROM EXCEL

Discussion in 'Requests' started by sattam, Oct 25, 2018.

    
  1. sattam

    sattam Active Member


    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
     


  2. sivam

    sivam Active Member


    Try like this $$Date:$_1
     
    vinoth likes this.


  3. drive

    drive Active Member


    ;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
     


  4. sattam

    sattam Active Member


    misunderstanding sir, I have to set Vch date ie cheque date in narration field. $$Date:$_1 shows action execution failed.
     


  5. sattam

    sattam Active Member


    what about adjustment multiply bill ref
     


  6. sattam

    sattam Active Member



  7. sivam

    sivam Active Member



    You Declare a Variable/Local Variable in and use $$Date Function. While Set to Narration, you change to string
     
    vinoth likes this.


  8. sattam

    sattam Active Member


    [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
     


  9. sattam

    sattam Active Member


    Sir please rectify the code
     


  10. sattam

    sattam Active Member



  11. sattam

    sattam Active Member


    Please help me how to set multiply bill reference against one payment voucher.
     


  12. sivam

    sivam Active Member


    [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
     
    sattam and vinoth like this.


  13. sattam

    sattam Active Member


    Sir this problem get solved.
    Please help me how to set multiply bill reference against one payment voucher.
     


  14. sattam

    sattam Active Member


    [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:mad:@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
     


Share This Page