need help for Amount calculation in POS VOUCHER

Discussion in 'Free Source Codes' started by ONKAR, Dec 25, 2019.

    
  1. teja varma

    teja varma Active Member


    Units should be in grams not KG
    REFQTY- > 1000gms
     
    ONKAR likes this.


  2. ONKAR

    ONKAR Active Member


    Teja Bhai is this profile picture really yours ?? If yes then, then you look like a hero. bro, and bro please give me one update in it, please add a button in pos voucher menu bar like enable or disable this features, it's very useful for me please bro, When a customer takes the item from me in the grams like, I will enable it through a button and a customer will make a normal purchase, ie, for example, Colgate, so I will disable it because it will be very useful for me brother. , please, thank you.!!
     


  3. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Just Change Formula
     


  4. Sanjeev S

    Sanjeev S Active Member


    Dear Omkar,

    Try this......

    ;;;------------------ Teja Verma

    [#Field:VchStockItem]
    Sub Form:OnkarQtyCalcForm:mad:@IsPointOfSales and @@IsItemwithWeight and (NOT $$IsEndofList:#VCHStockItem)

    [System : Formulae]
    IsItemwithWeight : $IsPOSWindow:StockItem:#VCHStockItem

    [Report:OnkarQtyCalcForm]
    Form:OnkarQtyCalcForm

    [Form:OnkarQtyCalcForm]
    Part:OnkarQtyCalcForm


    [Part:OnkarQtyCalcForm]
    Line:OnkarQtyCalcForm1,OnkarQtyCalcForm2
    Width:50% page

    [Line:OnkarQtyCalcForm1]
    Space Top:0.2
    Field:Name Field, SimpleField,ShortnameField,ComputedQtyTitle
    Local:Field:NameField:Info:$$LocaleString:"Item"
    Local:Field:SimpleField:Info:$$LocaleString:"Rate"
    Local:Field:ShortNameField:Info:$$LocaleString:"Material Amt"
    Local:Field:Default:Width:20
    Local:Field:Default:Style:Normal Bold
    Local:Field:Default:Align:Center

    [Field:ComputedQtyTitle]
    Use:NameField
    Info:"Calc QTY"

    [Line:OnkarQtyCalcForm2]
    Space Top:0.2
    Fields:OrefItem, Orefamount,Oaskedamount,Osaleqty
    Local:Field:Default:Width:20
    Local:Field:Default:Style:Normal Bold
    Local:Field:Default:Align:Center

    [Field : OrefItem]
    Use : Name Field
    Set as : $.StockItemName
    Skip : Yes
    Width : 10


    [Field:Orefqty]
    Use:Qty Primary Field
    Storage:Orefqty


    [Field:Orefamount]
    Use:Amount Field
    Storage:Orefamount
    Set as : $$AsAmount:mad:MyRate

    MyRate : $$Number:$$CurrentValue:$StandardPrice:StockItem:$.StockItemName
    Set Always : Yes


    [Field:Oaskedamount]
    Use:Amount Field
    Storage:Oaskedamount

    [Field:Osaleqty]
    Use:Qty Primary Field
    Storage:ComputedQty
    On:Focus:Yes:Set Field:$$AsQty:mad:CalcQty ;a
    Set Always : Yes

    CalcAmt : $Oaskedamount
    CalcQty : @CalcAmt / $ORefAmount


    [#Field:VchBilledQty]
    Set By Condition:mad:@IsPointOfSales and @@IsItemwithWeight and (NOT $$IsEndofList:#VCHStockItem):$ComputedQty

    [#Field:VchValue]
    Set By Condition:mad:@IsPointOfSales and @@IsItemwithWeight and (NOT $$IsEndofList:#VCHStockItem):$Oaskedamount


    [System:UDF]
    Orefqty:Quantity:2003
    Orefamount:Amount:4002
    Oaskedamount:Amount:5002
    ComputedQty:Quantity:3003
    IsPOSWindow : Logical : 3003


    [#Part: STKI Basic Features]
    Add : Part : At End : STKI POSWindow

    [Part : STKI POSWindow]
    Line : STKI POSWindow

    [Line: STKI POSWindow]

    Fields : Medium Prompt, STKI POSWindow
    Local : Field : Medium Prompt : Set as : $$LocaleString:"Additional Window for Weight?"
    Space Top : 0.5


    [Field: STKI POSWindow]
    Use : Logical Field
    Type : Logical : Forced
    Storage : IsPOSWindow
    Set as : if $$InCreateMode then NO else $$Value
    SetVal : No
    Set always : Yes
    Inactive : $$IsSysName:$BaseUnits

    upload_2020-1-5_14-57-0.png

    I have taken Dalchini Unit as gms and rate also per gram.

    I hope this will ease the issue further.

    Regards,
     

    Attached Files:



  5. ONKAR

    ONKAR Active Member


    @Sanjeev S Sir, Your solution is absolutely Right, I would like to thank you from the heart, but I want some update it in, for faster POS Entry, like drive sir solution, Your solution is in the form, but I want this in Before the quantity column for faster working, faster pos entry, sir, please. Thank You.
     


  6. Sanjeev S

    Sanjeev S Active Member


    Dear Omkar, one thing is sure that you can't put it before stockitem. Once you arrive at quantity you can skip quantity. Few fields you can skip by either SKIP or SKIP FORWARD rest is absolutely working fine and fast. I have also provided option for sub form yes/no at item level. I feel it can definitely be a faster POS entry.

    Regards,
     


  7. ONKAR

    ONKAR Active Member


    @Sanjeev S sir now the problem is solved, I found the solution I wanted, I would like to thank you @drive sir see the screenshot and text format solution both of you, and also thank you @teja varma Bhai, thank you guys ..thank you so much :):)

    [#Line: EI InvInfo]
    Add: Right Fields: Before: VCH ActualQty : MyRate
    [Field: MyRate]
    Use : Number Field
    Width : 16
    Align : Center
    Style : Normal Bold
    Set as : @mTotal/10000
    mTotal : $$number:mad:mTotal1
    Border:Thin Left Right
    Align : Center
    Local:Style:DEFAULT:Height:17
    Background : Deep Cobalt Blue
    Color : Lily White
    mTotal1 : ($Amount*10000/@mRate)
    mRate : $$Number:#VCHRate
    Format : "Decimal:3"
    Set Always:YES
    Skip:YES
    ;Invisible:Yes
    [#Field: VCH POSBilledQty]
    Set as:$$AsQty:#MyRate
    Set Always: YEs
    [#Field: VCH POSValue]
    Skip : No
    Read Only : NO

    Capture.JPG
     


  8. ONKAR

    ONKAR Active Member


    @Sanjeev S and @drive sir i need a small help from yours, i want to add symbol in your solution, see the screenshot, i added this - "( " + $$String:($BilledQty):Symbol,ShortForm,Secondary + " )" but not getting result,

    Capture.JPG
     
    panam likes this.


  9. panam

    panam Member


    de
    dear sir its working fine. check my screen shot
     

    Attached Files:

    • pos.jpg
      pos.jpg
      File size:
      148.9 KB
      Views:
      12


  10. Sanjeev S

    Sanjeev S Active Member


    Dear Onkar,

    You need to define the field as name field and not qty field

    You should get the desired result,

    Regards.
     


  11. Reagan

    Reagan New Member


    Hello guys I have a problem. I had my POS voucher amount field inactive by default by tally, so I added

    [#Field:VCH POSValue]
    Delete:Skip
    Delete:Read Only

    But now the problem is when I put an amount, the rate field doesn't update itself

    Rate is amount divided by quantity, I have tried different things but it has refused, I need your help. Thank you
     


  12. panam

    panam Member


    just goto to pos invoice configuration, enable allow modification of rate field during pos invoicing to "yes" and enter the rate manually.
     


Share This Page