Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 41

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 18th May 2002, 12:28
srkallam's Avatar
srkallam srkallam is offline
Junior Member
Join Date: May 2002
Location: Secunderabad
Posts: 26
srkallam is on a distinguished road
Baan: Baan IV C4 - DB: SQL 2000 - OS: WIN 2000
Material Shortage list for multiple products

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

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

Thanks in advance
K.Sudhakara Reddy
Reply With Quote
Old 22nd May 2002, 15:22
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,178
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Starting Point...

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!

Reply With Quote
Sponsored Links
Old 22nd May 2002, 19:32
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
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 .
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Old 28th August 2007, 09:42
k_d_mahajan's Avatar
k_d_mahajan k_d_mahajan is offline
Junior Member
Join Date: Jan 2003
Location: Aurangabad-MH-INDIA
Posts: 29
k_d_mahajan is on a distinguished road
Baan: BaaN IV - DB: ORACLE 9i - OS: Windows 2003 / Windows NT 4.0
Try the session tdinv0520m000.
Kalyan D. Mahajan ( )

Cell No: 9823163246
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for BaanIVc4 Training kusaha General Discussion & Chat 8 2nd March 2006 11:53
Material surcharge frank holland Manufacturing & Supply Chain 5 10th August 2004 16:23

All times are GMT +2. The time now is 22:24.

©2001-2018 - -