I am writing code for finding the shortage list for multiple products. Can any help me in writing the code/logic. This is not directly available in Baan IVc4, i think.

My requirement is - In the form I will be entering the Final product code and the quantity I want to produce.

----------------------------------------

Item 1 - 1000
Item 2 - 2000
Item 3 - 3000

This is my input form
---------------------------------------

using the tables of Bom & Inventory I want to get the Shortage to produce the above Items. Levels in the Boms are around 8 to 9. I want to know the shortage of the last level item also.

The ouptput screen should be like this

----------------------------------------------------------------------------------
Inventory on Hand Shortage for Total
Item1 Item2 Item3 Requirement
------------------------------------------------------------------------------------
ItemA 2500 --- 500 3000 6000
ItemB
ItemC
"
"
"

If any one has already worked on such requirement please help me in writing the code.

Thanks in advance

Well since this post has been here a few days, it looks like nobody has done something exactly like this. I would recommend starting with one of Baan's BOM programs. Use this to see how bills are exploded, modify to loop through a series of input parts. The inventory piece could be done in the script, but I would put it in the report. That way you could total all the sub-components for the input items, then check how much is on hand and what your shortages are. Just a thought.

Good Luck!

Mark

Hi Sudhakar,

How about you write an initial technical design and someone could review it for you. Usually requests for help in writing something from A-Z would go unanswered. Show us your effort and we could fix any problems. This may not be true if the problem is so unique that it sparks interest in someone.

Mark, this was the first report I developed three years ago in the U.S. I do not have the code for it though :(.

Try the session tdinv0520m000.