Dear All,

currently we have a standard session whina1210m000, which performs the inventory valuation and gives us a report by warehouse and Item code. we have a requirement to print the report warehouse/Item/ Lot wise.

Can any body advise and give some idea, how can I get the report by Lot.
The standard DLL used is whinadll1210. The Lot range will be given in session form.

Is the lot on the report? If so then (at least in 4c4) I can set the sort fields on the report to warehouse, item, then lot. Now if lot is not on the report that is a whole different story.

Hello there

For print the report warehouse/Item/ Lot wise, You need to do certain things

1) You need to copy the Standard Script to your Local VRC. Copy the standard Report to a different name and to your local VRC.
2) Is the Lot Number currently getting printed on the Standard Report
If No
a) you need to select the Lot Number in the query for Report field selection in the 4GL program script
b) Declare the Lot Number as an extern variable
c) In the specified report you need to declare Lot number as an Input field
d) And put a sort option on Lot Number (Either Ascending or Descending, depending on what you want)

If Yes
a)Just add the sort filter to the Lot Number in the Report Input field Session. Add ascending or Descending according to your choice.

Thanks a Lot Ajesh. for your quick reply and valuable time for posting your suggestions. The bottle neck is where to put the Lot in the query, the standard DLL used has 20000 lines of code. Its very difficult to find the point where to add this query for lot.

You can do the following

1) Copy the standard Script/Dll to your local VRC, If Possible
2) Put everything on Debug
3) Check for the clues like rprt_send, or brp.ready in the code
4) Ascertain that the Report field variables have been indeed sent through the DLL. Once that is done then
5) Put the Lot number field in that particular selection.


I always loved Debugging. ;)

And if you do not have standard session code there is another solution posted on this board where I believe you can just modify the report to include you new field. I know since we do not have source code I posted one, but I think Gunther(would have to search) posted a better solution in the Code and Utilities forum.