Dear All , I am trying to create a control at vchbatchbilled qty field during sale invoice but not getting success. Logic is: qty can't exceed the sales order qty but can be equal to or less than the order qty. Pls help Thanks Rishi
Put a field ahead of the VchBatchbilled Qty .. when the Sales order is selected copy the Qty of SO in that new field and control the billed qty field against the same
Sir, I did as u said but there is problem. Method Billed qty used in sales order and sales invoice both. I call the value of sales order qty in seperate field but when I change the qty in vchbatchbilledqty field this seperate field qty also changed . I want this seperate field qty should not be changed. Then control will proper work. Pls advice
;; jay shri ram [#Field: VCHBATCH NrmlBQty] Set as : if NOT $$IsFieldEdited AND (NOT $$IsEmpty:$$AltTable:VCHBATCHTrack:VCHBATCHOrder:$BilledQty) AND + ($$IsEmpty:$$Value OR $$IsFieldEdited:VCHBATCHTrack OR $$IsFieldEdited:VCHBATCHOrder) Then @FinalBalVal Else @ResetVal Control: cannotmorethanso : $billedqty > $$AltTable:VCHBATCHTrack:VCHBATCHOrder:$BilledQty [System: Formula] cannotmorethanso : $$LocaleString:" Not allowed more than " + $$LocaleString:$$AltTable:VCHBATCHTrack:VCHBATCHOrder:$BilledQty