TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace: • container_add_volume_inventory • tools_global_view • gui • billing_process_temp • setcsvdelimiter • receipts • inventory_right_menu • barcode-interpretation-definition • add_user • upload_files
cookbook:billing_process_temp

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
cookbook:billing_process_temp [2026/08/19 02:48] – [Table] Scott Cunliffecookbook:billing_process_temp [2026/08/19 05:12] (current) – [Generate the Invoice XML] Scott Cunliffe
Line 84: Line 84:
 </file> </file>
  
-When ''TMSS10LogStatsProcess'' is run with the ''-M'' option, ''$CUSTOMER'' contains the Customer-ID from the ''.ttstats'' file and ''$CUSTOMER2'' contains the mapped description.+When [[cli:TMSS10LogStatsProcess]] is run with the ''-M'' option, ''$CUSTOMER'' contains the Customer-ID from the ''.ttstats'' file and ''$CUSTOMER2'' contains the mapped description.
  
 <WRAP important> <WRAP important>
Line 92: Line 92:
 ==== Package Map ==== ==== Package Map ====
  
-Create a package map when the billing definition filters rules by package. The package assigned to the Customer must match the package filter in the applicable billing rules.+Create a [[billing:package_map|package map]] when the billing definition filters rules by package. The package assigned to the Customer must match the package filter in the applicable billing rules.
  
-If the Customer does not use package-based filtering, confirm whether the site's standard package map or wildcard rules should apply.+If the Customer does not use package-based filtering, confirm whether the site's standard [[billing:package_map|package map]] or wildcard rules should apply.
  
 ===== Configure Billing Rules ===== ===== Configure Billing Rules =====
Line 141: Line 141:
 AddStorageChargeItem("*", "US01", "LTO", "OFFS", AddStorageChargeItem("*", "US01", "LTO", "OFFS",
                      10, 0, 0, 0, 1,                      10, 0, 0, 0, 1,
-                     "$CUSTOMER2", "A - Storage:QBRACKSTORAGE", +                     "$CUSTOMER2", "A - Storage:QB_RACKSTORAGE", 
-                     "LT media storage", 0, 0);+                     "LTO media storage", 0, 0);
 </file> </file>
  
Line 172: Line 172:
 | Storage | Daily total | Real high-water | Real low-water | 3 = slot total; 4 = slot high-water; 5 = slot low-water | | Storage | Daily total | Real high-water | Real low-water | 3 = slot total; 4 = slot high-water; 5 = slot low-water |
 | Movement | Total movements | Movement high-water | Movement low-water | Not applicable | | Movement | Total movements | Movement high-water | Movement low-water | Not applicable |
-| Inventory | Total inventory | Inventory high-water | Inventory low-water | Not applicable |+| Inventory | [[billing:terms|Total inventory]] | [[billing:terms|Inventory high-water]] | [[billing:terms|Inventory low-water]] | Not applicable |
 | Journal | Total quantity | Journal high-water | Journal low-water | Not applicable | | Journal | Total quantity | Journal high-water | Journal low-water | Not applicable |
  
Line 198: Line 198:
 Create a dedicated test output directory and run the extractor for a known date range. The following command is a template; replace every value in angle brackets with the value required by the installed environment: Create a dedicated test output directory and run the extractor for a known date range. The following command is a template; replace every value in angle brackets with the value required by the installed environment:
  
-<code> +<file bat runExtraction.bat> 
-TMSS10LogStatsExtractDB \ +TMSS10LogStatsExtractDB  -h <journal-database-home> -R <date-range> -o <test-output-directory> -c US03 -C <customer-translation-map> 
-  -h <journal-database-home> \ +</file>
-  -R <date-range> \ +
-  -o <test-output-directory> \ +
-  -c US03 \ +
-  -C <customer-translation-map> +
-</code>+
  
 Use ''-H'' when the contract bills the maximum snapshot count observed during each day. Use ''-m'' only when the agreed process requires billing a Volume in multiple locations on the same day. Use ''-H'' when the contract bills the maximum snapshot count observed during each day. Use ''-m'' only when the agreed process requires billing a Volume in multiple locations on the same day.
Line 227: Line 222:
 Process the Customer statistics file with the approved definition and maps: Process the Customer statistics file with the approved definition and maps:
  
-<code> +<file bat runCreateXML.bat> 
-TMSS10LogStatsProcess \ +TMSS10LogStatsProcess -i <test-output-directory>/US03.ttstats -c <billing-definition>.ttsdef -M Customer.ttmap -P <package-map>.ttmap > <test-output-directory>/US03.xml 
-  -i <test-output-directory>/US03.ttstats \ +</file>
-  -c <billing-definition>.ttsdef \ +
-  -M Customer.ttmap \ +
-  -P <package-map>.ttmap \ +
-  > <test-output-directory>/US03.xml +
-</code>+
  
 Omit ''-P'' only when package mapping is not required. The ''-N'' option suppresses the XML declaration, stylesheet reference, and ''<tapetrack_data>'' wrapper and should not be used for a normal standalone QuickBooks import file. Omit ''-P'' only when package mapping is not required. The ''-N'' option suppresses the XML declaration, stylesheet reference, and ''<tapetrack_data>'' wrapper and should not be used for a normal standalone QuickBooks import file.
cookbook/billing_process_temp.1787107725.txt.gz · Last modified: 2026/08/19 02:48 by Scott Cunliffe