Data sequencing sort!

[lisachew]

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

 

[pcaenaro]

Lisa,

The Business Function has nothing to do with the
sequencing. It works item by Item (will be called 10 times
if you have 10 items on your report...).

Now, check your setting of the Data Sequence because this
should have solved your problem... make sure you run the
version for which you changed the sequence.

Hope this helps

Philippe



One World B7333 SP16 AS400

 

[lisachew]

Hello Philippe,

Thanks for your reply.

I have done as your way also. Changed the data sequencing of the report versions that I want. But then when I tried to run it again it seems to be not sorted for all the items in ascending orders.

I was wondering is there any other caused that may prevent it from sorting in the report?

Please advice.

Thanks again

Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[lisachew]

By the way my data sequencing is

Item
Location
Lot

R41411-Select Item For Counts

Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[mike_bennett]

Hello Lisa,

This could be a simple matter of sequencing on the wrong item number. The business function in the report returns the primary item number as defined in branch plant constants. Out our site we use the 2nd Item Number as our primary number. In most cases both our 2nd and short item numbers contain the same value, but not always. It could be possible, assuming a similar setup that your sequence for example on the short item number but the report is showing the second item number.

Hope this may help.

Regards

Mike Bennett

XE Sp16.1_016 Intel NT/Win2K Oracle 8I

 

[lisachew]

Hello Mike

Thanks a lot for your information, at least now I am clear on why data sequencing still cannot sort the item.

From your informatoin, I understand that you are refering to the business function below? You said that maybe my report might sort by the ITM which is right. And now I want to sort it to LITM. But when I tried changing it, like eg:
UNDEFINED <> mnShortItemNumber
BC 2nd Item Number -> szSecondItemNumber
RV Item Number <- szPrimaryItemNumber
*data sequence = litm,loc,lot

Anyway, it does not work so I assume that my way is wrong. Is there any other method of doing it or changing it. I am not too sure as I am still learning the JDE tools.

I appreciate your help very much. Thanks for your advice.

Just for you to refer ..........
F4101 Get Item Master Information
BC Item Number - Short -> mnShortItemNumber ##sort by this
RV Item Number <- szPrimaryItemNumber
UNDEFINED <> szSecondItemNumber ##can i use this to sort?
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

Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[mike_bennett]

Hi Lisa,

Just changing the data sequence would normally be enough, you would not have to change the item being passed into the business function.

I don't know if there are any other ramifications with changing the sequence on this report though, as it is not something I have had to modify.

Hopefully someone else may have some ideas.

Regards

Mike Bennett

XE Sp16.1_016 Intel NT/Win2K Oracle 8I

 

[Sharon_S]

Hi Lisa -

It sounds like you would like your report to sort on LITM instead of ITM. You can replace the ITM in the Sort Sequence with LITM for this. At first you were wanting to sort by UITM, which is not contained in any of the tables in the report's business view. I don't think you can sort by any column that is not contained in the business view since the sort order of the report is controlled by the ORDER BY clause of the SELECT statement issued to retrieve the data selected for the report. Even if you got UITM back from the business function call, the report could not be sorted in UITM order since it will be sorted in the same order in which the records are retrieved and by the time you are calling that function, that order is already in place.

I hope this helps and is not misleading. If I am wrong about this, please correct me.

Best Wishes,

Sharon
B733.1\SP7.1\Oracle 8.0.5\Ent HP-UX 11.0
Upgrading to XE\SP15.1\U3