Duplicate Purchase Control with original Invoice detail

Discussion in 'Free Source Codes' started by gaurang712, Jul 7, 2021.

    
  1. gaurang712

    gaurang712 Member


    I have achived this tdl for duplicate purchase control with bill no and amount detail. 001.jpg
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very nice......... ;):)
     


  3. gaurang712

    gaurang712 Member


    Thanks sir
     



  4. Well done
     


  5. ujwlgrg

    ujwlgrg Member


    Can u provide the code or tdl file anything????
     


  6. jgkumar1976

    jgkumar1976 Member



    sir,

    The Data Containing two financial year
    and the Purchase bill entered in march 2021
    and the same purchase bill entered in april 2021 by mistake and assumption that the goods received in april 2021
    in this situation the duplicate control not work because of financial year changed to current year 1-4-2021 to 31-03-2022


    please guide me how to check the collection and filter

    upload_2021-7-8_20-10-24.png
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    USE.....in your Collection...........

    Parm Var : SVFromDate : Date : @@PrevYearStart
    Parm Var : SVToDate : Date : ##SVToDate
     
    jgkumar1976 likes this.


  8. jgkumar1976

    jgkumar1976 Member


    Thank You Sir

    it is working
     


  9. tally.manish

    tally.manish Member


    Dear Sir

    Where we are using in collection

    please share collection code
     


  10. gaurang712

    gaurang712 Member


    [Collection : ClnSaleInfo]
    Type : Voucher ; Stock Item
    Child Of : $$BaseOwner:#VchRef
    Filter : SalesFilt
    Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName,reference,ReferenceDate
     


  11. gaurang712

    gaurang712 Member


    system formulas
    party01:$$CollectionField:$LedgerName:1:ClnSaleInfo
    party02:$$CollectionField:$Reference:1:ClnSaleInfo
    party03:$$CollectionField:$amount:1:ClnSaleInfo
    party04:$$CollectionField:$ReferenceDate:1:ClnSaleInfo
     


  12. tally.manish

    tally.manish Member


    Dear Sir

    Thanks
     


Share This Page