- Print
- DarkLight
- PDF
- Go to RetailVista to statistics > advanced statistics.
- Choose "111: Statistics per product category" as the type of statistic.
- In the "sales" tab, enter two periods.
Period 1 is your previous period (so last month).
Period 2 is your current period.
- In the "Excel" tab, choose XXX for column selection.
- In "Filter template," choose 111 - per product category revenue excl.
- You will now see differences in column F of your Excel document. You can mark the lines without differences as green after further verification through statistic 300.
- The category "SLA RetailVista Transaction-based" cannot be verified.
- The category "Data Traffic Colocation Extra (API)" cannot be verified.
- The categories "SLA Banksys payment terminals" and "SLA CCV payment terminals" can be approved unless you see that a delivery is dated in the current year. You can tell from the current year that it is a project. Now your verification goes a step further through the project. Verify if the price and contract date are correct through the project.
- The "RetailVista usage report" deliveries should be set to new immediately. These need to be verified by Ernst first. - Now go back to the statistics module in RetailVista and select "300: customer statistics" for the statistic type.
- In the "articles" tab, select the category you need to verify first under "Article category". This is "Data Services IASO per month".
- Also select a filter template here. - Make sure your date is correct and set up your Excel tab correctly. - You can now see from your new Excel document that the difference comes from Tuincentrum Oosterik. Period 1 is still charged, but period 2 is not. This indicates a cancellation. - And this is confirmed when you search in eSocrates. - You can also see a note about this in the project via Teamwork. - Now we create a note with the message: "Cancellation IASO administratively verified".
- Now you can move on to the next category.
- Once you have verified all categories, check the projects in Teamwork that are scheduled under "Check invoices - licenses/contracts/SLA".
- For a cancellation, check if it is indeed no longer invoiced, and for a new license, check the date/quantities/price, etc. When prices are not correctly created contractually, you should report this to the contract administration. They can adjust this for you (unless you are authorized to do so yourself).