Proofing Price Templates

We're just beginning our first season build using v12.5.1 and I am now creating all 42 of our price templates. For those of you who have worked with Price Templates for a season build already, what did you use to proof the set up? Obviously because I'm typing in prices, I want a second set of eyes to look at everything to ensure that:

A) Each zone has a price or is disabled if there isn't

B) Comparing prices to the spreadsheet to ensure that the amounts are correct

C) All price types appear

D) Discounts (%age based) are calculated correctly off the base price

If anyone can point me in the proper direction for a report or even some SQL code you've used to proof that would be great.

Parents
  • Hi Michele,

    I believe there is a shared report on TASK for just this. I'm not sure the name in TASK but if we just adjusted a little for us, then it should be "Price Matrix Verification" It's an SSRS report. I didn't download it from the shared reports so I can't be certain of the actual name. It's been a savior when it comes to price grid checking.

    Christopher Cuhel, The 5th Avenue Theatre

  • Christopher,

    If you could find the name or solution number, that would be so appreciated. I've looked through and the only one I could find is from Chris Jensen but it's based on a performance and I want to proof at the template set up before it gets to the performance level.

    Thanks,
    MK

Reply Children