Sage 100

Does anyone have an import into either CI_Item or the Vendor Price Level file that uses a file that only has the alias in the file, not the actual item number? This would be a vendor's price list, sent to my end user. I think this cold is getting to my brain.

Version???

2013

I'd love to know if this is possible: ""out of the box"", I always end up joining the 2 tables in Access or something to get the actual item # on the record.

I don't think the File Assign would work as, in theory, the same alias could exist for multiple vendors. I think you're stuck with the approach @BrettLyder proposes. I too would love a better way.

I was hoping someone had the perform logic, because that's the way I want to go. I'll check my other source and see if he has done this.

That is a difficult one since you can have the same alias apply to multiple vendors. In the past I have usually done a query or crystal report to pull the MAS data I need to combine with the import file data and create a complete import file. I have better luck with that over using perform logic, etc.