How to view a spreadsheet with all billing rule details

IN THIS EXAMPLE , ONE SPREADSHEET IS CREATED TO VIEW ALL PICKUP RULES FOR ALL CUSTOMERS

 

MM 05172023 1

DOWNLOAD REQUEST SCREEN

 

MM 05172023 2

PICKUP RULES SPREADSHEET:

Each Rule Class has its own section
Each customer in the Rule Class has its own row

 

MM 05172023 3

FIRST ROW IDENTIFIES COLUMNS:

Customer Profile Info
Containers/Rules in the Rule Class
MM 05172023 4

NEXT TWO ROWS INDICATE:

Base (Global) price for each rule in the Rule Class
Base (Global) Quick Quote Price for each rule in the Rule Class
MM 05172023 5

INDIVIDUAL CUSTOMER ROWS:

Indicate custom pricing for each relevant customer / rule

 

A SIMILAR SPREADSHEET CAN BE CREATED FOR DELIVERY RULES