- This topic has 3 replies, 1 voice, and was last updated 1 year, 3 months ago by Cleo Isco.
-
AuthorPosts
-
July 11, 2023 at 2:56 pm #47538jakubGuest
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 ๐
July 12, 2023 at 12:25 am #47551Cleo IscoKeymasterHere 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.July 19, 2023 at 1:11 pm #47670JakubGuestHi 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.
July 20, 2023 at 1:22 am #47677Cleo IscoKeymasterIn 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.
-
AuthorPosts
- You must be logged in to reply to this topic.