How can I see Available Stock in Sell By Date Report in Clarus WMS?

How can I see Available Stock in Sell By Date Report in Clarus WMS?

How to Set Up an Available Stock in Sell By Date Report

This guide explains how to set up an Available Stock in Sell By Date Report in Clarus WMS. You can customise the report with variables that suit your business requirements, helping you track stock expiration dates effectively.


Step-by-Step Guide

1. Schedule a New Report

Begin by setting up a Scheduled Report as detailed in a previous article. In the Reports section, click +Add Report. From the dropdown menu, search for Available Stock in Sell By Date.

2. Add Parameters and Variables

For the Account ID parameter: Select account_id as the Parameter Name. Then, for the Variable Value, enter your account ID number (e.g., 1).

AlertREMEMBER: The account ID number is essential for the report to show data relevant to your specific account.

3. Save the Report

Once you have entered the account_id variable, click Save. The report will now display the available stock with sell-by dates for the specified account.


FAQs

How do I customise the report for my account?

Set the account_id parameter to your specific account ID number to view stock data for that account.

Can I add more variables to the report?

Yes, you can add additional parameters and variables to refine the report based on your needs.

How is the data organised in this report?

The report will display available stock items based on their sell-by dates, helping you track stock expiration.

Can I schedule this report to run regularly?

Yes, once saved, the report can be scheduled to run automatically at your chosen frequency.

Can I generate reports for multiple accounts?

Yes, by adding more account_id variables, you can run the report for multiple accounts if necessary.


    • Related Articles

    • What is the Stock Balance Data Grid in Clarus WMS?

      Stock Balance Screen The Stock Balance screen in Clarus WMS helps you manage your inventory effectively. It provides a detailed overview of your stock levels across different warehouses, showing what's currently available, what's been allocated, and ...
    • How do I transfer stock or pallets in Clarus WMS?

      Easily Transfer Stock and Pallets Clarus WMS simplifies moving stock or pallets between warehouses or locations. This guide explains how to perform both internal stock moves and transfers between different warehouses. Step-by-Step Guide 1. Access the ...
    • How do I set up a Goods Out Transaction Report in Clarus WMS?

      Setting Up a Goods Out Transaction Report This guide explains how to set up and customise a Goods Out Transaction Report in Clarus WMS. By following these clear steps, you can create a report that provides relevant insights for your business. ...
    • How can I troubleshoot sales orders that won't allocate to a pick in Clarus WMS?

      Troubleshooting Stock Allocation for Sales Orders If you are struggling to allocate stock to a pick for a sales order, this guide offers a clear checklist to help you identify and resolve common issues, ensuring smooth order fulfilment. Step-by-Step ...
    • How do I remove a Scheduled Report in Clarus WMS?

      How to Remove or Delete a Scheduled Report This article provides a simple guide on how to remove individual reports from a schedule or delete an entire scheduled report in Clarus WMS. Follow these straightforward steps to manage your scheduled ...