Hello Everyone, Good Morning to all Please let me know how to get total of No. of Kind packages in Invoice Print I tried by separate column in voucher entry column but it is also not working i think i missed a collection. Please help me out how to write a collection for it
Please review my code once [#Line: EI ColumnOne] ;; Inv Voucher Title Add:Right Field:Before : VCH QtyTitle: CHS Packet [Field:CHS Packet] Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth SubTitle : Yes Setas : $$LocaleString:"Packets" Style : Small Bold Align : Centre Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl Skip : Yes Fixed : Yes [#Line: EI InvInfo] ;; Inv Voucher Body Add:Right Field:Before:VCH BilledQty:CHS BilledPacks [Field:CHS BilledPacks] Use : Number Field Set as : $$Value Storage : BilledPackets Style : Normal Bold Border : Thin Left Align : Center [#Field: EI QtyTotal] ;;Inv Vch Total Add:Field:Before:EI ActualQtyTotal:VchFldPacTotal [Field: VchFldPacTotal] Use : Number Field Set as :$$Total:CHSBilledPacks;$$CollNumTotal:StkGrpinventoryEntries:$BilledPackets;:CHSBilledPacks;VCHBATCHBilledQty;VCHBATCHFldQty;VCHBATCHFldQty; Style : if @@IsInvVch then "Normal" else "Normal Bold" Storage : VchFldPacTotal Background : Green Align :Center Set Always : Yes [System:UDF] VchFldPacTotal: Number:697 BilledPackets:Number:2020
Not working sir, I Tried like this in above code [Field: VchFldPacTotal] Use : Number Field Set as :$$Total:CHSBilledPacks Storage : VchFldPacTotal Background : Green Align :Center Set Always : Yes
It is not coming as it has not been defined for that purpose.......... Above code is only for voucher Entry screen........ add the fields in the PRINT and it will display.
@Abhinandanjain and @ChSuresh try this one , [#Line:EI ColumnOne] Add : Right Field : Before : VCH QtyTitle : CHS Packet Local : Field : CHS Packet : INFO : “PACKETS” [#Line:EI InvInfo] add : right field : before : VCH ActualQty :CHS Packet [Field : CHS Packet] use : Name field Storage :CHS PacketStorage Set always : yes Width : 15 Align : Center invisible : not@@ISSALES @@ISSALESORDER [System : UDF] CHS PacketStorage : String : 6000 [#Line: ExpInv Column1] Add : left Field : After :EXPINV DescTitle : CHS Packet Local : Field : CHS Packet : Info : ”PACKETS” Local : Field : CHS Packet : Delete : Storage Local : Field : CHS Packet : Type : String Local : Field : CHS Packet : align : Center Local : Field : CHS Packet : Width : 10 Local : Field : CHS Packet : border : thin left [#Line :ExpInv InvDetails] add : left Fields : after : EXPINV Desc :CHSPacketStorage [ Field : CHS PacketStorage] use : Name Field Set as :$CHSPacketStorage Set Always : Yes Width : 10 Align : Center Border : Thin Left