Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th May 2002, 11: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
ItemB
ItemC
"
"
"

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

Thanks in advance
__________________
K.Sudhakara Reddy
Wipro
Reply With Quote
Sponsored Links
  #2  
Old 22nd May 2002, 14:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
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!

Mark
Reply With Quote
  #3  
Old 22nd May 2002, 18:32
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
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
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
  #4  
Old 28th August 2007, 08: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
E-mails: kalyanmahajan@indiatimes.com
k_d_mahajan2000@yahoo.com
Reply With Quote
Reply


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 10:53
Material surcharge frank holland Manufacturing & Supply Chain 5 10th August 2004 15:23


All times are GMT +2. The time now is 03:45.


©2001-2017 - Baanboard.com - Baanforums.com