D2. Inventory Management

Prev Next

Ways to Apply

The Point of Sale Management module allows organizations to process in-person transactions quickly and efficiently while maintaining a complete financial record within Recreation Management. Inventory Management allows your organization to track item counts that are kept by location, and a tracked item with no stock shows as Out of Stock. Cashiers can’t sell it unless they hold the Override Inventory permission. If counts go stale, sales stop even though the shelf is full, so only track items you’ll keep counted. Costs of Goods sold is an additional feature in Recreation Management’s inventory system.


Video Lesson

To learn more, please watch our instructional video about Inventory Management and the Sale of Items. Once finished, review how to apply what you learned in the system before continuing to the next lesson, Internal Account Actions.


Need Help?

View answers to questions frequently asked by users in our Frequently Asked Questions or contact your CivicPlus representative if you have additional questions. Alternatively, you can review Tasks to Complete to see tasks that you can implement in your system on your own as well as Best Practice suggestions for implementation of Inventory.


Frequently Asked Questions

Do we have to enter a cost?

No, utilizing Cost of Goods Sold is optional. If you do enter it, enter the total cost for the whole quantity, not the unit cost. For 100 candy bars that cost $80 in all, enter $80. The system works out the per-item cost, and later entries pre-fill the cost from the last batch, which you can override.

The shelf count doesn't match the system. What do I do?

Add or burn the difference, with a note that says it's a count correction, so the log shows what happened. Don't adjust by overriding sales. Please refer to our Track Inventory History article for additional guidance on how to filter the log when you're investigating.

Should the person who receives stock also be able to remove it?

Consider separating them. Burn entries are how shrinkage disappears from the count, so many organizations give burn and override permissions to a supervisor only. See the Security Center module and the Permissions Guide.

We entered the wrong cost. How do we fix it?

  • On the batch: in the Inventory Log, select the Edit Inventory Record (pencil) icon on the entry, update Cost of Batch, and save.

  • After items were sold: an administrator can edit an item's cost on a receipt. Find the receipt in the Financial Transaction Browser, open the COGS Edit tab, update the Cost column and save. This is an Administrator permission only.

A tracked item shows out of stock but there's stock on the shelf.

No entry has been added, or the count ran out. Add an inventory entry for that location.

Which items should track inventory, and which shouldn't?

Track It When…

Don't Track It When…

The item has real stock you can run out of, such as drinks, snacks and merchandise

Stock is effectively unlimited, such as day passes or an item you make to order

You need to know shrinkage, or margin on what you sell

No one will keep the counts up to date


Tasks to Complete

While learning how to utilize Point of Sale Management, you may experience areas where you have questions. If you have any questions or run into issues, please keep track of them so your CivicPlus representative may address them.

Please complete the following:

Inventory Management Tasks

  • Assign the five inventory permissions by role.

  • Add opening entries for each tracked item at each location, with notes.

  • Run the Inventory Valuation Detail report to check the starting position.

  • Sell a tracked item and watch the count drop.

  • Let an item run out, and see the cashier's error with and without Override Inventory.

  • Burn an item and read the log's notes.

  • Void a sale and check whether the count returns.

  • Fix a wrong batch cost, and a receipt cost.


Best Practices

Please consider some of our suggestions for applying best practices in the  software. It is essential to evaluate your current processes and identify areas where improvements can be made. By doing so, you will not only streamline your workflow, but also provide a better experience for both staff members and public users.

Best Practice Recommendations

  • Track only what you'll keep counted

  • Give burn and override to a supervisor

  • Enter total batch cost, not unit cost

  • Write a reason on every burn

  • Keep counts by location

  • Use the date and time on entries

  • Run the Inventory Valuation Detail report regularly

  • Never enter a negative number

  • Archive items you're out of

  • Test void and refund behavior

Recommended Launch Checklist

  • List the items that really need counts, and leave the rest untracked.

  • Decide who receives stock at each location and how often counts are updated.

  • Decide who gets Add Inventory Entry, Burn Inventory and Override Inventory.

  • Decide whether to enter cost, and agree the process with finance.

  • Decide how stock moves between locations.

  • Enter received stock promptly, with the date and time.

  • Burn waste and expired stock with a clear reason.

  • Review the Inventory Log and valuation report on a regular day.

  • Archive items you stop selling.


Initial Missteps

While learning how to utilize Inventory Management, you may experience areas where you have questions. If you have any questions or run into issues, please keep track of them so your CivicPlus representative may address them. Please review initial missteps that are common with the implementation of Inventory Management to avoid issues when the feature is used.

Mistake

What Happens

Do This Instead

Entering unit cost

The batch cost is wrong, and so are margin and valuation.

Enter the total for the quantity.

Giving everyone Override Inventory

Counts stop being reliable.

Give it to supervisors.

Forgetting inventory is by location

Counts differ by place.

Check the location on each entry.

Assuming a void returns stock

It isn't described.

Test, and add an entry if needed.

Not fixing a wrong batch cost

Margin is wrong.

Edit Cost of Batch in the Inventory Log.