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.
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.
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).
REMEMBER: The account ID number is essential for the report to show data relevant to your specific account.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.
Set the account_id parameter to your specific account ID number to view stock data for that account.
Yes, you can add additional parameters and variables to refine the report based on your needs.
The report will display available stock items based on their sell-by dates, helping you track stock expiration.
Yes, once saved, the report can be scheduled to run automatically at your chosen frequency.
Yes, by adding more account_id variables, you can run the report for multiple accounts if necessary.