Required Vehicle No. in Sales Register in Columnar

Discussion in 'Free Source Codes' started by Rakesh Kumar, Nov 22, 2019.

    
  1. Rakesh Kumar

    Rakesh Kumar Member


    Respected Experts,

    Please help me to display Vehicle no. Sales Register in Columnar :
    Code is given below :

    [#Part: CMP COLBasics]
    Add: Lines: After: COLREGWithGSTIN:MotorVehicleNo

    [Line: MotorVehicleNo]

    Fields : Medium Prompt, MotorVehicleNo
    Local : Field : Medium Prompt : Info : $$LocaleString:"Lorry No. ?"
    Invisible : NOT @@IsGSTOn

    [Field: MotorVehicleNo]
    Use : Logical Field
    Modifies : MotorVehicleNo
    System: Variables]
    MotorVehicleNo : No

    [Variable: MotorVehicleNo]

    Type : Logical
    Persistent : Yes

    [#Line: DSP ColVchTitle]
    Add: Field : After: DBC GSTIN:DBC MotorVehicleNo
    Local : Field:DBC MotorVehicleNo : Set as : $$LocaleString:"LORRY NO."

    [Field: DBC MotorVehicleNo]

    Use : Short Name Field
    Set as : $MotorVehicleNo
    Width : 0
    Style : Normal
    Invisible : NOT (##MotorVehicleNo AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left


    [#Collection: Columnar Vouchers of Company]

    Fetch : AllInventoryEntries.GSTEntryLedgerName
     


  2. Rakesh Kumar

    Rakesh Kumar Member


    Its my humble request to all the experts, please give me some clue to manage the above code.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You are trying to enter the Vehicle Number in the Sales Register ????
     


  4. Rakesh Kumar

    Rakesh Kumar Member


    Yes Amit Sir. I want to show vehicle number in Sales Register. Please give me a clue
     


  5. gangstar

    gangstar Member


    Problem Solved G

    [#Part:dbl line narration]
    Option:lorryno:mad:@issales

    [!Part:lorryno]
    Add:Line:Before:vch narrprompt:lorrytit

    [Line:lorrytit]
    Field:medium prompt,lorrytit
    Local:Field:medium prompt:Set as:"Lorry No."
    Local:Field:medium prompt:Color:red
    Local:Field:medium prompt:Background:white
    Local:Field:medium prompt:Style:normal bold

    [Field:lorrytit]
    Use:short name field
    Storage:MotorVehicleNo
    Width:15
    Format:"No Comma"
    Color:red
    Background:white

    [System:UDF]
    MotorVehicleNo:String:21714

    [#Part: CMP COLBasics]
    Add: Lines: After: COLREGWithGSTIN:MotorVehicleNo

    [Line: MotorVehicleNo]

    Fields : Medium Prompt, MotorVehicleNo
    Local : Field : Medium Prompt : Set as:"Lorry No. ?"

    [Field: MotorVehicleNo]
    Use : Logical Field
    Modifies : MotorVehicleNo

    [Variable: MotorVehicleNo]

    Type : Logical
    Persistent : Yes

    [System:Variables]
    MotorVehicleNo:""

    [#Line: DSP ColVchTitle]
    Add: Field : After: DBC GSTIN:DBC MotorVehicleNo
    Local : Field:DBC MotorVehicleNo : Set as :"LORRY NO."

    [#Line:dsp colvchdetail]
    Add: Field : After: DBC GSTIN:DBC MotorVehicleNo

    [Field: DBC MotorVehicleNo]

    Use : short name field
    Set as : $MotorVehicleNo
    Width : 0
    Style : Normal
    Invisible : NOT ##MotorVehicleNo
    Skip : Yes
    Border : Thin Left


    [#Collection: Columnar Vouchers of Company]

    Fetch : MotorVehicleNo
    Type:vouchers

    [#Collection: columnar filtered vouchers of company]
    Fetch : MotorVehicleNo
    Type:vouchers
     


  6. Rakesh Kumar

    Rakesh Kumar Member


    Dear Gangstar, please share the screenshot. Code is not working.
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In the Sales Voucher..... enter the Lorry No.

    once done, then it will display in the columnar register.
     


  8. neha shruti

    neha shruti New Member


    how to filter party name in sales register?
    need help
    thanks in advance
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use Alt+F12
     


Share This Page