Cycle count T code LX 17

[Former Member]

Hello Gurus

In the Inventory cycle process when I am executing T code LX 17 For viewing the inventory differences , it is showing me the Relative difference in % between the quantity counted and the book amount in the inventory procedure. Now what I would like to see is the Difference in Dollar amounts. Is there a way we can do, by which we can see inventory differences by dollar amounts and not by %.

I am entering following details in LX17 screen

Warehouse number

storage type

Storage bin

I would really appreciate if someone can look into it and give me some valuable suggestions.

Thanks

Regards

Nishant

[Former Member]

I got the issue resolved.The standard SAP T code was not the solution what I was looking for.

Had to create a custom program for it.Anyways thanks everyone for looking over. I am closing the thread.

Thanks

Regards

Nishant

[Former Member]

In LX17, give value in field variance instead of percentage in the selection screen and try

[Former Member]

Hello Vineet

Thanks for your reply.

I tried entering it as variance but still the system is not showing me the difference.

Is there any other T code in WM we can see the list of difference value wise or in $ amounts because

Dollar amounts gives us a better picture , that where are we. Is it something to do with the layout tab at the bottom of LX 17.

Regards

Nishant

[Former Member]

In the output of the report , select the proper layout and search for the differnce amount field and change the output layout.

[Former Member]

Hi vineet

Thanks for your reply.

The client has /Z layout for the LX17, so do we have to add in the field for the difference or how would we

make it work. Or would generating a Query be a better option.

Thanks

Regards

Nishant

[Former Member]

In the output of report , goto change layout ...all the possible fields can be displayed from there, search for the value field if it is there if not do a modification in the report and add the value column with proper logic.

[Former Member]

Hi Vineet

I tried changing the Output format by applying a filter and then saving the format but after executing the transaction again the system shows no data available.Well that surprises me because with the same inputs I am able to default format but not the new one.

Moreover would it possible to see difference between Putaway Qty & Available Qty( After the cycle count). I tried using LX23 but again It shows no data available.

Thanks

Nishant

[Former Member]

Hello Vineet

I got the issue resolved.The standard SAP T code was not the solution what I was looking for.

Had to create a custom program for it.Anyways thanks for looking over. I am closing the thread.

Thanks

Regards

Nishant