lisachew
Active Member
Hello
I have a problem on data sequencing sort.
PLease refer to report R41411.
Now the report is using the F4102 as the business view and is passing all the short item number UITM to a business function - F4101 Get Item Master Information and passing back again all the UITM to the business view.
Now user wants all the item to be sorted as in printing the lowest number to the biggest item number. I have changed the data sequencing to UITM, LOC & LOT. But yet it still didnt print in ascending order.
So is there any way for me to make the business function to pass the UITM to the business view in ascending order? Please help as I am not quite familiar with the business function. Or maybe there is another cause that caused this sequencing prob?
Below is the example:
F4101 Get Item Master Information
BC Item Number - Short -> mnShortItemNumber
RV Item Number <- szPrimaryItemNumber
UNDEFINED <> szSecondItemNumber
UNDEFINED <> szThirdItemNumber
RV Description <- szDescription
UNDEFINED <> szDescriptionLine2
UNDEFINED <> szItemFlashMessage
UNDEFINED <> szPrimaryUOM
UNDEFINED <> szSecondaryUOM
UNDEFINED <> szPurchasingUOM
UNDEFINED <> szPricingUOM
UNDEFINED <> szShippingUOM
UNDEFINED <> szWeightUOM
UNDEFINED <> szVolumeUOM
UNDEFINED <> cSuppressErrorMessage
UNDEFINED <> szErrorMessageID
BC Business Unit -> szBranchPlant
UNDEFINED <> cBackOrdersAllowedYN
UNDEFINED X cStockingType
RV BPFG - Bulk/Packed Flag (wf) <- cBulkPackedFlag
RV CLEV - Inventory Cost Level (wf) <- cInventoryCostLevel
UNDEFINED <> szLineType
UNDEFINED <> cLotProcessType
UNDEFINED <> mnShelfLifeDays
UNDEFINED <> szGLClassCode
UNDEFINED <> cContractItem
UNDEFINED <> szProductionUOM
UNDEFINED <> szFromGrade
UNDEFINED <> szThruGrade
UNDEFINED <> mnFromPotency
UNDEFINED <> mnThruPotency
UNDEFINED <> cPriceLevel
UNDEFINED <> cGradePotencyPricing
UNDEFINED <> cRoundToWholeNumber
UNDEFINED <> cKitPricingMethod
UNDEFINED <> szComponentUOM
UNDEFINED <> szStandardUOMConversion
UNDEFINED <> mnBuyer
UNDEFINED <> mnPlannerNumber
UNDEFINED <> szPrintMessage
UNDEFINED <> cCommitmentMethod
UNDEFINED <> cCheckAvailability
UNDEFINED <> cSerialNumberReqsted
UNDEFINED <> cLotStatusCode
UNDEFINED <> cPurchasePriceLevel
Please advice.
Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2
I have a problem on data sequencing sort.
PLease refer to report R41411.
Now the report is using the F4102 as the business view and is passing all the short item number UITM to a business function - F4101 Get Item Master Information and passing back again all the UITM to the business view.
Now user wants all the item to be sorted as in printing the lowest number to the biggest item number. I have changed the data sequencing to UITM, LOC & LOT. But yet it still didnt print in ascending order.
So is there any way for me to make the business function to pass the UITM to the business view in ascending order? Please help as I am not quite familiar with the business function. Or maybe there is another cause that caused this sequencing prob?
Below is the example:
F4101 Get Item Master Information
BC Item Number - Short -> mnShortItemNumber
RV Item Number <- szPrimaryItemNumber
UNDEFINED <> szSecondItemNumber
UNDEFINED <> szThirdItemNumber
RV Description <- szDescription
UNDEFINED <> szDescriptionLine2
UNDEFINED <> szItemFlashMessage
UNDEFINED <> szPrimaryUOM
UNDEFINED <> szSecondaryUOM
UNDEFINED <> szPurchasingUOM
UNDEFINED <> szPricingUOM
UNDEFINED <> szShippingUOM
UNDEFINED <> szWeightUOM
UNDEFINED <> szVolumeUOM
UNDEFINED <> cSuppressErrorMessage
UNDEFINED <> szErrorMessageID
BC Business Unit -> szBranchPlant
UNDEFINED <> cBackOrdersAllowedYN
UNDEFINED X cStockingType
RV BPFG - Bulk/Packed Flag (wf) <- cBulkPackedFlag
RV CLEV - Inventory Cost Level (wf) <- cInventoryCostLevel
UNDEFINED <> szLineType
UNDEFINED <> cLotProcessType
UNDEFINED <> mnShelfLifeDays
UNDEFINED <> szGLClassCode
UNDEFINED <> cContractItem
UNDEFINED <> szProductionUOM
UNDEFINED <> szFromGrade
UNDEFINED <> szThruGrade
UNDEFINED <> mnFromPotency
UNDEFINED <> mnThruPotency
UNDEFINED <> cPriceLevel
UNDEFINED <> cGradePotencyPricing
UNDEFINED <> cRoundToWholeNumber
UNDEFINED <> cKitPricingMethod
UNDEFINED <> szComponentUOM
UNDEFINED <> szStandardUOMConversion
UNDEFINED <> mnBuyer
UNDEFINED <> mnPlannerNumber
UNDEFINED <> szPrintMessage
UNDEFINED <> cCommitmentMethod
UNDEFINED <> cCheckAvailability
UNDEFINED <> cSerialNumberReqsted
UNDEFINED <> cLotStatusCode
UNDEFINED <> cPurchasePriceLevel
Please advice.
Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2