Baanboard.com
FAQ - Sponsors - Staff

Go Back   Baanboard.com > Forum > Baan SIGs > AFS/DDC/OLE: Function servers
Reload this Page Sales order through AFS

Retirement Notice

Baanboard is shutting down on 31-dec-2023. See: http://www.baanboard.com/baanboard/showthread.php?t=76043

User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
20%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
40%
Focus on process automation/ integrations/ Real time data/ BI analytics
13%
Stick to basics
27%
Total votes: 15

Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th November 2004, 12:36
Debdas Banerjee Debdas Banerjee is offline
Member
  
Join Date: Feb 2003
Location: Mumbai
Posts: 90
Debdas Banerjee is on a distinguished road
Baan: 4c4 - DB: sql-2000/ informix - OS: Advance server / unix
Sales order through AFS
Hi All

Sorry I am reopen the the case.
I am trying to maintain a new order through AFS and I am able to maintain three step
1 ) Maintain sales order ( tdsls4101m000)
2 ) Maintain extention to sales ordre header ( tdsls101s002)
3 ) maintain sales order line ( tdsls4102s000)
4 ) Maintain extention to sales order line ( tdsls102s002)

Bur I am umabe to maintain the last one . it gives error " Extention to sales order header not exits " , where as i have checked that is maintain. Is there any relation to Extention to sales order line with extention to sales order header .

I am attaching my code , any help

Regards


Code:
function read.main.table()
{
  aa = 40
| For Order Header
	 stpapi.put.field( "tdsls4101m000", "tdsls040.orno", str$(aa))
	 stpapi.put.field( "tdsls4101m000", "tdsls040.cuno", "DA0015")
	 stpapi.insert( "tdsls4101m000", 1, error )
	|End order header

		| For Order Header extention details - ok
		  stpapi.handle.subproc( "tdsls4101m000", "tdslsl101s002", "add")	
		  stpapi.zoom.option( "tdsls4101m000",21,"tdslsl101s002", error)	
		  stpapi.continue.process( "tdslsl101s002", error )
		  stpapi.put.field( "tdslsl101s002", "tdind013.orno",str$(tdsls040.orno))
		  stpapi.insert( "tdslsl101s002", 1, error )
		  stpapi.end.session("tdslsl101s002", error)
		| End for Order header  ok
			
		| For Line details
		  stpapi.handle.subproc( "tdsls4101m000", "tdsls4102s000", "add")	
		  stpapi.continue.process( "tdsls4101m000", error )
		  stpapi.put.field( "tdsls4102s000", "tdsls041.cuno",(tdsls040.cuno))
		  stpapi.put.field( "tdsls4102s000", "tdsls041.pono",str$(1))
		  stpapi.put.field( "tdsls4102s000", "tdsls041.item","LSGPA0050AA50050")
		  stpapi.put.field( "tdsls4102s000", "tdsls041.cwar","F01")
		  stpapi.put.field( "tdsls4102s000", "tdsls041.oqua",str$(20.00))
		  stpapi.put.field( "tdsls4102s000", "tdsls041.pric",str$(200.00))
		  stpapi.insert( "tdsls4102s000", 1, error )
		  stpapi.end.session("tdsls4102s000", error)
		| end for Line details 
*************Problem area ***********not inserting data ***************************
		| For Item Line  extention details 
		  stpapi.put.field( "tdsls4102s000", "tdsls041.orno",str$(tdsls040.orno))
		  stpapi.find("tdsls4102s000",error)
       		  stpapi.handle.subproc( "tdsls4102s000", "tdslsl102s002", "add")	
		  stpapi.zoom.option( "tdsls4102s000",1,"tdslsl102s002", error)	
		  stpapi.put.field( "tdslsl102s002", "tdind017.orno",str$(tdsls040.orno))
		  stpapi.put.field( "tdslsl102s002", "tdind017.pono",str$(1))
		  stpapi.put.field( "tdslsl102s002", "tdind017.otcc","01")
		  stpapi.put.field( "tdslsl102s002", "tdsls017.otca",str$(4.00))
		  stpapi.continue.process( "tdslsl102s002", error )
		  stpapi.get.field( "tdslsl102s002", "tdsls017.otca",bb)
		  message("%s",bb)
		  stpapi.insert( "tdslsl102s002", 1, error )
		  stpapi.end.session("tdslsl102s002", error)
		| end for Line details 
		  stpapi.end.session("tdsls4101m000", error)	
		| End for Line details ok
|	endselect
}
__________________
Deb
Arise Awake & Stop not till the Goal is Reached...........Swami Vivekananda.
Last edited by mark_h : 4th November 2004 at 17:35.
Reply With Quote
  #2  
Old 4th November 2004, 17:39
mark_h's Avatar
mark_h mark_h is offline
Guru
  
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,819
mark_h will become famous soon enoughmark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Moved it to this forum and you need to check your private messages. As for this post - I am not familiar with the sessions but I wonder if closing them is causing the problem. I would put comment marks in fron of stpapi.end.session("tdsls4102s000", error), stpapi.put.field( "tdsls4102s000", "tdsls041.orno",str$(tdsls040.orno)) and the stpapi.find("tdsls4102s000",error). No promise this will work, but I though maybe by ending the session and restarting it was losing something.

Mark


Code:
function read.main.table()
{
  aa = 40
| For Order Header
	 stpapi.put.field( "tdsls4101m000", "tdsls040.orno", str$(aa))
	 stpapi.put.field( "tdsls4101m000", "tdsls040.cuno", "DA0015")
	 stpapi.insert( "tdsls4101m000", 1, error )
	|End order header

		| For Order Header extention details - ok
		  stpapi.handle.subproc( "tdsls4101m000", "tdslsl101s002", "add")	
		  stpapi.zoom.option( "tdsls4101m000",21,"tdslsl101s002", error)	
		  stpapi.continue.process( "tdslsl101s002", error )
		  stpapi.put.field( "tdslsl101s002", "tdind013.orno",str$(tdsls040.orno))
		  stpapi.insert( "tdslsl101s002", 1, error )
		  stpapi.end.session("tdslsl101s002", error)
		| End for Order header  ok
			
		| For Line details
		  stpapi.handle.subproc( "tdsls4101m000", "tdsls4102s000", "add")	
		  stpapi.continue.process( "tdsls4101m000", error )
		  stpapi.put.field( "tdsls4102s000", "tdsls041.cuno",(tdsls040.cuno))
		  stpapi.put.field( "tdsls4102s000", "tdsls041.pono",str$(1))
		  stpapi.put.field( "tdsls4102s000", "tdsls041.item","LSGPA0050AA50050")
		  stpapi.put.field( "tdsls4102s000", "tdsls041.cwar","F01")
		  stpapi.put.field( "tdsls4102s000", "tdsls041.oqua",str$(20.00))
		  stpapi.put.field( "tdsls4102s000", "tdsls041.pric",str$(200.00))
		  stpapi.insert( "tdsls4102s000", 1, error )
		|  stpapi.end.session("tdsls4102s000", error)
		| end for Line details 
*************Problem area ***********not inserting data ***************************
		| For Item Line  extention details 
		|  stpapi.put.field( "tdsls4102s000", "tdsls041.orno",str$(tdsls040.orno))
		  |stpapi.find("tdsls4102s000",error)
       		  stpapi.handle.subproc( "tdsls4102s000", "tdslsl102s002", "add")	
		  stpapi.zoom.option( "tdsls4102s000",1,"tdslsl102s002", error)	
		  stpapi.put.field( "tdslsl102s002", "tdind017.orno",str$(tdsls040.orno))
		  stpapi.put.field( "tdslsl102s002", "tdind017.pono",str$(1))
		  stpapi.put.field( "tdslsl102s002", "tdind017.otcc","01")
		  stpapi.put.field( "tdslsl102s002", "tdsls017.otca",str$(4.00))
		  stpapi.continue.process( "tdslsl102s002", error )
		  stpapi.get.field( "tdslsl102s002", "tdsls017.otca",bb)
		  message("%s",bb)
		  stpapi.insert( "tdslsl102s002", 1, error )
		  stpapi.end.session("tdslsl102s002", error)
		| end for Line details 
		  stpapi.end.session("tdsls4101m000", error)	
		| End for Line details ok
|	endselect
}
Reply With Quote
Reply

« Previous Thread | Next Thread »

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

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
AFS to update Sales Order Line Discount Percentage DStroud AFS/DDC/OLE: Function servers 4 18th March 2005 15:59
Sales Order AFS Hanging veyant AFS/DDC/OLE: Function servers 3 23rd September 2004 18:39
AFS : Create a sales Order Line for a Generic Item van_math AFS/DDC/OLE: Function servers 2 1st June 2004 15:32
Archiving of Sales Order Data kclewley Archiving & Multisite 6 21st January 2003 13:00


All times are GMT +2. The time now is 01:30.

Frontpage - Privacy Policy - Terms of Service

©2001-2023 - Baanboard.com - Baanforums.com