Client is running Sage 100 v2018 and have asked for a VI import of cash receipts. They scan in information and save it as a csv. However, the information does not include Customer Number...only Invoice Number. Within the Sage 100 Company where the data is being imported, they do not have duplicate invoice number from one customer to another. I've found a couple of similar subjects within sageCity but one was fixed based on a different procedure prior to importing and the other dealt with Payroll from older datafiles. I'm assuming this would be a Perform process but I'm not knowledgeable with writing the code.
Thank you.