A user remotely enters invoices and export the batch under CSV format. Then she sends the exported batch as an attachment via e-mail to her main office. All their customer numbers are 3 digits in length.

Main office will import the batch and post it. Everything went ok, until they added some new customers with 4-digit numbers, say 1008. While posting that batch, the programme will drop "8" the 4th digit and allocate the transactions to customer number 100. Very strange. Need your help.

Zafi