How to fetch multiple cost-centre in sales voucher import.....?

Discussion in 'Free Source Codes' started by Jenny, Mar 25, 2021.

    
  1. Jenny

    Jenny Active Member


    Please help me out this Query.... in my function its working perfectly to fetch single cost-centre for sales voucher import but in multiple costcentre its not fetch....my function is given below....
    Code:
    ;;BY SALES Entry
    
    70 : INSERT COLLECTION OBJECT : LedgerEntries
    71 : SET TARGET : LedgerEntries
    72 : SET VALUE : LedgerName : "Sales - Services"
    73 : SET VALUE : Amount : $DSDSAAmt
    74 : SET VALUE : Is Deemed Positive : "No"
    75: Insert Collection Object:CategoryAllocations
    76: Set Value:Category:$_6
    
    77: Insert Collection Object:Cost Centre Allocations
    78: Set Value:Name:$_7; or $_8 or $_9 or $_10 or $_11 or $_12 or $_13 or $_14 or $_15 or $_16 or $_17 or $_18 or $_19 or $_20 or $_21 or $_22 or $_23 or $_24 or $_25 or $_26 or $_27 or $_28 or $_29
    ;"Savio" or "Yaimi" or "Wendy" or "Debbie" or "Rupesh" or "James" or "Akshali" or "Janvi" or "Rohini" or "Latika" or "Ragini" or "Sona" or "Nutan" or "Jyoti" or "Amol" or "Mangesh M" or "Roshan" or "Pinky" or "Smita" or "Najma" or "Devendra" or "Lalu" or "Surekha"
    ;79: Set Value:Amount: $_7 or $_8 or $_9 or $_10 or $_11 or $_12 or $_13 or $_14 or $_15 or $_16 or $_17 or $_18 or $_19 or $_20 or $_21 or $_22 or $_23 or $_24 or $_25 or $_26 or $_27 or $_28 or $_29
    
    80 : SET TARGET : ..
     


  2. FreeLance-Tech

    FreeLance-Tech New Member


    ;;BY SALES Entry

    70 : INSERT COLLECTION OBJECT : LedgerEntries
    71 : SET TARGET : LedgerEntries
    72 : SET VALUE : LedgerName : "Sales - Services"
    73 : SET VALUE : Amount : $DSDSAAmt
    74 : SET VALUE : Is Deemed Positive : "No"
    75: Insert Collection Object:CategoryAllocations
    76: Set Value:Category:$_6

    76.5 : WalkCollection : ListoFCstName
    77: Insert Collection Object:Cost Centre Allocations
    78: Set Value:Name: $Name

    80 : SET TARGET : ..
    81 : End Walk




    [Colletion : ListoFCstName]

    ListName : $$LocleString:"CstName1"
    ListName : $$LocleString:"CstName2"
    ListName : $$LocleString:"CstName3"
    ListName : $$LocleString:"CstName4"
    ListName : $$LocleString:"CstName5"
    ListName : $$LocleString:"CstName6"
     


  3. Jenny

    Jenny Active Member


    updated code but same problem one costcentre fetch....
     


  4. Jenny

    Jenny Active Member


    I POST MY CODE AND EXCEL SHEET PLZ HELP ME
     

    Attached Files:



Share This Page