[Reportendingorders] Form: pendingorders Title:"Pending Sales Orders:::::::::::::" ;;Collection:summary collection ;;Collection:mysales Variable:myname1:Number [Formendingorders] Partendingorders1;;,pendingsales,part33 Height : 100% Page Width : 100% Page Button : new booking,sale [Partendingorders1] Lines:ltitle11,pendingorders1 Repeatendingorders1:collxnamit1c Scroll:Vertical Border:thick bottom [Line:ltitle11] ;;Fieldoa,pob,poc,pod,poe,pof,pog,poh,poi Useendingorders1 Local :Field:default:Type:String Local :Field:default:Align:Left Local :Field:default:Width@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 [Lineendingorders1] 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:$ledgermobilemyformula:collxnledg myformula:#fponame1 [Field:fpoorderno1] Use:name field Width@amountwidth Align:Center Set as:$mpoorderno [Field:fpobooked1] Use:name field Width@amountwidth Set as:$b/$$NumItems:collxnamit [Field:fpotype1] Use:name field Width@amountwidth Set as:$mpotype [Field:fporate1] Use:name field Width@amountwidth Set as:$mporate [Field:fpogodown1] Use:name field Width@amountwidth Set as:$$Line;;$mpogodown;;$$NumItems:collxnamit [Field:fposupplied1] Use:name field Width@amountwidth Set as:$s/$$NumItems:collxnamit [Field:fpobrickbalance1] Use:name field Width@amountwidth Set as:$$QtySubtract:$b:$s/$$NumItems:collxnamit [Field:fpoamountbalance1] Use:name field Width@amountwidth Align:Right ;; Set as:if $$number:#fposupplied1>0 then $$ReportObject:$$CollectionFieldByKey:$closingbalancemyformula:collxnledg else $$number:#fpobooked1*$$Number:#fporate1 Set as:$$ReportObject:$$CollectionFieldByKey:$closingbalancemyformula: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 Actionisplay:mysalesx Scope:Selected Lines Modeisplay ;;Actionrintendingorders [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
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.
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.
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...