Skip to Content
-1

inventory conversion

we receive furnace oil in ton basis.GRPO is also made in Ton as also the invoice.But the physical inventory is in KL and for production issue also in KL.The experts suggested to receive in ton and goods issue it in ton.Then in another code enter manually the ton amount divided by the density(to get KL) in receipts of inventory transaction and then do the goods issue.But problem is when entering the KL quantity the price is being picked up from Ton code.

xxxxx code: furnace oil: 1 Ton:Rate 20000

after conversion with density factor of 0.985

yyyyy code :furnace oil: 1.015 KL:Rate :20000/1.015= 19704

but the rate is showing as 20000.

Please help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Dec 09, 2017 at 03:03 PM

    Hi U Bhat,

    Please check the below steps.. I am not sure I am right, but it may help you. it helps, please appreciate.

    i) Hope you need to check the UOM conversion factor in the article/ Material master. 1000 KL = 1 TON. or maintain it as per your requirement, also price should maintain in that way.

    ii) Material/Article's base UOM needs to be checked. if you are maintaining in TON then you should maintain as TON.

    iii) If you are maintaining/ converting the price in the customized code then check the UOM and convert into TON since you will maintain only in TON's.

    Regards,

    Raja.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 09, 2017 at 03:09 PM

    Sir,

    I am confused by this answer.I am only an end user.also the density changes with every truck consignment

    Regards

    Ubhat

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 09, 2017 at 03:13 PM

    Sir,

    Can a solution be arrived at like this.

    Receive in Ton in the GRPO but get converted into KL after writing suitable formula with provision to change the formula for each GRPO(because density factor keeps changing with every truck)The A/P invoice will be in Ton as usual.

    Regards

    U Bhat

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 09, 2017 at 03:25 PM

    we are using B1 9.2

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2017 at 01:21 PM

    cost of 1 ton = 20000

    1 ton = 1.015 kl ( according to yours case )

    so price of 1.015 will be 20000 only.

    you have only converted the quantity by dividing it with density factor and no where you have changed the amount, so it is obvious that 1.015kl will show 20000 only,

    what you are asking is possible but please let the person who implemented the software do that, you being an end user may not be the right person to change the process and configuration of your system

    Thanks

    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.