Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
Where is your Baan/LN hardware located?
On Premise
57%
Hosted Data Center
14%
Cloud (Azure/AWS - Not Infor Cloudsuite)
29%
Infor Cloudsuite
0%
Total votes: 7

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th June 2019, 17:31
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 641
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Wink DLL ticpr.dll2001 in Baan IV
Baan: Baan IVc4
C/S: Both

Hi,

NOTE: THIS IS REGARDING BAAN IVC4

I was trying to create items from csv file and then update the cost price through AFS for sessions ticpr2210m000 but no luck. I also tried AFS for update cost price session ticpr2220m000 but without any good luck.

The strange thing is i am not getting any error message. Then I came across a thread (i do not remember) that mentioned dll ticprdll2001. I tried to do bic_info on this dll but could not find anything. I think this dll exists in LN.

Is there any similar DLL in Baan IVc4 through which I can calculate cost price of item? Or, can someone explain with example how to use session ticpr2210m000 or ticpr2220m000 to update cost price.

I have crawled all the threads related to this cost price update stuff but without any luck.

Any help will be highly appreciated in this regard.

Vishal
Reply With Quote
  #2  
Old 11th June 2019, 13:18
BaanInOhio BaanInOhio is offline
Senior Member
 
Join Date: Oct 2005
Location: Northeast Ohio
Posts: 192
BaanInOhio is on a distinguished road
Baan: Baan 4c4, 5C, LN - DB: Informix, Oracle, SQL - OS: HP UX, Win2K
Try to call ticpr2210 (background) from your session. The ticpr2210 script will auto load some expected extern variables from the caller and attempt to update the cost price when running in background. Make sure that you use these exact field names and define all as extern.

I did this a long time ago so your version of ticpr2210 may differ, but it worked for me back then.

Code:
	table  tiitm001

	extern  domain  tcyesno  actualize.copr               | update cost prices?
	extern  domain  tccpcc   calc.cd fixed                | cost price calc code
	extern  domain  tcdate   calc.date                    | cost price calc date
	extern  domain  tcccmt   calc.meth                    | cost price calc method
	extern  domain  tccitg   citg.f fixed, citg.t fixed   | item group
	extern  domain  tcitem   item.f fixed, item.t         | item
	extern  domain  tccuni   cntr.f fixed, cntr.t fixed   | container
	extern  domain  tcyesno  optm.oqan                    | optimized order qty
	extern  domain  tcyesno  optm.oqan.sub                | optimized order qty sub
	extern  domain  tiqep1   calc.oqan	                  | order quantity


|	read tiitm001 fields from imported item

	calc.item.f = tiitm001.item
	calc.item.t = tiitm001.item
	calc.cntr.f = tiitm001.cntr       | or '  ' when containers not used
	calc.cntr.t = tiitm001.cntr       | or 'zzz' when containers not used
	calc.citg.f = tiitm001.citg
	calc.citg.t = tiitm001.citg
	calc.cd = ticpr000.sccc                 | or specific calc code
	calc.meth = tcccmt.single.level    | can also use tcccmt.top.down
	calc.date = date.num()                 | or specific date
	optm.oqan = tcyesno.yes
	optm.oqan.sub = tcyesno.yes
	calc.oqan = 0
	actualize.copr = tcyesno.yes
	zoom.to$("ticpr2210s000", z.session, prog.name$, "", 0)
Reply With Quote
  #3  
Old 11th June 2019, 13:48
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,270
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
In this thread http://www.baanboard.com/baanboard/s...pr2210m000+afs it looks like a couple of them got the session working thru afs by writing the report to a file.
__________________
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
  #4  
Old 11th June 2019, 16:25
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 641
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Red face Problem solved

Hi BaanInOhio,

Worked like a charm. Thanks a lot.

Vishal
Reply With Quote
Sponsored Links
  #5  
Old 17th June 2019, 22:26
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 735
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
I had used load dll , exec dll fucntion to run in type 4 programs and they have worked without any issues, an alternative to AFS
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
Help regarding tools session rahul.kolhe22 Tools Development 4 22nd January 2010 13:31
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Baan Internet Applications mr_suleyman Tools Development 1 5th September 2006 15:55
BaaN - 114 , Baan Roles . Spain - Transacciona C. andres77 Jobs and Resumes 0 20th January 2006 00:07


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


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