ICM Cloud Export to ROSS after commissions

Created by Kathy Kale, Modified on Mon, 16 Sep, 2024 at 2:40 PM by Kathy Kale



https://cloud.varicent.com/


run this after commissions match.

export to excel

*****************************************************

Make sure to change the Value column in the excel to Number, no commas.

if you do not, it will put quotes around the values that are more than 1,000

these lines will read in as 0 commissions.

***********************************************  



Based on the spPeriodPayDate

Run 3 exports - takes under 2 minutes

Creates 3 export files



User options         Downloads

click on 3 dots to download




 

Now you can see the Download option



Click on the download at the top right corner

Click on "Full download history"



Clock the folder option to see where these are stored

  



copy these 3 to your ROSS user folder

        KKALE or SZACHARIAS

Run the programs in ROSS to pull in the



Copy and paste into your ROSS user folder



Rename them for easy running of the Import into ROSS.

CHANGE the value to format number with no commas.  

If you do not change the format, it will format the values over 1000 with quotes and read the value as $0.00



Save as CSV


Make sure the data is for this period.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article