Skip to main content
Question

Daily Backlog Snapshots

  • December 11, 2020
  • 7 replies
  • 360 views
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Superhero (Customer)
  • 542 replies

If I take our order backlog as of tonight at midnight, subtract from that our backlog as of this morning at midnight, then add today's revenue, I will get today's net bookings.

Σ Bookings = Δ Backlog + Revenue

This calculation method accurately handles both order line cancellations and intentional shipping differences.

 

Does anyone else here do this?

What are you using to get a daily snapshot of your backlog?

How are you handling different time zones?

Is your solution easy to maintain/change?

Is it durable?

Is it simple and trustworthy?

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
This topic has been closed for replies.

7 replies

durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • December 14, 2020

Bump.

How does everyone capture their bookings and de-bookings?

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • December 16, 2020

Bump

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • December 28, 2020

Bump.

How does everyone capture their bookings and de-bookings?

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • December 29, 2020

We currently have a fragile system in place to do this, and I’d like to replace it. Does anyone have any brainstorming ideas for how to approach this?

 

I’ve considered a FLASHBACK query to ensure I get a snapshot of the open bookings at precisely midnight, but I’d need to make sure the UNDO is configured correctly.

ORA-01555 Snapshot Too Old (dba-oracle.com)

 

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • January 7, 2021

What is a good way to report net bookings for a given time period?

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • February 12, 2021

How does everyone else track their net bookings?

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Author
  • Superhero (Customer)
  • 542 replies
  • February 24, 2021

Bump. How should we go about tracking net bookings?

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
Terms & ConditionsCookie settingsAccessibility statement