We can't have that. We really need a customer code that exports and imports without alteration. But that cannot be done with Adagio because of the leading zeros so my pre-processing program will replace the leading zero with a one as Bruce G. suggested and new house accounts will be created starting with number 100000.

There are other things that the pre-processing program must do. The POS export columns need to be adjusted to make Adagio A/R import happier. The invoice amount comes out of POS without a decimal point so one must be added. The invoice date does not look like a date (missing /s).