help..alternate quantity column

Discussion in 'Tally Developer' started by talha62481, Oct 28, 2014.

    
  1. talha62481

    talha62481 Member


    I want to make an slightly change in purchase invoice in which quantity primary unit is kgs. but i want an another column field for 2nd unit of measure like in carton. but this unit have no link with rate. It's just only for show the amount of an item in invoice print and at voucher entry level. And it also shows in stock summary. If i want to see how much quantity in carton. is sold how it is possible.
    It's not working when i use alternate unit and its not showing the column in version 1.1. B'coz at any any time variance in weight.
    some time 1 carton. is = 5 kg. or sometime 1 carton = 6kg.

    but i need two quantities for only some item
    because in sales we need only one quantity and no other column

    how to add alternative quantity for a stock item ...because there is no feature of alternative quantity in version 1.1

    Pls help me.

    Thanx in advance
     
    Last edited: Nov 5, 2014


  2. admin

    admin Administrator Staff Member


    In the alternative field you need mention the type as mentioned below.

    Type: quantity: secondary


    By using above type, tally will automatically displays alternative qty.
     


  3. talha62481

    talha62481 Member


    I want to make an slightly change in purchase invoice in which quantity primary unit is kgs. but i want an another column field for 2nd unit of measure like in carton. but this unit have no link with rate. It's just only for show the amount of an item in invoice print and at voucher entry level. And it also shows in stock summary. If i want to see how much quantity in carton. is sold how it is possible.
    It's not working when i use alternate unit and its not showing the column in version 1.1. B'coz at any any time variance in weight.
    some time 1 carton. is = 5 kg. or sometime 1 carton = 6kg.

    Pls help me.

    Thanx in advance
     
    Last edited: Nov 4, 2014


  4. talha62481

    talha62481 Member


    how to add alternative quantity for a stock item ...because there is no feature of alternative quantity in version 1.1
     


  5. Manoj Garg

    Manoj Garg Member


    not working sir.
     


  6. Murali.R

    Murali.R Member


    sir.
    Item A is main Unit is Nos, and alternative Unit is Case, this conversion is 1 case = 60 nos. I made the sales invoice Item A Billed Qty is 125 Pcs . In invoice print
    I define two column 1, is Case 2, is Nos , I want the value 2 case ,5Nos
    Please help me admin
     


  7. Murali.R

    Murali.R Member


    sir.
    Item A is main Unit is Nos, and alternative Unit is Case, this conversion is 1 case = 60 nos. I made the sales invoice Item A Billed Qty is 125 Pcs . In invoice print
    I define two Field 1(IE Qty1])is Case, Field2(IE Qty21)is Nos , I want the value 2 case ,5Nos
    Please help me admin

    The field is
    [Field : IE Qty1]
    Use : QtySecondaryField
    Set as : $BilledQty
    Border : Thin Left
    Format :"No Symbol,No Zero"
    Style : Style9
    Width : 5
    Align : Right

    [Field : IE Qty21]
    Use : QtyPrimaryField
    Set as : $BilledQty
    Border : Thin Left
    Format :"No Symbol,No Zero"
    Style : Style9
    Width : 4.2
    Align : Right

    Please help me admin
     
    Selva kumar likes this.


  8. sattam

    sattam Active Member


    any body can solve this issue?
     


  9. Murali.R

    Murali.R Member


    yes , i will solved
     


  10. sattam

    sattam Active Member


    Mr. Murali.R if you solved this Please share the code.
     


  11. Murali.R

    Murali.R Member


    Dear satam,

    [Field : MyItemsSQtycase]
    Use : Qty Primary Field
    Style : Small Bold
    Set As : @@MyRMcase1
    Format :"No symbol,No Zero"
    Color : Red

    [Field : MyItemsSQtyNos]
    Use : Qty Primary Field
    Style : Small Bold
    Set As : @@MYRMpce1
    Format :"No symbol,No Zero"
    Color : Blue

    [System : Formula]
    EmptySOFilter : Not $$IsEmpty:$StkOutQty
    MyRMDen : $Denominator:stockitem:$stockitem

    MyRMcase : $$Number:$ActualQtyToT/$$Number:($Denominator:Stockitem:$Stockitem)
    MyRMcase1: $$RoundDown:mad:@MYRMcase:1

    MYRMpce : @@MYRMcase1*$$Number:($Denominator:Stockitem:$Stockitem)
    MYRMpce1: $$Number:$ActualQtyToT-@@MYRMpce
     



  12. how to deactivate auto conversion of alternate unit. I want fill alternate unit manually.
    like in sale to Abc company - 1Mt =20 bags and sale to Xyz co 1Mt=21 bags.
    means bags may be different in 1Mt according to mesh size of item.
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Alternate Unit is a "compounded" on basis of primary unit. e.g. 1 dz of 12 nos etc.

    You need to add one more FIELD if you want your own manual qty input and show it in a column of whichever report you need.
     



  14. No need to deactivate just enter the alt. unit as of your own. It will accept the value irrespective of auto converion rate
     


  15. Neeraj Singh

    Neeraj Singh New Member


    it will very simple sir

    add 2 fields (type of number field) before qty field
    and set the both field in string set as in the qty field
     



  16. code for override conversion of alternate unit
     


  17. Vijay Shetye

    Vijay Shetye Member


    Ypu can direcctly mention in Qty field as 1mt = 21 bag it will get updated
     


Share This Page