Check monthly batch.
  • 19 Jun 2024
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Check monthly batch.

  • Dark
    Light
  • PDF

Article summary

- 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).


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.