Problem with UOM conversion BSFN

[Gov]

Hi,

When I am trying to calculate the quantity From UOM to TO UOM using BSFN - B4000520, it is working fine for the case 1. In case 2 ; it is not converting the quantity, eventhough we have record in F41002. Please see the following mapping and correct me if I am wrong
Case 1:

From UOM = EA
To UOM = CS
quantity = 5

F5741001. BC Business Unit -> szBranchPlant

(EA) F5741001. BC UOM -> szFromUnitOfMeasure

(CS) F4101. BC sz_UnitofMeasure_UOM1 -> szToUnitOfMeasure

(5) F5741001. BC Quanity -> mnQuantityToConvert

UNDEFINED X cInventoryInterfaceFlag

UNDEFINED X mnConversionFactorFromToPrim

UNDEFINED X mnConversionFactorFrom_to_To

UNDEFINED X mnConversionFactorTo_to_Primar

UNDEFINED X cPotencyType

(3070) F4101. Va_ShortItem_ITM <> mnShortItemNumber

UNDEFINED X cUOMByBranch

UNDEFINED X szUOMToPrimary

UNDEFINED X szUOMToSecondary

UNDEFINED X szUOMToPurchasing

UNDEFINED X szUOMToPricing

UNDEFINED X szUOMToWeight

UNDEFINED X szUOMToVolume

UNDEFINED X szUOMToShipping

UNDEFINED x -> szStandardUOMConversion

Va_CalculatedQuanity <- mnQuantityConvertedFromtoTo


Case 2:

From UOM = CS
To UOM = EA
Quantity = 5

F5741001. BC Business Unit -> szBranchPlant

(CS) F5741001. BC UOM -> szFromUnitOfMeasure

(EA) F4101. BC sz_UnitofMeasure_UOM1 -> szToUnitOfMeasure

(5) F5741001. BC Quanity -> mnQuantityToConvert

UNDEFINED X cInventoryInterfaceFlag

UNDEFINED X mnConversionFactorFromToPrim

UNDEFINED X mnConversionFactorFrom_to_To

UNDEFINED X mnConversionFactorTo_to_Primar

UNDEFINED X cPotencyType

(3070) F4101. Va_ShortItem_ITM <> mnShortItemNumber

UNDEFINED X cUOMByBranch

UNDEFINED X szUOMToPrimary

UNDEFINED X szUOMToSecondary

UNDEFINED X szUOMToPurchasing

UNDEFINED X szUOMToPricing

UNDEFINED X szUOMToWeight

UNDEFINED X szUOMToVolume

UNDEFINED X szUOMToShipping

UNDEFINED x -> szStandardUOMConversion

Va_CalculatedQuanity <- mnQuantityConvertedFromtoTo

Is there any thing to do with strcture code (USTR) in this BSFN.

Regards, Gov

 

[Gergely_Pongracz]

Hi Gov,
It looks good at the first sight. Are you sure the values mapped contained the correct values? E.g. by ER debug?
Regards:
Gergely Pongrácz
e-Best, Hungary

 

[Gov]

Hi Gergely,

I debugged the report. I found, the variables are having values. But I dont know why it is not retrieving conversion factor in second case. Any thing wrong in the mapping.

Regards, Gov

 

[Gergely_Pongracz]

Hi Gov,
Well, if you create a small (containing only entry, run of report on a small amount of data, exit) debug log (I hope you are above Xe) and mail it to me in a zip file I can have a look.
The problem may also be in the database...
Regards:
Gergely Pongrácz

 

[Gov]

Thanks Gergely. Finally I solved the issue with UOM conversion BSFN.

 

[Prathiba]

Hi,

You said you solved the issue but do not explain how. I have a similar issue, could you please give the solution details.

Thanks,
Prathibha

Oneworld XE, AS400/DB2