Sage 100

Another VI Question: Customer is on 5.0, new implementation. We are going to be creating a UDF at the customer master to reference a third party 'customer ID' (can't implement expanded customer numbers as these are beyond that length too). He would like to import in AR Invoice using this UDF as the key field. In other words the source file will not have the Sage customer ID in it. Any suggestions? He doesn't want to do any custom programming/pre processing.

He doesn't want to do any custom programming/pre processing."" I do not believe so. Everything in standard VI is driven by key fields and adding a UDF as the key field would likely involve custom programming.

At LEAST some perform logic, which isn't that big of a deal, in the scheme of things. I have an import into Cash Receipts where the only thing available was the customer and the PO, and had someone write perform logic to find the invoice based on the PO.

It would require custom perform logic to be created.

Thank you!

I would uses access to link to the text, csv file and create a query that creates the proper customer number. You can import from this query or view. Should be simple.