Setting fields when importing Excel file
Is it possible to have a specific auto entry on some fields during an import? I get Excel Sales reports from different distributors, and when I import the file, I'd like to specify values for fields that show the distributor and the month of the report. Up til now I've been adding this manually to the Excel sheet before import, or doing a replace after, or, more dangerously, changing the auto entry for the field for a particular import. It seems to me there should be a better way than any of these, but I can't see what it is. Any help would be appreciated.
I'm using FM Pro Adv 11.