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: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 27th January 2003, 21:00
wricks's Avatar
wricks wricks is offline
Join Date: Jan 2002
Posts: 30
wricks is on a distinguished road
Baan: Baan 5b - DB: Oracle 8I - OS: Windows 2003
Question Adding a line to a Sales Order.

I am currentlly working on a project to customize tdsls4102s000 Sales order line session to assigned the Planned Delivery Date based upon inventory levels.

The users want me to be able to split the order line automatically if we do not have enough stock to fullfill the order line quantity. For example a customer would like 10 Item 1's. We have 5 in stock and another 20 coming in on a PO next friday.

I would have to change the order quantity on the current line to 5 for Planned delivery date of today and add another Sales order line for 5 next Friday.

I have never attemped to add a sales order line to an order in Baan. Normally this is a project we would stay away from, but this new feature would be a great benefit to our Customer Service department.

I have been trying to find a routine in Baan to allow me to do this easily and safely. Anybody have any experience in doing this?

Thanks for your help.
Steven G Wrick
Sr Programmer/Analyst
Wetherill Associates Inc.
Reply With Quote
Old 28th January 2003, 01:51
Paul P's Avatar
Paul P Paul P is offline
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Smile AFS?

Dear Steven,

You might want to give AFS a try. Basically AFS is BaanERP API instruction set that lets you "remotely control" BaanERP sessions. Using this, you can instruct from a customised program inside or a program outside BaanERP, for example, to open sales order line session in BaanERP, synchronise a certain line, put a new value in order qty field, save, and exit. Because it rides on BaanERP session logic, you can be sure that any data modification you make through AFS will be safe, as all the checking will also be performed.

There is a forum in this bulletin board specially catering for AFS, where a lot of members would be happy to help you with AFS should you need it

Reply With Quote
Old 28th January 2003, 02:20
donsrini's Avatar
donsrini donsrini is offline
Join Date: May 2002
Posts: 31
donsrini is on a distinguished road
Lightbulb ATP/CTP Functionality in Sales

We have implemented similar functionality for Sales, Production and Service.
We have done this in Baan 5b.
If you can tell me what Baan version you are on, I can kind of help you do this.
You can email me at
Reply With Quote
Old 28th January 2003, 13:46
wricks's Avatar
wricks wricks is offline
Join Date: Jan 2002
Posts: 30
wricks is on a distinguished road
Baan: Baan 5b - DB: Oracle 8I - OS: Windows 2003
I forgot to tell you all that we are on Baan IVc4.
Steven G Wrick
Sr Programmer/Analyst
Wetherill Associates Inc.
Reply With Quote
Old 28th January 2003, 16:33
dnnslbrwn's Avatar
dnnslbrwn dnnslbrwn is offline
Senior Member
Join Date: Jan 2003
Location: Toronto
Posts: 149
dnnslbrwn is on a distinguished road
Baan: IVc4 - DB: Informix - OS: Unix
While changing sales order lines is not easy, your requirement reduces most of the issues that you would encounter... the order quantity does not change so 'on order' does not need to be changed in the item master or the item/warehouse table.

Don't think there is anything standard, but a new session to do this should not be hard to write. I assume a new session as I would see this as a batch program to 'clean up' orders every night, but I guess this could also be attached to a button on the Sales Order line session and run in real time.

I assume you will only be doing this on records that have not been delivered at all so create a test to stop your code in that instance.

Change the quantity on the original order line to the new quantity, then just copy the record in tdsls041 to the next free position number and change the quantity to the remaining quantity and the date to the new delivery date (all of the other fields will stay the same). Next, do the same on tdsls045.

The only thing that I can think of as an additional step would be to modify the planned inventory movements table (tdinv150) to reduce the quantity of the original line and copy it as well to the new position number with the remaining quantity and date.

Oops... there is an amount field you will need to adjust as well on the sls tables.

Hope this helps.


Reply With Quote
Old 30th January 2003, 21:48
Ruskin's Avatar
Ruskin Ruskin is offline
Unconfirmed User
Join Date: Feb 2002
Location: New Zealand
Posts: 91
Ruskin is on a distinguished road
Baan: All - DB: MS-SQL, Informix, Oracle - OS: UNIX and NT Server

Dennis has the easiest idea, but if you go this way, don't forget to also include table tdsls051.

You may also have to check;

Also, the best way to check on whether the orderline can be updated, is to use the standard Baan function calls (if you have source code, check out the script tdsls4102). These calls check a heap of stuff, such as procedure masks (order status), deliveries, application locks (for other users modifying this orderline), etc...
Reply With Quote
Old 31st January 2003, 00:57
popeye's Avatar
popeye popeye is offline
Senior Member
Join Date: Oct 2001
Location: CA, USA
Posts: 149
popeye is on a distinguished road
I think AFS is a cleaner/easier solution when you want to play around with Complex sessions like Item Master/Sales ORders/ POs etc.

Advantages: - It's easy to implement
- You don't have to bother about the functionality

Please let me know if you need any docs on AFS.
I have some training material which I had created for my current client.

Hope this helps.
Reply With Quote
Old 31st January 2003, 21:06
sbakshi's Avatar
sbakshi sbakshi is offline
Junior Member
Join Date: Jan 2002
Location: USA
Posts: 24
sbakshi is on a distinguished road
Use Qkey


You can try using QKey by Fullscope. I have worked with it and we have used it extensively.

With this product, you can modify the exisiting script of SALES ORDER LINES without using source.

When user completes a line or say tabs thru the last field or clicks on SAVE button, a function can execute checking the required Order qty and if not sufficient, a second line is inserted.

Reply With Quote
Old 7th February 2003, 03:44
avpatil avpatil is offline
Join Date: Feb 2002
Posts: 720
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Splitting Sales Order Line

I some how don't like the functionality of splitting sales Order Lines. First of all if you give a future deleivry date and some how inventoty arrives before it them other sales Order will get allocations. This is some thing you need to think about it. Also if you a price grading and that too on line level, it might posses a problem. What I will suggest is creating a possible delivery schedule. I don't understand how this will customer service. POssibily you can give a delivery schedule.
Adding to sales Order line is bit cumbersome, but can be done. We don't have Baan source but use QKey Extensively.

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
Sales Order Lines manasrpadhi AFS/DDC/OLE: Function servers 2 21st September 2011 13:11
add surcharge line to a sales order lesperancer Distribution, Transportation & Warehousing 2 26th November 2003 18:59
Issue with sales order line with cost item Renegade AFS/DDC/OLE: Function servers 4 26th June 2003 18:11
Archiving of Sales Order Data kclewley Archiving & Multisite 6 21st January 2003 12:00

All times are GMT +2. The time now is 14:55.

©2001-2018 - -