free code :- Custmoer Item Rate fixed

Discussion in 'Free Source Codes' started by psjain_jal, Apr 21, 2013.

    
  1. psjain_jal

    psjain_jal Member


    Hello Admin & All Members,

    I am Giving the item rate control tdl as per customer. ie we can set rate of items as per customer.
    Code:
    [#Part: MST LED Explode Sundry]
        Add : Line : At end : ItemRateSetings
    [Line :  ItemRateSetings]
      Field : Medium Prompt, ItemRateSetings
      Local : Field : Medium Prompt : Set As : "Set/Alter Item Rates :"
        [Field :  ItemRateSetings]
            use : Logical Field
            Set aS : No
          Sub form : ItemRateSF : $$Value
    [Report : ItemRateSF]
        Form :ItemRateSF
        [Form :ItemRateSF]
            Part :ItemRateSF
            [Part :ItemRateSF]
                Line : ItemRateSF
                Repeat : ItemRateSF : ItemRatesAggregate
                Scroll : Vertical
                Break on : $$Isend:$MSTSFItemName
                [Line :ItemRateSF]
                    Field : MSTSFItemName,MSTSFItemRate
              [Field : MSTSFItemName]
                      Use : Name Field
                        Storage :MSTSFItemName
                        Table : MyStockitems,End of List
                    [Field : MSTSFItemRate] 
                        Use  : Amount Field
                        Storage :MSTSFItemRate
                        Inactive : $$IsEnd:$MSTSFItemName
    [System : UDF]
     
    ItemRatesAggregate    : Aggregate : 21000
    MSTSFItemName        : String    : 21001
    MSTSFItemRate        : Amount    : 21002
     
    [Collection : MyStockitems]
      Title : "List of Items"
        Type : StockItem
        Format : $Name,25
     
    [#Field: VCH NrmlRate]
     
        Control : MyRateControl : $(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate < $$Value And $$IsSales:##SVVoucherType
     
    [System : Formula]
     
    MyRateControl : "Rate Control"
    IsSameItem : $$ReqObject:$StockitemName = $MSTSFItemName
    
    Enjoy enjoy............................................................................
    once's again i told to all members of the community is that "Sharing Your Knowledge with other help you to increases your knowledge ".:)
    Hence pl shares your full code to All members. &
    Pl help me in my Issue to the post the Link is :- http://tdlexperts.com/index.php?threads/help.2755/
     
    santosh swami, panam and G Vijay like this.


  2. NMS

    NMS Member


    Thanks For sharing.....
     


  3. mpal2311

    mpal2311 Active Member


    Please give some example, as after defining the rates of an item to a customer, it is not fetching the rates set to the customer.
     


  4. psjain_jal

    psjain_jal Member


    here is screen shoot attached.

    My friend enjoy :) & don't any comment like U are the TDL Programmer??????
    When any one in learning don't pass any like comment.

    ok................................

    Thanks
    pankaj jain
     

    Attached Files:



  5. psjain_jal

    psjain_jal Member


    it was not fetching any rates but it can not pass entry below or above the rate of items to particular customers .
     


  6. G Vijay

    G Vijay Member


    Hi,

    Thanks for providing such a good TDL... but rate is fixed at sundry customer / supplier, is not reflecting at the time of Invoicing.

    once we entered the rate amount, it is giving error.

    I request, you can please provide, while doing sales voucher, as soon as we select the item name, it has to fetch the rate.

    Thanks & Regards,
    G vijay
    ===========================

     


  7. mpal2311

    mpal2311 Active Member


    It is not controlling as stated by you. Please help.
     


  8. psjain_jal

    psjain_jal Member


    it was not fetching any rates but it can not pass entry below or above the rate of items to particular customers .
    it was not fetching any rates but it can not pass entry below or above the rate of items to particular customers .
     


  9. psjain_jal

    psjain_jal Member


    for fetching rate i need add some lines in this tdl
     


  10. mpal2311

    mpal2311 Active Member


    waiting for updated codes.
     



  11. waiting for update
     


  12. psjain_jal

    psjain_jal Member


    I can not replay to this due engage in my sister marriage right now after completing the funcation I will Look in this matter, OK >???????>>>>

    I am post those tdl which is ready made with me. So pl Keep waiting 08.05.2013
     


  13. mpal2311

    mpal2311 Active Member


    Welcome back. We are still waiting for new updates/tdl which are readymade with you.
     


  14. mpal2311

    mpal2311 Active Member


    Enjoy enjoy............................................................................
    once's again i told to all members of the community is that "Sharing Your Knowledge with other help you to increases your knowledge ".:)
    Hence pl shares your full code to All members.

    What happen Sir, No new codes to share?
    Waiting for update.
     


  15. psjain_jal

    psjain_jal Member


    Wait for some days i will give u a bundled
     


  16. psjain_jal

    psjain_jal Member


    Wait for some days i will give u a bundled of tdls
     


  17. mpal2311

    mpal2311 Active Member


    Where is the bundle ?
     


  18. mpal2311

    mpal2311 Active Member


     


  19. mpal2311

    mpal2311 Active Member


     


  20. laxman

    laxman Member


    ye bundle bundle kya hai...... ye bundle bundle..
     
    Ras Raj likes this.


  21. mpal2311

    mpal2311 Active Member


    yeh TDL ka bundeled hai mere dost.
     
    Ras Raj likes this.


  22. laxman

    laxman Member


    ha ha ha....
     


  23. mpal2311

    mpal2311 Active Member


    Bundle ???????
     


  24. G Vijay

    G Vijay Member


    any updates on this?????
     



  25. Sir Hope you have developed the bundle for fetching the prices in sales invoice. Kindly update... Thanks
     


Share This Page