Here i have problem with Excel import of Sales voucher where i need duplicate control over voucher Reference, hence i am using automatic Voucher number i need control on voucher Reference only 057 : SET VALUE : VoucherNumber : $$RoundUp:$DSDVchNo 058 : SET vALUE : Reference : $DSDVchNo i need to duplicate control if i imported same reference number voucher data Tally Experts Please Help me
Write a collection to get reference from the relevant vouchers. Like [Collection : My Coll] Type: Vouchers: VoucherType Child of : $$VCHTypeSales ;; For Sales Voucher Belongs To : Yes Fetch: Reference Search Key : $Reference 057 : SET VALUE : VoucherNumber : $$RoundUp:$DSDVchNo 058 : SET vALUE : Reference : $DSDVchNo ;;Checking Referen 059 : If : $$IsEmpty: ($$ReportObject:$$CollFieldbyKey:$Reference:$DSDVchNo:MyColl) 060 : MsgBox: "Status": "Reference Number is New" 061: Else 062: MSGBOX : "Eror!!!" : "Reference already Exist" 063: End If
Dear Admin Thanks for your replay bu i am getting Bad formula error while try to import Tally please help me Thanks in advance