2. Client Related Rates
2. Client Related Products Workflow
1. Purpose
Configure all rate-related master data for a client so that handling, storage, and other charges can be calculated, posted to the general ledger, and reported accurately.
2. Step-by-Step Configuration
Start 🟢
MANDATORY SETUPÂ
-
CR.06 – Client Names & AddressesÂ
- Ensure the client master record exists before assigning rates.
-
CR.10 – Measuring Unit CodesÂ
- Define unit-of-measure codes (e.g., EA, PLT, CBM) used in rate calculations.
-
CR.36 – Revenue Reporting CodesÂ
- Create reporting codes that map revenue to specific services or departments.
-
GL.06 – General Ledger Account CodesÂ
- Enter GL accounts for handling, storage, surcharges, and other charge categories.
OPTIONAL SETUPÂ
-
CR.20 – Invoice Group CodesÂ
- Group related charges under a single invoice section (e.g., “Inbound Handling,” “Storage”).
-
CR.19 – Cumulative Quantity Rate BreaksÂ
- Define tiered rate breaks based on quantities or periods (e.g., 1–100 units @ $5, 101–500 units @ $4).
MANDATORY SETUPÂ
-
CR.22 – Rates (Handling, Storage, etc.)Â
- Enter the actual rate values for each service, linked to the measuring unit codes and rate-break tiers.
OPTIONAL SETUPÂ
-
CR.17 – Table of Charge CodesÂ
- Create lookup tables that simplify ad-hoc charge calculations (e.g., temperature-holding fees, special services).
-
OR.42 – Query of Rate InformationÂ
- Run an on-screen lookup to verify all rate definitions for the client.
OUTPUT
-
CR.48 – Client Rates ReportÂ
- Generate and print the comprehensive Client Rates Report, summarizing every configured rate, tier, and GL mapping.
EndÂ
4. Outputs & Artifacts
- Measuring Unit Table (CR.10)
- Revenue Reporting Codes (CR.36)
- GL Account Setup (GL.06)
- Invoice Group Definitions (CR.20)
- Quantity Rate Breaks (CR.19)
- Rate Entries (CR.22)
- Charge Tables (CR.17)
- On-Screen Rate Query (OR.42)
- Client Rates Report (CR.48)
5. Best Practices
Master-Data First: Always complete steps 2–6 (client record and unit/GL setup) before defining rates.
Tier Validation: After creating rate breaks (CR.19), test a sample calculation to confirm tier logic.
GL Mapping: Ensure every rate category maps to a valid GL code to avoid posting errors.
Report Review: Review the printed Client Rates Report (CR.48) with the client for sign-off before going live.
6. Legend & Roles
| Icon / Color | Meaning |
|---|---|
| 🟢 Green oval | Start |
| 🟨 Yellow rectangle | Mandatory Setup |
| Â Light yellow | Optional Setup |
| 🟦 Data / Manual | Data Entry or Query |
| đźź§ Orange rectangle | Output / Document |
| đź”´ Red oval | End |
Was this article helpful?
Give feedback about this article