UOM Conversion

[BOLTIE]

HI

I have a Purchase order for a item where the Items Primary Unit of measure is MM and Purchase order UOM iS KG .

I calulate the quantity converted to primary using the F41002 Get Item UOM Conversion . After this quantity is convereted to Primary UOM which is MM ,I insert to a customised table , Now this values is stored in the customised table in MM , now there is another report which uses this value to update smething in JDE at that point of time I want to Convert the quantity back from MM to KG

As of Now i pass the following

F41002 Get Item UoM Conversion
BC Business Unit (F43121) -> szBranchPlant
VA rpt_szPrimUnitofMes_UOM -> szFromUnitOfMeasure
(This is MM)
BC Unit of Measure as Input (F43092) -> szToUnitOfMeasure
(This is KG)
VA rpt_mnQuantityMoved_QTYM -> mnQuantityToConvert
VA rpt_mnConvertedQuantity_QTYM <- mnQuantityConvertedToPrimary
Bc Item No Short -> mn ItemNoshort

This is going wrong what parameters shud i pass to get the inverse conversion # which is from MM to KG as primary UOM is MM

Regards#
Bolton
E8.11

 

[Imran]

Hi Bolton,

Use this parameters to get the conversion value:

F41002 Get Item UoM Conversion
BC Business Unit (F43121) -> szBranchPlant
VA rpt_szUnitOfMeasurePur3_UOM3 -> szFromUnitOfMeasure
VA rpt_szUnitOfMeasureF4101_UOM -> szToUnitOfMeasure
VA rpt_mnF41002ConverFactor_CONV <- mnConversionFactorFromToPrim
BC Item Number - Short (F43121) -> mnShortItemNumber

For any reference, feel free to let me know.

 

[BOLTIE]

Hi Imran

Thanks but isnt there any business function which will give me the quantity converted in the inverse way .

As per your logic it will give me the conversion factor and then I will have to multiply that with the quantity but then I will also have to face rounding issues.

Just chking if there is any Standard business function which does this already for us.

Thanks Again

 

[peter_hamilton]

You almost have it correct, but you are using the wrong return value.
You are asking for the qty in primary, but you already start in qty at
primary. That is why it isn't working.
There is another return parameter calling qtyconvertedfromto (or
something like that) and this will give you the answer you are looking
for.

Also, when using this BSFN, if the primary uom is known, you should
ALWAYS pass this in (into the primary uom parameter) as if you don't
pass it in, then the BSFN goes and reads the F4101 to get it (which is a
waste of time/io if its already known).

Cheers,

 

[Imran]

Hi Boltie,

I think Peter has already given u the solution, just to pass all the correct parameters and get the parameters.


Imran Shaikh
9819234677 (Mob)

 

[BOLTIE]

HI

Thanks both of you I used the quantity converted from to To but the issues is the value is given in decimals if the values has to be converted to 78 it will give you 77.7999 something like this then I guess we will have to use the rounding function in expression but again how many decimals , doesnt this standard business function do it by itself.

Thanks Bolton