plz help me sir but not working that code in this form [System:formulae] HPUnitDtlss:$ItemUnitQtys [Collection:HPUnitCollections] Source Collection: Default Walk: InventoryEntries Fetch:BilledQty,StockItemName By :ItemUnits:$$IsSysName:$AdditionalUnits:StockItem:$StockItemName Aggr Compute :ItemUnitQtys:Sum:$BilledQty:Symbol,ShortForm,Secondary ;+ " )" Format:Symbol,ShortForm,Secondary
what i am do plz help me sir [System:formulae] HPUnitDtlss:$ItemUnitQtys [Collection:HPUnitCollections] Source Collection: Default Walk: InventoryEntries Fetch:BilledQty,StockItemName By :ItemUnits:$$IsSysName:$AdditionalUnits:StockItem:$StockItemName Aggr Compute :ItemUnitQtys:Sum:$BilledQty:Symbol,ShortForm,Secondary ;+ " )" Format:Symbol,ShortForm,Secondary
Try any $$CollQtyTotal:InventoryEntries:$BilledQty $$FilterQtyTotal:InventoryEntries:OwnItemOutEntries:$ActualQty + $$Negative:$$FilterQtyTotal:InventoryEntries:OwnItemOutRevEntries:$ActualQty $ActualQty * $$ToValue:$CostDate:$ClosingRate:StockItem:$StockItemName $$AllocTrackValue / #TRACKVCHQty $$AsInQty:$$NettQty:$$VchItemTotal:$ClosingBalance:StockItem:$StockItemName $$AsReqObj:$$CollQtyTotal:StockItemBelongsToGroupName:$ItemLedTrSaleQty ($$AsSignedQty:$$PrevFld / $$Number:$$AsSignedQty:$$PrevFldTotal) * 100 $$BaseValue:$$ToValueConsDay:$$ResidualValue:#StockItemNameBatchNameGodownName:#DSPVchOutQty $$CollQtyTotal:InventoryEntries:$BilledQty Double Sub Column Titles : $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType EXPINV BilledQtyTotal if $StockItemName = $$ReqObject:$Name then $ActualQty else ($ComponentReqdQty:StockItem:$StockItemName * ($ActualQty / $BasicQty:StockItem:$StockItemName)) $$IsSysName:$StockItemName OR $$IsSysName:$AdditionalUnits:StockItem:$StockItemName OR $$IsEmpty:$ActualQty $$NettQty:#DSPVchInTotalQty:#DSPVchOutTotalQty (##ShowQtyExtract AND $$IsInventoryOn) OR @@IsVarInvVch $$SubTotalSPVchInQty $$SubTotalSPVchOutQty $$Total:VCHBATCHBilledQty Line 34047: $$Total:VCHBilledQty