Importing A Sales Rep Designations.CSV to model

sagarkpr

Need some direction. During L3 Technical Exam, I am not sure which module do we import A Sales Rep Designations.csv.

The downloaded file only have Account Code and Sales Rep Code.

Is there some intermediate work that needs to be done to the file before It can be imported.

Thanks for your help

Accepted answers

umangsinghal

Looks like you need to import this into Accounts list. Csv file having Account Name, Account Code and Rep code. You must be having a property in Accounts list named "Rep code".

All comments

umangsinghal

Do you have any module with dimension of Account Code and Sales Rep code?

sagarkpr

I double checked and I could not find any module with that dimensionality. Maybe I missed an activity or a step during the course.

umangsinghal

Looks like you need to import this into Accounts list. Csv file having Account Name, Account Code and Rep code. You must be having a property in Accounts list named "Rep code".

sagarkpr

I can do that.

Once I complete that, do then I have to use this property to identify the sales rep associated with each account and update it in QUO01?

umangsinghal

I do not remember the exact requirement. But you can follow the instructions provided in L3 Exam.

Dikshant

@sagarkpr,

For each A1 Account, there is a dedicated Sales Representative, and the Sales Rep will be stored in the line item, where line item format is Sales Rep list type and module dimension is A1 Accounts.

sagarkpr

@dikshant, Thanks I was able to get that with earlier response. I am trying to figure now how to take that info and populate it in QUO01 Module.

Dikshant

@sagarkpr, load the csv file directly. The module is dimensioned by A1 Account, and the line item is in Sales Rep list format.

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…