praveenk
Member
Hi all,
I am new to JDE.I stuck up with one UBE,
Purpose of UBE:
• To review cancelled parent items (kit items) in the Sales Order Detail (F4211) file and make sure that all of the component lines have been cancelled. If lines are found that are still at an open status, these lines should be cancelled. This cancellation process will include writing a record to the Sales Ledger file (F42199). The only lines to be updated will be those that need to be cancelled. In other words, no updates will be processed to the F4211 or F42199 files unless a line needs to be cancelled. This UBE should generate a report showing those items that will be changed. (This should be the Parent item and any child item)
In report initialize section i have given conditions as
• Select from the F4211 file where SDCOMM = ‘K’ (these are the parent items)
• Where SDCNDJ is in the given date range that is specified by a processing option. If no date range is given, default to today
• And SDLTTR = ‘980’ or ‘984’
• And SDNXTR = ‘999’
and in DO section i used
F4211.Select
F4211.Fetch Next to read component lines
Logic
• The program should look at all cancelled kit parent lines that have been selected in the data selection.
• Use the kit related fields to determine which lines are related to each other. If the component line’s next status is not equal to ‘999’, then cancel the component line.
o In the F4211, the kit related fields are as follows:
SDRLIT = The Short Item Number (SDITM) of the parent line.
SDKTLN = The Line Number of the Parent item.
But i am not getting correct output.
Output
• The report should show the parent item and the associated related lines being cancelled.
Can any one help me out in this issue.
Thanks,
Praveen.
I am new to JDE.I stuck up with one UBE,
Purpose of UBE:
• To review cancelled parent items (kit items) in the Sales Order Detail (F4211) file and make sure that all of the component lines have been cancelled. If lines are found that are still at an open status, these lines should be cancelled. This cancellation process will include writing a record to the Sales Ledger file (F42199). The only lines to be updated will be those that need to be cancelled. In other words, no updates will be processed to the F4211 or F42199 files unless a line needs to be cancelled. This UBE should generate a report showing those items that will be changed. (This should be the Parent item and any child item)
In report initialize section i have given conditions as
• Select from the F4211 file where SDCOMM = ‘K’ (these are the parent items)
• Where SDCNDJ is in the given date range that is specified by a processing option. If no date range is given, default to today
• And SDLTTR = ‘980’ or ‘984’
• And SDNXTR = ‘999’
and in DO section i used
F4211.Select
F4211.Fetch Next to read component lines
Logic
• The program should look at all cancelled kit parent lines that have been selected in the data selection.
• Use the kit related fields to determine which lines are related to each other. If the component line’s next status is not equal to ‘999’, then cancel the component line.
o In the F4211, the kit related fields are as follows:
SDRLIT = The Short Item Number (SDITM) of the parent line.
SDKTLN = The Line Number of the Parent item.
But i am not getting correct output.
Output
• The report should show the parent item and the associated related lines being cancelled.
Can any one help me out in this issue.
Thanks,
Praveen.