After adding Additional Fields to the purchase and sales register my daybook takes a lot of time to load. Is this how it will be or is there a way to improve it. Please help. ;;;;;;;;;;;Voucher Register Columns;;;;;;;; [#Line: DSP VchDybkDetail] Add: Right Fields :After : DSP VchNumber : MyQtytotal [Field: MyQtytotal] Use : Name Field Align : Right Width : @@VCHQtyWidth Style : small bold italic Set as:$$CollectionField:$Qty:1:sumMcoll Set always : Yes Skip : Yes Invisible: Not $$IsPurchase:##VoucherTypeName Inactive:Not $$IsPurchase:##VoucherTypeName [Collection:Collec] type: vouchers: vouchertype Child Of: $$VchTypePurchase Belongs To:Yes [Collection:sumMcoll] Source Collection :Collec Walk :AllINVENTORYENTRIES By :vch:$vouchernumber Aggr Compute:qty:Sum:$BilledQty Filter:fltr [System:Formula] fltr:$vch=#dspVchNumber ;;;;;;; Collection;;;;;; [#Collection: NRM Vouchers of Company] Fetch : Reference,EICheckPost,BasicShipVesselNo,BasicPurchaseOrderNo [#Field: EI ConsigneeGSTIN] Set as: #EIBuyerGSTIN
Do not understand or know wot your requirement is....... According to that....use a proper filter............. right now your filter is going through all vouchers...... hence time taken as per your data load.
Compute your QTY in the default collection... i.e. NRM Vouchers of Company Use $$CollQtyTotal to derive your values....... (Refer to COLL- InventoryEntries)...... it is easy...you can do it......... Delete your 2 collections........... Also in all the Invisible and Inactive Field attributes ........... add at the end ......... AND ##IsDaybook I think, above will solve your issues.
Sir, I did through $$CollQtyTotal the loading time is improved, but it is showing quantity only when I am exploding the report.
[Field: MyQtytotal] Use : Name Field Align : Right Width : @@VCHQtyWidth Style : small bold italic Set as : $$CollQtyTotal:InventoryEntries:$BilledQty Set always : Yes Skip : Yes Invisible: Not $$IsPurchase:##VoucherTypeName AND ##ISDAYBOOK Inactive:Not $$IsPurchase:##VoucherTypeName AND ##ISDAYBOOK [#Collection: NRM Vouchers of Company] Fetch : Reference,EICheckPost,BasicShipVesselNo,BasicPurchaseOrderNo,BilledQty [#Collection : DayBook Vouchers Of Company] Fetch : Reference,EICheckPost,BasicShipVesselNo,BasicPurchaseOrderNo,BilledQty [#Collection: Daybook ExplodeColl] Fetch : *.*
Actual and best way is........... [#Collection: NRM Vouchers of Company] Compute : MyQty : $$CollQtyTotal:InventoryEntries:$BilledQty [Field: MyQtytotal] Use : Name Field Align : Right Width : @@VCHQtyWidth Style : small bold italic Set as : $MyQty Set always : Yes Skip : Yes Invisible: Not $$IsPurchase:##VoucherTypeName AND ##ISDAYBOOK Inactive:Not $$IsPurchase:##VoucherTypeName AND ##ISDAYBOOK
yes Sir, That is how i Have done. But since now the data is loading fast so i have added quantity Field to daybook also. for that i have Computed the same in the [#Collection : DayBook Vouchers Of Company].