Stock quantity Domestic-Import without Split Valuation

[Former Member]

HI

Is there a way to find out the stock quantity which were procured from domestic as well as Import sources. I need to set the configs accordingly. I do not want to use split valuation.

Regards

[Former Member · Accepted solution]

Hi,

One suggestion, activate batch management and maintain some logic for domestic procurement and import procurement for e..g. domestic batch will start with D1234 and Import batch will start from I1234 at the time of GR, so that you can identify the stock.

Pl. try

Regards,

Vikas

[Former Member · Accepted solution]

Thanks Manish & Vikas for the replies

I will not be able to go for two different codes for the same material and at the same time I wish to have the opening stock and closing stock quantity i.e i wish to use the MB5B report also. My users are completely novice and I definitley would like to leave a system config for which they will not find it difficult to maintain afterwards I mean it has to be very very simple so that a lay user without much effort should be able to take out the report and maintain the materials whenever required.

Segregating during GR is also a option but again it is an extra entry and the user has to remember the details for Domestic and Import before posting.

Different Vendor account grouping will not solve my issue

Any more suggestions experts

Regards

Edited by: samuel mendis on Jun 16, 2009 10:33 AM

[murugan_mgl · Accepted solution]

HI,

Why dont u create two storage locations one for import & other for domestic.U can receive the material based on the vendor and generate a report.

murugan

[Former Member · Accepted solution]

Hi guys

If I somehow convince the client and go for Split valuation, how does it affect the BOM as the same material is procured domestically/Imported and Produced in_house also. Does BOM has facility of assigning Valuated type init so that I can create a valuatiion type In_house and proceed. Ultimately my aim is to have stock viewing at all levels for all the three categories any time.

Regards

[Former Member · Accepted solution]

Hi,

If you go for split valuiation, there will be only one code which will reflect in BOM...as far as Stock is considered you can see the same based on Batch also and based on valuation type thru MM03

Regards,

Vikas

[former_member433442]

Hi,

If you are using different purchasing groups for import and domestic procurement, then you can get the stock list based on purchasing group in MB52.

Regards,

Prabu

[Former Member]

Hi,

If you don't want to use split valuation then you have to create two different material code for same material to find out the stock quantity which were procured from domestic and Import sources.

OR you can configure two different vendor account group to track,but in this case you will not be able to see the present imported stock and domestic stock

[former_member212745]

If you are using two different Vendor account groups for local vendor and import vendor, then you can easily find the GR list from these two vendors using MB51.