Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
20%
Hire more inhouse skilled & capable IT Resource to work directly with SI
30%
Rely on SI Architects/Consultants
0%
Total votes: 10

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd July 2004, 18:10
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Senior Member
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
sales order generation

hi
i am developing a session to generate sales orders in Baan Vc. But i am not able to do it. please can anybody guide me how to do it. by dll or AFS or some thing else. can i use dal.set.property functions.
regards
gaurav Gupta
Reply With Quote
  #2  
Old 26th July 2004, 09:13
Andreas's Avatar
Andreas Andreas is offline
Senior Member
 
Join Date: Nov 2001
Location: Hannover
Posts: 263
Andreas is on a distinguished road
Baan: ERP LN FP5 - DB: Oracle 10g - OS: AIX, SLES
did it with a baan dll

Hi,
as you mentioned you will do it on 5c. So have a look at the dll tdslsdll1234.
I used this one and it works great.
__________________
Jazz is not dead, it just smells funny!
F.Z.
Reply With Quote
  #3  
Old 26th July 2004, 10:53
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Senior Member
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
but dll not working

Hi Andreas
I am also trying to use the same dll but it is giving me some error. can u please suggest me how to do it in proper manner. i am new to Baan 5.
Thanks
Regards
Gaurav Gupta
Reply With Quote
  #4  
Old 26th July 2004, 14:13
Andreas's Avatar
Andreas Andreas is offline
Senior Member
 
Join Date: Nov 2001
Location: Hannover
Posts: 263
Andreas is on a distinguished road
Baan: ERP LN FP5 - DB: Oracle 10g - OS: AIX, SLES
Short description

Hi Gaurav,
try to give a short description what to do.
Before adding sales orders/lines do a call of function tdsls.dll1234.read.initial.values(), so you don't have to deal with parameter tables in your own script.
After that do a call of tdsls.dll1234.add.sales.orders for every SO-Line you want to add (you can get parameter list with bic_info).
After every SO you have to call the function dsls.dll1234.consider.additional.costs , which ends generation.
You have to commit by yourself.
In case of an error the add.sales.order function gives you a DALHOOKERROR . The error message can be checked with dal.get.error.message().
Hope this helps,
Andreas
__________________
Jazz is not dead, it just smells funny!
F.Z.
Reply With Quote
  #5  
Old 27th July 2004, 11:30
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Senior Member
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
Used the same DLL

Hi Andreas
Thanks for your valuable info. I am using the same dll. But it is throwing an error. I am attaching the error pic. and the source code.
Please suggest what to do.
Thanks
Regards
Gaurav Gupta
Attached Images
File Type: jpg err.JPG (29.7 KB, 24 views)
Attached Files
File Type: txt sales.txt (19.7 KB, 48 views)
Reply With Quote
  #6  
Old 28th July 2004, 10:28
Andreas's Avatar
Andreas Andreas is offline
Senior Member
 
Join Date: Nov 2001
Location: Hannover
Posts: 263
Andreas is on a distinguished road
Baan: ERP LN FP5 - DB: Oracle 10g - OS: AIX, SLES
Seems like error in standard

Hi Gaurav,
in my case i didn't run in this error because i'm generating SO only with cost items.
The error points to a dll that deals with item master plan (which we don't use).
I think there is something wrong with the plan or the periods.

Have you tried to copy a SO-line with your item with Baan-Session tdsls4201s000 or just insert a new SO-line with exactly the values you put in your source for the function call to tdslsdll1234?
I would first check if the problem exist in this standard sessions also.
Do you have the newest object for cprmpdll0002?

Andreas
__________________
Jazz is not dead, it just smells funny!
F.Z.
Reply With Quote
  #7  
Old 28th July 2004, 10:40
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Senior Member
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
error solved

dear Andreas
Thanks for your valuable comment. I tried using tdsls4201s000 it created the sales order sucessfully. But now i got the solution of this error it was throwing the error due to warehouse. I am selecting warehouse from item sales data. and this error was coming due to that warehouse. if i change the warehouse. problem is solved.
Thanks
Regards
Gaurav Gupta
Reply With Quote
  #8  
Old 12th January 2021, 13:02
KaasKarthik KaasKarthik is offline
Member
 
Join Date: Aug 2020
Posts: 47
KaasKarthik is on a distinguished road
Baan: 9.2 - DB: sql - OS: windows 10
is there any dll for generating or creating sales order and purchase order,
if we insert using insert and (normal assignment of field) method ,it is effective ,please help me very very urgent guys..............
waiting for reply,
thank you.....
Reply With Quote
Sponsored Links
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
Sales Order Lines manasrpadhi AFS/DDC/OLE: Function servers 2 21st September 2011 14:11
NO Transport order generated sammeer Distribution, Transportation & Warehousing 4 7th June 2003 09:02
Sales Order to Production Order hexagenia Manufacturing & Supply Chain 6 3rd April 2003 07:57
Archiving of Sales Order Data kclewley Archiving & Multisite 6 21st January 2003 13:00
Baan V 50c sp6 - Sales order generation from sales contracts mzuniga Distribution, Transportation & Warehousing 3 27th February 2002 02:21


All times are GMT +2. The time now is 09:17.


©2001-2020 - Baanboard.com - Baanforums.com