Differences

This shows you the differences between two versions of the page.

--- billing:customer_map [2026/08/18 02:21] – [Customer Map and Package Map] Scott Cunliffe
+++ billing:customer_map [2026/08/18 03:45] (current) – [See Also] Scott Cunliffe
@@ Line 1: / Line 1: @@
 ====== Customer Description Map ======
-The Customer Description Map file maps a TapeTrack [[definitions:customer-id|Customer-ID]] to a readable Customer name, location, account name, or other billing description.
+The Customer Description Map file maps a TapeTrack [[object:customer|Customer-ID]] to a readable Customer name, location, account name, or other billing description.
 The map is used by [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]] when processing TapeTrack statistics (.ttstats) files for billing.
@@ Line 37: / Line 37: @@
   /etc/tapetrack/billing/customer.txt
-The location of the file is supplied to ''TMSS10LogStatsProcess'' using the ''-M'' argument.
+The location of the file is supplied to ''[[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]'' using the ''-M'' argument.
@@ Line 86: / Line 86: @@
-===== Creating a New Mapping =====
-Before adding a new Customer Description Map entry:
-  - Confirm the TapeTrack Customer-ID.
-  - Confirm the approved customer or location description.
-  - Confirm the required QuickBooks customer name or identifier.
-  - Check that the Customer-ID is not already mapped.
-  - Add the new entry to the Customer Description Map.
-  - Confirm that the Customer is also present in the Package Map.
-  - Test the mapping with a sample ''.ttstats'' file.
-  - Review the generated XML before using the mapping in production.
-Example:
-  US04=Chicago
-<WRAP important>
-The Customer-ID in the map must match the Customer-ID stored in TapeTrack and contained in the ''.ttstats'' file.
-</WRAP>
-===== Modifying an Existing Mapping =====
-When changing an existing Customer Description Map entry:
-  - Confirm that the change has been approved.
-  - Make a backup copy of the current map file.
-  - Update only the description on the right side of the mapping.
-  - Do not change the TapeTrack Customer-ID unless the Customer-ID has also changed in TapeTrack.
-  - Generate a test billing XML file.
-  - Confirm the new description matches the corresponding QuickBooks customer.
-  - Retain the previous file for audit and rollback purposes.
-Example change:
-<code>
-Before:
-US01=Los Angeles Data Centre
-After:
-US01=ACME Los Angeles
-</code>
-Changing a customer description does not change the statistics, billing package or billing rates. It changes the customer description used by the billing output.
-===== Validation =====
-The Customer Description Map should be validated before every production billing run.
-Check that:
-  * Every billed Customer-ID has a corresponding map entry.
-  * No Customer-ID appears more than once.
-  * Customer descriptions are accurate and approved.
-  * Customer descriptions match the intended QuickBooks customer records.
-  * There are no unwanted spaces around the Customer-ID.
-  * The file contains no spelling errors.
-  * The file is readable by the billing service account.
-  * The correct version of the file is being used.
-  * Test billing XML contains the expected customer descriptions.
-A validation table can be maintained for each billing run.
-^ Check ^ Expected Result ^
-| Customer-ID exists in TapeTrack | Customer record is present. |
-| Customer-ID exists in Customer Description Map | One mapping is present. |
-| Customer-ID exists in Package Map | One billing package is assigned. |
-| Customer description is approved | Description matches the billing profile. |
-| QuickBooks customer exists | Mapping resolves to the intended QuickBooks customer. |
-| Test XML is correct | Customer and item descriptions display as expected. |
 ===== Troubleshooting =====
@@ Line 218: / Line 150: @@
   * [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]
   * [[master:customer|Adding and Maintaining Customers]]
-  * [[definitions:customer-id|Customer-ID]]
   * [[billing:package_map|Package Map]]
   * [[billing:billing_rules|Billing Rules]]