Dear Experts

Discussion in 'Tally Developer' started by NMS, Dec 15, 2013.

    
  1. NMS

    NMS Member


    Dear Expets,
    I had created a Ledger commision under (indirect income) and i had set the percentage for calculation on Total Sales ..when i select commision Ledger in Sales or Purchase Voucher the amount is coming Automatically ok.. but when i use journal voucher amount is not calculating automatically.. plz Help..
     


  2. NMS

    NMS Member


    Dear Experts,
    Plz Help......
     


  3. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear NMS ,

    Kindly give brief details or elaborate so that we can get your exact query.

    Are you giving / storing the Commission Value at Sales / Purchase Voucher ?? Or how are you calculating on Total Sales or Bill Wise .

    Where the value needs to be calculated ?
     


  4. NMS

    NMS Member


    Dear Taufeeq Thanks for Reply..
    created a Ledger commision under (Indirect income ) and go to group alter select indirect income and set used for calculation (taxes. discount) : yes.. and open the ledger in alter mode .. give the percentage :1 in percentage of calculation line..and see in purchase and sales voucher after entering the items selcect commision ledger the amount is coming automatic ...but in journal voucher amount is not coming auutomatic..
    plz help....
     


  5. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Can you upload the snapshot or with complete details of transaction with Dr Ledger and Cr Ledger details.

    For Eg. Dr. Telephone Exp - 1489 - Exp Ledger
    Dr. Sales Commission - 11 - Duty / Tax Ledger
    Cr. XYZ Part - 1500 - Party Ledger
     
    kamalpatel likes this.


  6. NMS

    NMS Member


    Dear Taufeeq see in screen ..
    i had given manually commision ...but when i select agent commision ledger amount should come automatic..
    plz help...[​IMG]
     

    Attached Files:



  7. NMS

    NMS Member


    Dear Taufeeq and Experts,
    Plz give me Example or solution...
     


  8. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear NMS,

    Sales Commission is always debited. You are treating it as Credited. You are recieving Commission or Paying Commission ???

    Secondly You are paying from your side or deducting from the party ??. Or you should pass a different entry for the Sales Commission.
     
    kamalpatel likes this.


  9. NMS

    NMS Member


    Dear Taufeeq,
    Iam receving commision and I want to deduct from party..
     


  10. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear NMS,


    Just go through the below code. May it will be helpful to you.


    [System: UDF]

    Broker Name : string : 2001

    [#Part: EI BaseInfo]

    Option: EI Broker Name: $$IsPurchase:##SVVoucherType

    [!part : EI Broker Name]

    add : line : At Beginning : Broker Name


    [Line : Broker Name]

    Field : Simple Prompt , Broker Name
    Local : Field : Simple Prompt : Set as : "Broker Name:"
    Local : Field : Simple Prompt : Width : 14

    [Field : Broker Name]

    Use : Name Field

    Storage : Broker Name

    Keys : create ledger

    Table : Broker Name , Not Applicable , End of list

    Show Table : Always

    Common Table : No

    [Table : Broker Name]

    Title : "List Of Broker "

    Collection : ledgers

    [collection : ledgers]

    Type : ledger

    format : $name , 20

    Child Of : "Commission Broker"

    Belongs To : yes



    [Collection : BaseCollOfPurchVoucher]
    Type : Voucher : VoucherType
    ChildOf : $$VchTypePurchase
    Belongsto : Yes
    Fetch : Date, voucherTypename,PartyLedgerName, LedgerEntries.*, BrokerName.*

    [Collection : SubCollectionForVchPurbroker]

    Source Collection : BaseCollOfPurchVoucher
    Compute : Date : $Date
    Compute : VoucherTypeName :$VoucherTypeName
    Compute : PartyLedgerName : $PartyLedgerName
    Compute : FullInvAmt : $Amount
    Compute: AmtWithoutTax : ($Amount - $$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)
    Compute: AmtOfTax : ($$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)

    [System : Formula]

    TaxAmtOfLed : $$IsLedOfGrp:$LedgerName:$$GroupDuties
     
    kamalpatel likes this.



  11. Dear sir
    How to connect made a table, for, exp. I have made to two type printing in address on envelop, how to use table
     



  12. Dear sir
    How to connect made a table,
    for exp. : - I have made to two type printing in address on envelop, how to use table in one by one two printing a envelop size
     


  13. Mahesh Sethi

    Mahesh Sethi Member




    Dear Taufeeq Bhai,

    Where effect the below code. Pls Explain for my knowledge purpose.

    Thanks in Advance

    Manish


    [Collection : BaseCollOfPurchVoucher]
    Type : Voucher : VoucherType
    ChildOf : $$VchTypePurchase
    Belongsto : Yes
    Fetch : Date, voucherTypename,PartyLedgerName, LedgerEntries.*, BrokerName.*

    [Collection : SubCollectionForVchPurbroker]

    Source Collection : BaseCollOfPurchVoucher
    Compute : Date : $Date
    Compute : VoucherTypeName :$VoucherTypeName
    Compute : PartyLedgerName : $PartyLedgerName
    Compute : FullInvAmt : $Amount
    Compute: AmtWithoutTax : ($Amount - $$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)
    Compute: AmtOfTax : ($$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)

    [System : Formula]

    TaxAmtOfLed : $$IsLedOfGrp:$LedgerName:$$GroupDuties[/QUOTE]

    [Collection : BaseCollOfPurchVoucher]
    Type : Voucher : VoucherType
    ChildOf : $$VchTypePurchase
    Belongsto : Yes
    Fetch : Date, voucherTypename,PartyLedgerName, LedgerEntries.*, BrokerName.*

    [Collection : SubCollectionForVchPurbroker]

    Source Collection : BaseCollOfPurchVoucher
    Compute : Date : $Date
    Compute : VoucherTypeName :$VoucherTypeName
    Compute : PartyLedgerName : $PartyLedgerName
    Compute : FullInvAmt : $Amount
    Compute: AmtWithoutTax : ($Amount - $$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)
    Compute: AmtOfTax : ($$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)

    [System : Formula]

    TaxAmtOfLed : $$IsLedOfGrp:$LedgerName:$$GroupDuties[/QUOTE]
     


  14. Mahesh Sethi

    Mahesh Sethi Member




    Dear Taufeeq Bhai,

    Where effect the below code. Pls Explain for my knowledge purpose.

    Thanks in Advance

    Manish


    [Collection : BaseCollOfPurchVoucher]
    Type : Voucher : VoucherType
    ChildOf : $$VchTypePurchase
    Belongsto : Yes
    Fetch : Date, voucherTypename,PartyLedgerName, LedgerEntries.*, BrokerName.*

    [Collection : SubCollectionForVchPurbroker]

    Source Collection : BaseCollOfPurchVoucher
    Compute : Date : $Date
    Compute : VoucherTypeName :$VoucherTypeName
    Compute : PartyLedgerName : $PartyLedgerName
    Compute : FullInvAmt : $Amount
    Compute: AmtWithoutTax : ($Amount - $$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)
    Compute: AmtOfTax : ($$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)

    [System : Formula]

    TaxAmtOfLed : $$IsLedOfGrp:$LedgerName:$$GroupDuties[/QUOTE]

    [Collection : BaseCollOfPurchVoucher]
    Type : Voucher : VoucherType
    ChildOf : $$VchTypePurchase
    Belongsto : Yes
    Fetch : Date, voucherTypename,PartyLedgerName, LedgerEntries.*, BrokerName.*

    [Collection : SubCollectionForVchPurbroker]

    Source Collection : BaseCollOfPurchVoucher
    Compute : Date : $Date
    Compute : VoucherTypeName :$VoucherTypeName
    Compute : PartyLedgerName : $PartyLedgerName
    Compute : FullInvAmt : $Amount
    Compute: AmtWithoutTax : ($Amount - $$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)
    Compute: AmtOfTax : ($$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)

    [System : Formula]

    TaxAmtOfLed : $$IsLedOfGrp:$LedgerName:$$GroupDuties[/QUOTE]
     


  15. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Sorry I didn't understand what is your query / problem ??
     


  16. Mahesh Sethi

    Mahesh Sethi Member


    Dear Taufeeq Bhai,

    Where effect the below code. Pls Explain for my knowledge purpose.

    Thanks in Advance

    Manish


    [Collection : BaseCollOfPurchVoucher]
    Type : Voucher : VoucherType
    ChildOf : $$VchTypePurchase
    Belongsto : Yes
    Fetch : Date, voucherTypename,PartyLedgerName, LedgerEntries.*, BrokerName.*

    [Collection : SubCollectionForVchPurbroker]

    Source Collection : BaseCollOfPurchVoucher
    Compute : Date : $Date
    Compute : VoucherTypeName :$VoucherTypeName
    Compute : PartyLedgerName : $PartyLedgerName
    Compute : FullInvAmt : $Amount
    Compute: AmtWithoutTax : ($Amount - $$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)
    Compute: AmtOfTax : ($$Abs:$$FilterAmtTotal:LedgerEntries:TaxAmtOfLed:$Amount)

    [System : Formula]

    TaxAmtOfLed : $$IsLedOfGrp:$LedgerName:$$GroupDuties
     


  17. Ankur Tiwari

    Ankur Tiwari Member


    Dear Experts I Tried my Best to Import Excel to Tally Journal Voucher with cost centre but not success please guide us
     


Share This Page