Dear All Experts, In sales voucher i have created one new number field and i have given 100 in that field. I want to increase by one as 101 in next sales voucher like voucher number. please give me sample code or guidance. Thanks in Advance.
Mr Mutharasan you need to set value at field level through formula as below :- Just try it am not sure [Field : your field] Set as : If $$Number@NoOfVouchers = $$Number:"0" then "100" + else @@NoOfSVCurrentVouchers + 1 Set Always : Yes Storage : UDFNO [System: Formula] NoOfVouchers: $$CollectionField:$UDFNO:1:CurrentSalesVouchers CurrentSalesVouchers: $VoucherTypeName = "Sales"
Sorry above post was wrong :- [Field : your field] Set as : If $$Number@NoOfVouchers = $$Number:"0" then "100" + else @@NoOfVouchers + 1 Set Always : Yes Storage : UDFNO [System: Formula] NoOfVouchers: $$CollectionField:$UDFNO:1:CurrentSalesVouchers CurrentSalesVouchers: $VoucherTypeName = "Sales"
Dear Taufeeq Shaikh, Thank you very much for your reply. it is working but the number does not increase. it is showing same number in subsequent sales vouchers. But my requirement is the number should be increase by one like voucher number. if is it possible please reply me. Thanking You