customization of slow moving inventory report

 

customization of slow moving inventory report

--------------------slow moving Inventory report--------------

In order to help us identify our dead inventory, we have to create slow moving inventory report. here we have to see, When was the product last sold and  The dead stock means, zero sales in the past 12 months.  Once we have defined the time of product death, we need to create a report based on this.

Identifying dead products is not an annual event. running the dead stock report on an annual basis, is not a good suggestion.  We need to be far more proactive than this.  If we employed this method, we could tack on an additional 11 months of inventory carrying cost to any items that died in February.  we need to know what died every month. so if we Make this report a part of our first day of the month routine means, it is easy to identify how much dead stock is there for every month.

this is the importance of slow moving inventory report..

coming to report, here i have taken inventory_item_id,segment1,description,item_type,creation_date columns from mtl_system_items_b and for transacations i have taken mtl_material_transactions....

common column for these two tables is inventory_item_id.

and the customization what i have did here is, i have added two columns organization_id,primary_unit_of_measure from mtl_system_items_b table and made the changes respectively in data model as well as layout model....

the process of customization is, have taken standard slow moving inventory report and renamed that report with some other name. and placed the report in server. and went to system administrator responsibility and took standard report in concurrent program, and gone through copy to button and renamed that program name and short name. and in the executable part taken report name as executable file name and saved the changes that i have made. and added this report to inventory responsibility. and did changes in the renamed report. in the data model added ,required two columns in the sql code. after adding those, i have assigned those two fields in the respective group(because if add columns in the sql code those two fields will come down to the lowest group so assigned those two fields in respective groups). and coming to layout part, selected two fields and placed it respective repeating frame and assigned source to those two fields. here have to be careful in the process of placing the fields in the repeating frame..after doing changes, compiled the report, if compilation is successful means, and placed that report in the server, and gone to inventory module and submit the request for that respective concurrent program. if the request came normal means, then taken print out for that output. if that output is error out means, seen the error in view log, again gone through report and made the changes according to that error message and saved the report. compiled. again and placed that report in the server and submitted request in the inventory responsibility, until getting the request condition as completed and normal.