How do I create an Import Scenario to add the customer's Credit Limit to their Financial Credit Verification Rules from a spreadsheet file?
Best answer by jsudak
View originalHow do I create an Import Scenario to add the customer's Credit Limit to their Financial Credit Verification Rules from a spreadsheet file?
Best answer by jsudak
View originalHello,
Are you having trouble with an Import Scenario that you have already configured? If yes, please post screen shots of the import scenario and your results, including any errors.
If you are brand new to Import Scenarios and are just getting started, a good place to begin is the free instructional videos on Acumatica Open University:
https://openuni.acumatica.com/courses/reporting/i100-integration-scenarios/
Laura
Thanks for the suggestion. The 4 hours I spent on this course did not help at all (which, sadly, I find is typical of most of the courses). I learned more about Data Providers, Import Scenarios, and Import by Scenario, but nothing that directs me through the process of adding/updating the field I need loaded.
I have a 3-column spreadsheet that has the Account ID, Customer Name, and Credit Limit in $$$. I do not have a comprehensive list of customers, just the credit limits for a portion of them that needs to be added to the Customer Record on the Financial tab under Credit Verification Rules.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.