Sage 100

VI guru input request :) v2014 (sorry did not get spu and std or adv.) Import routine into AR using ODBC source from another program. This program creates invoices that are then imported into Sage. First thought this is WAD, but I guess it had been working until recently. The invoice number being imported is 4 digits (like 1234 or could be 1234.1) of course Sage adds leading zeros. Any way to get Sage to only see what I want it to?

AR Invoice Entry supplies the leading zeroes also - Unless an alphabetic character is included in the invoice #.

Invoice numbers like 1234.1 I would suspect would not get padded with leading zeroes, I would expect.

I manually tested AR invoice entry and yes @RandyMarion any number entered after a period will enter without leading zeros. Also, if a letter precedes the number it will take it as entered. I am going to have to look at some old invoice numbers in their system to see if something like that got dropped off.