importing of vouchers using excel with manual numbering issue

Dear Sir,

Vouchers/Transactions will import from excel to tally randomly.not able understand the issue, most of the times it imports only one vouchers and says voucherno already exists,but if manually go and alter the vouchertype master screen , the transcations will get ported . please suggest the solution!

 

Hi Vikram,

Because You may be setting the VoucherNumber while Importing.In The Voucher Type you have Specified as Atomatic. system will Generate the Voucher No.
and Through function u r forcing to set the Value.
Dont specify the EX. 10 : SET VALUE : Voucher Number : $StorageName when that voucher type is Automatic.
One more disadvantage is there when you keep automatic and click the import for 2nd time once again it will get imported.
So,Better it is prefered as Manual Voucher no and prevent duplicate yes.

 

But i am using the manual numbering with prevent duplicate option only,still the problem is same!

 

Problem is still the same (first import creates only one voucher though several entries in the excel)......please help,