[jakub]

Hi

I’m trying to build report that would show all the bins last inventory date + previous inventory dates.

This is for compliance purposes to be able to track if every bin has been counted enough times within specific date range.

Any ideas how to tackle this ? 😀

Thanks 🙂

[Cleo Isco]

Here are some ideas for the steps:

– Collect inventory data: Gather the historical inventory data that includes the bin IDs and their corresponding inventory dates. Ensure you have a comprehensive dataset covering the required date range.
– Group data by bin: Organize the inventory data by bin ID to group all the inventory records for each bin together.
– Sort data by inventory date: Sort the inventory records within each bin group in descending order based on the inventory dates. This will allow you to easily identify the last inventory date and subsequent previous dates.
– Retrieve last inventory date: For each bin group, extract the first record to obtain the last inventory date. This will be the most recent date the bin was counted.
– Capture previous inventory dates: Retrieve the remaining records in the bin group to obtain the previous inventory dates. These dates will represent the previous counts of the bin.
– Generate the report: Create a report that displays the bin ID along with its last inventory date and the corresponding previous inventory dates. You can present this information in a tabular format or any other suitable format for compliance tracking purposes.

[Jakub]

Hi thanks Cleo

I’ve used LX03 to display all bins and changed layout to show last inventory date, but how to get to the historical count dates?

Also LX03 there’s no fields to specify time range.

[Cleo Isco]

In SAP, the LX03 transaction is used to display the stock situation for a particular storage type or warehouse number. It does not directly provide the option to view historical count dates or specify a time range. However, there are alternative approaches you can take to access historical count dates and filter the results based on a specific time range. Here’s how you can achieve that:

Transaction LX27: To view historical count dates, you can use the transaction code LX27. Enter the warehouse number and material or storage type, and execute the transaction. It will display a list of historical inventory documents with their respective count dates.

Inventory Management Reports: SAP provides several standard reports that allow you to analyze inventory and its history. Transaction codes like MB51 (Material Document List) or MMBE (Stock Overview) can provide historical information on inventory movements. By selecting the relevant filters and columns in these reports, you can retrieve the desired historical count dates.

[Author]

Posts