Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > AFS/DDC/OLE: Function servers

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
0%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
100%
Focus on process automation/ integrations/ Real time data/ BI analytics
0%
Stick to basics
0%
Total votes: 1

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #16  
Old 16th December 2020, 14:51
KaasKarthik KaasKarthik is offline
Member
 
Join Date: Aug 2020
Posts: 65
KaasKarthik is on a distinguished road
Baan: 9.2 - DB: sql - OS: windows 10
Smile reply

even though the dal was easy ,
but our task is to do with wrapper script ,but the dal type seems to be easy.


thank you for your reply..
Reply With Quote
  #17  
Old 17th December 2020, 11:52
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 246
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
hi,
you can view the error details in the server log to see what 314 means in your db, this might have some overflow values. if your not using dal.new.object you need to read manually in the script the last number in tcmcs050 and plus 1 after saving your sales order.
regards,
Reply With Quote
Sponsored Links
  #18  
Old 27th December 2020, 08:36
Predator Predator is offline
Senior Member
 
Join Date: Apr 2005
Posts: 100
Predator is on a distinguished road
Baan: Baan5 - DB: MSSQL2000 - OS: Windows Advance Server 2000
Hi

Hi,

I have the AFS, please PM me.

TQ
Reply With Quote
  #19  
Old 17th September 2022, 10:15
vk1971bhardwaj vk1971bhardwaj is offline
Junior Member
 
Join Date: Mar 2013
Posts: 4
vk1971bhardwaj is on a distinguished road
Baan: BaaN C4/LN infor 10 - DB: oracle - OS: Window Nt
SALE ORDER Line in Infor LN through AFS

Successfully created line and Approved same through AFS

function create.so.lines()
{
domain tcorno orno.f
string pono.f(4)
stpapi.put.field("tdsls4101m000","tdsls401.orno", str$(tdmfc503.orno))

ret = stpapi.find("tdsls4101m000", err.msg)
if isspace(err.msg) then
ret = stpapi.mark("tdsls4101m000", err.msg)
ret = stpapi.synchronize.dialog("tdsls4101m000", "add", err.msg)
if isspace(err.msg) then
stpapi.put.field("tdsls4101m000","tdsls401.orno", str$(tdmfc503.orno))
stpapi.put.field("tdsls4101m000","tdsls401.pono", str$(10))
stpapi.put.field("tdsls4101m000","tdsls401.seqn", str$(0))
stpapi.put.field("tdsls4101m000","tdsls401.cwar", str$(sel.cwar))
stpapi.put.field( "tdsls4101m000", "tdsls401.item.segment.1", "" )
stpapi.put.field( "tdsls4101m000", "tdsls401.item.segment.2", tdmfc501.item(10;38))
stpapi.put.field("tdsls4101m000","tdsls401.ofbp", str$(tdmfc503.bpid))
stpapi.put.field("tdsls4101m000","tdsls401.qoor", str$(tdmfc503.bags))
stpapi.put.field("tdsls4101m000","tdsls401.cuqs", str$(tdmfc506.cuni))
stpapi.put.field("tdsls4101m000","tdsls401.pric", str$(tdmfc501.pric))
stpapi.put.field("tdsls4101m000","tdsls401.ddta", str$(utc.num()))
stpapi.put.field("tdsls4101m000","tdsls401.rdta", str$(utc.num()))
stpapi.put.field("tdsls4101m000","tdsls401.stbp", str$(tdmfc503.bpid))
stpapi.put.field("tdsls4101m000","tdsls401.stad", str$(tdmfc503.bpid))
stpapi.put.field("tdsls4101m000","tdsls401.ccty", str$("IN"))
stpapi.put.field("tdsls4101m000","tdsls401.cvat", str$(tdmfc506.cvat))
stpapi.put.field("tdsls4101m000","tdsls401.bptc", str$("IN"))
ret = stpapi.insert("tdsls4101m000", 1, err.msg)
|message("Sale Order Line Generated for S.No. %d", err.msg)
if isspace(err.msg) then
stpapi.get.field("tdsls4101m000", "tdsls401.orno", orno.f)
stpapi.get.field("tdsls4101m000", "tdsls401.pono", pono.f)
approves.so.order()
else
message("Error : %s", err.msg)
ret = stpapi.recover("tdsls4101m000",err.msg)
endif
else
message("Error : %s", err.msg)
endif
else
message("Error : %s", err.msg)
endif
stpapi.end.session("tdsls4101m000")

stpapi.end.session("tdsls4101m000")

}

function approve.so.order()
{
stpapi.put.field("tdsls4100m000","tdsls400.orno", str$("orno.f"))
ret = stpapi.find("tdsls4100m000",err.msg)
ret = stpapi.mark("tdsls4100m000", err.msg)
stpapi.form.command("tdsls4100m000", 18, "approve.sales.order", error)
stpapi.end.session("tdsls4211m000")
stpapi.end.session("tdsls4100m000")
}
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
AFS Sales Order Insert eric.dizon AFS/DDC/OLE: Function servers 3 11th June 2014 22:46
Afs for Outbound Lines at warehouse order not working... patwanirav Blogs and Web links 1 26th July 2013 11:24
Use Afs to Create Sales Order and Sales Order Lines JerryMaWang AFS/DDC/OLE: Function servers 2 1st June 2011 22:12
Dal king1980 Tools Development 6 19th March 2010 12:10
Baan IV c4 SP18 Sales Order Lines AFS vinceco252 AFS/DDC/OLE: Function servers 6 21st July 2009 23:23


All times are GMT +2. The time now is 00:15.


©2001-2022 - Baanboard.com - Baanforums.com