AnsweredAssumed Answered

Setting fields when importing Excel file

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

Title

Setting fields when importing Excel file

Post

Hi,

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.

Thanks

 

Outcomes