This article will talk you through why we do this task, and how to carry out the task.
TABLE OF CONTENTS
Why do we carry out this task?
Each month, around the 15th, we should run an SQL Query to check all Private Sellers that have been set up the month before. This is to ensure their payment is set up, and the branch has been set up correctly.
How to carry out this task
- Open SQL Developer, Right click on HI1_RMPROD, and select properties as Highlighted
2. It will open a login page; you will need to put in your username and password.
Make sure to test your connection using the highlight button at the bottom, If it says ‘Status; Success’, you can connect!
3.Once connected, you will want to copy and paste the below into the query sheet;
4.Once you have Copy and Pasted the query in and changed the dates, you will want to press the green play button in the corner;
5. Once the query has run, it will show all the results; These are all the PV’s set up in Novus for that particular month.
6. You will now want to open Site Admin. Taking the first Branch ID, search the Branch ID and go to products, Open Novus. You will want to check the PV is on the correct package compared to the country on the query results. You will also want to check there is an AM assigned.
For Example; I checked the first result on the page.
