;[include:c:\users\kamalhasan\desktop\refresh tdl\refresh tdl.txt] [style:ftnrnb] font:"times new roman" bold:no height:12 [style:ftnrb] font:"times new roman" bold:yes height:13 [#menu:gateway of tally] add:item:report:display:sales [report:sales] form:sales variable:svfromdate,svtodate set:svfromdate:$$monthstart:##svcurrentdate set:svtodate:$$monthend:##svcurrentdate [form:sales] top part:rnheader,rntitle,rnbody button:changedybkdate,changeperiod,entertoedit,explodeflag [part:rnheader] line:rnheader [line:rnheader] field:name field local:field:name field:set as:"sales report " +"("+ $$string:##svfromdate + " - " + $$string:##svtodate+")" local:field:name field:style:ftnrb local:field:name field:full width:yes local:field:name field:align:center [part:rntitle] line:rntitlee [line:rntitlee] field:sno,vchno,vchreff,vchddate,vchsupp,vchitem,vchbq right field:vchaq,vchsrate,vchprate local:field:sno:set as:"s.no" local:field:vchno:set as:"voucher no." local:field:vchreff:set as:"refrence no." local:field:vchdate:set as:"voucher date" local:field:vchsupp:set as:"party name" local:field:vchitem:set as:"item name" local:field:vchbq:set as:"actual quantity" local:field:vchaq:set as:"billed quantity" local:field:vchsrate:set as:"sales rate" local:field:vchprate:set as:"purchase rate" local:field:daefault:type:string local:field:daefault:style:ftnrb local:field:default:align:center border:column titles [part:rnbody] line:invetdet repeat:invetdet:vchcoll border:thin cover scroll:vertical float:no common border:yes [line:invetdet] field:sno,vchno,vchreff,vchddate,vchsupp,vchitem,vchbq right field:vchaq,vchsrate,vchprate [field:sno] set as:$$line style:ftnrnb border:thin left right width:5 [field:vchno] set as:$vouchernumber style:ftnrnb border:thin right width:10 [field:vchreff] set as:$reference style:ftnrnb border:thin right width:10 [field:vchddate] use:short date field set as:$date style:ftnrnb border:thin right width:10 align:center [field:vchsupp] set as:$partyledgername style:ftnrnb border:thin right width:25 table:list of all ledgers,all items show table:always [field:vchitem] use:name field set as:$stockitem style:ftnrnb border:thin right full width:yes display:item monthly summary variable:stockitemname [field:vchbq] set as:$inventoryentries.billedqty style:ftnrnb border:thin right width:10 format:"no symbol" [field:vchaq] set as:$inventoryentries.actualqty style:ftnrnb border:thin right width:10 format:"no symbol" [field:vchsrate] use:rate price field set as:$inventoryentries.rate style:ftnrnb border:thin right width:10 [field:vchprate] use:rate price field set as:$origbilledqty style:ftnrnb border:thin right width:10 [field:ramarks] use:name field set as:$narration style:ftnrnb border:thin right left [collection:vchcoll] type:vouchers filter:salesreport fetch:stockitemname,partyledgername,narration,inventoryentries.billedqty,inventoryentries.actualqty,amount fetch:inventoryentries.rate [system:formulae] salesreport:$$issales:$vouchertypename