Past Usage History in Invoices?

Dan Kamins's Avatar

Dan Kamins

15 May, 2012 12:50 AM

Previous customer invoices are available via API and include a record of all charges including when users exceeded their tracked item allowances.

What we would like to see in addition to this is a record of all of their tracked item usages at billing time even if such usage did not incur a charge (i.e. under included amount). Since many of the tracked items are periodic, this information is lost the instant the bill is generated.

As this could increase the amount of data for each invoice, perhaps a checkbox option at the product level to "record all usage with invoice?" would be appropriate?

If there is another way to access this information (if it is even stored at all), please let us know. Thank you.

  1. Support Staff 1 Posted by Marc Guyer on 15 May, 2012 09:27 PM

    Marc Guyer's Avatar

    Hi Dan -- We have the data but it's nowhere to be found in the GUI or API after an invoice period has ended. For example, for this customer, the item quantities for the period 2012-04-14 21:52:38 - 2012-05-14 21:52:38 were:

    +-------------------+----------+
    | code              | quantity |
    +-------------------+----------+
    | SMS_MT_TOTAL      | 817.0000 |
    | SMS_MO_TOTAL      |  58.0000 |
    | SMS_MT_SPRINT     | 112.0000 |
    | SMS_MT_TMOBILE    |  41.0000 |
    | SMS_MT_CRICKET    |   2.0000 |
    | KEYWORDS_STANDARD |   3.0000 |
    | USERS             | 750.0000 |
    +-------------------+----------+
    
  2. 2 Posted by Dan Kamins on 15 May, 2012 09:33 PM

    Dan Kamins's Avatar

    Good to know it's still around. Might there be any easy way to make it accessible via API? I suggested including it in invoices, but maybe even simpler just a separate API call to load this data for a specific customer?

    Because we push "add item quantity" to CG, and CG closes the period on its own and zeroes out the periodics, you are essentially the authoritative accounting of usage. This is why we would like to have access to these statistics, e.g. to check "how many widgets does customer X use on average each month".

    Thank you.

  3. Dean closed this discussion on 22 Jan, 2013 10:35 PM.

Discussions are closed to public comments.
If you need help with Cheddar please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

28 Mar, 2024 10:45 PM
24 Jan, 2024 08:33 AM
11 Jan, 2024 07:13 AM
30 Nov, 2023 02:07 AM
22 Nov, 2023 08:41 AM