i have loaded the inventory cube from 2lis_03_bx the quantity is turning up for movement type 601 but the amount is not getting reflected it is always blank.
If ( SOURCE_FIELDS-BWVORG EQ '000' "Other Issues
OR SOURCE_FIELDS-BWVORG EQ '101' "Returns / Vendor
OR SOURCE_FIELDS-BWVORG EQ '104' "Material Transfer
OR SOURCE_FIELDS-BWVORG EQ '105' "Stock Adjustment InvD
OR SOURCE_FIELDS-BWVORG EQ '106' "Stock Ajdustment Other
OR SOURCE_FIELDS-BWVORG EQ '110' )
"Issues from stock transfer
AND SOURCE_FIELDS-BWAPPLNM EQ 'MM'
only movements which are relevant for stock control
AND SOURCE_FIELDS-BWBREL EQ '1'
AND SOURCE_FIELDS-BWGEO <> 0
SEE OSS NOTE 630254
AND ( SOURCE_FIELDS-BSTTYP IS INITIAL OR
( SOURCE_FIELDS-BSTTYP CA 'EQ' AND
SOURCE_FIELDS-KZBWS CA 'AM' ) ).
*IF THE RETURNCODE IS NOTE EQUAL ZERO, THE RESULT WILL NOT BE UPDATED
RESULT = SOURCE_FIELDS-BWGEO.
and i can see for other movement type like 641 the amount is turning up.
Can anyone advise me on this