Stock Audit Report group by warehouse

[former_member445201]

Hi There,

When running  Stock Management > Stock Reports > Stock Audit Report, is there a way to at the result to be grouped by per Warehouse?

One of the user has this option where it is grouped by warehouse.  The rest of the user does not have the warehouse as grouped and list every transactions such as delivery note, invoices etc.

I believe this is a user settings as whenever that particular user logs onto anyother PC it is grouped by warehouse but anyone else it is not.

The image attached is how it is when grouped by warehouse.

I have looked within SAP and compared the settings from the user but to no avail.  Does anyone know how to get this setting onto other users?

[Former Member · Accepted solution]

Hi,

Could you post you first screen for this report? Even as old as 2005A version has this option.

Thanks,

Gordon

[former_member445201 · Accepted solution]

[kothandaraman_nagarajan · Accepted solution]

Hi,

The above requirement is not enabled due to initial settings of the company details. If you choose Manage item cost per warehouse then only check box will appear.

Please check under --->Administration--->System initialization--->Company details--->Basic initialization tab---> Manage item cost per ware house.

Thanks & Regards,

Nagarakan

[former_member445201 · Accepted solution]

HI,

--->Administration--->System initialization--->Company details--->Basic initialization tab---> Manage item cost per ware house - is greyed out and disabled i believe this was set up when SAP was originally installed and cannot be undone.

Found SAP article:1099094

It is strange that the account user is able to group by warehouse but the rest of the users are unable to get the same result.  We are all using the same company.

Is there no other way to get this to work as the same as the account user?

If it is not possible could you help to provide a similar report/query as the stock audit report with the same criteria?

What we require are:

1. Able to run it as at date -  meaning we could run it today for 31st March 2013, or as at any other date in the past. E.g if auditors ask me what was the stock as at 31st Dec 2012- I should be able to put the date in the report and it should give me the stock valuation as at that date.

2. Able to choose a range of products e.g. – from a0001 to g0031

3. Able to filter it using the same criteria as per audit report e.g.- item group and properties.

4. Able to choose the warehouse/warehouses we want or run it for total.

5. Include the following things in the report- Item Code, Description,  Quantity, cost per item and total value per product

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes. You are correct. Once posting done, it will be greyed.

Please close this thread and open new thread above requirements.

Thanks & Regards,

Nagarajan

[former_member445201 · Accepted solution]

Hi,

Is there no other way to get this to group by warehouse? strange one user is able to and the rest arent.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Are you working in China?

Thanks & Regards,

Nagarajan

[former_member445201 · Accepted solution]

Hi,

No i am in London UK. I saw that tread from the user about localization but could not find where that option is within SAP.  CAn you point me into the correct settings?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Are you talking about SAP note?

Thanks & Regards,

Nagarajan

[former_member445201 · Accepted solution]

Hi,

Its from this post: http://scn.sap.com/thread/2089268

[kothandaraman_nagarajan · Accepted solution]

Hi,

That's why I have asked the localization. same thing you can find under SAP help file or just right under the Manage item cost per ware house--->Choose what's this?

But you localization in UK.

Once transaction posted, you can't reverse back.

Thanks & Regards,

Nagarajan

[former_member445201 · Accepted solution]

Hi,

So how is it possible for one user to have this grouped by WHS and other cannot?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Is it under same database? if yes, the above scenario is not possible. Please post screen shot  basic initialization tab.

Thanks & Regards,

Nagarajan

[former_member445201 · Accepted solution]

hi, please find attached the screenshot as requested

[kothandaraman_nagarajan · Accepted solution]

Hi,

From the screen shot, database is by non-perpetual system.

The following option will be enabled when we use perpetual system.

1. Manage Item &Cost per Warehouse

2. U&se Purchase Accounts Posting System

3. All&ow Stock Release Without Item Cost

I don't have non-perpetual system to test above condition. But once posted, settings are irreversible. 

Further, this setting applicable to all user not for invidual user.

Thanks & Regards,

Nagarajan

[former_member445201 · Accepted solution]

Hi Naga,

Please i gather that was the case but wanted to check with the experts for second opinion.  I just found it strange that the accountant is the only one who can group by warehouse and the rest including other superusers cannot.

Thank you i will close this tread. 

[kothandaraman_nagarajan]

Hi,

Please advice your SAP version and PL.

You can select group by warehouse in selection criteria:

Thanks & Regards,

Nagarajan

[former_member445201]

Hi Nagarajan,

sorry to not mention.  I am on SAP 8.8 PL20.  I see your screenshot it must be a newer version as i do not have the option "group by warehouse".

[kothandaraman_nagarajan]

Hi,

The above screen shot from 8.82 version. it also available for version 8.8 PL10.

As said by Gordon, please post selection criteria window here.

Thanks & Regards,

Nagarajan