• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

F41021/PBIN/Stock Status Report


Dear list,

I am trying to customize a stock status report. Among other requirements, the most important is to have on one line the primary and the secondary location along with their quantities.
The way report is printing now it is adding two lines, one for primary and the other for secondary location.

In F41021, there is a column PBIN. One row will have P for primary and second will have S for secondary. I would like a way to combine these two records/rows in one line on my report.

Would appreciate all the help I can get.


OneWorld Xe, Update 2, SQL 7.0, Windows 2000, Applied all base line ESUs



What I would do is filter the records to select only the Primary locations (there should always be one) and add some logic in the "Do section" event of the report to get the quantities for the secondary locations (there might be none or more than one). Something like:

F41021.Select(pass the Branch, Item Number and PBIN='S') to select only the secondary locations

F41021.Fetch.Next to get the quantity and pass it to a report variable on that line. (once again you might have to loop here as long as you find records in case you have several secondary locations)

Hope this helps



One World XE SP18 AS400