Stock Adjustments.

Former Member · ‎11-20-2007

Hi...

I am in a scenario where i recieve a Sales Order for a Product ( Combo PacK) hardly once in a month and this combo pack has two products in it which we use to sell seperately till now. So this process is mainly of SD but the Inventory has to be taken care by MM....Our Plant is only a distribution centre( No Prodcution takes Place) where we combine this two prodcuts and sell it. Can anyone please

explain how can i track the inventory of GR of the Finished Product and GI of the

Components.

Cheers

Rob

Former Member · ‎11-20-2007

Hi,

Do my favorite subcontracting pO process.

Create a BOM in CS01 for 3rd FG. Usage must be either Production or Universal.

Release the bom in its header. Status Released for Production!!

Now, setup a Subcontracting PO for the 3rd finished product. Create a Vendor for your own company. Setup service charges to repack. Ignore if you don't want.

(Free Item should be selected in PO if you don't want processing fee to be shown)

Process component supply (2 little FGs) via 541 mvt type to S/C vendor

Process gR in MIGO for the finished product using the subcontracting PO.

Financials will go perfectly

FG stock and value increases for 3rd FG

First 2 FGs will reduce stock and total value from inventory.

3rd FG is available in the plant ready to sell.

process your Sales order as you wish.

-

Alternatively, create a production order (or process order if its PP/PI) to complete production of 3rd FG. Confirmthe Prod Order. 3rd FG comes to stock.. Financials go perfect ...no hastles.....You can sell it as usual.

This requires implementation of PP or PP/PI module

The first option can be easily implemented with out the use of PP/PI module. Costing goes perfectly in this as well. This is most preferred in a case where you get repacking done in copackers (vendors) or 3rd party vendor sites. We do this extensively. Of course, the second option is also used in our own plants when we manufacture.

Good luck

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 8, 2007 4:08 PM in response to: Gopala Turaga Reply E-mail this post

Hi Boss....

Thanks for the Efforts & Time ...Since i was clueless.

Awesome Boss.....I will try with the two options & Update u ASAP , we have PP Module implemented. Do u have any Process doc u prepared for this, if anything can u please send it to my mail id..balaji_genupur@yahoo.com.

What do u think personally PP is better or MM better, I dont gave a great knowledge on Inventory....

Waiting for ur reply

Regards

Balaji

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 8, 2007 4:14 PM in response to: Gopala Turaga Reply E-mail this post

Hi Boss..

What does Release the BOM in Header Means???

How i shd do it ??

Regards

Balaji

Gopala Turaga

Posts: 423

Questions: 10

Registered: 6/5/06

Forum points: 698

Re: Inventory - Needed Help

Posted: Nov 8, 2007 4:19 PM in response to: Balaji Genupur Reply E-mail this post

Hi,

Thanks for the satisfaction expressed from the solutions provided.

If PP is already implemented, now, call your counter parts for a meeting.

Present your options. You will mainly focus on subcontracting process.

Advantage out of this is, simple to workout. Especially, if vendors are involved, where is the question of implementing our PP module in their systems? Its just not possible. Then, left over is the famous subcontracting stuff.

If repacking happens only in the company facilities, and if PP wants to do it, it has advantages: Activity costing, work centers setup, exact scheduling, routing etc can be used which will help streamlining Production facilities. Availability check for SD can be integrated via TOR to PP module. That will help SD guys to commit to customers correctly. Also product costing (both planned and actual) can be measured. After revenue generation from AR via SD billing for the PGI'ed quantity of Deliveries created in LE, the data can be transmitted to CO-PA module to arrive at profitability. That allows them to measure their standard costs for raw materials and activity costs to be renewed time and again if they are far away from reality. Materials procurement can plan better to cater to the requirements of manufacturing (PP) via MRP and buyers can pay attention to strategic procurements ratther than pencils and erasers. In turn, entire Supply Chain management can get optimized; the result is long term benefits via productivity improments, no stock out situation, customer satisfaction, perfect deliverability at every step etc.....huh...=let me take a break! your question really inspired me.....

Regads

Gopala Turaga

Posts: 423

Questions: 10

Registered: 6/5/06

Forum points: 698

Re: Inventory - Needed Help

Posted: Nov 8, 2007 4:20 PM in response to: Balaji Genupur Reply E-mail this post

Hi

In CS02, click our famous TOPI (hat) to go to header details. You will automatically guide your self then what is meant by "Releasing" the BOM (status)

Regards

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 8, 2007 8:56 PM in response to: Gopala Turaga Reply E-mail this post

Hi Boss..

If i am using PP then , GI for the Production Order has be done and then GR is done for the Finished Product .What are movement types involved for GI against Production Order ( Here Backflush Comes into Picture right??).....Is it possible for u write the sequence in steps involved...Sorry to Trouble,,,jus to make things clear and not to screw up........

If vendor is our own plant then ...just we have to define the Plant as a Vendor,,,Thats it right ??

This scenario seems to be a Cake Walk for u ...Hope i need to borrow some cake from you...._:) to fullfill my client Stomach _:) and offcourse me ....

thanks for the efforts......

Regards

Balaji

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 8, 2007 11:04 PM in response to: Gopala Turaga Reply E-mail this post

Hi ...

We have a Plant( its just a Repacking Facility ) no Production takes place. Sorry for the wrong info in the previous messages. Jus one Plant now i have FG A & FG B and i as to repack it to FG C. Now can i define my own plant as vendor where

GI also takes place???? and this is the Plant where the GR also Takes Place...

or there is any other soln ...hope i am clear with u ..if not let me know..

Keeping hopes on u ...

Regards

Balaji

Gopala Turaga

Posts: 423

Questions: 10

Registered: 6/5/06

Forum points: 698

Re: Inventory - Needed Help

Posted: Nov 9, 2007 3:16 AM in response to: Balaji Genupur Reply E-mail this post

Hi,

Yes, if PP module is not required, the subcontracting process that I explained perfectly works. So, on the name of the plant, you will have a Vendor number created...This vendor master is as good as any other external vendor for the plant. Remaining is exactly as I explained earlier.

All you can present as it is.

Your potential questions will be:

1) from FI folks....

.....we want to track the repack processing fee....how can we do this?

.....You can setup an info record for subcontracting process for this vendor on the same plant, porg, PB00 pricing condition say $ 2.00 per pack

CO guy will coordinate with you to create a condition type that passes statistically the processing fee to CO-PA.

This info record is the only source for standard cost estimate (product costing)

Don't worry much in this....They will work with you. In case you need help, I am there

2) Usage Variance report will be asked....

Let them explain to you...I don't want to confuse you with our business process

3) Can I have the flexibility to consume different components than actually planned in the BOM?

Yes and No.

Yes - if properly PrePlanned for the right mix of components at the time of PO creation itself.

No- once a GR processing is completed for the PO line item. Meaning, once partial receipt is done, components can not be changed....Of course, I have remedy for this also.,...when needed, I will let you know

4) At the time of GR, can I change the component qtities...

Yes

5) At the time of GR can I make some components consumption totally as zeros

Yes

6) At the time of gR, I don't know what components were consumed because, my vendor gives only after the delivry. So, can I post components totally zero and post process the component consumption and update the PO appropriately?

Yes

7) Invoice process -...fool proof

😎 Can I substitue components? Yes via PO

Now, you can attack on them...

Good Luck

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 9, 2007 3:26 PM in response to: Gopala Turaga Reply E-mail this post

Hi..

Awesome answers ...i am totallly depending on u .....As u said....

1. Vendor Master created.

2. Material Master Created.

3. BOM created.

4. Source List Created.

5. Info Record Created .

6. Now i created a PO with Item Category L ....am i right ?i can see the BOM Components in the PO when i click the Icon.

7. NOw i went to do a GI for this Purchase Order and the error i get is Purchase Order Contains no item for Stock Transfer.??? Whether i have to create a PO with doc type UB ??? Since reciveing & supplying in the same Plant ?????We had created a Plant Vendor right ?????.....I am confused here ..waiting for ur reply...meanwhile i will try to proceed ....But u have to help me out boss..........

I am learning a new things because of you ...Happy for it .....

Regards

Balaji

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 9, 2007 3:31 PM in response to: Gopala Turaga Reply E-mail this post

Hi ..

That error is gone ,,,,transaction erro done by me,,,,,

Say first i have to do a GR 101 & then 541 for GI right????

when i try to do GR now i get a msg No special stock O of the material (batch ) exists in storage location for 0002001010 913700605572.

REgards

Balaji

Csaba Szommer

Posts: 343

Questions: 22

Registered: 5/8/07

Forum points: 390

Re: Inventory - Needed Help

Posted: Nov 9, 2007 3:39 PM in response to: Balaji Genupur Reply E-mail this post

Hi Balaji,

As I understand your process is:

materialA + materialB > materialC

Why don't you issue PrdOrd for materialC? Are you using PP modul? If yes I think it would be very natural...

Does the WH staff pack the goods?

Thanks,

Csaba

Gopala Turaga

Posts: 423

Questions: 10

Registered: 6/5/06

Forum points: 698

Re: Inventory - Needed Help

Posted: Nov 9, 2007 3:39 PM in response to: Balaji Genupur Reply E-mail this post

Hi Balaji,

Good to hear from you that you could use my inputs...

Up to 6 what you did is pefect..

7. NOw i went to do a GI for this Purchase Order and the error i get is Purchase Order Contains no item for Stock Transfer.??? Whether i have to create a PO with doc type UB ??? Since reciveing & supplying in the same Plant ?????We had created a Plant Vendor right ?????.....I am confused here ..waiting for ur reply...meanwhile i will try to proceed ....But u have to help me out boss..........

...

Answer: This step what you did is wrong. PO first of all should have blank account assignment category..Also, if you have put U, in the item category, remove it and Put L.

Now, you should supply components required for manufacturing the finished product to vendor via MB1B transaction, (you may do in MIGO also...)..

For simplicity, go with this.

Use Mvt type 541. You will enter the Vendor# (the same as PO vendor)

Move atleast the quantity that you had entered in the PO components overview. First make the required unrestricted quantity for each components available by using say 561 mvt type into the plant (via mb1C).

After doing this, you will simply receive using the PO 101 mvt. Nothing to issue. Start differentiating the terms issueing and transfer posting. You are now a consultant.

Regards

Balaji Genupur

Posts: 112

Questions: 30

Registered: 6/20/07

Forum points: 28

Re: Inventory - Needed Help

Posted: Nov 9, 2007 3:47 PM in response to: Csaba Szommer Reply E-mail this post

Hi ...

Yes , but our Plant is just a repacking facility.

1 FG A + 1 FG B ( 2 materials ) = 1 FG C ( 1 Material )...

After i got the above error i went to Me2o from there i see the two Component Materials and issued the Goods and then i did a GR for the FG C. But for FG C i see MVT 101 but FG A & FG B i see the MVT543 which is GI against sales order stock.....but to above mails i saw it shd be 541????...

Whats happening here???? But beleive me its really interseting .....

Regards

Balaji

Csaba Szommer

Posts: 343

Questions: 22

Registered: 5/8/07

Forum points: 390

Re: Inventory - Needed Help

Posted: Nov 9, 2007 4:02 PM in response to: Balaji Genupur Reply E-mail this post

Hi,

I think you can use PrdORd for repackaging activities as well - but of course the decision is in your hand.

(I think it's more natural than Purchase orders within a plant.)

BR

Csaba

Pages: 2 [ 1 2 | Next ] Back to Thread List

Former Member · ‎11-20-2007

Hi

You are purchasing two materials basically & selling them as a combo for specific requirements.

So for the two materials GR's are made seperatley. so the inward movement can be tracked.

When selling them as Combo, you can create a Sales BOM for the materials & sell them as a combo. so at the time of delivery the stock gets deducted in both the materials. In this way you can keep a trcak of the Goods issues also.

Reward points if useful

Thanks & Regards

Kishore

Stock Adjustments.

Accepted Solutions (0)

Answers (2)

Answers (2)

Re: Stock Transfer between two EWM Managed plants ...

Re: Production Schedule Gantt Chart

Re: Sales analysis report query

Link TaxGL with book GL

Re: Use of Sequence into SAP B1 / SAP Business One