AnsweredAssumed Answered

Setting fields when importing Excel file

Question asked by vmtc on Jun 7, 2012
Latest reply on Jun 8, 2012 by Sorbsbuster


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.