Item Price not Less than Pur Cost

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Nov 27, 2013.

    
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear All,

    I had made the below code for controlling the Sales Price of Item not Less than Purchase Cost. But am not getting result. Kindly give some rectification.:-

    [#Field: VCH Rate]
    Validate : $$IsEmpty:$$Value OR $$Value <= $LastPurcPrice:StockItem:$StockItemName

    ;;Validate : $$IsEmpty:$$Value OR $$Value <= $StandardCost
    ;;Option : $$IsSales:##SVVoucherType
     
    kamalpatel likes this.


  2. Maulik Patel

    Maulik Patel Active Member


    Is multiple godown or batch is enabled in configuration?
     


  3. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Multiple Godown is Yes. But Batch is not
     
    kamalpatel likes this.


  4. Maulik Patel

    Maulik Patel Active Member


    Then you need to modify VCH Batch Rate field instead of VCH Rate.
     
    kamalpatel likes this.


  5. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Thanks A Lot Maulik Bhai,

    It worked
     
    kamalpatel likes this.


  6. Maulik Patel

    Maulik Patel Active Member


    Taufeeq, If you want validation only in invoice then write

    [#Field: VCH Batch Rate]
    Add : Option : VCH Sales Batch Rate : @@IsSales
    [!Field : VCH Sales Batch Rate]
    Validate : ($$IsEmpty:$$Value OR $$Value <= $LastPurcPrice:StockItem:$StockItemName)
     
    khushbu and kamalpatel like this.


  7. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Problem Solved Thanks
     
    kamalpatel likes this.


  8. Manoj Garg

    Manoj Garg Member


    Not getting the result.
    Please help.
     


  9. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Its Working Fine Mr. Manoj
     


  10. Manoj Garg

    Manoj Garg Member


    It struck on item price even if price entered higher than purchase.
     


  11. Basha

    Basha Member


    Hello Dear Its Working Fine Mr. Manoj
     


  12. Manoj Garg

    Manoj Garg Member


    I don't know what is wrong. but I uses the codes as suggested above. It struck on the rate field.
     


  13. Maulik Patel

    Maulik Patel Active Member


    Manoj Sir,

    please try below code and check that is your current value is greater than the value displayed in message.

    [#Field: VCHBATCH Rate]
    On : Focus : Yes : Set : LstPurRate : $$Number:$LastPurcPrice:StockItem:#VCHStockItem
    Notify : MSGLASTRATE : @@IsSales
    ;;Notify : MSGCURRENT : @@IsSales

    [System : Formula]

    MSGLASTRATE : $LastPurcPrice:StockItem:#VCHStockItem
    MSGCURRENT : $$Value
     


  14. Manoj Garg

    Manoj Garg Member


    Thanks A Lot Maulik Sir,

    It worked.
     


  15. nagaraju

    nagaraju New Member


    ok sir but it is not bloking it should be enter the voucher
     


  16. Maulik Patel

    Maulik Patel Active Member


    Notify : MSGLASTRATE : @@IsSales
    this line is used to just give notification to user. If you want to block then you will need to use "Validate", for which example has been given in this thread.
     



  17. Dear expert
    please help me,

    we have made table for print envelop print two different size (big and small), how to connect, tdl code attached
    our mail id, : pradeep20777@gmail.com
     

    Attached Files:



  18. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Mr Pradeep Kumar just change the Print Config file. Their you need to write the current File Names with the path. That's it.
     
    kamalpatel likes this.



  19. Mr. Taufeeq Shaikh ji, please send us correct code, kindly do the needful.
     


  20. Deepak83

    Deepak83 New Member


    Dear Experts !

    In Delhi VAT, we need to show different Rate of Tax on item under DVAT 2004 in Annexure 2A/2B
    Is any one have solution for above said in Tally ? while making entry of sale agst c form tally should ask the VAT rate in Delhi.
    How to manage this thing with the help of TDL ??

     


  21. Ronnie Katsie

    Ronnie Katsie New Member


    Dear Experts
    what is the code refferenced to standard cost price the same way LastPurcPrice is used
     



  22. How to make Stop Duplicate Purchase Voucher Entry ? Please provide the logic & codes
     


  23. Rajsrisrimal

    Rajsrisrimal Member



    Dear sir How to block if we use actul qty and billed qty
    I like to block (purchaes cost+ 5% / actul qty ) = sales price
     


Share This Page