can some one say me how to fetch inv supplier invoice no from purchase invoice

Discussion in 'Requests' started by bikash agarwal, Apr 22, 2018.

    

  1. can some one say me how to fetch inv supplier invoice no from purchase invoice


    not working
    :------------------------------
    [#Form : Purchase Color]


    [#Line: DBTitle1]
    Fields : DSP VchDateTitle, DSP VchAcctTitle
    Add:Field:After:DSP VchAcctTitle:BILLCol23

    [Field:BILLCol23]

    Set As : " Supplier Invoice Ref."
    Color : blue
    Width : 12
    Align : left
    Style : Normal Bold
    border : thin right left


    [#Line: DSP VchDybkDetail]
    Add: Field :After :DSP VchAccount:Refnobb


    [Field:Refnobb]
    Use :UniDateField
    Set As : $invreferenceno ;;; $REFERENCE is working but $RefDate1 not working
    Width : 12
    Align:Center
    Style : Normal
     



  2. ;;TDL ------------------supplier info no
    [#Form : Purchase Color]


    [#Line: DBTitle1]
    Fields : DSP VchDateTitle, DSP VchAcctTitle
    Add:Field:After:DSP VchAcctTitle:BILLCol23

    [Field:BILLCol23]

    Set As : " Supplier Invoice Ref."
    Width : 12
    Align : center
    Style : Normal Bold
    border : thin right left
    color: green6


    [#Line: DSP VchDybkDetail]
    Add: Field :After :DSP VchAccount:Refnobb


    [Field:Refnobb]
    Use :Name Field
    Set As : $REFERENCE
    Width : 15
    Align:Center
    color : blue
    Style : Normal bold
    Border: Thin Left right



    working but reference date not comming
     


  3. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Hi..
    If you are referring to purchase bills then use these two methods

    $PARTYINVNO
    $PARTYINVDATE


    They are part of main voucher collection
     


  4. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Hi..
    If you are referring to purchase bills then use these two methods

    $PARTYINVNO
    $PARTYINVDATE


    They are part of main voucher collection
     



  5. supplier invoice no with date in purchase register
     

    Attached Files:

    • 658.png
      658.png
      File size:
      149.6 KB
      Views:
      62


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use this code..........


    Code:
    [#Form : Purchase Color]
    
    
    [#Line: DBTitle1]
    ;    Fields     :    DSP VchDateTitle, DSP VchAcctTitle
        Add    :     Field    : After : DSP VchAcctTitle    : BILLCol20
    
    [Field:BILLCol20]
    
        Set As    :    "Supplier Invoice Reference"
        Width     :     15
        Align     :     center
        Style     :     Normal Bold
        border     :     thin right left
        Line    :     0
    
    
    [#Line: DSP VchDybkDetail]
        Add    :     Field    : After    : DSP VchAccount    : Refnobb
    
    
    [Field:Refnobb]
        Use         : Name Field
        Set As         : $Reference  + " / " + $$String:$ReferenceDate:ShortDate
        Width         : 15
        Align        : Center
        color         : blue
        Style         : Normal bold
        Border        : Thin Left right
    
    [#Collection: NRM Vouchers of Company]
    Fetch : Reference, ReferenceDate
    
    [#Collection : Vouchers of Ledger]
    Fetch : Reference, ReferenceDate
     


  7. Asir

    Asir New Member


     


  8. Asir

    Asir New Member


    Thanks . But the same appearing in Sales Register also. How to use this only for Purchase Register ?
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The Title Line ----DBTitle1 and DSP VchDybkDetail is common for all REGISTERS... hence you will get it in purchase/sales/journal etc.......

    If you want you can try CONDITION in the fields......try it......
     


Share This Page