Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Poll
Is it good to change the Technology per business or changing Business per Technology?
Change Technology per Business
67%
Change Business according to Technology
0%
It Depends
33%
Never change Business
0%
Total votes: 6

Baanboard at LinkedIn


Reference Content

 
Items for 'Code/Script' (by date)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.

 

If you would like to search through the content then please refer to the Site Search page.

 

Issue in AFS
By krushna at 19 Apr 2021 - 06:17

Hello Gurus,

 

I have created a AFS where its closing production orders through the session ticst0201m000,

But i am facing some error during running it, only while its going to print the report.

 

I have attached the code and the error, its much much appreciated if someonne could understand  tht where my code going wrong.

 

please check once and let me know where i am going wrong.


Easy SQL
By vivet2 at 7 Nov 2020 - 11:15

Hi,

any body has prog guide for infor ln 10.3.

Please provide.

 Thanks in advance.Smile 

 


Easy SQL
By vivet2 at 31 Oct 2020 - 11:08

hi,

I want to fech some data through easy sql but i am not able to make query in where condition for date range. my query is.

 

 select tfgld018.ttyp,tfgld018.docn,tfgld018.dcdt,tfgld018.stat

from tfgld018

where tfgld018.stat = 3 and

tfgld018.dcdt  >= :tfgld018.dcdt.t and

tfgld018.dcdt  <= :tfgld018.dcdt.f 

  system throuwing error.    ttadv3280m000: ttadv31853 : Execute Query: Range should be date(YYYY,MM,DD)   Please help .. 

AFS printing Report
By vk1971bhardwaj at 29 May 2020 - 18:15
hi everyone  can anybody help me in AFS report printing, on other session this script is working fine but on this session it not works because this report contain our company logo so please help string spool.device(2) spool.device = "D" stpapi.put.field("tdmfd4401m009", "company", str$(comp.f)) stpapi.put.field("tdmfd4401m009", "tran.f", str$(ttyp.f)) stpapi.put.field("tdmfd4401m009", "docn.f", str$(invoice.no)) stpapi.put.field("tdmfd4401m009", "mchk", str$(tcyesno.no)) stpapi.set.report("tdmfd4401m009", "rtdmfd440109000", spool.device,error) stpapi.print.report("tdmfd4401m009", error) stpapi.end.session("tdmfd4401m009", error)

spool report to second device
By roylansink at 7 Apr 2020 - 14:29

Hi All, 

 I'm trying to print a report to a second device. The idea is that with the print, the report is stored to a folder as well. 

The following code is used for testing purpose, but when I run the report, I get a blank notepad file. What am I doing wrong?  

<code>
after.report.1:
after.layout:

|Save original values
org.spool = spool.id
org.pr.line = spool.pr.line
org.fileout = spool.fileout

|Open extra spooler and print report
spool.id = spool.open("rtcmcs041011000","NOTEPAD",0)          
spool.line()
spool.close()   

|fill predefined vallues with original values 
spool.id = org.spool
spool.pr.line = org.pr.line  

</code> 


Beginner BaaN IV
By jayasree at 18 Oct 2019 - 19:36

Hi

I am a beginner in BaaN IV. i got error at runtime when trying to display multi occ session  by checking enum values in query.extension

query.extension="xxxx.yyy<>domainnme.segment domain.1.procr"

Is there any other way to do...

Thanks 

 


Beginner BaaN IV
By jayasree at 18 Oct 2019 - 19:36

Hi

I am a beginner in BaaN IV. i got error at runtime when trying to display multi occ session  by checking enum values in query.extension

query.extension="xxxx.yyy<>domainnme.segment domain.1.procr"

Is there any other way to do...

Thanks 

 


I want to initialize some value while standar script executed
By DDPatel at 25 Jun 2019 - 12:10

Hiiiii all,

 

I have customize one session "Purchase Order Approval Process".

 

I have writen User exit in on Purchase Order ,User could not able to approve purchase Order until they approved the "Purchase Order approval process" in my customize table.

All the scenario is working fine..

 

Now my question is....How can i display my customize table status in Standard table??

I also have tried USER EXIT,but that can only execute on change or delete..

 

 

Best Regards,

DPatel

 


duplicate record in query.extend.where.in.zoom
By DDPatel at 20 Jun 2019 - 06:42

hiii gurus,

 

I need a help in query.extend.where.in.zoom.

(Scenario)

field.orno.from:
   before.zoom:
   selection.filter:
      query.extend.select.in.zoom("tdcsl491.orno")
      query.extend.from.in.zoom("tdcsl491")
      query.extend.where.in.zoom("tdpur400.orno = tdcsl491.orno)

- i have used two table in query.extend.

- on above example tdpur400.orno has only one record but tdcsl491.orno has a multiple record.

So, When i am trying to open the zoom button,it show me many duplicate record...

 

Is that possible to get single/Unique record on  "query.extend.where.in.zoom" ???

 

 

Thanks in Advance,

DPatel


Open Reporting System For Infor ERP LN
By ckassab at 6 Jun 2019 - 22:03

Open Reporting System.

What is it?.

It is an easy way to get your own good looking reports with output comming directly from ERP LN report sessions as file downloads in Excel xlsx format.

 

 

 

 

All sources and documentation on GitHub: Open Reporting System

 

 



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


©2001-2021 - Baanboard.com - Baanforums.com