This post was originally written for the C45-committee, and was published here.
There is no denying that monthly CTS is tough. The process continues to be a challenge for many LPs, especially those who rely on spreadsheets or legacy seed-to-sale systems. In fact, many of the producers we speak to spend a whopping 30% of their time compiling their CTS reports...!
One of the key drivers behind building Elevated Signals was to create software that would simplify the CTS process (we also manage quality compliance and environmental data, but this post will focus solely on inventory). And we’ve since helped tonnes of LPs of all shapes and sizes speed-up and reduce errors in their inventory reporting.
In this post we wanted to share some of the insights we’ve gathered along the way. In the hope that it’ll help you with the process.
Typical CTS challenges & solutions
If you don’t have all of your ducks in a row internally, filling in the CTS workbook can become a complete nightmare. We’ve spoken to producers who have essentially had thousands of plants go ‘missing’ at the end of the month and have no way of figuring out where they’ve gone. That means long days and nights (and weekends!) trying to figure out what has happened.
Here are a of the common mistakes we see producers making:
Problem #1: Transcription errors & information loss
More often than not LPs report inventory in the following format: paper notes -> paper notes -> spreadsheets. For example, a propagation activity is logged on paper multiple times a week and then at some point that information is entered into a spreadsheet. The inventory manager is then responsible for reconciling this at the end of the month.
If you are reporting inventory this way, stop right now! There are far to many opportunities for transcription errors and information to get lost. This is the biggest cause of CTS mistakes.
Solution #1: Get rid of paper.
It’s not the 1950’s. If your organization is still regularly using paper for tracking inventory you are at a material disadvantage. We can’t stress this enough. All inventory should be captured and reported directly into a digital system, at least once a day, for traceability and accountability purposes.
Problem #2: Seed-to-sale software argues with reality
This was nicely summarized by one of our customers recently:
“We had a room with 200 plants and it [the seed-to-sale software] would say we had 174. It wouldn’t allow us to change anything and it was impossible to speak to customer service. It was infuriating.”
If your seed-to-sale is pumping out CSVs with broad numbers and no way of tracing where those numbers have come from, it’s very hard, if not impossible, to verify and fix anomalies and errors.
Solution #2: Use a system that has a double entry ledger & give users the ability to correct mistakes
A double entry ledger system is a method of recordkeeping that tracks where inventory comes from and where it goes. Like a bank account, every transaction gets two entries - a debit and a credit to describe whether inventory is being transferred to or from a batch.
With this sort of system in place, each inventory transaction affects two different batches. For example if you do a harvest, the number of plants goes down - while the amount of fresh cannabis goes up.
Seed-to-sale systems don’t have this capability and as a result products easily go missing. Furthermore, if a mistake has been made, S2S doesn’t let a user correct it. Making CTS difficult.
A good auditing tool that is GMP validated (like ours :) ) uses double-entry ledger, and allows people to correct mistakes; all changes and numbers are traceable for accountability.
Problem #3: Delay between paper records & S2S reporting
Many producers combine paper based record keeping with a legacy seed-to-sale system. The problem with this approach is that you can never be 100% sure how much inventory you have to hand at any one time and, as a result you’ll always have a reporting lag.
Solution #3: Access to real time inventory
Replacing this half digital/half paper system with a fully digital one will give you access to real time inventory levels. This is important, not just for the team responsible for CTS, but the success of the business as a whole.
One final point: It’s important to ensure that every member of your team (old and especially new) understands the CTS process and the consequences of data being captured incorrectly. Map out workflows that help visualize how information flows through your facility, and where it is stored, so your team can clearly see how their actions influence the wider operation.
If any of these problems sound familiar, if you have any questions on CTS, we’re always happy to chat: firstname.lastname@example.org