Unique Batch No.

Discussion in 'Requests' started by Najas Jameela Nazar, Feb 8, 2017.

    
  1. Najas Jameela Nazar

    Najas Jameela Nazar New Member


    How can I make batch name unique for a particular item?
     
    zakirhossain_diu likes this.



  2. hi,
    Do you had found way of your query??
    Thank you
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Unique : yes (in field level)
     
    zakirhossain_diu likes this.



  4. Dear Amit Kamdar,
    Thank you for your earliest reply. I am trying to create Unique Batch Number Item wise. Like "Batch 1" already created for "Item A", Now If user put again "Batch 1" for "Item A" System will notify as duplicate.

    Thanks much for your valuable time.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear Zakir,

    I have already given the solution. What seems to be the problem??
     



  6. Dear,
    I am getting resultfrom second line.
    In case of First Line of Batch allocations I am not getting success.
    I am trying to create Purchase voucher, on Attached image batch Name at fisrtline already created with earlier voucher yet its taking but in second line its working.
    Thank you

    Code:
    [#Collection: Active Batches VchExtract]
    
        Title               : $$LocaleString:"List of Active Batches"
        SubTitle            : $$LocaleString:"Name", @@ExpirySubTitle, $$LocaleString:"Balance"
       
        Parm Var            : pvStockItemName    : String : $StockItemName
        Source Collection    : Batches VchSrc
          Fetch                : Name, Parent, ExpiryPeriod, ActualQty, ClosingBalance, GodownName, ClosingAsondate, MfdOn
        Format              : $Name, 10
        Format              : $ExpiryPeriod, 8 : Month Ending
        Format                : $ClosingAsondate,8   : "Base"
        Filter              : BelongsToSVGodown
        Client Only            : Yes
        Keep Source         : ....
        Unique    : $Name   ; Yes
    
     

    Attached Files:



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You must read the solution....all words should be read.....

    I had said to use .... Unique : Yes in field level.

    You are using it in a collection. From your message in Post # 4, it is clearly understood that you want to prevent duplicate entry of Batch number. So to prevent that you should be using it at the field level and not the collection. A collection is a collection of data, it is not going to prevent duplicates from being entered.
     
    zakirhossain_diu likes this.


Share This Page