Product Reporting

Created by Aaron Eustace, Modified on Thu, 31 Jul at 5:07 AM by Michelle Armstrong

Overview


MyTBMHUB has an all-encompassing suite of detailed reports, in this section we will guide you through which reports are most useful and significant to answer product specific information and queries. 



Inventory Report

 

This report gives you access to a view of your SKU’s and their quantities. It displays how your stock levels are distributed and allocated through the various levels of the fulfilment processes. These can include:

 

Stock level - the amount of stock physically held in the warehouse

Allocated – stock that is reserved for customer orders

On hand – this is stock that is available to you once the existing orders are fulfilled from the allocated stock

Off hand – stock that is onsite but is unavailable to be ordered. It is booked into an ‘off hand location.’ This feature is only used if you have indicated to us that stock needs to be reserved.

On order – Stock that is on an open ASN due to be delivered to TBM Required by back order – stock that is required to clear open back orders

In quarantine – Stock that has been deemed faulty and cannot be sold. I.e returns/damages

 

Low stock report 

Provided you have set a low stock level alert, this report is where you will find the SKU’s that have depleted to the level of requiring replenishment.

  

Product Usage Report

This report provides a full audit trail that tracks inbound and outbound activity at a product level. Additionally, it timestamps all actions assigned to both your inbound and outbound activity. If you want to align your internal stock records with our real time updates this report is your first port of call. It can be filtered by:

 

  • In 
  • Out
  • Allocated

  

Products Expiring

Provided you have set a batch expiry date alert, this report is where you will find the SKUs that are reaching expiry. The default notifications are 28 days, but this can be adjusted at the product set up stage or adjusted at a later stage by editing the product.

 

Bundle Inventory Report

This will give you the quantity of bundles that can be processed based on the available stock levels of the component’s SKUs.

  

Missing Attribute Report

This report highlights any product attributes or information that has been missed at the product setup stage. These attributes will need to be populated as soon as possible.

 

Historic inventory report 

This report provides you with an overview of past inventory levels on a specified date.

  

Products Breakdown Report (Bundles)

This gives you visibility of the which components are assigned to each bundle. Additionally, it shows the percentage value of the components in the bundle, relative to the overall cost of said bundle.

 

Product Cartons

This report gives visibility to the information that was assigned to both inner and master cartons in the product setup stage. It will display the number of items assigned in either, as well as the associated barcodes.

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article