Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
0%
200 - 500 GB
25%
500 - 800 GB
0%
800 - 1200 GB
0%
1200 - 1500 GB
0%
1500 - 2000 GB
75%
> 2000 GB
0%
Total votes: 4

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 20th March 2018, 12:06
Premahari Premahari is offline
Member
 
Join Date: Mar 2018
Posts: 50
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
AFS for Closing Purchase order

Hi I have created one customised session, where it will close purchase orders based on date or order number. My AFS is not working Can anyone give suggestions.

stpapi.put.field("tdpur4223m000", "buy.from.bp.f", " ")
stpapi.put.field("tdpur4223m000", "buy.from.bp.t", "ZZZZZZZZZ")
stpapi.put.field("tdpur4223m000", "purchase.office.f", " ")
stpapi.put.field("tdpur4223m000", "purchase.office.t", "ZZZZZZ")
stpapi.put.field("tdpur4223m000", "order.type.f", " ")
stpapi.put.field("tdpur4223m000", "order.type.t", "ZZZ")
stpapi.put.field("tdpur4223m000", "purchase.order.f", tfacp251.orno)
stpapi.put.field("tdpur4223m000", "purchase.order.t", tfacp251.orno)
stpapi.put.field("tdpur4223m000", "process.upto", " ")
stpapi.put.field("tdpur4223m000", "print.errors",str$(tcyesno.yes))
stpapi.set.report("tdpur4223m000", "rtdpur422301000",device, error )
stpapi.continue.process("ttstpsplopen",error)
stpapi.form.command("tdpur4223m000",5,"exec.cont.process", errmsg)
Reply With Quote
  #2  
Old 21st March 2018, 13:16
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,114
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Is tfacp251.orno a string? Make them strings.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #3  
Old 22nd March 2018, 05:47
Premahari Premahari is offline
Member
 
Join Date: Mar 2018
Posts: 50
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
I don understand. Why should I make orno as strings? Can u please explain?For order number domain we are using is tcorno right?
Reply With Quote
  #4  
Old 23rd March 2018, 07:14
giggty's Avatar
giggty giggty is offline
Member
 
Join Date: May 2017
Posts: 88
giggty is on a distinguished road
Baan: Infor ERP 10.6 - DB: MSSQL Server 2008 R2 - OS: Windows Server 2012
Also stpapi.continue.process is for Baan IV, so if you are on LN you should use stpapi.form.command(). stpapi.form.command("tdpur4223m000",5,"exec.cont.process", errmsg) seems to be what you need, so just remove stpapi.continue.process("ttstpsplopen",error) line.
Reply With Quote
  #5  
Old 24th March 2018, 19:00
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,114
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Quote:
Originally Posted by Premahari View Post
I don understand. Why should I make orno as strings? Can u please explain?For order number domain we are using is tcorno right?
When using api code all variables need to be passed as strings - so I usually use str$(tfacp251.orno).
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #6  
Old 6th April 2018, 04:30
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 510
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
stpapi.continue.process("ttstpsplopen",error) is not required,even i think

Did it work using stpapi.form.command??
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
How to generate the Purchase Order No. with AFS tracylee AFS/DDC/OLE: Function servers 3 25th March 2016 21:35
Purchase order AFS For Approval anjunath AFS/DDC/OLE: Function servers 1 12th September 2015 11:12
Subcontracting Purchase Order LittleJohn Manufacturing & Supply Chain 3 30th May 2005 05:01
purchase order activity skipped rcitra Distribution, Transportation & Warehousing 8 21st February 2005 02:30
India Localization problem while making afs of Purchase Order crdeshpande AFS/DDC/OLE: Function servers 6 26th November 2003 10:25


All times are GMT +2. The time now is 23:35.


©2001-2018 - Baanboard.com - Baanforums.com