Sale Price Control with profit percentage

Discussion in 'Free Source Codes' started by Raju Das, Apr 14, 2014.

    
  1. Raju Das

    Raju Das Member


    Dear All,

    I had Done the below code for controlling the Sales Price of Item not Less than Purchase Price with Profit Percentage (i.e 5% Profit)

    Here it is....

    [#Field: VCH Rate]
    Option: VCH Rate1: $$IsSales:##SVVoucherType
    [!Field: VCH Rate1]
    Control : Msg1:($$IsEmpty:$$VchRate OR $MSG2)

    [#Field: VCHBATCH Rate]
    Option: VCHBATCH Rate1: $$IsSales:##SVVoucherType
    [!Field: VCHBATCH Rate1]
    Control: Msg1:($$IsEmpty:$$VchRate OR $MSG2)

    [System : Formula]
    MSG1: "Below price"
    MSG2:$$VchRate:<= ((($$Number:$LastPurcPrice:StockItem:$StockItemName * 5) / 100) + ($$Number:$LastPurcPrice:StockItem:$StockItemName))
     


  2. Niraj

    Niraj New Member


    not working
     


  3. Raju Das

    Raju Das Member



    Bro what version u use....
    Bro its also working in Version 1.1 to 4.8
     


  4. Niraj

    Niraj New Member


    i am using rel A1.1 i have activated in tdl ..anything else hv to do to activate
     


  5. Niraj

    Niraj New Member


    after activating in tdl still; sales invoice is gentrated blow purchase price
     


  6. Raju Das

    Raju Das Member



    :mad: :mad::mad::mad::mad: Niraj u first learn TDL, after u come to this forum and start comment, another dont comment like this, u r fully unknown TDL programming.....
     
    Ras Raj and RIBU like this.


  7. anikht11

    anikht11 New Member


    Very nice Bro it's Working very Smooth.....
     


  8. sanskruti

    sanskruti Member


    hello brother it is not hes foal t i think he is copy past the code when copy the code from this page it will make foaltin this line will converted to smiles instead of brackets
    Control : Msg1:($$IsEmpty:$$VchRate OR $MSG2)
     


  9. Niraj

    Niraj New Member


    boss ...it will work only with some Items and Profit Ratio will be same bill cant Genarate above percentage Level..the price will be as per percentage ..
     


  10. Raju Das

    Raju Das Member



    Bro u r totally unknown TDL, ..................
     


  11. Niraj

    Niraj New Member


    Sir ,
    U check First ....u cant modified sales price
     


  12. 9779845157470

    9779845157470 New Member


    not alter sales invoice
     


  13. Saudi Solutions

    Saudi Solutions New Member


    Very nice... Thanks a lot
     


  14. saif

    saif New Member


    Good work
     



  15. Mr Raju nice & very much usefull module.... Thank you..
     


  16. Rajan Pillai

    Rajan Pillai New Member


    Hi everybody,

    This is an altered code from TDLExperts, I don't rember who made it,
    The item list shows Stock Quantity, Last Sale Price and MRP of the product .
    I hope he will forgive me ....
     

    Attached Files:

    santosh swami and Mukesh Kumar like this.


  17. Rajsrisrimal

    Rajsrisrimal Member


    Great help sir
     


  18. sayed

    sayed Member


    siri want control price by stock item cost plss help me
     


  19. V Shankar

    V Shankar New Member


    Thank you
     


  20. vaithy

    vaithy New Member


    Mr. Raju really excellent
     


  21. ebek

    ebek Member


    This tdl Good.
    but problems voucher two item posted then rate difar voucher not save
     


  22. Devaki

    Devaki Member


    [#Field: VCH Rate]
    Option: VCH Rate1: $$IsSales:##SVVoucherType
    [!Field: VCH Rate1]
    Control : Msg1:($$IsEmpty:$$VchRate OR $MSG2)

    [#Field: VCHBATCH Rate]
    Option: VCHBATCH Rate1: $$IsSales:##SVVoucherType
    [!Field: VCHBATCH Rate1]
    Control: Msg1:($$IsEmpty:$$VchRate OR $MSG2)

    [System : Formula]
    MSG1: "Low Price" + $$NewLine+""+ $$NewLine+" Please Enter Correct Rate !!!"

    MSG2:$$VchRate:<= ($$Number:$LastPurcPrice:StockItem:$StockItemName /(1-0.05))
     


  23. Devaki

    Devaki Member


    This is based on markdown calculation
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Does this work ... when there are multiple Stock items to be billed in the Invoice ???
     


  25. Devaki

    Devaki Member


    sir i am not expert, just changed the calculation only. Mr.Raju posted as markup calculation. Normally we are calculating profit from sale price (Markdown Basis).
     


Share This Page