Skip to Content

Goods movement with dynamic UoM

Hi,

We have a requirement as follows -

For the material Pipe. Purchase Order Unit is Meter (M). Base Unit of Measure is Joint (JT). The approximate relation is 1JT= 10M. However this may vary on every Goods Receipt.

During first Goods Receipt supplier may send 700M of Pipe in 68 JTs, Therefore the relation becomes 1JT = 10.29 M. During second goods receipt supplier may send 300M of Pipe in 31JTs. Therefore the relation becomes 1JT = 9.68. This is just an example. The supplier sent pipe length and the number of joints may vary every time and therefore the relation between JT and M may change upon every Goods Receipt.

Question is how, without Batch Management or applying Batch Specific UoM criteria, we can achieve this functionality i.e. on GR screen we can put in the pipe length and number of joints and the relation will be calculated based on that automatically? i.e. we need to achieve dynamic conversion between Base UoM and PO UoM?

Any help will be appreciated.

Thanks,

Amit

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 17, 2014 at 04:22 PM

    Hi,

    If there is dynamic conversion factors irrespective of batch, then there will be inconsistency in the stock. System wont be able to store the dynamic conversion factor against a specific lot and system cant convert the stock between different UOM's.

    As of my knowledge, there is no option other than batch specific UOM.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

    • This has never been possible with batch management, since the valuation type is just a field in the batch record, And as it is just one field you cannot have a part of this batch with a different valuation type.

      you need another batch and move the stock from old batch to new batch with 311 movement type.

  • Posted on Jul 18, 2014 at 05:57 AM

    If you do not want to use batch specific uom or even batch management.

    Then you can purchase the material as per your requirement but you can't segregate the stock.

    Suppose you purchase the material first time.

    700M of Pipe in 68 JT. Here you conversion is 1 JT = 10.29 M.

    You can use the conversion in either info record or in material master (If you are using info record then it will be the first prior).

    You have done GR, your stock will be updated as per your base unit of measure. So your stock will be

    700M.

    Now you purchase the material for second time.

    300M of Pipe in 31JT. Here your conversion is 1 JT = 9.68 M.

    At that time you have to change the conversion in either info record or in material master - unit of measure (If you are using info record then it will be the first prior).

    You have done GR, your stock will be updated as per your base unit of measure. So your stock is updated for 300M.

    Now your stock will be 700+300 = 1000M.

    Here is the problem, when you will go MMBE or MB52 to check the stock, your system will show you only 1000M quantity. You can't find how many quantity was purchased with which conversion. You have to look into the PO for this.

    Your wrote, You can achieve the functionality if you can enter the conversion at the time of GR (in MIGO), Then why not in info record or material master.

    When you have to use the conversion 1 JT = 10.29 M, then you can maintain the conversion in info record or material master, then when you will go for PO creation, system will take the conversion automatically.

    After that, when you need to purchase the material with conversion 1 JT = 9.68 M, before PO creation, just go to info record or material master and change the conversion. Then create PO, system will take the conversion automatically.

    Test the scenario and revert back if any issue.

    I've tested the same in my system, it has worked properly.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 18, 2014 at 07:11 AM

    Thanks AKPT, Dev and Jurgen for all the helps you did.

    I shall try to apply the suggestions and try to see if that helps. However, I got some idea from the discussions.

    Thanks again.

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.