what is the error

Discussion in 'Tally Developer' started by BHARATKHABAR, Jan 20, 2017.

    
  1. BHARATKHABAR

    BHARATKHABAR New Member


    [Report:pendingorders]
    Form: pendingorders
    Title:"Pending Sales Orders:::::::::::::"
    ;;Collection:summary collection
    ;;Collection:mysales
    Variable:myname1:Number
    [Form:pendingorders]
    Part:pendingorders1;;,pendingsales,part33

    Height : 100% Page
    Width : 100% Page
    Button : new booking,sale

    [Part:pendingorders1]
    Lines:ltitle11,pendingorders1
    Repeat:pendingorders1:collxnamit1c
    Scroll:Vertical
    Border:thick bottom

    [Line:ltitle11]

    ;;Field:poa,pob,poc,pod,poe,pof,pog,poh,poi
    Use:pendingorders1

    Local :Field:default:Type:String
    Local :Field:default:Align:Left
    Local :Field:default:Width:mad:@amountwidth
    Local :Field:default:Skip :Yes
    Local :Field:fponame1 :Set as:"Name";;+$$LocaleString:"Order No"
    Local :Field:fponame1 :Width:30
    Local :Field:fponame1 :align:Centre
    Local :Field:fpophone1 :Width:10
    Local :Field:fpophone1 :align:Centre
    Local :Field:fpoorderno1 :Set as:"Order No."
    Local :Field:fpobooked1 :Set as:"Booked"
    Local :Field:fpotype1 :Set as:"Type"
    Local :Field:fporate1 :Set as:"Rate"
    Local :Field:fpogodown1 :Set as:"godown"
    Local :Field:fposupplied1 : Set as:"Supplied"
    Local :Field:fpobrickbalance1 : Set as:"Bricks balance"
    Local :Field:fpoamountbalance1 : Set as:"amount Balance"
    Local :Field:fpophone1 : Set as:"Phone No"

    ;;Border: flush totals

    [Line:pendingorders1]
    Field:fponame1,fpophone1,fpoorderno1,fpobooked1,fpotype1,fporate1,+
    fpogodown1,fposupplied1,fpobrickbalance1,fpoamountbalance1
    Border: flush totals
    Access Name:"po"+$$String:$$Line

    [Field:fponame1]
    Use:name field
    Width:30
    Set as:$mponame
    Display:ledger vouchers;;:$$IsLedger:"Amit";;:$pname;;:not $$IsEmpty:$mponame
    Variable:ledger name
    Modifies:name
    [Field:fpophone1]
    Use:name field
    Width:10
    Set as:$$ReportObject:$$CollectionFieldByKey:$ledgermobile:mad:myformula:collxnledg
    myformula:#fponame1


    [Field:fpoorderno1]
    Use:name field
    Width:mad:@amountwidth
    Align:Center
    Set as:$mpoorderno

    [Field:fpobooked1]
    Use:name field
    Width:mad:@amountwidth
    Set as:$b/$$NumItems:collxnamit
    [Field:fpotype1]
    Use:name field
    Width:mad:@amountwidth
    Set as:$mpotype
    [Field:fporate1]
    Use:name field
    Width:mad:@amountwidth
    Set as:$mporate
    [Field:fpogodown1]
    Use:name field
    Width:mad:@amountwidth
    Set as:$$Line;;$mpogodown;;$$NumItems:collxnamit
    [Field:fposupplied1]
    Use:name field
    Width:mad:@amountwidth
    Set as:$s/$$NumItems:collxnamit

    [Field:fpobrickbalance1]

    Use:name field
    Width:mad:@amountwidth
    Set as:$$QtySubtract:$b:$s/$$NumItems:collxnamit

    [Field:fpoamountbalance1]
    Use:name field
    Width:mad:@amountwidth
    Align:Right
    ;; Set as:if $$number:#fposupplied1>0 then $$ReportObject:$$CollectionFieldByKey:$closingbalance:mad:myformula:collxnledg else $$number:#fpobooked1*$$Number:#fporate1
    Set as:$$ReportObject:$$CollectionFieldByKey:$closingbalance:mad:myformula:collxnledg ;;else $$number:#fpobooked1*$$Number:#fporate1

    ;;Set as:$$Number:#fpobooked1
    myformula:#fponame1
    Color:red
    Format:"decimal, 0.3"

    [Collection:myvch]
    Type:voucher
    Filter:isboth
    ;;Filter:issalesVT,issalesorderVT
    [Collection:collxnamit]

    Source Collection:myvch
    walk :inventory entries

    By: mpovchtype :$vouchertypename
    By: mponame :$partyLedgerName
    By: mpoorderno :$reference
    By: mpotype :$stockitemname
    By: mporate :$rate
    ;;By: mpoqty :$actualqty
    ;;By: mpogodown :$godownname
    ;;Aggr Compute:mpoqty1:Sum:$actualqty

    Aggr Compute:b:Sum:if $$IsSalesOrder:$vouchertypename then $ACTUALqty else 0
    Aggr Compute:s:Sum:if $$IsSales:$vouchertypename then $ACTUALqty else 0

    [Collection:collxnamit1c]

    Source Collection:collxnamit

    Walk:collxnamit

    By:mponame :$mponame
    By:mpoorderno :$mpoorderno
    By:mpotype :$mpotype
    By:mporate :$mporate

    Aggr Compute:b:Sum:$b
    Aggr Compute:s:Sum:$s
    Filter:removedelivered
    Sort:default:$mponame

    [Collection:collxnledg]

    Type:ledger
    Fetch:name,closingbalance,ledgermobile
    Sort:default:$name
    Search Key:$name
    filter:checkcbdebit

    [Button:New Booking]
    Key:alt+N
    Action:Create:advance booking

    [Button:Sale]
    Key:alt+s
    Scope:Selected Lines
    Inactive : not ($$NumLinesInScope:SelectedLines =1)
    ;;Action:Set:myname1:$$Line
    ;;Action:Call:mysale:##myname1
    Action:Display:mysalesx
    Scope:Selected Lines
    Mode:Display
    ;;Action:print:pendingorders

    [System:Formulas]


    issalesorderVT :$$IsSalesOrder:$vouchertypename
    issalesVT :$$IsSales:$vouchertypename
    isboth :$$IsSalesOrder:$vouchertypename or $$IsSales:$vouchertypename
    removedelivered :$$QtySubtract:$b:$s > 0
    checkcbdebit :$$IsDr:$closingbalance

    [Function:mysale]

    Parameter:lin:Number
    Return:Number

    10:msgbox:inside fxn:##lin


    [Report:mysalesx]
    Form:mysales
    Collection:collxn mysales

    [Collection:collxn mysales]
    Data Source:Report:selected lines
    Fetch:*,*.*;;mponame,partyledger,fponame1,name
    [Form:mysales]
    Part:mysales
    Height:90% page
    Width:90%page
    [Part:mysales]
    Line: mysales;;,date,name,phoneno,qty,type,rate,amount,labour
    ;;Repeat:gpno:mysales
    [Line:mysales]
    Fields:medium prompt,gpno,gpno1,gpno2,gpno3

    Local:Field:medium prompt:Set as:"GATE PASS NO:"
    Local:Field:default:Width:30
    ;;Local:Field:default:Set Always:Yes
    Local:Field:default:use:name field
    Local:Field:default :Border:thick right

    [Field:gpno]

    Set as: $$String:($name+$partyledgername+$mponame+$fponame1)+$$String:$NAME

    [Field:gpno1]
    Set as: $$String:$partyledgername

    [Field:gpno2]

    Set as: $$String:$mponame

    [Field:gpno3]
    Set as: $$String:$fponame1
     
    Last edited: Jan 24, 2017


  2. admin

    admin Administrator Staff Member


    Be specific on error. If you are getting error please attach the same. And tell us what is final result you are expecting from this report.

    Kindly attach your code.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Well the error is...that you are not clear on what error you are getting. If you want help from others....then try to plan ideas in their mind. You already know ...but we dont know. So give screenshots on what result u want? what error you are getting? So we know where to look.
     


  4. mailamitgoyl

    mailamitgoyl New Member



    thanks a lot sir. You are right. will keep in mind next time.
     


  5. Bipin Damania

    Bipin Damania Active Member


    Request to post your code in Code section instead of just copy paste in normal post box, so that Junk & Special characters can be avoided...
    Everyone is busy in their own routine work and if you want anyone will resolve your issue then you should provide clear code and screenshots...
    I hope you will understand and take tis as positive suggestion...
     
    Last edited: Apr 2, 2021


  6. kosi

    kosi Member


    Which error are u talking of
     


Share This Page