Want some help for me

Discussion in 'Requests' started by ONKAR, Apr 30, 2019.

    
  1. ONKAR

    ONKAR Active Member


    I have created a code for display profit column in the voucher , for instant shown us for per bill profit, so the problem is not getting the exact result I want, please correct my code and give me the right solution.
    what is the calculation formula

    ;;Reclaculate formula's
    [System: Formula]
    CalcedAmt: ($Rate * $BilledQty) - $StandardCost
    NrmlAmount: ($BilledQty * $Rate) - $StandardCost

    see this screenshot


    screen shot.JPG



    [System : UDF]

    TTEPurchaseRate : String : 2011

    [#Line : EI ColumnOne]

    Add : Right Field : Before : VCH QtyTitle : TTEPROFIT


    [Field :TTEPROFIT]
    Use : Name Field
    Width : 16
    Align : Center
    Setas : $$LocaleString:"PROFIT"
    Style : Normal Bold
    Set Always : Yes
    Border: Thin Left Right
    Skip : Yes

    ------------------------------------------------

    [#Line : EI InvInfo]
    Add : Right Field : Before : VCHBilledQty : VCHPROFIT

    [Field : VCHPROFIT]
    Use : Name Field
    Align : Center
    Width : 16
    Color : DEEP COBALT BLUE
    Set as : $StandardCost-$StandardRate
    Set Always : Yes
    Skip : Yes



    in this image i.e. Somnath premium agarbatti standard cost is 10 rs. and the standard selling price is 15, so I want to display profit of the item rs. 5 in this profit column, so how to get each of the items profits amount in this column
     


  2. murarikiran

    murarikiran Administrator


    Use below methods for StandardCost & StandardRate

    StandardCost --> $StandardCost:StockItem:$StockItemName
    StandardRate --> $StandardRate:StockItem:$StockItemName
     


  3. ONKAR

    ONKAR Active Member


    @murarikitan i know this , i think you have not understand my question , i want standard cost - ( Subtraction ) standard Rate difference means profit in my this column , i.e. Standard cost is ₹10/- and standard Selling price is ₹15/- , so difference is ₹5/- means profit ₹5/- displayed in this column.
     


  4. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    [Field : VCHPROFIT]
    Use : Amount Rate Field
    Align : Center
    Width : 16
    Color : DEEP COBALT BLUE
    Set As :$Rate-$StandardCost:StockItem:$StockItemName
    Set Always : Yes
    Skip : yes
     


  5. ONKAR

    ONKAR Active Member


    @jaykumartailor sir, As per your solution it's perfectly working on sales voucher, thank you so much, perfectly working, but I want also a total of this column, please sir.

    SEE THIS SCREENSHOT​

    Capture.JPG
     


  6. ONKAR

    ONKAR Active Member


    @JaykumarTailor sir please check this code for a total of this column, but not getting total, please give me the correct formula

    Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : TTE Total

    [Field: TTE Total]
    Use : TTE VCH PROFIT
    Border : Totals
    Set as : $$String:mad:@VCH PROFIT Total
    Skip : Yes
    Set always : Yes

    [System: Formula]
    TTE Total : $$Number:$VCHPROFIT
    VCHPROFITTotal : $$CollTTETotal:InventoryEntries:mad:@VCHPROFIT
     


  7. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Mr. Onkar
    This One Is Old Code Need Only For Change Set As.

    You Are Not Trying A Little Bit.
    No One Can Feed You For A Longer Time

    [#Line: EI ColumnOne]

    Option : TTE EI ColumnOne : @@IsSales


    [!Line: TTE EI ColumnOne]

    Add : Right Fields : At Beginning : TTE VCH NumPack


    Local : Field : Default : Align : Center

    Local : Field : TTE VCH NumPack : Info : "PROFIT"



    [#Line: EI InvDetails]

    Option : TTE EI InvDetails : @@IsSales


    [#Line: CI InvDetails]

    Option : TTE CI InvDetails : @@IsSales


    [#Line: EI InvInfo]

    Option : TTE EI InvInfo : @@IsSales

    [#Line: CI InvInfo]

    Option : TTE EI InvInfo : @@IsSales

    [!Line: TTE EI InvInfo]

    Add : Right Fields : At Beginning : TTE VCH NumPack
    Local : Field : TTE VCH NumPack : Storage : BasicNumPackages


    [Field: TTE VCH NumPack]
    Use : Name Field
    Align : Center
    Width : 16
    Border : Thin Left Right
    Color : DEEP COBALT BLUE
    Set As :$Rate-$StandardCost:StockItem:$StockItemName
    ;;Set as :$StandardCost:StockItem:$StockItemName
    Set Always : Yes
    Skip : Yes
    Invisible : NOT ##VrVarC1
    Skip on : $$IsEnd:$StockItemName
    ;; Inactive : $$IsEnd:$StockItemName


    [#Form: Export Invoice]

    Option : TTE Export Invoice NP : @@IsSales

    [!Form : TTE Export Invoice NP]


    Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : TTE Total NumPack

    [Field: TTE Total NumPack]

    Use : TTE VCH NumPack
    Border : Totals
    Set as : $$String:mad:@NumNumPackTotal
    Skip : Yes
    Set always : Yes

    [System: Formula]
    NumNumPack : $$Number:$BasicNumPackages
    NumNumPackTotal : $$CollNumTotal:InventoryEntries:mad:@NumNumPack
     
    Last edited: May 1, 2019


  8. ONKAR

    ONKAR Active Member


    I know sir, but amit sir told me that this formula is not perfect for this code, its wrong calculation, so I want.
     


  9. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    For Total Profit of item
    Set As :$billedqty*($Rate-$StandardCost:StockItem:$StockItemName)
     


  10. ONKAR

    ONKAR Active Member


    @jaykumartailor sir, thank you so much as per your solution, it's perfectly working on sales voucher, but Amit sir's calculation/solution this formula wrong as you know of my old post, so what ??

    SEE THIS SCREENSHOT

    Capture 2.JPG
     


  11. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Good Job.
    Keep Going on.
    :)
     


  12. ONKAR

    ONKAR Active Member



  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear Onkar,

    Am a bit disappointed by your progress...... copy paste is okay...but one must learn from it also. Am expecting lot more from you.

    You try to make your code in a hurry...hurry....hurry......... slow down a bit...understand the code and then implement as per your needs.

    By this time I was expecting your knowledge and skills to grow a bit more..... still am glad you are learning and making progress and really doing things. But now onwards do things with a bit more understanding. Take your time and apply logic to problems.

    Experts are here always to help serious learners and coders. Keep it up.
     


  14. ONKAR

    ONKAR Active Member


    YES SIR JI.
     


  15. ASHOK

    ASHOK Member


    Sir final code
     


  16. ONKAR

    ONKAR Active Member


    @ASHOK, sir code is already uploaded here, please see this post
     


  17. ASHOK

    ASHOK Member


    Sir please upload the fresh code
     


  18. ONKAR

    ONKAR Active Member


    @ASHOK sir, code is already on the forum, please scroll and see my first thread , then you will get this code
     


  19. ASHOK

    ASHOK Member


    sir total nahi aa raha
     


  20. ASHOK

    ASHOK Member


    Sir total ki jagah MAD aa raha hai
     


  21. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Change mad to : @
     


  22. ASHOK

    ASHOK Member


    sir working well thanks

    sir tally me hsn or rate wise stock nahi chek kar sakte app tdl code bana do
     


  23. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Already available in forum. Search it.
     


  24. ASHOK

    ASHOK Member


    Sir hsn wise stock ko chack nahi kari sakte
     


  25. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Dear ashok,
    your mail id please?
     


Share This Page